The URL can be used to link to this page

08-28-2012 (City Council) Agenda Packet 0417- IA Wylie City Council - NOTICE OF MEETING 4 f.C9L RA.p� pX5n P�3f lLyyp,, Regular Meeting Agenda August 28, 2012 — 6:00 p.m. Wylie Municipal Complex - Council Chambers 300 Country Club Road, Building #100 Eric Hogue Mayor Kathy Spillyards Mayor Pro Tern David Goss Place 1 Nathan Scott Place 2 Bennie Jones Place 4 Rick White Place 5 Diane Culver 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 • Ray Miranda, The Story Church PRESENTATIONS • Evelyn Lopez Junior Mayor for the Day August 28,2012 Wylie City Council Regular Meeting Agenda Page 2 of 4 CITIZENS COMMENTS ON NON-AGENDA ITEMS Residents may address Council regarding an item that is not listed on the Agenda. Residents must provide their name and address. 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. 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 the August 14, 2012 Regular Meeting of the Wylie City Council. (C. Ehrlich, City Secretary) B. Consider, and place on file, the City of Wylie Monthly Revenue and Expenditure Report for July 31, 2012. (L. Bantz, Finance Director) C. Consider, and place on file, the City of Wylie Monthly Investment Report for July 31, 2012. (L. Bantz, Finance Director) D. Consider, and place on file, the WEDC Financial Report for July 31, 2012. (S. Satterwhite, WEDC Executive Director) E. Consider, and act upon, Wylie East High School vendor registration to hold a carnival fundraiser benefiting Wylie East High School scholarships at Olde City Park on September 24, 2012. (R. Diaz, Parks &Recreation Superintendent) F. Consider, and act upon, Wylie Youth Soccer Association vendor registration to host a fundraiser "Casino Night" event at the Bart Peddicord Community Center on November 3, 2012. (R. Diaz, Parks &Recreation Superintendent) REGULAR AGENDA 1. Consider, and act upon, Ordinance No. 2012-26 amending Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. (C. Holsted, City Engineer) Executive Summary On December 14, 2010 Council held a work session to discuss the water and sewer rate study prepared by McLain Decision Support Systems. The study incorporates the water and sewer capital improvements plan (CIP), outstanding debt service, the proposed wholesale water rate increases from the North Texas Municipal Water District, the transfer to the general fund, and the expansion of the Public Works Service Center. The report was updated in June, 2011 based on information contained in the Indirect Cost Study which identified personnel expenses attributable to the utility fund. August 28,2012 Wylie City Council Regular Meeting Agenda Page 3 of 4 Public Hearing 2. Hold a Public Hearing on the fiscal year 2012-2013 Proposed Budget and provide all interested persons an opportunity to be heard, either for or against any item in the proposed budget; and set and announce the date, time and place of the meeting at which Council will vote on the final proposed budget. (L. Bantz, Finance Director) Executive Summary Executive Summary A Public Hearing is required to be held on the fiscal year 2012-2013 Proposed Budget. In addition the time date, and place that the vote will be taken on the final proposed budget must also be scheduled. Any changes made to the proposed tax rate or proposed budget could affect required publications and steps in the tax rate and budget approval process. READING OF ORDINANCES JOINT WORK SESSION WITH WYLIE ECONOMIC DEVELOPMENT CORPORATION BOARD Call to Order the Wylie Economic Development Corporation Board of Directors • Hold a joint work session between the Wylie City Council, Sanden International (U.S.A.), Inc., and the Wylie Economic Development Corporation Board of Directors to receive an update from Sanden officials on matters pertaining to strategic partnerships and future investment in the Wylie community in addition to an update on commercial activity in the Wylie community provided by the Wylie City Council and WEDC. (S. Satterwhite, WEDC Executive Director) Adjourn the Wylie Economic Development Corporation Board of Directors RECONVENE INTO REGULAR WORK SESSION WORK SESSION • Discuss issues surrounding joint funding with the WEDC for the extension of Woodbridge Parkway. (S. Satterwhite, WEDC Executive Director) RECONVENE INTO REGULAR SESSION August 28,2012 Wylie City Council Regular Meeting Agenda Page 4 of 4 EXECUTIVE SESSION Recess into Closed Session in compliance with Section 551.001, et.seq. Texas Government Code, to wit: Section 551.087 Deliberations Regarding Economic Development Negotiations; Closed Meeting: • Deliberate an Amended and Restated Retail Development Agreement between Woodbridge Crossing, L.P. and the City of Wylie. 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 form,m,m 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: Texas Government Code Section: §551.071—Private consultation with the attorney for the City. §551.072—Discussing purchase,exchange,lease or value of real property. §551.074—Discussing personnel or to hear complaints against personnel. CERTIFICATION I certify that this Notice of Meeting was posted on this 24th day of August 2012 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 . ' 7 Wylie City Council CITY OF WY LIE Minutes Wylie City Council Meeting Tuesday August 14, 2012 - 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:00 p.m. City Secretary Ehrlich took roll call with the following City Council members present: Mayor Pro Tem Kathy Spillyards, Councilwoman Diane Culver, Councilman Nathan Scott, Councilman Rick White, Councilman David Goss, and Councilman Bennie Jones. Staff present were: City Manager, Mindy Manson; Assistant City Manager, Jeff Butters; Fire Chief, Randy Corbin; City Engineer, Chris Hoisted; Police Chief, John Duscio; Planning Director, Renae 011ie; Library Director, Rachel Orozco; Public Services Director, Mike Sferra; Finance Director, Linda Bantz; Public Information Officer, Craig Kelly; City Secretary, Carole Ehrlich, and various support staff. INVOCATION & PLEDGE OF ALLEGIANCE David Keuss, representing the Woodbridge Bible Church, gave the invocation and Boy Scout Troop 302 presented the colors and led the Pledge of Allegiance. PRESENTATIONS • Proclamation for Clay Little Day Mayor Hogue presented a proclamation to Clay Little proclaiming August 14, 2012 as Clay Little Day in the City of Wylie. Hogue explained Clay had achieved the designation of Eagle Scout by retiring 719 flags. Mayor Hogue also presented Eagle Scout Little with a United States Flag that had flown over the Texas Senate, State Capitol, and the City of Wylie. Members of Boy Scout Troop 302 were in attendance for the presentation. Minutes August 14, 2012 Wylie City Council Page 1 CITIZENS COMMENTS ON NON-AGENDA ITEMS Residents may address Council regarding an item that is not listed on the Agenda. Residents must provide their name and address. 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. Public Works Superintendent Tim Hopwood addressed council stating that the city began fogging on Tuesday, August 7, 2012 when the city was notified of a possible positive human case of West Nile Virus in Wylie. He explained that there had been two positive WNV cases in Wylie and one just north of the city limits. He reported fogging neighborhoods on weeknights from 10 p.m. to 5 a.m. were being conducted in conjunction with trash pickup scheduling. Public education efforts have been published on light board signs, 25 neighborhood signs, NIXLE, the monument digital sign, the city website, Wylie News, streaming video, channel 41, Wylie Living newsletters, and the city Facebook page. Hopwood cautioned residents to wear dark clothing, use repellent with deet, wear long sleeves and pants, avoid outside at dusk and dawn, and remove standing water. The city is coordinating with Code Enforcement to receive calls regarding abandoned pools and standing water. 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 the July 24, 2012 Regular Meeting and July 31, 2012 Special Called Work Sessions of the Wylie City Council. (C. Ehrlich, City Secretary) B. Consider, and act upon, Ordinance No. 2012-22 authorizing the annexation of a 2.208 acre tract of land situated in the James Truitt Survey,Abstract No. 920, Collin County, Texas, generally located north of Brown Street and east of Ballard Avenue. (R. 011ie, Planning Director) C. Consider, and act upon, Ordinance No. 2012-23, an ordinance of the City of Wylie, Texas, adopting Article VIII (Planting, Maintaining Trees, Shrubs on Public Property) of Chapter 78 (Parks and Recreation) of the City of Wylie Code of Ordinances; To provide for the care of public trees and shrubs within the City of Wylie; providing for a penalty for the violation of this ordinance; providing for savings and severability clauses; providing for an effective date of this ordinance; and providing for the publication of the caption hereof. (S. Rodgers, Parks Manager) D. Consider, and act upon, approving Resolution No. 2012-24(R) and authorizing the City Manager to execute a Municipal Maintenance Agreement with TxDOT to update the previous Agreement that was executed in 1995. (M. Sferra, Public Services Director) E. Consider, and act upon, Resolution No. 2012-29(R) authorizing the City Manager to execute a Landscape Maintenance Agreement with TxDOT for the installation of landscaping on State Highway 78. (M. Sferra, Public Services Director) Minutes August 14, 2012 Wylie City Council Page 2 F. Consider, and act upon, approval of Resolution No. 2012-25(R) authorizing the City Manager to execute a TxDOT Gateway Monument Agreement for the reinstallation of the Welcome to Wylie monument sign on State Highway 78. (M. Sferra, Public Services Director) G. Consider, and act upon, Resolution No. 2012-26(R) and authorizing the City Manager to execute an interlocal purchasing agreement with the City of Grand Prairie for the purchase of goods and services. (G. Hayes, Purchasing Agent) H. Consider, and act upon, the approval of the purchase of Pavement Resurfacing Services from Reynolds Asphalt and Construction Company in the estimated annual amount of$300,000, through an existing City of Grand Prairie contract, and authorizing the City Manager to execute all necessary documents. (City of Grand Prairie Bid No. 11099). (M. Sferra, Public Services Director) L Consider, and act upon, Ordinance No. 2012-24 amending Section 3 of Ordinance 2007-36 and Article IV, Section 110-133 of the Code of Ordinances, establishing a school zone for certain streets; establishing prima facie maximum speed limits during school hours in such zone; providing for installation of signs and markings; regulating vehicular and pedestrian traffic; providing for a penalty for the violation of this ordinance, providing for repealing, savings and severability clauses; and providing for an effective date of this ordinance. (C. Holsted, City Engineer) J. Consider, and act upon, approval of Ordinance No. 2012-25 establishing speed zones for Country Club between FM 544 and Parker Road. (C. Holsted, City Engineer) Council Action A motion was made by Councilman White, seconded by Councilwoman Culver to approve the consent agenda as presented. A vote was taken and the motion passed 7-0. REGULAR AGENDA 1. Consider, and act upon, Resolution No. 2012-27(R) of the City Council of the City of Wylie, Texas, accepting the proposed property tax rate for fiscal year 2012-2013, accepting the calculation of the effective tax rate, and providing for the publication as provided by the Texas Property Tax Code. (L. Bantz, Finance Director) Staff Comments Finance Director Bantz addressed council stating that the proposed budget is based on a tax rate of $0.8889 per $100 valuation. This year's effective tax rate is $0.895086 and the rollback tax rate is $0.943626. Any change in the proposed tax rate will require revision of the proposed budget. Since the proposed tax rate is less than both the effective and rollback tax rate, no public hearings on the tax rate are required. Council Action A motion was made by Councilman Scott, seconded by Councilman Jones to adopt Resolution No. 2012-27(R) of the city council of the City of Wylie, Texas, accepting the proposed property Minutes August 14, 2012 Wylie City Council Page 3 tax rate for fiscal year 2012-2013, accepting the calculation of the effective tax rate and providing for the publication as provided by the Texas Property Tax Code. A vote was taken and the motion passed with Mayor Hogue, Mayor Pro Tem Spillyards, Councilman Goss, Councilman Scott, Councilman Jones, Councilman White, and Councilwoman Culver voting for and none against. 2. Consider, and act upon, Resolution No. 2012-28(R) to work with ETMC and the Southeast Collin County Emergency Medical Services Coalition to apply for grant funding through the Texas Healthcare Transformation and Quality Improvement Program in accordance with section 1115 of the Social Security Act, known as the 1115 Waiver. (R. Corbin, Fire Chief) Staff Comments Fire Chief Corbin addressed council stating that the SECCEMS Coalition and ETMC are investigating the possibility of applying for funding through the 1115 Waiver Program offered through the Texas Health and Human Services Department matching public funds to an EMS delivery system. In order to apply for funding, the government requires a resolution be considered through a public meeting. Council Action A motion was made by Councilman White, seconded by Councilman Goss to adopt Resolution No. 2012-28(R) to work with ETMC and the Southeast Collin County Emergency Medical Services Coalition to apply for grant funding through the Texas Healthcare Transformation and Quality Improvement Program in accordance with section 1115 of the Social Security Act, known as the 1115 Waiver. A vote was taken and the motion passed 7-0. READING OF ORDINANCES City Secretary Ehrlich read the caption to Ordinance No.'s 2012-22, 2012-23, 2012-24, and 2012-25 into the official record. Mayor Hogue convened into Executive Session at 6:35 p.m. reading the caption below. EXECUTIVE SESSION Recess into Closed Session in compliance with Section 551.001, et.seq. Texas Government Code, to wit: a. 551.071: Private consultation with the City Attorney when the City seeks the advice of its attorney about: (1)pending or contemplated litigation; (2) a settlement offer; or (2) on a matter in which the duty of the attorney to the governmental body under the Texas Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with this chapter; and 551.074: Deliberation regarding the appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee; or to hear a complaint or charge against an officer or employee. • Proposed Settlement and Release Agreement with Cody Clark Minutes August 14, 2012 Wylie City Council Page 4 Mayor Hogue reconvened into Open Session at 7:07 p.m. RECONVENE INTO OPEN SESSION Take any action as a result from Work Session or Executive Session. Council Action A motion was made by Councilman Jones, seconded by Councilman Goss to deny the proposed Settlement and Release Agreement with Cody Clark. A vote was taken and the motion failed 2-5 with Councilman Goss and Councilman Jones voting for denial and Mayor Hogue, Mayor Pro Tem Spillyards, Councilman Scott, Councilman White, and Councilwoman Culver voting against a motion to deny. Council Action A motion was made by Councilwoman Culver, seconded by Councilman White to accept the proposed Settlement and Release Agreement with Cody Clark. A vote was taken and the motion passed 5-2 with Mayor Hogue, Mayor Pro Tem Spillyards, Councilman Scott, Councilman White and Councilwoman Culver voting for acceptance, and Councilman Goss and Councilman Jones voting against acceptance. Mayor Hogue convened into Work Session at 7:10 p.m. WORK SESSION • Presentation of our new Customer Relationship Management Tool (C. Kelly, Public Information Officer) Public Information Officer Kelly addressed council stating that after months of hard work and training by departments throughout the organization, he was excited to provide a quick overview of the city's new Citizen Relationship Management System, known as CRM. This system moves the city to the forefront of customer service and improves communication to better manage, track, and respond to resident requests. The new system promotes transparent and open government, and confidently assures residents that their requests for service will be promptly addressed. Kelly explained the program was seamlessly available on the city website or through free Android, iPhone or iPad applications known as GORequest. Upon submitting a request, requestors will receive a message confirming receipt and the expected turnaround time of the service request. Tracking numbers allow residents to easily check the status of their requests online. Another helpful feature is the FAQ (Frequently Asked Questions) list of popular city topics which may answer citizen's questions immediately. Over 50 service requests are available for citizens to submit online and 22 available in the mobile application. Kelly reported the city receives approximately 500 requests per year; with the new system that is expected to double. Minutes August 14, 2012 Wylie City Council Page 5 • Discussion regarding the Wylie Wave Program (Council) Councilman Jones addressed council stating that during the budget work sessions it was decided to cancel the Wylie Wave and Tween Scene for FY 2012/2013, due to budgetary issues. Councilman Jones stated that since that time he has been in contact with staff to look at other options to allow some form of these programs to continue. He asked that council listen to staff options and also hear from some of the participants who were present and requesting to speak to the council regarding their experience with the current programs. City Manager Manson explained that if the city was not going to continue to provide the Wylie Wave, it didn't mean the city would go "cold turkey" and not offer other options for youth programs at the Recreation Center. These optional programs, if approved by council would be set this fall to take place next summer. Manson noted the Parks staff was available to present some of these options. Parks Superintendent Diaz and Recreation Programmer Annika Sacco addressed council stating that the city could add to the recreation programming, options to allow contracted camps to provide activities for children. All camps would be contracted to an outside instructor and fees would be set based on that cost and include some staff costs for lunch monitoring. Parents would sign up for each camp separately and the camps would be for shorter time periods. Some classes that could be offered would include art camps, sport camps and other activities children would enjoy. City Manager Manson explained having contracted camp instructors would allow the city to pay the contractors and base fees on those costs, allowing the program to be budget neutral. Councilman Jones asked City Manager Manson to explain what the ramifications would be in light of not using the WISD facilities, to allow the city to continue the Wave program. City Manager Manson explained that in light of not being able to use the school facilities and moving the program to the Recreation Center, the enrollment would have to be cut in half. Cost would be projected at approximately $106,000, this would be a gap of $35,000 the city would be expending; to make it a budget neutral program the cost to participants would be $180 per week per child; allowing half the enrollment. Mayor Hogue stated the WISD would be offering recreational activities for their summer AlphaBest program. He explained he was told by the school district that three issues were considered in increasing the fees to the city to utilize their facilities for the Wave program. Those concerns included: the extended length of the Wave program made it difficult to prepare the facilities use for the next school year, there were supervision issues and WISD felt additional supervision was needed from school staff, and the wear and tear on existing school facilities based on the large enrollment in the programs, affects the life of the buildings. Councilwoman Culver stated that she had heard from parents that could not afford the WISD AlphaBest program; she noted that she wanted to be on record as stating that if the Wylie Wave program was continued it would be far more expensive to the participants than the AlphaBest program. Many Wylie Wave instructors, participants and parents were present to address council requesting the continuation of the Wylie Wave and Tween Scene programs. Direction from council was for staff to review further options to provide programs/camps for the youth next summer; preferable at a budget neutral cost. Additional direction was to take the time to review all options available. Council requested a work session with the WISD Superintendent and the public to hear about the new program offered by the school district. Minutes August 14, 2012 Wylie City Council Page 6 ADJOURNMENT With no further business before the Wylie City Council, a motion was made by Councilman Jones, seconded by Councilman Goss to adjourn the meeting at 8:35 p.m. A vote was taken and the motion passed 7-0. Eric Hogue, Mayor ATTEST: Carole Ehrlich, City Secretary Minutes August 14, 2012 Wylie City Council Page 7 Wylie City Council AGENDA REPORT .4'1WI VII+M'4 Meeting Date: August 28, 2012 Item Number: B. Department: Finance (City Secretary's Use Only) Prepared By: Finance Account Code: Date Prepared: August 20, 2012 Budgeted Amount: Revenue and Expenditure Exhibits: Monthly Report Subject Consider, and place on file, the City of Wylie Monthly Revenue and Expenditure Report for July 31, 2012. Recommendation Motion to accept and place on file, the City of Wylie Monthly Revenue and Expenditure Report for July 31, 2012. Discussion The Finance Department has prepared the attached reports for the City Council as required by the City Charter. Approved By Initial Date Department Director LB 08/20/2012 City Manager MM August 23, 2012 Page 1 of 1 CITY OF WYLIE MONTHLY FINANCIAL REPORT July 31,2012 ANNUAL CURRENT YTD ACTUAL Benchmark BUDGET MONTH ACTUAL YTD ACTUAL AS A PERCENT 83.33% ACCOUNT DESCRIPTION 2011-2012 2011-2012 2011-2012 OF BUDGET GENERAL FUND REVENUE SUMMARY TAXES 17,344,265 314,077 16,217,580 93.50% A FRANCHISE FEES 2,241,000 21,801 2,110,352 94.17% B LICENSES AND PERMITS 411,000 66,506 470,583 114.50% INTERGOVERNMENTAL REV. 600,272 136,528 641,881 106.93% SERVICE FEES 2,716,000 241,036 2,227,958 82.03% C FINES AND FORFEITURES 307,000 24,755 226,678 73.84% INTEREST INCOME 19,000 1,757 14,884 78.34% D MISCELLANEOUS INCOME 341,389 20,319 263,800 77.27% OTHER FINANCING SOURCES 1,681,997 0 1,681,997 100.00% REVENUES 25,661,923 826,779 23,855,713 92.96% USE OF FUND BALANCE 934,010 NA NA NA E TRANSFER FROM EMERGENCY COMMUNICATIONS 248,224 0 335,105 135.00% TOTAL REVENUES 26,844,157 NA NA NA GENERAL FUND EXPENDITURE SUMMARY CITY COUNCIL 95,681 3,436 70,362 73.54% CITY MANAGER 700,600 56,671 546,494 78.00% CITY SECRETARY 252,154 19,887 197,600 78.36% CITY ATTORNEY 128,000 0 78,077 61.00% FINANCE 893,964 63,683 728,055 81.44% FACILITIES 467,209 18,851 269,191 57.62% MUNICIPAL COURT 279,959 19,067 193,075 68.97% HUMAN RESOURCES 201,183 17,017 163,484 81.26% PURCHASING 151,365 8,221 121,173 80.05% INFORMATION TECHNOLOGY 1,003,066 27,378 869,242 86.66% F POLICE 5,454,207 466,360 4,478,363 82.11% FIRE 5,735,142 552,961 4,792,815 83.57% EMERGENCY COMMUNICATIONS 1,139,996 86,218 756,456 66.36% ANIMAL CONTROL 327,356 29,968 253,755 77.52% PLANNING 485,519 39,647 378,323 77.92% BUILDING INSPECTION 667,438 47,159 514,110 77.03% CODE ENFORCEMENT 250,748 20,084 176,106 70.23% STREETS 1,567,725 100,058 1,109,576 70.78% PARKS 1,550,830 154,446 1,243,876 80.21% RECREATION 212,050 44,364 93,485 44.09% LIBRARY 1,401,348 113,122 1,132,658 80.83% COMBINED SERVICES 3,639,283 196,971 3,081,118 84.66% TOTAL EXPENDITURES 26,604,823 2,085,569 21,247,394 79.86% REVENUES OVER/(UNDER)EXPENDITURES 239,334 -1,258,790 2,608,319 13.10% A. Property Tax Collections for FY11-12 as of July 31 are 100.00%,in comparison to FY10-11 for the same time period 99.78%. B. Franchise Fees:The majority of franchise fees are recognized in the third and fourth quarter with electric fees making up the majority. C.Service Fees:Trash fees billed in October are applicable towards FY 2010-11 revenue with the remaining fees coming from WAVE and other seasonal fees. D.Interest Income: In relation to the last 12 months the current interest is in line with projections. E. Use of Fund Balance:to supplement Debt Service and Replacement/New Fleet and Equipment. F. Due to the timing of technology purchases,expenses have increased;however,these will level out throughout the fiscal year. CITY OF WYLIE MONTHLY FINANCIAL REPORT July 31,2012 ANNUAL CURRENT YTD ACTUAL Benchmark BUDGET MONTH ACTUAL YTD ACTUAL AS A PERCENT 83.33% ACCOUNT DESCRIPTION 2011-2012 2011-2012 2011-2012 OF BUDGET UTILITY FUND REVENUES SUMMARY SERVICE FEES 10,341,000 1,004,839 8,135,028 78.67% INTEREST INCOME 15,000 1,035 10,599 70.66% MISCELLANEOUS INCOME 35,000 3,535 33,712 96.32% OTHER FINANCING SOURCES 0 0 0 0.00% TOTAL REVENUES 10,391,000 1,009,409 8,179,339 78.72% G UTILITY FUND EXPENDITURE SUMMARY UTILITY ADMINISTRATION 295,050 18,920 238,478 80.83% UTILITIES-WATER 1,116,406 98,223 828,726 74.23% CITY ENGINEER 438,935 40,409 352,198 80.24% UTILITIES-SEWER 660,027 45,379 456,909 69.23% UTILITY BILLING 625,373 44,543 500,556 80.04% COMBINED SERVICES 14,183,712 945,041 11,587,902 81.70% TOTAL EXPENDITURES 17,319,503 1,192,515 13,964,769 80.63% REVENUES OVER/(UNDER)EXPENDITURES -6,928,503 -183,106 -5,785,430 -1.91% H G.Most Utility Fund Revenue billed in October are applicable to FY 2010-11. H.Use of Fund Balance for Community Park Utility Infrastructure. Wylie City Council AGENDA REPORT ft:try rF Meeting Date: August 28, 2012 Item Number: C. Department: Finance (City Secretary's Use Only) Prepared By: Finance Account Code: Date Prepared: August 20, 2012 Budgeted Amount: Exhibits: Investment Report Subject Consider, and place on file, the City of Wylie Monthly Investment Report for July 31, 2012. Recommendation Motion to accept and place on file, the City of Wylie Monthly Investment Report for July 31, 2012. Discussion The Finance Department has prepared the attached reports for the City Council as required by the City Charter. Approved By Initial Date Department Director LB 08/20/2012 City Manager MM August 23, 2012 Page 1 of 1 2011-2012 Investment Report July 31, 2012 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 $39,844,204.15 MMA 0.1316% Texpool 12/31/2006 NA 2 $15,021,287.42 MMA 0.1359% TexStar 3/15/2011 NA $54,865,491.57 Total Weighted Average Coupon: 0.13% Money Markets: $54,865,491.57 Weighted Average Maturity(Days): 1.00 Certificates of Deposits: $0.00 $54,865,491.57 9 Wylie City Council y AGENDA REPORT Meeting Date: August 28, 2012 Item Number: D. Department: WEDC (City Secretary's Use Only) Prepared By: Sam Satterwhite Account Code: Date Prepared: July 13, 2012 Budgeted Amount: Exhibits: 1 Subject Consider, and place on file, the Monthly Revenue and Expense Report for the Wylie Economic Development Corporation as of July 31, 2012. Recommendation Accept, and place on file, the monthly Revenue and Expense Report for the Wylie Economic Development Corporation as of July 31, 2012. Discussion The Wylie Economic Development Corporation (WEDC) Board of Directors approved the attached financials on August 17, 2012. Approved By Initial Date Department Director SS 08/23/2012 City Manager MM August 23, 2012 Page 1 of 1 8-09-2012 03{14 PM CITY OF WYLIE PAGEL 1 BALANCE SHEET AS OF: JULY 3IST, 2012 111-WYLIE ECONOMIC DEVEL CORP ACCOUNT* TITLE 44 ASSETS 662624 1000-10110 CLAIM ON CASH AND CASH EQUIV, 1,427,659.I5 1000-10115 CASH - wB1 - INWOOD 0,00 1000-10139 INWOOD BANK - ESCROW 0.00 1000-14180 DEPOSITS 2,000.00 1000-10199 OTHER - MTSC CLEARING 0.00 )000-10341 TEXPOOL 0,60 1000-10343 LOGIC 0.00 1000-10481 INTEREST RECEIVABLE 0.00 1000-11911 ACCTS RE: '.TSC 0.02) 1000-11S1') ACCTS REG - SALES TAX 6,00 1000-12810 LEASE PAYMENTS RECEIVABLE 4,783,896,40 1000-12996 LOAN RECEIVABLE 0.00 1000-12990 ACCTS REG - JTM TECH 0.00 1000-12999 ACCTS REC - SAVAGE 240,8258 1000-14112 INVENTORY - MATERIAL/ SUPPLY 0.00 1000-14114 INVENTORY - LAND 8 BUILDINGS 2,294,512.3Y 1000-14118 INVENTORY - BAYOU! OANDIIR BLVD 0.00 1000-14310 PREPAID EXPENSES - MISC 0,00 1000-14410 DEFERRED CHARGES 892,943.40 11,653,836,68 TOTAL ASSETS )1,453,836.48 -------------- ITABIL/TTES 2000-20110 FEDERAL INCOME TAN 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-2010 NATIONWIDE DEFERRED COMP 0.00 2000-20116 HEALTH NSUE PAY-EMPLOYEE { 196.15) 200o-20117 TMRS PAYABLE 0.00 2000-20118 ROTH IRA PAYABLE 0.00 2000-20119 WORKERS COMP PAYABLE 6.00 2000-20120 PICA PAYABLE 0.60 2000-20121 TEC PAYABLE 0,00 2600-20122 STUDENT LOAN LEVY PAYABLE 4.00 2000-20123 ALIMONY PAYABLE 0,00 2000-20124 BANKRUPTCY PAYABLE 0.00 2000-20129 1/AL/, DEFERRED COMP 0.00 2000-20126 ICMA PAYABLE 4.00 2000-20127 EN!. LRGAL SERVICES PAYABLE 0.00 2009-20130 FLEXIBLE SPENDING ACCOUNT 2,849.90 2090-20132 FM! CARE ELITE 0.00 2000-20151 ACCRUED W.A.GES PAYABLE 0.00 2000-20190 ADOTT EMPLOYEE INSUE PAY 0.00 2000-20198 MISC PAYROLL PAYABLE 0,00 2000-20201 AP PENDING 5,806.40 2000-20210 ACCOUNTS PAYABLE 94,144.46 B-09-,2012 09:14 UN CITY or WYLIE PAGE: 2' BALANCE SHEET AS OP: JU1.9.) 31ST, 2012 I 11:-WY LT E ECONOMIC OEVEL CORP ACCOUNT# TITLE 2000-20090 PROPERTY TAXED PAYABLE 0,00 2000-29540 NOTES PAYABLE 8B2,943.40 2009-20619 DUE TO GENERAL FUND 0.00 2009-22239 DEFERRED REVENUE 141,903,98 20004-22235 DEFERRED REV - LEASE PR INCI PAL. 54 889,409.72 20011-22290 DEFERRED REVENUE. - LEASE INT 904,430.29 2000-2'2915 RENTAL DEPOSITS 2,699.90 TOTAL L112,,BILITIES 1,924,189.99 EQUITY 4-66-46) 3000-34110 EUND BALANCE - RESERVED 488,181.60 3900-94S9D SUMO SALANCE-•,UNEESERV/UNDEsIG 3,269,210,27 TOTAL BEGINNING: EQUITY 3,1537,991.87 TOTAL REVENUE 1,593,213.31 TOTAL EXPENSES 1,620,949.89 REVENUE OVER/)UNDER) EXPENSES 1, 23,736.183 TOTAL EQUITY & OVER/(UNDER) 9,729,055.69 TOTAL LIABILITIEs, EQUITY & OVER!(UNDER) 11,659,896,6B 6-674606-666-66 8-09-2012 0840 AM CITY OF NYLON PAGE( 1 BALANCE SHEET AS OF: DULY 31ST, 2012 922-GEN LONG TERM DEBT (WEDC) ACCOUNT)) TITLE ASSETS 1000-10312 GOVERNMENT NOTES 0.00 1000-18110 LOAN - WEDO 0.00 1000-1,812o LOAN - BIRMINGHAM 0.00 1000-18210 AMOUNT TO BE PROVIDED 0.00 1000-18220 BIRMINGHAM LOAN 0.00 0.00 TOTAL ASSETS 0.00 LIABILITIES 2000-20310 COMPENSATED ABSENCES PAYABLE 43,002.56 2000-20321 COMP ABSENCES PAYABLE-CURRENT 0,00 2000-21410 ACCRUED INTEREST PAYABLE 0.00 2000-28205 WEDC LOANS - CURRENT 55,089.419 2000-28220 BIRMINGHAM LOAN 0.00 2000-28230 INWOOD LOAN 0.00 2000-28235 ANB LOAN 289,748,24 2000-28236 ANB CONSTRUCTION LOAN 4,645,710.78 2000-28240 HUGHEE LOAN 1.53,598,50 2000-28250 CITY. OF WYLIE LOAN 0,00 2000-28260 PRIME NUTS LOAN 0,00 2000-28270 BOALAND/ANDERSON LOAN 0.00 2000-28280 CAPITAL ONE C132AD LOAN 0,00 TOTAL LIABILITIES 5,191,179.57 EQUITY - . 3000-14590 FUND BALANCE-UNRESERVIUNDESIG( 5,40),14 ,58) TOTAL BECIANIAM EQUITY ( 5,403,147.581 TOTAL REVENUE 0,00 TOTAL EXPENSES ( 211,168.011 REVENUE OVER/(UNDER) EXPENSES 211,968.01 TOTAL EQUITY 4 OVER/(ANDER2 1 5,191,179.57) TOTAL LIABILITIES, EQUITY & OVER/(UNDER 0,00. 8-09-2012 oa;40 AM CITE OF YLIE PAGE: 1 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OEM jULY )1ST, 2012. 11IDWYLTE ECONOMIC DEVEM CORP FINANCIAL SUMMARY CURRENT CURRENT PRIOR YEAR Y-T-1/ Y-T-0) BUDGET % OF SEEDET PERIOD PO ADJUST, ACTUAL ENCUMBRANCE BALANCE. BUDGET f'IVENUEJTSIAIY, TAXES 1,801,162.00 125,555.03 0.00 1,030,000.34 0.00 170,5.61.86 517,22 INTEREST INCOME 261,260.00 10,512.60 0,00 107,099,48 0.00 174,160.52 38.08 MISCELLANEOUS INCOME 90,882.00 8,606„110 0.00 154,315.34 0.00 3 83,433.34) 169.80 OTHER FINANCING SOURCES 209,930.00 30,25(.61 0,00 301,198.65 0.00 I 91,268,55) 143.48 TOTAL REVENUES: 2,383,234.00 113,260444 0.00 1,503,216.73 0,0r2 190,620.29 80.65 EXPENDITURE SUMIABR DEVELOPMENT CORD-MEDC 2,067,796,09 299,012.93 0.00 1,620,223.06 1,638.36 1,145,904.64 58460 TOTAL EXPENDITURES 2,767,766.00 299,012.93 0,00 1,820,223.00 1,638-36 1,145,904.64 58,60. REVENUE OVER/IONDER) EXPENDITURES 3 384,532,0013 125,102.401 0.00 3 21,009.293 3 1,6384381 ( 355,864.351 7.45 5--09-2[712 08:40 AM CITY OF WYLIE PAGE: 2 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OF JU1,Y 31ST, 2012 1I.I. WY LIE ECONOMIC 0 EVE 1;. ="i;:R13. REVENUES CURRENT CURRENT PRIOR YEAR;. Y-T-f.7 Y-T e t1S„`[1')' V OF BUDGET PERIOD PO ADJUST„ ACTUAL ENCUMBRANCE BALANCE BO DIIFr "CARES 4(110.-40150 REV IN LEIN OF TAXES 155,5415.00 0.00 0,011 G.:0.3 83.0E 1550883.00 0.00 4000 47710 7111,E5 TAX 1,64502 3.00 325,555.03 0.00 1,0300600.34 0.00 8144912.663 62.64 TOTAL TAXES 1,801,1.:2.111 125,555.03 0,00 I,1340,600,34 --.. 0.00 t15,5 1 .66 57,22 INTEREST INCOME I770 48858 CERTIFICATE I"' DEPOSIT 0.00 0.10 81.00f1 0.0O3 a..00 7.07 0.881 4008 1(1110 ALLOCATED INTEREST EARNINGS 3,711.0"u 157.41. 0.061 1,478.03 0'.00 1.,521.4'2 49.21 4000 46140 I'55:005 INTEREST 0,10 0,00 0.0E 0,00 0.V80 0.00 0,00 4000 46143 1,0v(r INTEREST 0,00 0.00 [1,00 O.00, 0.:30, 0.00 0,0 4000-46150 INTEREST 7111(11I1G5 214,260,00 (0,325.35 0.00 105,621.45 83.00 (72,638.55 37.96 4000 46210 1.6(15 MONEY MARKET INTEREST 0,03 O.00 4.(3B t.C)ll 3.08 19 1,619 TOTAL INTEREST INCOME 281,2€60,00 12,512.80 (1.00 107,094.48 0.01 174,160,52 38.07 NI SCE 1.1,11EC:15 I NCO ME 40 0-4811.0' REN.A1. INCOME 88,442.77 6,1)00.I00 0.00 51, 20.PO 0.:10 38,582.00 54.518.. 4000-418310 RECOVERY - PRIOR YEAR. EXPE'1 0.20 0,011 O.00 47.00 0.00, 0,00 0.00 4010-48410 7I!SCELLA1[F5U1 111110E10 2,400.00 108.00E 0.01 102,41.5,34 0.00 ( 1130,015,34) 287.31. 4000-48430, GAIN/LOSS SALE OF ('A1 ASSET 0.11€) 0,111 O. 7.11E 0.+0, «1, &0 0.00 TOTAL MISCELLANEOUS 'INCOME 40,€882 00 6,806.00 0.083 1540 115.34. 0.810,,. 1 63,499,141 1811.811 4170 .81€0 TRANSFER 111014 GENERAL FUND 7.00 G.00 0.0E 0.00 0.1)0 O.00 8.00 4800-48:325 BANK NOTE PROCEEDS 0S,00 0,001 0.00 0.00 0.0E O.00 3.2 4000-47550 €E Se PRINCIPAL PAYMENTS C0 209,930.00 3:1,3S8t.61 (1.01) 171,1E17.55 1.011 #' 91,26a.5`31 241,48 TOTALOTHER FINANCING SOURCES ..... 20 ,.930,00 10,156,61 .., 0.00 ..... 301,198,55 0.00 1 91,268.551 143.48 Ti",TIlL REVENUES 2,383,234.00 123,230.44 0.00 1,593,213,71 0.00' 7+0,020,29 88,85 8-09-2012 08:40 AM CITY OF WYLIE PACE: 3 REVENUE AND EXPENSE REPORT - (UNAUDITED) AS OF: JULY 3LST, 2012 1.11-WYLIE ECONOMIC DCVF.L CORP DEVELOPMENT CORD-WEDC DEPARTMENTAL EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET I OF BUDGET PERIOD PO ADJUST. ACTUAL. ENCUMBRANCI, BALANCE BUDGET PERSONNEL SERVICES 5611 51110 SALARIES 172,370.00 28,709,24 0,00 154,672.02 0.00 17,697.98 89,73 5611-51130 OVERTIME 0.00 0.00 0.00 0.00 0,00 0,00 0,00 5611-51140 LONGEVITY PAY 1,057.00 0.00 0.00 1,060.00 (1,00 ( 3,00) 100,28 S61.1.-51145 SILK 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,320.00 870.78 0.00 9,143.19 0,.00 2,176.81 80,77 5611-51220 PHONE ALLOWANCE 3,456.00 864.00 0.00 3,389.52 0,00 66.48 98,08 5611-31230 CLOTHING ALLOWANCE 0,00 0.00 0.00 0.00 0.00 0,00 0,00 5611-51310 TMRS 21,771.00 3,735.98 0.00 20,760.92 0.00 1,010.08 95.36 5611-51410 HOSPITAL & LIFE INSURANCE 27,260.00 3,535.86 0.00 19,650.99 0.00 7,609.01 72,09 5611-51420 LONG-TERM DISABILITY 983.00 38.22 0.00 382.20 0,00 600.80 39,88 5611-51440 FIC11 10,687.00 1,801.06 0.00 8,050,41 0.00 2,636.59 75.3.3 5611-51450 MEDICARE 2,500.00 421.21 0.00 2,334.97 0.0(1 165.03 93.40 5611-51470 WORKERS COMP PREMIUM 656.00 0.00 0.00 539.51 0,00 116.49 82,24 5611-51480 UNEMPLOYMENT COMP (TAC) 540.00 0.00 0.00 522.00 0.00 18.00 96.67 TOTAL PERSONNEL SERVICES 252,600.00 39,976.35 0.00 220,505.73 0.00 32,094.27 87.29 SUPPLIES 561.1.-52010 OFFICE SUPPLIES 5,000.00 80.13 0.00 3,592.40 35.85 1,371.75 72.57 5611-52040 POSTAGE & FREIGHT 980.00 121.00 0.00 297.56 2.68 679.76 30.64 5611-52130 TOOLS/ EQUIP - UNDER $1000 0.00 0,00 0.00 0.00 0.00 0.00 0.00 5111-52810 FOOD SUPPLIFS 5,000.00 361.94 0.00 3,177,84 27.45 1,794.71 64.11 561.1.-52990 OTHER 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 10,980.00 563.07 0.00 7,067.80 65.98 3,846.22 64.97 MATERIALS FOR MAINTFNANC 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 484.98 0.00 978.81 0.00 2,021.19 32.63 5611-54990 OTHER 0.00 0.00 0.60 0.00 0.00 0.00 0.00 TOTAL MATERIALS FOR iv1AINTENANC 3,000.00 484.98 0.00 978.81 0.00 2,021.19 32.63 CONTRACTUAL SERVICES 56/1-56030 INCENTIVES 1,000,378.00 194,968,91 0.00 401,377.96 0.00 599,000.04 40.12 561.1.-56040 SPECIAL SERVICES 173,314.00 1,638,11 0.00 13,652.87 0.00 159,661.13 7.88 5611-56080 ADVERTISING 26,800.00 3,304,.85 0.00 13,124.85 0.00 13,675.15 48.97 5611-56090 COMMUNITY DEVELOPMENT 40,250,00 ( 400,00) 0.00 35,321.74 378.19 4,550.07 88.70 5611-56110 COMMUNICATIONS 4,480.00 346,12 0,00 3,298.84 125.08 1,056.08 76.43 561.1.-561.80 RENTAL 22,600,00 1,893.96 0.00 20,126.08 0.00 2,473.92 89.05 5611-56210 TRAVEL I TRAINING 22,787.00 1,162,50 0,00 15,558.29 1,069.11 6,159.60 72.97 5611.-56250 DUES & SUBSCRIPTIONS 8,803.00 280,00 0.00 7,558.00 0.00 1,245.00 85,86 5611-56310 IiNSURANCE 1,078.0E 0.00 0.00 303.00 0.00 775.00 28.11 5611-5651.0 AUDIT & LEGAL C,TRVICES 82,750.00 726,58 0.00 58,715.73 0.00 24,034.27 70.96 5611-56570 ENGINEERING/ARCHITECTURAL 37,000,03 845,.00 1 ,00 12,465.00 0.00 24,535.00 33.69 5611-56610 UTILITIES-ELECTRIC 1,500.00 409.59 0.00 1,409.99 0.00 2,090.01 40.29 TOTAL CONTRACTUAL SERVICES 1,42.3,740.00 205,175.62 0.00 582,912.35 1,572.38 839,255.27 41.05 a-ny-zozz oo.«o ^w czz~ OF wxLzo x^oo. 4 movuwvo AND oxrowoo REPORT (nNAuozroo) AS OF. ^uLx 31xT' 2012 Ill-wxLzE ocomomzc uovo^ CORP ou,oLormomr coor-wonc oop^mrMEw,^L oxconn,rnmnS cvmuowr cvmmwr rpzop YEAR ,'r-o ,-r-n avncnr or on000r pupmu ,o ^uunxz. ^cro^L rwcv,Bm^wco axLvmcu avucEr DEBT uonvzcu & cxr, uEeL 56/1-57/10 ooar ocnvzcu 63s,446.00 52'812�91 o�nn 568'8/0.70 0,00 6/,035.30 89.4* 5611 57�/n ayo noar axeowao ___----�L.00 0.00 _----- 0.00 __- 0.00 -_----�0.00 0�00 -_0.00 roc^L 000~ comvzco & cap, mop^ 635'846�00 52'812�9/ o�ou 568'810�70 0.00 67'035.30 ny�v^ cuPzraL nnrLAx �ozI-so`Io L^wo-co^ceaoo enzco ,`o'oon.uu n�ou o�ov `'onmn 0.00 149'n00�00 0�67 56z1 so/2n nuvoLurmomr ,nas v�no 0,00 o�nn 0.00 0.00 u�oo n�oo �3611 bpibu ^uwo-aErrommomro 0.00 n�nu 0.00 0.00 o.00 0.00 0.00 -6/1 5oz/u urpomrx ^ ^LLoxa ^o'noo.00 o on 0,00 n�oo 000 «n'ovo.on n�oo sn/l-b3410 oxwzc^m, xrorw 230'000.00 u�on o�no 218'335�82 0.00 11'664�18 94�93 56/1 5oo'u com,vru« o^uo/unr,w^uo ,,uou.00 o�on n�no ,'n`,�rn 0.00 988�21 5n�59 rvawIrnno u rz,rvnos ,«'snn.^o o�on 0.00 14'600�00 0,00 o�uo 100�00 56/1 5oe/o avzLu,wuu n�vn n oo o�ou o�uo 0.00 0,00 0.00 �oz/ soyoo oomrma cxpzrAL ourL^x 0�00 o�oo 0.00 ______�� o.ou o�uo o�n� ror^^ capzraL ov~LaY ^z^'vun'no v uo o.uv zs"'s4��o, n�ou 201.6,,2 zy -5z.o1 vruEu rImawczmu (USES )9111 TRANSFER TO ^Eumn^` ruwu s'oou.no 0.00 0.00 5'000�00 0.00 u�nn mo�vv 5611-39190 rmansrmm TO rooavuo"^uF zmc 0.00 0.00 0.00 n no 0.00 0.00 0.00 *oz�-�nysn rmuzorr ancoomrzma 0�00 0.00 0.00 -»=«« 0�00 0�00 _0�00 ror^L uroo* r`mxwczmu /v,00/ u'nuu�oo 0.00 0.00 5,000�ov 0.00 o�no ^nn.nu 'TOTAL DEVELOPMENT umvo^om"Emr mou'munr c',s,'r^o�oo 299'012.93 0.00 1'620'223.00 ,'*^u.so 1'145'904�6" sa�+o rvr^L E,ezun`xvnmc z',o,',^a�nn 2e9'012 s, v�on ,'mn'zzz�ou 1'638.36 ,',«n'snu.o« 56.60 -------------- --- ------------- -------------- ------------ _111 nnvxwoo OVER (vaoou) oxvswuzrvvEo ,n«'`a,,vv/ ( 'zs'roz�^s) n�vo z,'on,�z,/ ( ,'ssn.sa) ( 355.834�35) 7.45 °`^ omo OF mopoar °'^ Wylie Economic Development Corporation Inventory Subledger July 31, 2012 Inventory- Land Date of Pur. Address Acreage Improvements Cost Basis Value Sq. Ft. McMasters 7/12/05 709 Cooper 0.48 n/a 202,045.00 Heath 12/28/05 706 Cooper 0.46 32,005 3,625 186,934.22 Perry 9/13/06 707 Cooper 0.491 n/a 200,224.00 Bowland/Anderson 10/9/07 Cooper Dr. 0.372 n/a 106,418.50 KCS 8/1/08 Cooper Dr. 0.406 n/a 60,207.87 Hughes 7/25/06 211 -212 Industrial 0.74 209,801 10,000 420,361.21 R.O.W. 0.18 41,585.26 Prime Kuts 10/8/07 207 Industrial 0.20 182,223 4,550 229,284.00 R.O.W. 0.11 n/a 77,380.45 Cazad 3/17/08 210 Industrial 0.27 128,083 3,900 200,781.55 Ferrell 9/29/05 2806 F.M. 544 1.09 n/a 239,372.00 Sale of R.O.W. 2/14/07 -0.09 -20,094.48 Crossroads 6/12/09 2804 F.M. 544 0.44 24,696 4,750 171,842.02 Regency Pk. 6/4/10 25 Steel Road 0.65 n/a 25,170.77 Premier Plaza 8/26/05 Martinez Lane 25.00 n/a -639,000.00 Sale to Savage 5/28/08 -3.87 -98,917.20 SAF-Holland 12/14/10 Martinez Lane 1.33 n/a -225,514.65 ACE Martinez Lane 22.44 96,000 Premier Industrial Park 7/12/07 Hensley 3.2 n/a 155,000.00 Total 53.88 576,808 122,825 2,296,512.37 *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. *Should lease to term and not execute purchase option, WEDC liable to reimburse ACE for Holland property purchase ($112,500). Wylie Economic Development Corporation Balance Sheet Sub ledger July 31, 2012 Notes Payable Date of Rate of Purchase Payment Beginning Bal. Principal Interest Interest Principal Balance May 31, 2012 $5,155,045.09 Hughes(#72 of 120) 7125106 3,676.29 162,634.22 2,998.65 677.64 5.00 159,635.57 ANBTX(#21 of 60) 10/28/10 8,454.82 311,227.74 7,173.93 1,280.89 4.95 304,053.81 ANBTX-ACE(#12 of 180) 8/1/11 40,681 80 4,681,183.13 17,509.24 23,172.56 5.75 4,663,673.89 June 30, 2012 27,681.82 $25,131.09 $5,127,363.27 Note: Principal and Interest payments vary by date of payment. Wylie Economic Development Corporation AVOIDED TAX SUB LEDGER-Ascend Custom Extrusion July 31, 2012 2011 Amt. Received COW Tax WISD Tax 1/5 of July COW 1/5 of July WISD Total Payment Pmt. Date Ck.# August 4,257.03 7,766.75 851.41 1,553.35 14,428.54 September 4,257.03 7,766.75 851.41 1,553.35 14,428.54 October 4,257.03 7,766.75 851.41 1,553.35 14,428.54 November 4,257.03 7,766.75 851.41 1,553.35 14,428.54 December 4,257.03 7,766.75 851.41 1,553.35 14,428.54 1/4/2012 WISD-52923 Total 21,285.15 38,833.75 4,257.05 7,766.75 72,142.70 COW-52915 2012 Amt. Received COW Tax WISD Tax Total Payment January 4,257.03 7,766.75 12,023.78 February 4,257.03 7,766.75 12,023.78 March 4,257.03 7,766.75 12,023.78 April 4,257.03 7,766.75 12,023.78 May 4,257.03 7,766.75 12,023.78 June 4,257.03 7,766.75 12,023.78 July 4,257.03 7,766.75 12,023.78 August September October November December Total 29,799.21 54,367.25 84,166.46 WYLIE ECONOMIC DEVELOPMENT CORPORATION SALES TAX REVENUE FOR THE MONTH OF AUGUST 2012 MONTH WEDC WEDC WEDC DIFF % DIFF 2010 2011 2012 11 VS 12 11 VS 12 DECEMBER $81,014 $103,687 $112,676 $8,989 11.10% JANUARY 91,593 100,999 118,175 17,176 17.01% FEBRUARY 153,281 158,204 171,759 13,555 8.57% MARCH 89,717 104,670 113,571 8,900 8.50% APRIL 89,119 98,463 115,114 16,650 16.91% MAY 144,953 158,379 154,424 -3,955 -2.50% JUNE 111,174 116,832 119,326 2,494 2.13% JULY 99,065 119,527 125,555 6,028 5.04% AUGUST 144,373 157,310 155,875 -1,436 -0.91% SEPTEMBER 98,102 123,153 OCTOBER 96,010 118,827 NOVEMBER 145,337 163,346 Sub-Total $1,343,739 $1,523,400 $1,186,475 $68,401 6.12% AUDIT ADJ TOTAL $1,343,739 $1,523,400 $1,186,475 $68,401 6.12% WEDC SALES TAX ANALYSIS $200,000 , n_........ w w. $180,000 $160,000 $140,000 $120,000 -- 02011 $80,000 •2012 $60,000 q ._ $40,000 $20,000 in E > > ro Q ' -) rn E o co 0 Z Wylie City Council AGENDA REPORT Meeting Date: August 28, 2012 Item Number: E. Department: Public Services (City Secretary's Use Only) Prepared By: Robert Diaz Account Code: Date Prepared: August 28, 2012 Budgeted Amount: Exhibits: 1 Subject Consider, and act upon, Wylie East High School vendor registration to hold a carnival fundraiser benefiting Wylie East High School scholarships at Olde City Park on September 24, 2012. Recommendation Motion to approve the Wylie East High School vendor registration to hold a carnival fundraiser benefiting Wylie East High School scholarships at Olde City Park on September 24, 2012. Discussion The Parks and Recreation Board unanimously approved the vendor registration at their August 20, 2012 meeting for Wylie East High School to host a carnival fundraiser during their homecoming parade at Olde City Park on September 24, 2012. The vendor registration form is attached to this agenda report for review. Approved By Initial Date Department Director MS 08/21/2012 City Manager MM August 23, 2012 Page 1 of 1 , W I ,.,,,, NRKS AND MAREN! I1 )N CITY OF YLIE 300 Country Club,Building 100,Wylie,TX 75098 972.,,16.6340 VENDOR REGISTRATiON-Once approved bv City Council vendor has 7 days to finalize event with Parks 84 Recreation acilitv sta '.Recommended timeline or submission to Park Board is 3-4 nzoth ns in advance o event. Group, Organization, Individual, etc. Name - Phone Number Address ef tiz,,,, Alternate Phone Number oil -0 TJ Milligtra City/State/Zip E-mail ., / Ti -7 tsoc4g ma gi .___A__Dis Ai irffildrOMP tRrairlrareihVIS r—I Contact Person Name Phone Number D!iurT _ ) - 1- 6'c''') T5i1 -7 Address Alternate Phone Number raq City/State/Zip E-mail tbcILA e -trii :-i. i ,_ (41 a,,,J0( L,,,,A, • \,.7 k.,v0<;:ri Emergency Contact Name Phone Number ---1 i Address Alternate Phone Number I City/State/Zip E-mail --,-. e— el • -')C)e'''? -rete, ,ecle- "--)t 1 ,,''' `',., , 1 Event information Event Name , ( Type of Event Purpose of Event L-, i r Location Proposed Event Date(s) Pt* ' I i Lq- Number of Individuals Vending Items Start Time End Time „ . Anticipated Number in Attendance Event Target Audience L5a [ o2IJ Specific Items to be Sold ----7, CfreA) ilki A L, 6A-Ty)o , cr-c, , 1 NOTE: If food is prepared on-site or off-site and brought to the location to be sold,the vendor must contact the City Inspections Office(972.516.6420)in order to obtain a Health Permit prior to the sale of such products.An inspector must examine the food preparation and food storage equipment to assure the health and safety of customers. Section 78-105 of the City Code of Ordinances states:it shall be unlawful for any person to solicit for sale,vend,peddle,sell or offer to sell any cold drinks,cigars,tobaccos,cigarettes,fruits, candies,goods,wares or merchandise of any kind or nature whatsoever within the city park or recreation or community center facility;provided,however,that this section shall not apply to any person,organizations,firms or corporations,or the agents of any person,or organization,firm or corporation,or employees of any person who are recommended by the parks and recreation board and approved by the city council to operate a concession or concessions for the sale of specified goods,or wares and merchandise within the city park or recreation or community center facilities of the city. Rev.7.22.11 Wylie City Council AGENDA REPORT Meeting Date: August 28, 2012 Item Number: F. Department: Public Services (City Secretary's Use Only) Prepared By: Robert Diaz Account Code: Date Prepared: August 28, 2012 Budgeted Amount: Exhibits: 1 Subject Consider, and act upon, Wylie Youth Soccer Association vendor registration to host a fundraiser "Casino Night" event at the Bart Peddicord Community Center on November 3, 2012. Recommendation Motion to approve the Wylie Youth Soccer Association vendor registration to host a fundraiser"Casino Night" event at the Bart Peddicord Community Center on November 3, 2012. Discussion The Parks and Recreation Board unanimously approved the vendor registration at their August 20, 2012 meeting for the Wylie Youth Soccer Association to host a fundraiser "Casino Night" event at the Bart Peddicord Community Center on November 3, 2012. The vendor registration form is attached to this agenda report for review. Approved By Initial Date Department Director MS 08/21/2012 City Manager MM August 23, 2012 Page 1 of 1 From: 08/08/2012 07:06 #261 P.001 /001 ,..,..._d _ PARKSAND RI•;C-ftl•x1'IoN CITY OF WYLIE 300 Country Club, Building 100,Wylie,TX 75098 V' 972.516.6340 VENDOR REGISTRATION-Once approved by City Council vendor has 7 days to finalize event with Parks& Recreation facility staff Recommended timeline for submission to Park Board is 3-4 months in advance of event. Refer to Cit of W he Code of Ordinances Section 78-105, Parks and Recreation, Peddling and vending of articles Group,Organization, Individual,etc. Name / Phone Number I YY • i n9 F 6 R(o �iif iS t ) 1 r iq"'io - 2dS Address Alternate Phone Number I tin ra;i hE 0,rea .br' I Wig- L L/a- 613)-o Ci /State/Zip E-mail Cont t Person Name Phone Number I. t ..t')'IIl't.i41hor S Address 0Q Alternate Phone Number City/State/Zip E-mail Emergency Contact Name Phone Number I ‘-ebilliP 1 hOnlaS I I Address Alternate Phone Number City/State/Zip E-mail Event Information Event Name I r di Fc � A-ir1 s 116 i / 1 Type of Eve t Purpose of Event trio NW `'Prizes Pei ranhlikl" I I ray_n?a ey fvr-fix. Co lkse Location Proposed Event Date(s) I Aar f- ee4toard 1-3-at-AP, Number of Individuals Vending items Start Time End Time / �r-:•CO I lr=na Anticipated Number in Attendance Event Target Audience /[30 /)-. .- I ¢ �. '#'x ill) I- -f-rYLu ie c, I Specific Items to be Sold NOTE: If food is prepared on-site or off-site and brought to the location to be sold,the vendor must contact the City Inspections Office(972.516.6420)in order to obtain a Health Permit prior to the sale of such products.An Inspector must examine the food preparation and food storage equipment to assure the health and safety of customers. Of Wylie City Council ,, , AGENDA REPORT Meeting Date: August 28, 2012 Item Number: 1. Department: Engineering (City Secretary's Use Only) Prepared By: Chris Hoisted Account Code: N/A Date Prepared: August 10, 2012 Budgeted Amount: N/A Exhibits: Rate Study, Ordinance Subject Consider, and act upon, Ordinance No. 2012-26 amending Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. Recommendation Motion to approve Ordinance No. 2012-26 amending Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. Discussion On December 14, 2010 Council held a work session to discuss the water and sewer rate study prepared by McLain Decision Support Systems. The study incorporates the water and sewer capital improvements plan (CIP), outstanding debt service, the proposed wholesale water rate increases from the North Texas Municipal Water District, the transfer to the general fund, and the expansion of the Public Works Service Center. The report was updated in June, 2011 based on information contained in the Indirect Cost Study which identified personnel expenses attributable to the utility fund. An approximately 6.75% increase per year over the three years is proposed in the updated rate study. The attached ordinance incorporates these recommendations into the water and sewer rates for FY 2013. Approved By Initial Date Department Director CH 8/10/2012 City Manager MM August 23, 2012 Page 1 of 1 ORDINANCE NO. 2012-26 AN ORDINANCE OF THE CITY OF WYLIE, TEXAS; AMENDING SUBSECTION B (WATER RATES) AND SUBSECTION C (SEWAGE COLLECTION AND TREATMENT RATES) OF SECTION 1 (WATER AND SEWER FEES) OF THE WYLIE COMPREHENSIVE FEE SCHEDULE; PROVIDING FOR A PENALTY FOR THE VIOLATION OF THIS ORDINANCE; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE OF THIS ORDINANCE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION OF THIS ORDINANCE. WHEREAS, the City Council of the City of Wylie, Texas ("City Council") has adopted Ordinance No. 2009-12 establishing a comprehensive fee schedule ("Comprehensive Fee Ordinance")for the City of Wylie, Texas ("Wylie"); and WHEREAS, the Comprehensive Fee Ordinance includes fees for water and sewer; and WHEREAS, the City Council has investigated and determined that it would be advantageous and beneficial to the citizens of Wylie to amend Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. 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: Amendment to Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. Amendment to the Wylie Comprehensive Fee Schedule Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule are hereby amended as identified in Exhibit "A", attached hereto and incorporated herein for all purposes. SECTION 3: Penalty Provision. Any person, firm, corporation or entity that violates this Ordinance shall be deemed guilty of a misdemeanor and upon conviction thereof shall be fined a sum not exceeding two thousand dollars ($2,000.00) if the violation relates to the public health and sanitation, otherwise the fine shall be a sum not exceeding 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 Wylie from filing suit to enjoin the violation. Wylie retains all legal rights and remedies available to it pursuant to local, state and federal law. SECTION 4: Savings/Repealing Clause. 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 Ordinance No.2012-26 Amendment to the Wylie Comprehensive Fee Schedule Page 1 prosecution from being commenced for any violation if occurring prior to the repeal of the ordinance. Any remaining portions of said ordinances shall remain in full force and effect. SECTION 5: 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. Wylie hereby declares that it would have passed this Ordinance, and each section, subsection, clause or phrase thereof irrespective of the fact that any one or more sections, subsections, sentences, clauses, and phrases be declared unconstitutional or invalid. SECTION 6: Effective Date. This Ordinance shall become effective from and after its passage and publication as required by the City Charter and by law. DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF WYLIE, TEXAS, on this 28th day of August, 2012. Eric Hogue, Mayor ATTESTED AND CORRECTLY RECORDED: Carole Ehrlich, City Secretary Date to be published in The Wylie News—September 5,2012 Ordinance No.2012-26 Amendment to the Wylie Comprehensive Fee Schedule Page 2 Exhibit "A" WYLIE COMPREHENSIVE FEE SCHEDULE I. WATER AND SEWER FEES. B. Water Rates. (1) The following monthly water rates shall apply to all domestic residential customers within the corporate limits of the City of Wylie, Texas. ALL PRICES ARE FOR 1,000 GALLONS OF METERED WATER. (a) Monthly minimum charge for first 1,000 gallons of metered water consumption: $10.67 (b) Volume charge for all consumption exceeding 1,000 gallons: 1,001 to 10,000 gallons: $3.59 Over 10,000 gallons: $4.67 (2) The following monthly water rates shall apply to all domestic commercial customers, (other than apartments, mobile home parks and other multi-unit dwellings not individually metered) within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water consumption: $14.57 (b) Volume charge for all consumption exceeding 1,000 gallons: $4.08 (3) The following water rates shall apply to all domestic apartments, mobile home parks, and other multi-unit dwellings, not individually metered, within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water $14.57 (b) Volume charge for all consumption exceeding 1,000 gallons $4.08 (4) The following monthly water rates shall apply to all irrigation meters within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water: (1)Residential irrigation $10.67 (2) Commercial & Multifamily $14.57 Ordinance No.2012-26 Amendment to the Wylie Comprehensive Fee Schedule Page 3 (b) Volume charge for all consumption exceeding 1,000 gallons: (1)Residential irrigation $5.16 (2) Commercial irrigation $5.16 (5) The monthly water charge for any customers (residential, commercial, apartment, mobile home park, or other multi-unit dwelling not individually metered) located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the corporate limits of the City. (6) Any bulk water customer who desires to withdraw water from a hydrant or other source not metered and charged directly to them, shall fill out a water application form and sign the form in the same manner as a regular metered customer. Bulk water rate charges are to be charged in twenty-five (25) gallon increments at the same rates as the commercial customers. C. Sewage Collection and Treatment Rates. (1) The following monthly sewage collection and treatment rates shall apply to all residential customers of the City of Wylie, Texas: (a) Customers who are 65 years of age or older and have a homestead exemption on the service address which appears in the tax records $23.59 (b) Customers who are disabled and have a homestead exemption on the service address which appears in the tax records $23.59 (c) All other customers $31.98 (2) The following monthly sewage collection and treatment rates shall apply to all commercial customers of the City of Wylie, Texas: (a) Monthly minimum charge first 1,000 gallons of metered water . $25.79 (b) Volume charge for all consumption exceeding 1,000 gallons .$ 2.18 (3) The following monthly sewage collection and treatment rates shall apply to each apartment unit, multiple-family unit, or mobile home space and special areas such as washateria, swimming pools, etc., where the apartment, multiple-family development or mobile home park is on a master meter for water consumption with the City of Wylie, Texas: (a) Monthly charge $31.98 (4) The monthly sewer charge for any customers (residential, commercial, apartment, mobile home park, or other multi-unit dwelling not individually metered) located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the corporate limits of the City. Ordinance No.2012-26 Amendment to the Wylie Comprehensive Fee Schedule Page 4 (5) The monthly water and sewer rate charge for residential and commercial customers located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the corporate limits of the City. Ordinance No.2012-26 Amendment to the Wylie Comprehensive Fee Schedule Page 5 I. AT A T AT Ism - AT I OF Y1_1E, TEXAS EVISED JUNE 20, 2011 Mciikain Adi '''''''1** Decision All , Suriport, ' Systems : - ,%hobo,' McLA1N Government Utility Rate Group 2201 Rockbrook Dr., Suite 1315 Lewisville, TX 75067 (214) 488-8808-Fax(972) 692-5397 bob(@mclaindss.corn MGLABH June 20, 2011 Linda Bantz Director of Finance City of Wylie 2000 Hwy. 78 North Wylie, TX 75098 Re: Final Report on Water& Wastewater Rates Dear Ms. Bantz: Enclosed is the Final Report on Water & Wastewater Rates, prepared by McLain Decision Support Systems (McLainDSS) for the City of Wylie. The report conveys the findings, conclusions, and recommendations of our firm with respect to the development of water rates to cover the projected water and wastewater costs for the period 2011 - 2019. The report is structured to provide the reader with a clear and accurate presentation of the revenue and rate issues facing the City of Wylie. However, this study does not constitute an examination of the financial statements of the City of Wylie, and, as such, we cannot and do not express any opinion regarding the validity or accuracy of the financial information provided. The report includes a significant amount of assumptions and detailed tables and worksheets. The detailed tables, exhibits, and worksheets provide an understanding of where the numbers come from and the related impact the rates will have on the City's customers. We have appreciated the courtesies and professional relationship extended to us during this engagement by the City's management and staff. Very truly yours, 7? ,7 ( `1 Robert McLain McLain Decision Support Systems Table of Contents I. Executive Summary 1 1.1 Purpose of Report 1 1.2 Questions to be Answered with this Report 1 1.3 Findings/Analysis Related to the Cost of Service 2 1.4 Findings/Analysis Related to the Existing Rate Design 6 1.5 Benchmarking With Other Cities 9 II. Identify Revenue Requirements 10 2.1 Purpose of This Section 10 2.2 Key Cost of Service Assumptions 10 2.2.1 Growth Assumptions 11 2.2.2 Additional Staffing 13 2.2.3 Salaries & Benefits 14 2.2.4 NTMWD Water Purchase Costs 15 2.2.5 NTMWD Wastewater Treatment Costs 17 2.2.6 Other Operating& Maintenance Costs 21 2.2.7 Non-Operating Costs 26 2.2.8 Existing and planned debt 26 2.2.9 Revenue Offsets 30 Appendix A— Supporting Worksheets List of Figures I. Executive Summary 1 Figure 1: NTMWD Water Rate/1,000 Gallons 2 1.1 Impact of Financing Scenarios 4 1.2 Impact on Average Combined Water& Wastewater Bills @ 8,000 Gallons 5 1.3 Financing Scenarios—Water 7 1.4 Financing Scenarios—Wastewater 8 Figure 2: Benchmarking with other Cities -Residential 9 II. Identify Revenue Requirements 10 2.1 Growth-Water 11 2.2 Growth—Water Billed for Wastewater 12 2.3 Existing& Projected Staffing Levels 13 2.4 Existing& Projected Salary & Benefit Costs 14 2.5 Water Purchases from NTMWD 15 2.6 Calculation of the Incremental Increase in NTMWD Water Purchase Cost per Th. Gallons .. 16 2.7 Wastewater Treatment Costs—NTMWD Muddy Creek Wastewater Treatment Plant 17 2.8 Wastewater Treatment Costs—NTMWD Muddy Creek Interceptor 18 2.9 Recap of Wastewater Treatment Costs 19 2.10 Calculation of the Incremental Increase in NTMWD Wastewater Cost per Th. Gallons 20 2.11 Recap of Operating and Maintenance Costs—Utility Administration (5711) 21 2.12 Recap of Operating and Maintenance Costs—Water Distribution (5712) 22 2.13 Recap of Operating and Maintenance Costs—Engineering (5713) 23 2.14 Recap of Operating and Maintenance Costs— Sewer Collection (5714) 24 2.15 Recap of Operating and Maintenance Costs—Utility Billing (5715) 25 2.16 Recap of Existing Water and Wastewater Debt Service Payments 27 2.17 Recap of Non-Operating Costs 28 2.18 Recap of the Gross Cost of Service 29 2.19 Recap of Revenue Offsets - Services 30 2.20 Recap of Revenue Offsets—All Other Revenue Offsets 31 2.21 Existing& Projected Total Sources of Funds 32 2.22 Recap of the Sources & Uses of Funds 33 Appendix A— Supporting Worksheets mwt � ^ » ¥w® Decision t \ sa .pp a! � t 111111101111P' Systems� cLA N ± . II X MeLAIN ALA SECTIONI Y 1.1. PURPOSE OF REPORT: The following report describes the findings of the water and wastewater rate study performed for the City of Wylie, and makes recommendations with respect to the rates to be charged to the City's customers. The objectives to be achieved within the scope of the engagement are as follows: ▪ To develop the bases to be used to project the water and wastewater units of service and cost of service over a multi-year planning period, FY 2011 - 2019; ■ To identify the full cost of the water and wastewater services over the multi-year planning period, based on the FY 2011 adopted budget; ■ To develop cost-based water and wastewater rates which will provide sufficient annual revenues to meet expenditures for all operating and non-operating costs; ■ To develop alternative water and wastewater rates which will provide sufficient annual revenues to meet expenditures for each system's operating and non-operating costs; ■ To prepare financial projections using the alternative, supplemented by a description of the key assumptions underlying the projections; ■ To create an executive summary documenting our findings and recommendations. 1.2. QUESTIONS TO BE ANSWERED WITH THIS REPORT: There are several questions that will be answered with this report: ■ What is the impact of the increased North Texas Municipal Water District(NTMWD) water purchase costs on overall water revenues required from water rates over the next ten years? (from $1.25 in FY 2010 to $2.03 in FY 2019). ■ What is the impact of the increased North Texas Municipal Water District(NTMWD) wastewater collection and treatment costs on overall wastewater revenues required from wastewater rates over the next ten years? ■ What is the impact of increasing the reimbursement to the General Fund by almost $800,000 in FY 2011, from $450,000 to $1,247,612, and then to $1,676,997 in FY 2012? SECTIONI—EXECUTIVE UMMA { PAGE 1 It II , X MoLAIN ALA What is the impact of eliminating the transfer of$1,500,000 to $0 in FY 2012? 1.3. FINDINGS/ANALYSIS RELATED TO THE COST OF SERVICE: ▪ The water and wastewater enterprise fund was in good financial condition as of 09/30/2009. The water and wastewater fund ended FY 2009 with $9,820,167 in operating reserves (working capital) (377 days of total expenditures). ■ The cost of water charged to the City of Wylie by the NTMWD is expected to almost double over the next ten years. Following is a chart illustrating these increases. Figure 1 NTMWD Water Rate/1,000 Gallons $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 FY 2002 $0.72 FY 2003 $ .87 FY 2004 0.92 FY 2005 , ,,,,,,,,, ,J $0.97 FY 2006 >,k OM,;/;,,M4„ $0.97 FY2007 $1.02 FY 2008 , $1.08 FY 2009 < ««««< /,/,, « ««««< ««, $1.18 FY2010 ,t $1.30 FY 2011 $ .37 FY2012 , $1.57 FY 2013 ,r «««««««J 7, ««««< «««<) ««««< «««<( $1.70 FY2014 I ,,, $1 :3 FY 2015 p,,, mm, ,w _ /,,,, ,,,,, F $1.94 FY 2016 �; $2 04 FY 2017 ,„ ,,,,_; , ) $2.13 FY 2018 , ,,t $2.18 FY 2019 ,, ,,,,,,,,, , ,,,,,,,,,,,,,,,,,, $2.24 The increased cost per 1,000 gallons, along with increased water purchase volume due to growth, with increase the water payments to NTMWD from $2,066,680 in FY 2010 to $3,339,955 in FY 2019 (62%). SECTION I—EXECUTIVE SUMMARY PAGE 2 II X MeLAIN ALA ▪ Additionally, the average cost per 1,000 gallons for wastewater collection and treatment charged to the City of Wylie is expected to increase substantially over the next ten years. Wastewater payments to NTMWD are expected to increase from $3,394,265 to $4,713,025 in FY 2019 (39%). ■ These increased costs, along with the minimization of the assistance from impact fees, will cause the net increase in the cost of service to be about $2,500,000 in FY 2012 (28%), and 66% by FY 2019. This will necessitate increasing rates by40% to 41% over the next nine years. ■ Financial Plan Notice. Water and wastewater costs have been projected for the period FY 2012 through FY 2019, based on the FY 2011 adopted budget. We believe the underlying assumptions that drive the cost of service through the FY 2019 provide a reasonable basis for management's forecast. However, some assumptions inevitably will not materialize as presented and anticipated events and circumstances may not occur; therefore, the actual results achieved during the forecast periods will vary from the forecast, and the variances may be material. Monitor expenditures very carefully over the planning period, compared to the expenditure levels shown in this report. Because the forecasts are developed upon expenditure levels outlined in this report, any significant increases of expenditures over the planned expenditure levels will affect the sufficiency of revenues over the study period. r Table 1.1 shows the impact of the rate increases. s . t • Days • r t ;•e x [tures Fiscai in r ti n T r et Year evenues •ese es says 2009 N/A $16,264,529 625 2010 N/A 10,138,905 343 2011 5.25% 10,835,230 351 2012 6.75% 5,899,472 173 2013 6e75% 4,765,303 133 2014 6.75% 3,958,411 106 2015 6.75% 3,547,279 91 2016 4.00% 3,650,028 92 2017 3.00% 3,840,238 93 2018 3.00% 4,058,560 95 2019 3.00% 4,367,385 98 3 SECTION 1—EXECUTIVE SUMMARY PAGE y Table 1.2 illustrates the impact of the financial forecast on the average residential users. "' i i 1 r 1 int i • si nti l ater , Wastewater :ills , i allons, it 3.5 illion r is r till % 2010 $ 56.83 $ o 2011 59.71 2a 8 5.1% 2012 63.60 3.90 6.5% 2013 7.76 4.16 6.5® 2014 72.20 4044 6a l 2015 704 4.74 6.6% 2016 79.94 3.00 3.9% 2017 2®2 2.34 2.9% 2018 4.6 2®41 2.9% 2019 7.1 2a4 2.9% $ 27A6 4 .3% SECTION 1—EXECUTIVE SUMMARY PAGE 1.4. FINDINGS/ANALYSIS RELATED TO THE EXISTING RATE DESIGN: ▪ Water Monthly Minimum Bills: The existing water rate design consists of a water residential monthly minimum bill of$8.90, and has not increased in the last decade. The monthly minimum bill for the non-residential meters is $12.15, and also has not changed in many years. One thousand gallons (1,000)is included in the monthly minimum bill for both residential and non-residential. ■ Water Volumetric Rates: The volumetric water rates for the residential class consists of a conservation rate, where a rate per thousand gallons of$2.99 is charged for any monthly consumption up to 10,000 gallons, and $3.89 for any monthly consumption greater than 10,000 gallons. The rate per thousand gallons for the non-residential class is $3.40, and the sprinkler rate per 1,000 gallons is $4.30. The existing rate design for water is illustrated on Table 1.3. ■ Wastewater Monthly Minimum Bills: The existing residential wastewater rate design consists of a monthly minimum bill of $27.00, regardless of meter size or customer class. The existing non-residential wastewater rate design consists of a monthly minimum bill of$21.50, regardless of meter size or customer class. One thousand gallons (1,000)is included in the monthly minimum bill for the non-residential class. ■ Wastewater Volumetric Rates: There is no volumetric rate charged to residential customers. The non-residential volumetric wastewater water rate design consists of a rate per 1,000 gallons of$1.82 for any water consumption over 1,000 gallons. The existing rate design for wastewater is illustrated on Table 1.4. SECTION I—EXECUTIVE SUMMARY PAGE MeLAIN Tad- 1. Pro•ose• gates ater ith$3.5 'Ilion Drawdown in FY 2012 Existing Proposed Planned Planned Planned 2011 2011 2012 2013 2014 (2) (2) (3) (4) (5) 1 Outside to Inside Ratio 1.15 1.15 1.15 1.15 1.15 Monthly Minimum Bills: 2 Residential $ 8.90 $ 9.37 $ 10.00 $ 10.67 $ 11.40 Non-Res denti a I 12.15 12.79 13.65 14.57 15.56 Residential: 4 1,001-10,000 $ 2.99 $ 3.15 $ 3.36 $ 3.59 $ 3.83 5 Over 10,000 3.89 4.09 4.37 4.67 4.98 Nan-Residential: 6 Over 1,000 $ 3.40 $ 3.58 $ 3.82 $ 4.08 $ 4.35 Sprinkler Meters: 7 Over 1,000 $ 4.30 $ 4.53 $ 4.83 $ 5.16 $ 5.51 8 From Monthly Minimum OH $ 1,191,758 $ 1,254,325 $ 1,358,191 $ 1,470,364 $ 1,591,492 9 From Volume Rates 3,766,117 3,963,838 4,278,314 4,617,180 4,982,304 10 Total Revenues Generated $ 4,957,875 $ 5,218,163 $ 5,636,505 $ 6,087,544 $ 6,573,797 11 Avg.Res,Mon.OH 8,000 Gallons $ 29.83 $ 31.40 $ 33.52 $ 35.78 $ 38.19 12 Monthly Difference-$ NJA 1.57 2.12 2.26 2A1 13 Monthly Difference-% NJA 5.3% 6.7% 6.7% 6.7% 14 Avg.Commercial 1 Inch Mon.Bill @ 27,000 Gallons $ 100.55 $ 105.83 $ 112.97 $ 120.60 $ 128.74 15 Monthly Difference-$ NJA 5.28 7.14 7.63 8.14 16 Monthly Difference-% NJA 5.2% 6.8% 6.7% 6.7% 17 Avg.Sprinkler 2 Inch Mon.Bill @ 60,000 Gallons $ 265.85 $ 279.81 $ 298.69 $ 318.86 $ 340.38 18 Monthly Difference-$ NJA 13.96 18.89 20.16 21.52 19 Monthly Difference-% NJA 5.2% 6.7% 6.8% 6.7% 20 Avg.Industrial 3/4 Inch Mon.OH @ 300,000 Gallon $ 1,028.75 $ 1,082.76 $ 1,155.85 $ 1,233.87 $ 1,317.15 21 Monthly Difference-$ NJA 54.01 73.09 78.02 83.29 22 Monthly Difference-% NJA 5.3% 6.8% 6.7% 6.7% SECTION I v EXECUTIVE SUMMARY PAGE 7 MAIN it X .t. . t Ta.le lA Proposed Rates- astewater With$3.5 Million Drawdown in FY 2012 Existing Proposed Planned Planned Planned Planned 2011 2011 2012 2013 2014 2015 (2) (2) (3) (4) (5) (6) 1 Outside to Inside Ratio Monthly Minimum Bilis: 2 Res identi a $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 I Mul ti-Fa mi y I ncl udes 3 Residential $ 27.00 $ 28.31 $ 30.09 $ 31.98 $ 34.01 $ 36.17 4 Multi-Family 27.00 28.31 30.09 31.98 34.01 36.17 Commerca 21.50 22.63 24.16 25.79 27.53 29.39 6 East Fork Residential 27.00 28.31 30.09 31.98 34.01 36.17 7 East Fork Seniors 20.00 20.95 22.22 23.59 25.05 26.60 8 East Fork Commercial 21.50 22.63 24.16 25.79 27.53 29.39 9 Northeast Residential 27.00 28.31 30.09 31.98 34.01 36.17 10 Northeast Seniors 20.00 20.95 22.22 23.59 25.05 26.60 11 Northeast Commercial 21.50 22.63 24.16 25.79 27.53 29.39 Volumetric Rates: 12 Residential $ - $ - $ - $ - $ - $ 13 Multi-Family 14 Commercial 1.82 1.92 2.04 2.18 2.33 2.49 15 East Fork SUD Residential 16 East Fork SUD Seniors 17 East Fork SUD Commercial 1.57 1.65 1.76 1.88 2.01 2.15 18 Northeast SUD Res identi a I 19 Northeast SUD Seniors 20 Northeast SUD Commercial 1.57 1.65 1.76 1.88 2.01 2.15 21 From Monthly Minimum Bill $ 4,128,722 $ 4,345,480 $ 4,706,212 $ 5,095,845 $ 5,516,635 $ 5,971,013 22 From Volume Rates 248,068 261,091 278,715 297,528 317,611 339,050 23 Tota Revenues Generated $ 4,376,790 $ 4,606,571 $ 4,984,927 $ 5,393,373 $ 5,834,246 $ 6,310,063 l 5.2% 6.8% 6.7% 6.7% 6.8% 25 Avg.Res.Mon.Bill @ 8,000 Gallons $ 27.00 $ 28.31 $ 30.09 $ 31.98 $ 34.01 $ 36.17 26 Monthly Difference-$ N/A 1.31 1.78 1.90 2.02 2.16 27 Monthly Difference-% N/A 4.9% 6.3% 6.3% 6.3% 6.4% 28 Avg.Commercial 1 Inch Mon.Bill @ 27,000 Gallons $ 68.82 $ 72.43 $ 77.32 $ 82.54 $ 88.11 $ 94.06 29 Monthly Difference-$ N/A 3.61 4.89 5.22 5.57 5.95 30 Monthly Difference-% N/A 5.3% 6.7% 6.7% 6.8% 6.8% 31 Avg.Industrial 3/4 inch Mon.Bill @ 300,000 Gallon $ 565.68 $ 595.38 $ 635.57 $ 678.47 $ 724.26 $ 773.15 32 Monthly Difference-$ N/A 29.70 40.19 42.90 45.80 48.89 33 Monthly Difference-% N/A 5.3% 6.7% 6.7% 6.8% 6.7% PAGE SECTION 1-EXECUTIVE SUMMARY 401 City of Wylie, Texas MCLAIN Update of Water & Wastewater Rates 1.5. BENCHMARKING WITH OTHER CITIES: Figure 2 illustrates how the average residential water and wastewater bills compare with area cities: Figure 2 Comparison of Selected Cities Combined Residential 5/8 x 3/4 inch Water& Wastewater Average Monthly Bill Water Bills, 8,000 Gallons per Month, Wastewater Bills,8,000 Gallons per Month Rockwall 1$43 50 Forney 544.7C Sunnyvale 4'$45 49] Frisco $53 14i Sachse Wylie $56 83 Murphy IF-55768 Wylie-Scenario 1 $59 02 Wylie-Scenario 2 t$59 711 Plano $65 21 Royse City 1$66 85 McKinney $69 441 Garland Rowlett $83.97 $87.66 Princeton Heath $98 85 SECTION I—EXECUTIVE SUMMARY PAGE 9 \ «� ~ Gym / Decision© z\ A \ , z .` Systems z © M LAIN it II X MeLAIN ALA r SECTION IY 2.1. PURPOSE OF THIS SECTION: A ten-year financial plan has been created for the water and wastewater fund using a "bottom- up" approach. Highlights of the City's water and wastewater costs over the planning period are presented in this section. Salaries have been supported by staffing tables. Operating and maintenance costs have been calculated in considerable detail. 2.2. KEY COST OF SERVICE ASSUMPTIONS: Water and wastewater costs were projected for the period FY 2011 through FY 2019, based on the adopted FY 2011 budget. We believe the underlying assumptions that drive the cost of service through the FY 2019 provide a reasonable basis for management's forecast. However, some assumptions inevitably will not materialize as presented and anticipated events and circumstances may not occur; therefore, the actual results achieved during the forecast periods will vary from the forecast, and the variances may be material. These financial projections were based on the following essential assumptions: ■ Growth; ▪ Additional staffing; ▪ Inflation; SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 1 it li xMA trs t tr 2.2.1. Growth assumptions. There is no assumption more critical than the growth assumptions that drive the financial plan. Table 2 1 shows the number of water meters that will be added per year. Table 2 2 shows the number of wastewater connections that will be added per year. Ta le .1 ey Finsin : s Growth - ater Annual Annual Consumption Fiscal Additional Billed Year eters Annual Billings (Th. Gals.) 2008 N/A N/A N/A N/A N/A 2009 238 127,474 N/A 1,331,863 N/A 2010 160 129,394 1.5% 1,213,256 -8.9% 2011 160 131,314 1.5% 1,227,808 1.2% 2012 160 133,234 1.5% 1,242,360 1.2% 2013 160 135,154 1.4% 1,256,911 1.2% 2014 160 137,074 1.4% 1,271,463 1.2% 2015 160 138,994 1.4% 1,286,015 1.1% 2016 160 140,914 1.4% 1,300,566 1.1% 2017 160 142,834 1.4% 1,315,118 1.1% 2018 160 144,754 1.3% 1,329,670 1.1% 2019 160 146,674 2.7% 1,344,221 2.2% SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 11 51 A r, x it I 1 , X MeLAIN t r * t tr t Ta • le .2 Key Findings Growth - ater Billed for astewater Annual Annual Consumption Fiscal Additional Billed Year eters Annual Billings (Th. Gals.) 2008 N/A N/A N/A N/A N/A 2009 222 153,030 N/A 1,232,717 N/A 2010 200 155,430 1.6% 1,127,583 -8.5% 2011 200 157,830 1.5% 1,145,760 1.6% 2012 200 160,230 1.5% 1,163,938 1.6% 2013 200 162,630 1.5% 1,182,116 1.6% 2014 200 165,030 1.5% 1,200,293 1.5% 2015 200 167,430 1.5% 1,218,471 1.5% 2016 200 169,830 1.4% 1,236,648 1.5% 2017 200 172,230 1.4% 1,254,826 1.5% 2018 200 174,630 1.4% 1,273,004 1.4% 2019 200 177,030 2.8% 1,291,181 2.9% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 1 ) MeLAIN t r * t tr ‘ t 2.2.2. Additional staffing. Table 2.3 illustrates the projected staffing levels over the next ten years. Ta • ie 2.3 Existing : Projected 0 perating : aintenance Costs Staffing Levels Utility Water Sewer Utility Fiscal Admin Dist, Engineering Collection Billing Total Year 5711 5712 5713 5714 5715 Staffing 2009 7.00 11.00 4.00 4.00 6.00 N/A 2010 7.00 11.00 4.00 4.00 6.00 32.00 2011 3.00 11.00 3.00 4.00 6.00 27.00 2012 4.00 11.00 4.00 5.00 7.00 31.00 2013 4.00 11.00 4.00 5.00 7.00 31.00 2014 4.00 11.00 4.00 5.00 7.00 31.00 2015 5.00 11.00 4.00 6.00 7.00 33.00 2016 5.00 11.00 4.00 6.00 7.00 33.00 2017 5.00 11.00 4.00 6.00 8.00 34.00 2018 6.00 11.00 4.00 7.00 8.00 36.00 2019 6.00 11.00 4.00 7.00 8.00 36.00 Staffing assumptions were provided by the City of Wylie SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 13 1 x ally III X` , , a a r r • 2.2.3. Salaries & Benefits. Salaries were increased annually using expenditure drivers of 5%, based on the FY 2011 budget. Medical insurance was increased annually at 7.5%. Other benefits were increased as a ratio of salaries. Table 2.4 Existing & Projected Operating & aintenance Costs Salaries& Benefits Utility Water Sewer Utility Fiscal Admin Dist. Engineering Collection Billing % # P P # P Year 5711 5712 5713 5714 5715 Total Incr. 2009 $ 497,726 $ 671,234 $ 370,391 $ 269,737 $ 294,592 $ 2,103,680 N/A 2010 495,265 704,786 391,170 286,310 321,643 2,199,174 4.5% 2011 267,424 634,977 326,466 302,786 331,749 1,863,402 -15.3% 2012 342,283 666,726 357,930 380,690 403,802 2,151,431 15.5% 2013 359,397 700,062 375,827 399,724 423,993 2,259,003 5.0% 2014 377,366 735,065 394,618 419,711 445,192 2,371,953 5.0% 2015 467,414 771,819 414,349 513,429 467,452 2,634,462 11.1% 2016 490,785 810,409 435,067 539,100 490,824 2,766,186 5.0% 2017 515,324 850,930 456,820 566,055 586,949 2,976,079 7.6% 2018 623,489 893,476 479,661 678,555 616,297 3,291,479 10.6% 2019 654,664 938,150 503,644 712,483 647,112 3,456,053 5.0% Percentage Increase FY2010-FY2019-> $ 1,256,879 57.2% SECTION I I- IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 14 City of Wylie, Texas ;' MCLAIN Update of Water & Wastewater Rates • 2.2.4. NTMWD water purchase costs. We have assumed the rate per thousand gallons charged by the North Texas Municipal Water District will increase as follows: Table 2.5 Existing & Projected Operating & Maintenance Costs Water Purchases from NTMWD Planned Annual Consumption Take-or- Actual & Amount Take-or- NTMWD Fiscal Pay Planned Over/(Under) Pay Annual Year Minimum Usage (000's) Minimum Minimum Charges Change 2009 1,721,763 1,503,570 (218,193) $ 1.18 $1,931,462 5.9% 2010 1,721,763 1,369,672 (352,091) 1.25 2,066,680 7.0% 2011 1,721,763 1,386,100 (335,663) 1.37 2,066,680 0.0% 2012 1,721,763 1,402,528 (319,235) 1.52 2,428,731 17.5% 2013 1,721,763 1,418,955 (302,808) 1.65 2,647,112 9.0% 2014 1,721,763 1,435,383 (286,380) 1.78 2,875,727 8.6% 2015 1,721,763 1,451,811 (269,952) 1.83 2,967,259 3.2% 2016 1,721,763 1,468,238 (253,525) 1.88 3,059,447 3.1% 2017 1,721,763 1,484,666 (237,097) 1.93 3,152,293 3.0% 2018 1,721,763 1,501,094 (220,669) 1.98 3,245,796 3.0% 2019 1,721,763 1,517,521 (204,242) 2.03 3,339,955 2.9% Note-the increases projected in the rate per th. gallons are based on a presentation by NTMWD management last year. SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 15 si X' 4 ,-„ '"` McLOUN r & vr Table 2.6 illustrates that the effective cost per 1,000 gallons paid to the NTMWD is significantly higher, due to the take-or-pay provision of the NTMWD agreement. . 411- XiSti 'r jectes * •erati : al te a ce sts Calculation of Incre ental Increase in T D ater urchase Cost er Th. allons Actual Actual Effective Projected Projected Average Incremental NT D Annual ater Increase ater Volume Purchase Average Fiscal Purchase Billed Cost/ Cost/ Year Costs ÷ (Th. Gals.) = Th. Gals. = Th. Gals. From From Supports Table 2.5 Table 2.1 Table 3.3 2009 $ 1,931,462 1,331,863 = $ 1.45 = N/A 2010 2,066,680 1,213,256 = L70 = 0.25 2011 2,066,680 1,227,808 = 1.68 = (0.02) 2012 2,428,731 1,242,360 = 1.95 = 0.27 2013 2,647,112 ÷ 1,256,911 = 2.11 = 0.15 2014 2,875,727 1,271,463 = 2.26 = 0.16 2015 2,967,259 1,286,015 = 2.31 = 0.05 2016 3,059,447 1,300,566 = 2.35 = 0.05 2017 3,152,293 1,315,118 = 2.40 = 0.04 2018 3,245,796 ÷ 1,329,670 = 2.44 = 0.04 * 2019 3,339,955 1,344,221 = 2.48 = 0.04 SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 16 1 ally III , X` McLA,Mr" r r ■ 2.2.5. NTMWD wastewater treatment costs. Tables 2.7 — 2.9 illustrate the assumptions used to forecast the wastewater treatment costs. Table 2.7 Existing & Projected Operating & Maintenance Costs NTMWD Muddy Creek Wastewater Treatment Plant Planned Muddy Muddy Average Planned Muddy Creek Creek Cost per Inflated WWTP Creek Fiscal WWTP Flow Th. at 3% Flow WWTP % Year Costs - (000's) = Gallons = Per Year x (000's) = Costs Incr. 2009 N/A 2010 $ 2,975,786 _ 2,259,974 = $ 1.32 2011 3,030,318 _ 2,327,773 = 1.30 1.8% 2012 $ 1.34 x 2,364,704 = $ 3,170,747 4.6% 2013 1.38 x 2,401,635 = 3,316,875 4.6% 2014 1.42 x 2,438,564 = 3,468,914 4.6% 2015 1.47 x 2,475,496 = 3,627,093 4.6% 2016 1.51 x 2,512,425 = 3,791,637 4.5% 2017 1.55 x 2,549,356 = 3,962,793 4.5% 2018 1.60 x 2,586,287 = 4,140,806 4.5% 2019 1.65 x 2,623,216 = 4,325,930 4.5% Percentage Increase FY2010-FY2019-> 45.4% SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 17 A i s airy III X` ,M McLA air r Table 2.8 Existing Projected Operating & aintenance Costs NTMWD Muddy Creek Interceptor Planned Muddy Muddy Average Planned Muddy Creek Creek Cost per Inflated Interceptor Creek Fiscal Interceptor Flow Th. at 3% Flow Interceptor % Year Costs - (000's) = Gallons = Per Year x (000's) = Costs Incr. 2009 N/A 2010 $ 182,212 + 2,259,974 = $ 0.08 2011 189,507 + 2,327,773 = 0.08 4.0% 2012 $ 0.08 x 2,364,704 = $ 198,289 4.6% 2013 0.09 x 2,401,635 = 207,427 4.6% 2014 0.09 x 2,438,564 = 216,935 4.6% 2015 0.09 x 2,475,496 = 226,827 4.6% 2016 0.09 x 2,512,425 = 237,118 4.5% 2017 0.10 x 2,549,356 = 247,821 4.5% 2018 0.10 x 2,586,287 = 258,954 4.5% 2019 0.10 x 2,623,216 = 270,531 4.5% Percentage Increase FY2010- FY2019-> 48.5% SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 18 A 1 ally III X` , , r r Table 2.9 Existing & Projected Operating & Maintenance Costs Recap of Wastewater Treatment Costs Muddy Muddy Creek Creek WWTP Interceptor Costs Costs Wylie Fiscal From From WWTP Pretreatment % Year Table 2.7 Table 2.8 Costs Costs Adjustment Total Incr. 2009 N/A N/A N/A N/A N/A $ 3,416,478 N/A 2010 2,975,786 182,212 36,485 56,095 143,687 3,394,265 -0.7% 2011 3,030,318 189,507 33,090 58,944 82,406 3,394,265 0.0% 2012 3,170,747 198,289 34,083 60,712 - 3,463,831 2.0% 2013 3,316,875 207,427 35,105 62,534 - 3,621,941 4.6% 2014 3,468,914 216,935 36,158 64,410 - 3,786,417 4.5% 2015 3,627,093 226,827 37,243 66,342 - 3,957,505 4.5% 2016 3,791,637 237,118 38,360 68,332 - 4,135,447 4.5% 2017 3,962,793 247,821 39,511 70,382 - 4,320,508 4.5% 2018 4,140,806 258,954 40,697 72,494 - 4,512,950 4.5% 2019 4,325,930 270,531 41,917 74,668 - 4,713,046 4.4% Percentage Increase FY2010-FY2019-> $ 1,318,781 38.9% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 19 411 '"` McLAM • r r -rade is Existin: : rojecte • eratin: : aintenanse Costs Calculation of T t Incremental aste water Increase in Cost per Th. Gallons Effective Actual & Actual & Average Projected Projected este-- Incremental NT D Annual ater Increase astewater Volume Treatment Average Fiscal Treatment Billed Cost/ Cost/ Year Costs (Th. Gals.) = Th. Gals. = Th. Gals, From From Table 2.9 Table 2.2 2009 $ 3,416,478 a- 1,232,717 = $ 2.77 = N/A 2010 3,394,265 a- 1,127,583 = 3.01 = 0.24 2011 3,394,265 a- 1,145,760 = 2.96 = (0.05) 2012 3,463,831 a- 1,163,938 = 2.98 = 0.01 2013 3,621,941 a- 1,182,116 = 3.06 = 0.09 2014 3,786,417 a- 1,200,293 = 3.15 = 0.09 2015 3,957,505 a- 1,218,471 = 3.25 = 0.09 2016 4,135,447 a- 1,236,648 = 334 = 0.10 2017 4,320,508 o 1,254,826 = 3.44 = 0.10 2018 4,512,950 a- 1,273,004 = 3.55 = 0.10 2019 4,713,046 a- 1,291,181 = 3.65 = 0.11 Note-the effective increase in the average cost per thousand gallons. SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 20 r ' - - r - M 2.2.6. Other Operating & Maintenance Costs. Most other operating and maintenance costs were driven by an annual inflation factor of 3% Table 2.11 Key Findings Recap of Operating Department Cost Utility Administration (5711) Salaries Materials Fiscal & For Contractural % Year Benefits Supplies Maint. Services Total Change From Supports Table 2.4 Table 2.18 2009 $ 497,726 $ 3,907 $ 200 $ 20,327 522,160 3.0% 2010 495,265 5,200 200 69,100 569,765 9.1% 2011 267,424 5,200 200 44,450 317,274 -44.3% 2012 342,283 5,356 206 45,784 393,628 24.1% 2013 359,397 5,517 212 47,157 412,283 4.7% 2014 377,366 5,682 219 48,572 431,839 4.7% 2015 467,414 5,853 225 50,029 523,521 21.2% 2016 490,785 6,028 232 51,530 548,575 4.8% 2017 515,324 6,209 239 53,076 574,848 4.8% 2018 623,489 6,395 246 54,668 684,798 19.1% 2019 654,664 6,587 253 56,308 717,812 4.8% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 21 1 ally III X` ,M `" a a r r Ta • le 2.12 Key Findings Recap of Operating Department Cost ater Distribution (5712) Salaries Materials Fiscal & For Contractural Capital Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2009 $ 671,234 $ 21,150 $ 81,990 $ 227,023 $ 9,985 1,011,381 -4.1% 2010 704,786 40,800 99,700 254,700 10,000 1,109,986 9.7% 2011 634,977 42,375 99,700 258,700 13,000 1,048,752 -5.5% 2012 666,726 43,646 102,691 266,461 13,390 1,092,914 4.2% 2013 700,062 44,956 105,772 274,455 13,792 1,139,036 4.2% 2014 735,065 46,304 108,945 282,688 14,205 1,187,208 4.2% 2015 771,819 47,693 112,213 291,169 14,632 1,237,526 4.2% 2016 810,409 49,124 115,580 299,904 15,071 1,290,088 4.2% 2017 850,930 50,598 119,047 308,901 15,523 1,344,999 4.3% 2018 893,476 52,116 122,618 318,168 15,988 1,402,367 4.3% 2019 938,150 53,679 126,297 327,713 16,468 1,462,308 4.3% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 22 1 airy III X` ,M r" r r Ta • le 2.13 Key Findings Recap of Operating Department Cost Engineering (5713) Salaries Materials Fiscal & For Contractural Capital Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2009 $ 370,391 $ 5,183 $ 129 $ 50,443 $ 308 426,455 0.8% 2010 391,170 12,050 1,100 84,750 - 489,070 14.7% 2011 326,466 18,050 12,750 52,750 25,000 435,016 -11.1% 2012 357,930 18,592 13,133 52,273 25,750 467,677 7.5% 2013 375,827 19,149 13,526 53,841 26,523 488,866 4.5% 2014 394,618 19,724 13,932 55,456 27,318 511,048 4.5% 2015 414,349 20,315 14,350 57,120 28,138 534,272 4.5% 2016 435,067 20,925 14,781 58,833 28,982 558,587 4.6% 2017 456,820 21,553 15,224 60,598 29,851 584,046 4.6% 2018 479,661 22,199 15,681 62,416 30,747 610,704 4.6% 2019 503,644 22,865 16,151 64,289 31,669 638,618 4.6% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 23 A i s ally III X` 411 ,M `" a a r r Ta • le 2.14 Key Findings Recap of Operating Department Cost Sewer Collection (5714) Salaries Materials Fiscal & For Contractural Year Benefits Supplies Maint. Services Total Change From Supports Table 2.4 Table 2.18 2009 $ 269,737 $ 16,131 $ 98,565 $ 109,752 494,185 8.8% 2010 286,310 24,400 71,650 118,300 500,660 1.3% 2011 302,786 27,590 69,150 117,100 635,126 26.9% 2012 380,690 28,418 71,225 120,613 723,000 13.8% 2013 399,724 29,270 73,361 124,231 752,304 4.1% 2014 419,711 30,148 75,562 127,958 782,868 4.1% 2015 513,429 31,053 77,829 131,797 887,481 13.4% 2016 539,100 31,984 80,164 135,751 924,374 4.2% 2017 566,055 32,944 82,569 139,824 962,887 4.2% 2018 678,555 33,932 85,046 144,018 1,087,292 12.9% 2019 712,483 34,950 87,597 148,339 1,133,481 4.2% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 24 1 airy III X` ,M r" r r Ta • le 2.15 Key Findings Recap of Operating Department Cost Utility Billing (5715) Salaries Materials Fiscal & For Contractural Capital Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2009 $ 294,592 $ 10,537 $ 13,916 $ 102,916 $56,659 478,621 -22.3% 2010 321,643 15,054 15,130 187,690 26,500 566,017 18.3% 2011 331,749 16,654 16,294 187,990 26,500 579,187 2.3% 2012 403,802 17,154 16,783 193,630 27,295 658,664 13.7% 2013 423,993 17,668 17,286 199,439 28,114 686,500 4.2% 2014 445,192 18,198 17,805 205,422 28,957 715,574 4.2% 2015 467,452 18,744 18,339 211,584 29,826 745,945 4.2% 2016 490,824 19,307 18,889 217,932 30,721 777,673 4.3% 2017 586,949 19,886 19,456 224,470 31,642 882,403 13.5% 2018 616,297 20,482 20,040 231,204 32,592 920,614 4.3% 2019 647,112 21,097 20,641 238,140 33,569 960,559 4.3% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 25 ▪ 2.2.7. Non-operating costs. The following tables illustrate the other non-operating costs that are incorporated into the financial plan. ▪ 2.2.8. Existing and planned debt. The following tables show the principal and interest payments incorporated into the cost of service. SECTION I I—IDENTIFICATION of REVENUE REQUIREMENTS PAGE 2 A airy III X` ,M r" r r Tasle2.1 . Key Fins ings Components of Non-Departmental Costs (5719) Recap of Existing ater& astewater Debt Service Payments PPFCO All All All Fiscal Series Revenue GO Combo Fiscal r Year 2005 Debt Debt Debt Fees Total Supports Table 2.17 2009 - - - - $ 582,293 2010 151,453 338,010 421,688 577,576 10,000 1,498,727 2011 151,454 - 591,989 576,175 5,000 1,324,618 2012 151,454 - 598,400 579,275 5,000 1,334,129 2013 151,451 - 598,313 576,875 5,000 1,331,639 2014 151,453 - 612,013 578,975 5,000 1,347,441 2015 151,453 - 609,913 580,475 5,000 1,346,841 2016 75,727 - 391,713 576,475 5,000 1,048,915 2017 - - 396,838 576,975 5,000 978,813 2018 - - 293,025 576,875 5,000 874,900 2019 - - 291,087 576,175 5,000 872,262 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 27 A ally III X` , , air r Table 2.17 Key Findings Components of Non-Departmental Costs (5719) Transfer Funding All NTMWD NTMWD to of Other Fiscal Water Sewer Existing General Pwks Non- Year Costs Costs Debt Fund Building Dept. Total From From From Supports Table 2.5 Table 2.9 Table 2.16 Table 2.18 2009 $ 1,931,462 $ 3,416,478 $ 582,293 $ 450,000 $ - $ 189,636 $ 6,569,870 2010 2,066,680 3,394,265 1,498,727 450,000 - 151,910 7,561,582 2011 2,066,680 3,394,265 1,324,618 1,247,612 - 225,320 8,258,495 2012 2,428,731 3,463,831 1,334,129 1,676,997 3,500,000 232,080 12,635,768 2013 2,647,112 3,621,941 1,331,639 1,727,307 - 239,042 9,567,041 2014 2,875,727 3,786,417 1,347,441 1,779,126 - 246,213 10,034,925 2015 2,967,259 3,957,505 1,346,841 1,832,500 - 253,600 10,357,705 2016 3,059,447 4,135,447 1,048,915 1,887,475 - 261,208 10,392,492 2017 3,152,293 4,320,508 978,813 1,944,099 - 269,044 10,664,757 2018 3,245,796 4,512,950 874,900 2,002,422 - 277,115 10,913,183 2019 3,339,955 4,713,046 872,262 2,062,495 - 285,429 11,273,187 SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 28 1 airy III X` , , a a r r Table 2.18 Recap of the Gross Cost of Service Utility Water Sewer Utility Non- Fiscal Admin Dist. Engineering Collection Billing Dept % r r 1 7 7 r Year 5711 5712 5713 5714 5715 5719 Total Incr. From From From From From From Supports Table 2.11 Table 2.12 Table 2.13 Table 2.14 Table 2.15 Table 2.17 Table 2.17 2009 $ 522,160 $1,011,381 $ 426,455 $ 494,185 $ 478,621 $ 6,569,870 $ 9,502,672 N/A 2010 569,765 1,109,986 489,070 500,660 566,017 7,561,582 10,797,080 13.6% 2011 317,274 1,048,752 435,016 635,126 579,187 8,258,495 11,273,850 4.4% 2012 393,628 1,092,914 467,677 723,000 658,664 12,635,768 15,971,651 41.7% 2013 412,283 1,139,036 488,866 752,304 686,500 9,567,041 13,046,029 -18.3% 2014 431,839 1,187,208 511,048 782,868 715,574 10,034,925 13,663,462 4.7% 2015 523,521 1,237,526 534,272 887,481 745,945 10,357,705 14,286,449 4.6% 2016 548,575 1,290,088 558,587 924,374 777,673 10,392,492 14,491,788 1.4% 2017 574,848 1,344,999 584,046 962,887 882,403 10,664,757 15,013,939 3.6% 2018 684,798 1,402,367 610,704 1,087,292 920,614 10,913,183 15,618,959 4.0% 2019 717,812 1,462,308 638,618 1,133,481 960,559 11,273,187 16,185,966 3.6% Percentage Increase FY2010-FY2019-> $ 5,388,886 49.9% SECTION I I- IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 29 1 x ally III X` i ,Mr" air r • 2.2.9. Revenue offsets. The following tables illustrate the projection of the non-rate revenues. Note-these revenues are used to reduce the revenues required from rates. Table 2.19 Key Findings Recap of Revenue Offsets -Service Charges Utility Weekend Water Sewer Turn On/ Water Pre- Inspection Tap Tap Turn Off Sales Treatment Fiscal Fees Penalties Fees Fees Fees Bulk Fees Year (44315) (44515) (44516) P (44517) P (44518) (44519) (44520) Total Supports Table 2.21 2009 1,000 163,618 54,245 6,220 62,275 16,184 38,654 342,196 2010 9,000 160,000 45,000 6,000 60,000 20,000 40,000 340,000 2011 9,000 160,000 45,000 10,000 60,000 10,000 45,000 339,000 2012 9,000 170,544 45,658 10,146 60,877 10,146 45,658 352,030 2013 9,000 181,754 46,316 10,292 61,755 10,292 46,316 365,725 2014 9,000 193,671 46,974 10,439 62,632 10,439 46,974 380,128 2015 9,000 206,339 47,632 10,585 63,509 10,585 47,632 395,281 2016 9,000 221,369 48,290 10,731 64,386 10,731 48,290 412,797 2017 9,000 232,979 48,948 10,877 65,264 10,877 48,948 426,893 2018 9,000 240,450 49,606 11,024 66,141 11,024 49,606 436,849 2019 9,000 249,342 50,264 11,170 67,018 11,170 50,264 448,227 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 30 A i s ally III X` 411 ,M `" a a r a a r Ta • Ie2.21 Key Findings Recap of Revenue Offsets -A11 Other Revenue Offsets Transfer Fiscal Interest Impact From Contributions Year Income Misc. Fees Fleet Fund Sewer Total Supports Table 2.21 2009 $ 191,389 $ 539,801 $ 1,500,000 $ - $ 51,500 $ 2,282,689 2010 30,000 30,000 1,500,000 - - 1,560,000 2011 30,000 35,000 1,500,000 241,440 - 1,806,440 2012 30,000 30,000 - - - 60,000 2013 30,000 30,000 - - - 60,000 2014 30,000 30,000 - - - 60,000 2015 30,000 30,000 - - - 60,000 2016 30,000 30,000 - - - 60,000 2017 30,000 30,000 - - - 60,000 2018 30,000 30,000 - - - 60,000 2019 30,000 30,000 - - - 60,000 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 31 1 x airy III X` , , a a r r Table 2.21 Existing . Projected Total Sources of Funds Waste- Non- Non- Total Water Water Rate Rate Sources Revenues Revenues Operating Operating of Generated Generated Revenue Revenue Funds Fiscal From From From From Supports Year Rates Rates Table 2.19 Table 2.20 Table 2.22 2009 $ 4,858,817 $ 4,218,909 $ 342,196 $ 2,282,689 $ 11,702,612 2010 4,899,029 4,316,790 340,000 1,560,000 11,115,818 2011 5,218,163 4,606,571 339,000 1,806,440 11,970,174 2012 5,636,505 4,984,927 354,460 60,000 11,035,893 2013 6,087,544 5,393,373 370,943 60,000 11,911,860 2014 6,573,797 5,834,246 388,527 60,000 12,856,570 2015 7,097,957 6,310,063 407,298 60,000 13,875,318 2016 7,465,516 6,647,752 421,269 60,000 14,594,537 2017 7,775,637 6,935,029 433,483 60,000 15,204,150 2018 8,097,646 7,233,560 446,075 60,000 15,837,281 2019 8,431,972 7,543,761 459,057 60,000 16,494,791 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 32 A i s airy III X` ,M r" a a r r Ta • le 2.22 Key Findings Recap of the Sources & Uses of Funds Less Total Gross Equals Beginning Sources Cost of Sources Operating of Funds Service Minus Equals Fiscal Reserve From From Uses of Ending Year Balance Table 2.21 Table 2.18 Funds Balance 2009 $ 15,477,878 $ 11,702,612 $ (9,502,672) $ 2,199,940 $ 16,264,529 2010 9,820,167 11,115,818 (10,797,080) 318,739 10,138,906 2011 10,138,905 11,970,174 (11,273,850) 696,324 10,835,230 2012 10,835,230 11,035,893 (15,971,651) (4,935,758) 5,899,472 2013 5,899,472 11,911,860 (13,046,029) (1,134,168) 4,765,303 2014 4,765,303 12,856,570 (13,663,462) (806,893) 3,958,411 2015 3,958,411 13,875,318 (14,286,449) (411,132) 3,547,279 2016 3,547,279 14,594,537 (14,491,788) 102,749 3,650,028 2017 3,650,028 15,204,150 (15,013,939) 190,210 3,840,238 2018 3,840,238 15,837,281 (15,618,959) 218,322 4,058,560 2019 4,058,560 16,494,791 (16,185,966) 308,825 4,367,385 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 33 . . . A \ � ww2 #min y* , y r)ecis ma 1P1II 1 !sems cL AIN' . . . . * Worksheet 1 Financial Summary-Combined Water&Wastewater With$3.5 Million Drawdown_.. Revised Planned Planned Planned Planned Planned Planned Planned Planned` Planned 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Description (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Beginning Working Capital Reserve $ 9,820,167 $ 10,138,905 $ 10,835,230 $ 5,899,472 $ 4,765,303 $ 3,958,411 $ 3,547,279 $ 3,650,028 $ 3,840,238 $ 4,058,560 Water Sa les $ 4,899,029 $ 5,218,163 $ 5,636,505 $ 6,087,544 $ 6,573,797 $ 7,097,957 $ 7,465,516 $ 7,775,637 $ 8,097,646 $ 8,431,972 Sewer Treatment 4,316,790 4,606,571 4,984,927 5,393,373 5,834,246 6,310,063 6,647,752 6,935,029 7,233,560 7,543,761 Bulk Water Sales 20,000 10,000 10,146 10,292 10,439 10,585 10,731 10,877 11,024 11,170 Penalties 160,000 160,000 172,975 186,972 202,070 218,355 229,841 239,569 249,675 260,172 All Other Service Fees 160,000 169,000 171,339 173,679 176,018 178,358 180,697 183,037 185,376 187,715 Interest Income 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Miscellaneous Income 30,000 35,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Transfer from Impact Fee Fund 1,500,000 1,500,000 Transfer from Fleet Fund 241,440 Contributions Service Fees $ 11,115,818 '.$ 11,970,174 $ 11,035,893 $ 11,911,860 '.$ 12,856,570 '.$ 13,875,318 $ 14,594,537 '.$ 15,204,150 '.$ 15,837,281 $ 16,494,791 Utility Administration(5711) $ 569,765 $ 317,274 $ 393,628 $ 412,283 $ 431,839 $ 523,521 $ 548,575 $ 574,848 $ 684,798 $ 717,812 Water Distribution(5712) 1,109,986 1,048,752 1,092,914 1,139,036 1,187,208 1,237,526 1,290,088 1,344,999 1,402,367 1,462,308 Engineering(5713) 489,070 435,016 467,677 488,866 511,048 534,272 558,587 584,046 610,704 638,618 Sewer Collection(5714) 500,660 635,126 723,000 752,304 782,868 887,481 924,374 962,887 1,087,292 1,133,481 Utility Billing(5715) 566,017 579,187 658,664 686,500 715,574 745,945 777,673 882,403 920,614 960,559 NTMWD-Water Purchases 2,066,680 2,066,680 2,428,731 2,647,112 2,875,727 2,967,259 3,059,447 3,152,293 3,245,796 3,339,955 NTMWD-Sewer Treatment 3,394,265 3,394,265 3,463,831 3,621,941 3,786,417 3,957,505 4,135,447 4,320,508 4,512,950 4,713,046 All Other O&M Expenditures 151,910 225,320 232,080 239,042 246,213 253,600 261,208 269,044 277,115 285,429 Total Operating Expenditures $ 8,848,353 $ 8,701,620 $ 9,460,525 $ 9,987,083 $ 10,536,895 $ 11,107,109 $ 11,555,398 $ 12,091,027 $ 12,741,637 $ 13,251,209 Debt Service-Existing $ 1,498,727 $ 1,324,618 $ 1,334,129 $ 1,331,639 $ 1,347,441 $ 1,346,841 $ 1,048,915 $ 978,813 $ 874,900 $ 872,262 Debt Service-Planned 3,500,000 Total Debt Service $ 1,498,727 $ 1,324,618 $ 4,834,129 $ 1,331,639 $ 1,347,441 $ 1,346,841 $ 1,048,915 $ 978,813 $ 874,900 $ 872,262 Transfer to General Fund I$ 450,000 $ 1,247,612 $ 1,676,997 $ 1,727,307 $ 1,779,126 $ 1,832,500 $ 1,887,475 $ 1,944,099 $ 2,002,422 $ 2,062,495 Non-Operating Expenditures $ 450,000 $ 1,247,612 $ 1,676,997 $ 1,727,307 $ 1,779,126 $ 1,832,500 $ 1,887,475 $ 1,944,099 $ 2,002,422 $ 2,062,495 Total Uses of Funds $10,797,080 $11,273,850 $15,971,651 $13,046,029 $13,663,462 $14,286,449 $14,491,788 $15,013,939 $15,618,959 $16,185,966 Sources Minus Uses of Funds $ 318,738 $ 696,324 $ (4,935,758) $ (1,134,168) $ (806,893) $ (411,132) $ 102,749 $ 190,210 $ 218,322 $ 308,825 Ending Working Capital Reserve $ 10,138,905 $ 10,835,230 $ 5,899,472 $ 4,765,303 $ 3,958,411 $ 3,547,279 $ 3,650,028 $ 3,840,238 $ 4,058,560 $ 4,367,385 %of Operating Expenditures 94% 96% 37% 37%, 29% 25% 25% 26% 26% 27% Targeted Days of Operating Reserves 90 90 90 90 90 90 90 90 90 90 Days of Working Capital 343 351 173 133 106 91 92 93 95 98 Revenue Increases Suggested........ Water N/A 5.25% 6.75% 6.75% 6.75% 6.75% 4.00% 3.00% 3.00% 3.00% Wastewater N/A 5.25% 6.75% 6.75% 6.75% 6.75% 4.00% 3.00% 3.00% 3.00% Overall Water&Wastewater N/A 5.25% 6.75% 6.75% 6.75% 6.75% 4.00% 3.00% 3.00% 3.00% APPENDIX A PAGE 3 II X MoLAIN ALA What is the impact of eliminating the transfer of$1,500,000 to $0 in FY 2012? 1.3. FINDINGS/ANALYSIS RELATED TO THE COST OF SERVICE: ▪ The water and wastewater enterprise fund was in good financial condition as of 09/30/2009. The water and wastewater fund ended FY 2009 with $9,820,167 in operating reserves (working capital) (377 days of total expenditures). ■ The cost of water charged to the City of Wylie by the NTMWD is expected to almost double over the next ten years. Following is a chart illustrating these increases. Figure 1 NTMWD Water Rate/1,000 Gallons $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 FY 2002 $0.72 FY 2003 $ .87 FY 2004 0.92 FY 2005 ,,,,,,,,, ,,, $0.97 FY 2006 >,k OM, M)„ $0.97 FY2007 $1.02 FY 2008 , $1.08 FY 2009 < ««««< «««<« ««««< $1.18 FY2010 �� $1.30 $ .37 FY2012 $1.57 FY 2013 7, ««««< «««<,k ««««< «««,( $1.70 FY2014 $1 :3 FY 2015 �� rrr� r � «««««��`��F $1.94 FY 2016 �, $2 04 FY 2017 �„ ,,,,,,,,, � ) $2.13 FY 2018 � $2.18 FY 2019 ««««<««««, $2.24 The increased cost per 1,000 gallons, along with increased water purchase volume due to growth, with increase the water payments to NTMWD from $2,066,680 in FY 2010 to $3,339,955 in FY 2019 (62%). SECTION I—EXECUTIVE SUMMARY PAGE 2 Wylie City Council qr AGENDA REPORT 0,0 Meeting Date: August 28, 2012 Item Number: 2. Department: Finance (City Secretary's Use Only) Prepared By: Linda Bantz Account Code: Date Prepared: August 10, 2012 Budgeted Amount: Exhibits: Subject Hold a Public Hearing on the fiscal year 2012-2013 Proposed Budget and provide all interested persons an opportunity to be heard, either for or against any item in the proposed budget; and set and announce the date, time and place of the meeting at which Council will vote on the final proposed budget. Recommendation Motion to set September 11, 2012 at 6:00 p.m. in the Council Chambers of the Wylie Municipal Complex, 300 Country Club Road, Wylie, TX as the date, time and place at which Council will vote on the final proposed budget. Discussion A Public Hearing is required to be held on the fiscal year 2012-2013 Proposed Budget. In addition the time date, time and place that the vote will be taken on the final proposed budget must also be scheduled. Any changes made to the proposed tax rate or Proposed Budget could affect required publications and steps in the tax rate and budget approval process. All interested persons shall be given an opportunity to be heard, either for or against any item on the proposed budget. At the end of the hearing, the City Council will schedule the date, time and place that the vote will be taken on the final proposed budget. This meeting is currently scheduled for September 11, 2012 at 6:00 p.m. in the Council Chambers of the Wylie Municipal Complex, 300 Country Club Road, Wylie, TX. The Local Government Code requires the City to follow certain meeting and notice (publication) guidelines. Approved By Initial Date Department Director LB 08/10/2012 City Manager MM August 23, 2012 Page 1 of 1 " i tarp., fbwi \ Wylie CityCouncil VrL'Airf44,1,) `, AGENDA REPORT tnfl rjrr n Meeting Date: August 28, 2012 Item Number: Work Session Department: WEDC (City Secretary's Use Only) Prepared By: Sam Satterwhite Account Code: Date Prepared: August 20, 2012 Budgeted Amount: Exhibits: Subject Hold a joint work session between the Wylie City Council, Sanden International (U.S.A.), Inc., and the Wylie Economic Development Corporation Board of Directors to receive an update from Sanden officials on matters pertaining to strategic partnerships and future investment in the Wylie community in addition to an update on commercial activity in the Wylie community provided by the Wylie City Council and WEDC. Recommendation N/A Discussion There is no specific agenda set for this work session. Mayor Hogue and Sanden Chairman/CEO Mr. Mark Ulfig are seeking an open dialogue between the Council, WEDC, and Sanden officials to discuss past, present, and future relationships as they may relate to strategic partnerships between the three entities. Approved By Initial Date Department Director SS 08/20/2012 City Manager MM August 23, 2012 Page 1 of 2 Sy1: ��T q IQve r ` S y e sir d mow• sr '" hdii‘ inn ... (.?. 6 , ; Delivering Excellence SAN DEN CORPORATION A GLOBAL siulLOCAL PERSPECTIVE Delivering Excellence Established July 30, 1943 Automotive Equipment Business Group Automobile air conditioning system Main business Food & Beverage Business Group sectors Vending machines and Retail store system Other Business Group Household and Environmental system Net sales JPY 215 billion Shareholder's JPY 47 billion equity Number of 8,693 (permanent staff only) employees Number of 59 business bases in 23 countries overseas bases *Converted by annual average JPY1=KRW 13.6 Delivering Excellence 7vo .. `.y`, I-P~f4‘\=1434-4,114410.14 4, , ,' ti.,I( ff :^tl r ^ .,""t",s'fkririiehmia�'acm; .5.3.7.:._-,c:fa'o.lrf.z,.",,',,,,1_7t > 4 , :-,% f>s,f,-✓isyj •.t-...�r.s.i'aTt .aF�^es+ , l? Vending/ - �� , c J '({�;.^ l ,v_i'L» :k 6, e � ...__'!f Retail Automotive Systems Equipment er Systems , Ly ��` r , a r° ,5aa°ate 2x 8 Household Environmental Sales by Business Segment Systems Sales by Geographic Area Vending/ Others (4% ) �,,,,,„ Retail ., ., w ,..::::;,,,,:,,,i,„:,,,,:,,i,,,,,,,,,,,,,,,,,:;,,,,,:<:::::: ,,,,.,,,,,o,:,„,0,,,,,„,,,,,,,,,,,o,„::::::,,„::: :'= ' ` ' America ( 11 % Japan ( 33% ) R: i. G � • • 4t,' •x�sa } ? s ; ,5' ^ ° ' '�'' �: ? f"t� �d , 9 F � +� � if r m i,' " " : + yo y°4 ; ' "maw: A` 2' 1 500° •. Europe (32 A Asia(24%*Converted by annual average JPY1=KRW 13.6 ' �' p \ ( , Delivering Excellence r e 2.,5" 'lition:,,;u.n,its ... Wautsi �, Poland Plant Shanghai Plants Wylie Plant France Plant Yattajima Plant �:� -� "��,� . .. "�.,:�'.._�' k . �: Japan .5 Million units - &" 4 t �'��xt� ". /it Malaysia Plant Europe India Plant x Million units Singapore Plant America D 2.0 Million units FY10 Total Sales Asia 13 Million units 2.0 Million units Iu. Delivering Excellence * C.P.4.4 C,„ ,,,,„_„„..:.„.. . „„:„,,,,,,..7._,-. .„,AT „„ -----,„ , ‘ , , , ,,,, .,. 4111111,N,: ..'_. VOA-Li L.:,, E-Kz _\43-4r., / , , 1471NId . Audi I ! i'' � . ►I L .. jt{ /� f PEUGEOT RENAULT i �z: . DAIMLE ,. ,, 'OPEL.€4S' ' 1 ' \ Aletk twis)* ;; ' NISSAN a FfiElLilai b'id'€ CITROENjF/IJAfT/ - 4, p ":;; m maims a� '',s u NISSAN , HONDP.?, 4, , TOYOTA PFUG T ski — fit' HON DA. RENAULT Cars Trucks OHW Delivering Excellence Europe VenAuto ve n i Rea r North America y A t1' I e Vending/Retail AutC motive Vending/Retail 0 r U"�C) �'� �/ g F of 5, { s Asia/ Oceania Aut 9 ive 8°k ,r Global „,,,,,,„,,,,,„,:„ -,,,,, / / ' „,:,,,,,iii„:,,, ,, ALI ‘. , Vndhj1aiI \ \ \ \ \\\ \ , , \ \ \ \\\\\\ \\ \\// \ 25% 1 ' � , ..,„:,„,,,,,,„.. tau 1 /4 of all vehicles are - , 'uippe • wit and : products 1 /3 of vett • ' • 0 ,,- ,hines area ande 0 . k4x roducts Delivering Excellence Delivering Excellence Market - The American Continents (North/Central/South America) s s �` Head Office : Wylie Texas - Sales/Customer Services - Design/Technical Development - Manufacturing - Human Resources Foundation: 1974 - IT Equity: $18 Million - Accounting/Financial Sales Amount: Approx. $320 Mil. - Corporate Planning Employees: 572 - ISO9000 / ISO14001/ TS16949 registered Area: Land 94 acres plant Detroit Office : Michigan ar -Sales/Customer Services -Technical promotion �e" Brazil Office : Sao Paulo -Sales/Customer Services ° Subsidiary Company : Mexico fik -Clutch Parts Production J Delivering Excellence se 74 A*, 400fr „>,&<,,,-tt,, .. fi r° � " "` :uaxr"z>,>a..,,,� ,aerr" <", n}isf,r, rr h „ cast r> vf r">'a�?»ra` ram' a}' � Die �r?r>`f 11 rr tA. . .1tl, :=.,,%?faux$`;: e r/rXlr// e"',`,'✓,5'�,r Age 40K ft. s .Y , r , ., s S` h "vr ':m..v Pa'nb`YrJ3�dtt�,9�ttZ ;,rrr <4� ,',�. ,,` ,^-',,.,!.:ar-yy ;,r,»,iant,:,rr>.,,, ,M. ".sr�,r'° /l,;,ate, 'is f{r,55`}; rs sr...., {?%l,us ,r ,d%':fi✓r,' r.,✓' "it '.•" .rT•n,. � �; ,a r>ra,,1,,';. SS;'»r�d`s.. z ,2 ;r v;.,`''."�. x ,�,>` ,5 t' :.�>,/1 t '„, ,' i>; =r,,,rs,,r ysgs /„/ �,'/=/'3r / ,'� :� ,ir°pyfp' fc2„f;, ` r ;e r>v/ ' _%`>,x a4s=r,, , fi }.x,,,} l ,i' t ! S,trl;.,'l''`�r2`>�rl<„ ,h rr:f/' f`a rr„ rrorr, *✓r'r a } r7i s'r �/,r a,,.,7';r f rr io em;, ` >rr>•,,;/ „, r"r,r' 1,,,,,,zzI `i>'>' {r'r/7r' ,` .s Assembly and machining n 3' r gi ., s.s° r•%�lfu;>.`P y� y" !w( . . /, 1! ! 300k sq. ft. r/ Office , , fr20k sq. ft. ��',/y `rs r.;a•" ® '` '• " wk'a" »jrr„ifP,,au,t',; ` ;/} »em,� » /,�{. ,a„ I" A:g5"."d1 m r• .a',.,? s4 ,, // '</•'i ?/%, '%?'.% ' ' {yr,C»' � . •er?' �afa" >r ;>r. r, aen"�r," ( ".., _ '.a.`' Fs ..,r ,r//' /%,.; err ,;^}fifl rm; (fime" ro ,F'z, ar.,27 rC�Fiat ;t, ,>✓./�.,,/,> '' "S %Nk%r •�} ff, ao; /r?;'' vi''„arr ,t , 'dr d" ��; ,,s�57,;;,> .'�.,"�, 'f u`' • :f" y-." rrg;»�v„<, jatr„ S,G _, ''" zy,r " P* .: jr fi �a'f. :�'a rri ,"!, ��"iF `>r'rh* ,r,.• °�lym,,_ .r L 'J ,.SFr-.;/;/1'7,°>;, ,r , . •/ ,�R • •,_ »rc.',. »,,,,/;I' a' .»,/r„'/m�' s',,.; z`�` myr• " .. '„� ,✓ ram or`% „f°axv ,z ,x" 'i sr�`. ""ems r�.. .''mbar d',r,t ' /r ,„„ ='r>, „a r•/'b+ur :..a 'r>2 ".p L," ? ,>l;'�,L,rrt„,G, 'l, /.r, ,%+ ''/,i»m',l r/:,~x+,s 'S' %%'` ...:v ..�;i' 40,2 � ,/// �;?r, %fy'ff% �r sir' .— <;'�- ".,e. / pry/r .'ma, rr/"- rr' rs`" r /> .$.'W ,,,r a' " Yi/,r, r„//d,1, ,r,r ra' :j's�•- `t /,��,.: ,Fy.l,I�`,F/r/'nr 'rr, r,/ �'r,''�vrl' '�%m u+.' ,f:"�JR ,1�KL �;;-:ro,: r,zr rr //rr,1' %>%;...rr:S.i; ">i`,�°" ,.l,tk.r 'r: ,.!/ r' /,di rlr�rr/i /» ," ;� `.'tr' r .�'. 'lr;^o , ., ,ara, ,,1/?' /A;;z`l,'d)„u,'m:rr'{ c�r'r�r7.,k«li=»,rl dr r „ems r*4 r dr s>„r..•,cn. a5 ' =,(,c<lu;�'`>•i"r�fs,,r ,,,,Y7= ,r//„/,/r,7r c',:,._; :al.�, brJ'r` ",N/ ?,r7,,ru //srr.,^„ rd,'afi iz=;rr'dF, ,»r >,>,mf". ,r,�iry ',a! rsr/r ri<r,;i /;'";>' �,' trs 4$4, "ae` ,> 2 „>�e,r //s t'e ,,. ;;�''/i' 'fir'' ,d,,, ,mr ">r M ,.`a"rr,. ,01rrr n�'r i '�'„fig. �, rr, �, r ' ��;: 1,:,",sif�S rt.:r„d',N-=;6r' "r5l'.:, r rrr,7r>fr,m ,l/,, %/'xd'o / ;,,y,,,!j�33;.,',`s, "'fig ri, %,qp /�L` r,yrS,6,s,' r%-'�r r f.frmr; a"r,'oii` /r/ ,/ sal „�:��r» r„ ,m, '•tF5'ii d6aa e3a,Fr'8v, ra/,,( ':i33 1rurl,3•r ;'l', Fdr r,)ir�"'r.rr r 'r%r" rYr'r/ „✓ro' .ri»»," r�/r 'y ,"' r%✓ r a/S>,vr"',.>;' ,rr'hsFv`>,:r„,%ram; Irry;r 1 „,F,�,rar,,,r,,,''",'" 'y, "rfi ,r}S rr,a2 r�tlr, r,7/,r•/r z/,e r'ar=�„/ » ,i, ',r;,/', ..�1' ,.'s�lFnr ��'� ' rr>, �+ ay° �( fj', , ,_'Fd'r, 'uF ,,:;;�f. .7/ter-''? /„> ';o`air> ,�;?,r r r/, =,+x rdr / r' �.E§S f -,5�r.'s f -'"?'i:r 'r4:a „ .v ;r„', r/f ,:y<r'e?t ",,., , r r�z III ,�r,/'r�„ r/=ra, .» ;, s.' r<//s r, 'r'i,r„ ''' % - , d r'f„,�r=" ra/S' ,/r�� a>'�;•.er,.rt »/',i„1%� 'r, d ,;''s '.1 r rr/'/I?',11" ,rl-.,;`r.• f�r," „zi>✓l/, 'r5i e, d 'rf i,/rn r" - �s iS r ��('' 4'rr>PC la a//,r�,r ,`>r'.r'r /, r�Fx f5 r/ r: Sr/,. „/:K:r'l.,i=%.,./..,,�'c;� it r'.vr „ ,�§;5„„'.'• :» . ar //r nr,' r�l r r�.'.r£` �. .6}l>r. R,rIr�"'%". r/r ,985 r .. , ,S" 2,/;'�iY'r 9>rr djSra'>� ?{fii 'ANY+ C" ,5r» %/z2ts,r,?a"lr »}; >=s;;/r �zrr ✓;Sir«�'� '? / �;'• �o.:>fr,/}/ ,,,;>d';r,,.k/kkiij,�rc"rr;?/�.;"i /v f»'� s, _ 'irrr.,✓l)" v>/»'jrrsr+;,3J°{'r°fbr r, rf fG',;an'r' 2/'._'/'rrj r�rrr:"". . "!I;; ''^�z,,,,,,.f°'�f33'�`;s,S- '%r% s rxrr;; r>a'<rar�-`"."; - �: . „,.;ta;x.". rd�?fCc"r�„/ 4 r •, 7"tcF,Fr ry„ - '.)0;' "` ram', a" ' ,O>',r.„,/;, /'.,,rRs> N"',` n✓,,," ,a f _Y%,da lk:t<Nk:§'wnarn.r,L .,�` >v�,.,a.,.+.•'" •9. ..ate' P, ;S'<Y?'i','„,r'yY ti> . im,. � ,r; '." �� '. ,;»fr . Administration & Current Test facilities - 90k sq. ft. fib. Delivering Excellence - 1974,Oct: SIA Established. ( Sales Office) - 1980: Plant constructed in Dallas, Texas. Wobble Plate SD5 Production Started. - 1984: Established SMX in Mexico ( Subsidiary Company) Comp to Clutch Production Started. - 1988: Established Business Office in Detroit Michigan. - 1989: Plant Constructed in Wylie, Texas. Current Head Office in U.S.A. Wobble Plate SD7 Compressor Production Started. - 1990: Clutch Production Started in Mexico ( SMX) - 1995: Scroll Compressor Production Started. - 2000: Die Cast Plant Constructed and Production started. er Y erN2 - 2001: Established Business Office in Brazil. E - 2002: Achieved ISO 14001 registrationf . Established Engineering Capability at Sales HQ in Detroit >, r - 2003: Received TPM Excellent Award k4.: - 2005: TS 16949 certified - 2006: Received Deming Award & Texas Award for Performance Excellence - 2010: PXE Production Start (Nov. 2010) - 2012 Production launch of PX for Nissan _ SANEIII it Delivering Excellence Over 40 million units produced 2.5 .3 0 2 _ AT* 15 - 404,,o, ,470,1414,, 4,-1,04,004r 00140,441,40,4ev,N,fami&,•,,,,.,too ,„: ,„„ ,, Ircitsio,*,40**440:04140011M-„,t, 2„0 - *toittploeivOsoftleow,"kiwi, 1,4/034PP,r":"""" " : ':"." rtFe,44, At4:410WILV44,040,1titth""":", 2:z.:44,41041 1,5 1I ' 1,,0 0.8 03 r-Ni „,.., 1-1 . 11- .,2-1 tzi 7--- — 6 ,_, -1 -1 00 7--- 00 -'7-1 ° '-I 6 0 o' o ,-i N DI 't .-ri :Q .,-,I cr, •_71 0 0 0 0 n 0 o 0 n o 0 0 0 0 n NIF-4 r-,I xi cri ,--- m c•---.. -,-',.! -4,. al m o o IN N N N IN ' `-1 N m ..J- Kz: '''Do /''7-0 IN NI N N IN SD5 E SD7 if TR E PX Delivering Excellence Over $150 million invested 45,000 — Wylie Plant 40,000 - = 35,000 - PX launch C 30,000 - 3 TR Compressor _ 25,000 — Foundation 1 DC, PXF launch 00 20,000 — New TR 0 launch y 15,000 C v 10,000 - 5,000 - 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 0 1 2 3 4 5 6 7 8 9 10 11 Delivering Excellence 0.�// 447W 71£f £✓✓` ✓: f :✓£r/✓✓ ✓ ,r5v .,-- J?r £i✓,, ✓ ,, '' ✓ ✓✓ ✓- I✓✓£ r ✓' ✓ r. _ ,-F y£✓ ✓ �,"✓,4 r �✓ yr ✓ ✓ .., T ✓ r ✓y✓ /✓�-" /� "" �� £, ✓T 1 £-, , .. .✓ £ £ ✓ry.k ,,'" ' I f ? Al 1r. ✓, 11, >t ✓ If ,£i ✓. ✓`, ,, /rF ;��;;s - l✓, r£', ,r.frJ ✓i`? ,,,,1,f ;.N2?,<" Y 22r,£;% ,r-( Belt Electric II Variable r}i . l Fixed ' i Driven Driven Int. : Ext I t. Ext i g lX I X I TR BIAS HBC L* .TkP l- SD I I 1 PX I I I T Al SHD XC16 ! >i g .-110 �+ II I III IH 'l (PXV1 ) 11 TRSE09 ! rt / ; "" , .. i,,'VA R a ,�q; ! 9 �,,a yIII ` P 7 1 I 3 TR' E ' SD7$ ! Sanden USA manufactures fixed ;� - SD ' displacement wobble plate and �� scroll compressors along with the TRSAOS SHS33 new PX variable swash plate g compressor that started ` egr gad production in November 2010. r Delivering Excellence k 4,500 3.9M 3.8M 4, �� 3.7M 351 SDV 3,500 379 359 2.7M 2.8M 2.9M 3,000 - :. 175 1 77 1 40 1a02 1 37 PX 2,500 2,000 - 743 739 801 / l / ll / S %f/ l / 408 1,500 // / // : // l, ✓ //l t/ // /l / / ///i// //i/l [9(� // �� %i/ ,,w„„,\,„,,.„„,1„,..0 J // /r �i�// f / !,,,,k..,/ r TR ,,ttf,,o. g. / / A % /�/ // //// i ill/ �/0/ �/l,/ ///// / / / / r,,,,, ,,,„ 1 000 l / // V. // r/ // /% ///�/ / , %/. /; /i/i" 500 SD7 z.s FY11 FY12 FY13 FY14 FY15 FY16 Delivering Excellence Plant FY12 FY13 FY14 FY15 TTL Investment New New Building 8,000 SDV Assembly 6,008 Plant in PX Shaft rotor 2,400 SDV CB 2,100 - Mexico PX CB 21ine 5,100 PX CB transfer & 1,809 Modify & New Asset PX CB Die Cast 1,800 PX CB Die Cast 1,800 SD Part transfer 1,890 PX Swash Pt 8,700 19,190 20,417 39,607 SMX SMX Building 1,500 CL Rotor 1,500 CL Rotor 1,500 PX FLB 2 lines 2,400 FLB (SD & TR) 1,184 Armature Plate 6 4,190 3,900 8,090 SIA Rebuild machines 420 420 PX Piston 13,215 PX Piston 11,000 24,215 13,635 11,000 24,635 TTL 37,015 35,317 72,332 *q x 3 l P "M b.,, (d Wz 177* aik Delivering Excellence Thank _WS Wylie City Council CITY O F WY 1 AGENDA REPORT Meeting Date: August 28, 2012 Item Number: Work Session Department: WEDC (City Secretary's Use Only) Prepared By: Sam Satterwhite Account Code: Date Prepared: August 20, 2012 Budgeted Amount: Exhibits: 0 Subject Discuss issues surrounding joint funding with the WEDC for the extension of Woodbridge Parkway. Recommendation Staff is seeking direction pertaining to the level of funding the City of Wylie will be providing for the construction of Woodbridge Parkway and the funding mechanism for the same. Discussion On December 13, 2011 the Wylie City Council directed the WEDC to develop a scenario under which the WEDC would take the lead in financing Wylie's share of ±$2 million to extend Woodbridge Parkway to connect with State Highway 78 in Sachse. With a total project cost of±$8 million, an Interlocal Agreement was executed on April 10, 2012 committing Collin County and the City of Sachse to fund ±$4 million and ±$2 million respectively for the road and bridge project. Further, the project is nearing 50% design and going out to bid in the next several weeks. Also at the December 13, 2011 meeting, Council contemplated a scenario under which the City of Wylie would fund a percentage of Wylie's ±$2 million via thoroughfare impact fees generated in the west zone which Woodbridge Parkway is located. The percentage discussed in 2011 was 50% by the City of Wylie and 50% by the WEDC. In evaluating undeveloped property in the west zone and the potential for thoroughfare impact fees which could be collected, it is difficult to identify a development scenario under which $1 million in thoroughfare impact fees will be generated. The inability to generate that amount in fees is directly tied to a prior commitment made by the City Wylie to reimburse Mr. Don Herzog for the construction of Woodbridge Parkway from F.M. 544 to Hensley out of thoroughfare impact fees. On August 17, 2012 the WEDC accepted a bid from American National Bank to finance up to $2 million in funds necessary to complete the Woodbridge Parkway project. The full $2 million was requested based upon the unknown level of participation by the City of Wylie. In discussions with the City Manager and City Engineer, it has been identified that there will be monies remaining from the 2005 bond program as a result of project savings. The City Engineer estimates that there will be approximately $3 million remaining from the 2005 bond program. A more detailed analysis will be provided by the City Engineer at the Work Session. Based upon the reality that no significant amount of monies can be generated by thoroughfare impact fees and further the WEDC's intent to take the lead on funding for Woodbridge Parkway based upon the impact on economic development, WEDC staff requests that the Wylie City Council consider funding $800,000 of the $2 million in improvements out of bond funds with the WEDC financing the remaining $1.2 million. If accepted by Council, an Interlocal Agreement will need to be approved between the WEDC and City Council identifying each entities funding responsibility. The WEDC will be closing on its construction loan no later than October 26, 2012 so that monies will be available prior to any contract being let. Page 1 of 2 Approved By Initial Date Department Director SS 08/20/2012 City Manager M1VI August 23, 2012