Loading...
08.28.2007 Town Council PacketIOWN OF SPER 1. Call to Order / Roll Call. 2. Invocation and Pledge of Allegiance. AGENDA Regular Meeting of the Prosper Town Council Prosper Middle School - Library 605 E. Seventh Street, Prosper, Texas Tuesday, August 28, 2007 at 6:00 p.m. 3. Announcements of dates and times of upcoming community events. CONSENT AGENDA (Items placed on the Consent Agenda are considered routine in nature and are considered non -controversial. The Consent Agenda can be acted upon in one motion. A majority vote of the Council is required to remove any item for discussion and separate action. Council members may vote nay on any single item without comment and may submit written comments as part of the official record.) 4. Consent Agenda MINUTES a. Consider and act upon minutes from the following Council meetings. (MD) August 14, 2007 — Regular Town Council Meeting ORDINANCES RESOLUTIONS AND AGREEMENTS b. An update on the Town's sports fields and/or the construction of future sports fields. (CC) C. Consider and act upon a Resolution denying the request of Atmos Energy Corp. for an annual Gas Reliability Infrastructure Program (GRIP) Rate Increase. FINANCIALS d. Consider and act upon the financial statements ending July 31, 2007. (RB) CITIZEN'S COMMENTS (The public is invited to address the Council on any topic. However, the Council is unable to discuss or take action on any topic not listed on this agenda. Please complete a "Public Comments Form' and present it to the Town Secretary prior to the meeting.) 5. Other Comments by the Public. REGULAR AGENDA (If you wish to address the Council during the regular agenda portion of the meeting, please fill out a "Speaker Request Form" and present it to the Town Secretary prior to the meeting, Citizens wishing to address the Council for items listed as public hearings will be recognized by the Mayor. Those wishing to speak on a non-public hearing related items will be recognized on a case -by -case basis, at the discretion of the Mayor and Town Council.) PUBLIC HEARINGS 6. A public hearing to consider and act upon an amendment to the Old Town Core District of the Town's Future Land Use Plan. (CA07-2). (CC) 7. A public hearing to discuss the Town of Prosper proposed FY 2007-2008 tax rate. {RB) Page I of 2 DEPARTMENT ITEMS S. Consider and act upon a change order to Red River Construction Company, Inc., for the Pump Station and 3 MG Ground Storage Tank Project. (HW) 9. Discuss and act upon creating Finance, Utility and Economic Development Committees comprised of members of the Town Council. (ML) 10. Consider and act upon a resolution making nominations for the Board of Directors for the Central Appraisal District of Collin County, Texas. (ML) 11. Consider and act upon a Resolution authorizing the Mayor to execute a boundary agreement with the Town of Little Elm. (ML) 12. Discussion of the 2007 Parks, Recreation and Open Space Master Plan. (WH) EXECUTIVE SESSION 13. Recess into closed session in compliance with Section 551.001 et. Seq. Texas Government Code, to wit: Section 551.072. To deliberate the purchase, exchange, lease or value of real property located at Lot 1, Block A, and Lot 1, Block B, of the Rhea Mills Estate. (HW) 14. Reconvene into Regular Session and take any action necessary as a result of the Closed Session, including, but not limited to: a. Consider and possibly act upon adoption of resolutions determining a public necessity to acquire by purchase or condemnation, property located within: i. Lot 1, Block A of Rhea Mills Estate; and ii. Lot 1, Block B of Rhea Mills Estate. (HW) 15. Possibly direct Town Staff to schedule topic(s) for discussion at a future meeting. 16. Adjourn. CERTIFICATION I, the undersigned authority, do hereby certify that this Notice of Meeting was posted on the inside window at the Town Hall of the Town of Prosper, Texas, a place convenient and readily accessible to the general public at all times, and sai Wnwsted by the following date and time: Friday, August 24, 2007 at 5:00 p.m. and remained so posted at least 72 hours before said meetin`y`a� h r "� 11*4 Matthew D. Denton, TRMC Date Noticed Removed w Town Secretary i- •,�� �� In addition to any specifically identified Executive Sessions, Council mWoSnven •� ~ uifically �n under Section 551 of the Texas Government Code at any point during the open meeting to discuss any item posted on this agendl��}�ct provides specific exceptions that require that a meeting be open. Should Council elect to convene into Executive Session, those exceptid�� ��}identified and announced. Any subsequent action, as a result of this Executive Session, will be taken and recorded in open session. NOTICE OF ASSISTANCE AT PUBLIC MEETINGS: The Prosper Town Council Meetings are wheelchair accessible. Persons with disabilities who plan to attend this meeting and who may need auxiliary aids or services such as Interpreters for persons who are deaf or hearing impaired, readers, or large print, are requested to contact the Town Secretary's Office at (972) 346-2640 or by FAX (972) 347-2111. BRAILLE IS NOT AVAILABLE. Page 2 of 2 0" ti -r c c F. S-PER 1. Call to Order / Roll Call. The meeting was called to order at 6:10 p.m. Roll call was taken by the Town Secretary. MINUTES Regular Meeting of the Prosper Town Council Prosper Middle School- Library 605 E. Seventh Street, Prosper, Texas Tuesday, August 14, 2007 at 6:00 p.m. Council present included: Mayor Charles Niswanger, Mayor Pro-T Dave Turley, Kenneth Dugger, Kevin Drown, Mike Wadsworth, a, Staff present included: Mike Land, Town Manager; Hul • Webb, Copple, Senior Planner; Wade Harden, Senior Planner Tolle Development Corporation; Kevin Carruth, Interim Town'Many 2. Invocation and Pledge of Allegiance. Mayor Niswanger led the Pledge of Allegiance. 3. Announcements of dates and times of Mayor Niswanger thanked Interim Town Manager K On Ca• t] AT Mayor Niswanger introduces`" �.`"' the Town's fi Town CONSENT AGENDA,`3r, �P:{};r yrfi;niy�u 4. Consent Agenda Deputy Mayor Pro-Tem of Denton, Town over the last few months. '''•yY•:it+:•iriy MINUTES a•" Consider anu kz. upon mi'vatps�from the following Council meetings. (MD) * July 2, 2007 �­.Speciaxl To' ; incil Meeting July 3, 2007 — dial Towillr ouncil Meeting 45t� • ,l u ly 9, 2007 —Seal Town Council Meeting + J;lafy.24. 2007 —R lar Town Council Meeting yes; Chris Economic b. An update oiWTown's sports fields and/or the construction of future sports fields. (CC) c. Consider and act upon an ordinance rezoning 24.3t acres on the southeast corner of Dallas Parkway and First Street, from Single Family-15 (SF-15) and Agricultural (A) to Commercial Corridor (CC). (Z07-13) (CC) Motioned by Mayor Pro-Tem Bristol, seconded by Councilmember Drown to remove items 4d and 4e from the consent agenda. Motion approved 7-0. Page 1 of 4 Motioned by Mayor Pro -Tern Bristol, second by Councilmember Dugger to approve the balance of the consent agenda subject to staff recommendations. Motion approved 7-0. d. Consider and act upon 1) approval of a letter of agreement relating to park improvement fees and requirements within the Village at Prosper Trail, Phase 1 subdivision and 2) adopt a resolution authorizing the Town Manager to execute the same. (CC) e. Consider and act upon 1) approval of a letter of agreement relati :Ao. park improvement fees and requirements within Glenbrooke Estates, Phase 1 subdi bn al 2} adopt a resolution , authorizing the Town Manager to execute the same. (HW)' >:,• Mayor Pro-Tem Bristol requested these two items be removed from t*'` cons ; enda because he had some questions regarding the pricing discrepancies for the hike and bik9,;� tray ;5 between ;'':;.two items. Bristol also noted some grammatical errors in the letters of agreement. Motioned by Mayor Pro -Tern Bristol, seconded by DeputX&or Pro-Tem Turley to appi q:"k 4d and 4e with the grammatical changes. - Motion approved 7-0. ti:3::'Y:•: ;>:•Y:>:•:,r., .;: CITIZEN'S COMMENTS '•a54i,��u't` 5. Other Comments by the Public. •v:•:.ti 51�:5;L� • iiyYe�`5 •�5:. t:t5r:4v:ti,`.i•:'��• ' There were no comments by the public. Y € << A 55. 55:i4. 5 �•W{:5 tJf1i'S!`:5 REGULAR AGENDA rZsrvS h�:ti$L; r,'.1+-iSn?Yi'sr"•'v \l l+ DEPARTMENT ITEMS 6. Discuss appoint proces:f vacancies o'-.'.Fhe Prosper Economic Development Corporation. �..,Y:'iY;i'7;•iY.S � •�••>{:vY�:r;{:.. eyti�., Councilmember Wadsworth as -. ur �'���,�vr, buiad.in£o Cation on this item. Motioned :Y Wads seconded by Councilmember Smith to approve Bob Luckock as the Chamber',,"'5Commerce re tive o1.EcQaornic Development Board and Councilmember Ray Smith as the Tgtuncil representat Y.` ;5Y ' •the Ecii€dir Development Board. .�,�.Y: u Motion apigd 7-0. ,; ., 7. Considd act upon : ---'approval of the Town of Prosper Parks, Recreation, and Open Space Master P��3�; lnd 2) adopt � resolution authorizing the Town Manager to execute the same. (CC) Chris Copple, Senior li���.:e council background information on this item. Trent Lewis, Jeff Stang, al$d Rick Wieland addressed the council on this item. Each councilmember gave detailed descriptions of their thoughts on the Plan as it was presented. Council directed staff to make the recommended changes and bring the item back on the August 28`h Town Council Meeting. Page 2 of 4 Motioned by Mayor Niswanger, seconded by Councilmember Smith to table the item until the August 28, 2007 Town Council Meeting. Motion approved 7-0. 8. Consider and act upon 1) approval of an Engineering Services Agreement with Dowdey, Anderson & Associates, Inc., regarding the Prosper Trail Culvert Extension & Drainage Channel Improvements and 2) adopt a resolution authorizing the Town Manager to execute the same. (HW) Hulon Webb, Director of Development Services, gave council background informatp on this item. Chris Blair and Ed Faulkner addressed council regarding this item. Motioned by Councilmember Smith, second by Deputy Mayor Pro-T "."'Tug Services Agreement with Dowdey, Anderson & Associates, Inc., re..,. the Drainage Channel Improvements and 2) adopt a resolution authorii'' '?he'T;ow Motion approved 7-0.1111,;, 9. Consider and act upon an ordinance Hulon Webb, Director of Development Services, gave council Chris Blair addressed council regarding this i Motioned by Mayor Pro-Tem Bristol, seconded b'' i member Wadswd' i, a municipal drainage utility system.,, Motion approved 6-1 with Councilmember Drown a'ltainins`:» sY� 10. Consider and act upp i.f sed tax rate f" 2007-200 (itC) Ron Butler, Business M" r, gave c} it background i formation on this item. Motioned by Councilmcmbe�`:" 2008 as $.52. Motion appro;r:.' II' '• 11. hsider and act > �.,, ness Manager, Ronutli 1) approve an Engineering i rail Culvert Extension & ?;ato execute the same. utility Sys ion on this an ordinance establishing by Ma Pro-Tem Bristol to set the tax rate for FY 2007- hearings on the proposed tax rate. (KC) information on this item. Motioned by C'``oImember Du, seconded by Councilmember Drown to set the dates of the public hearings for August 28, 2007ftSeptembs-1, 2007 at the Prosper Middle School Library. :.'... Motion approved EXECUTIVE SESSION;..""' l 12. Recess into closed session in compliance with Section 551.001 et. Seq. Texas Government Code, to wit: a. Section 551.072 to deliberate the purchase, exchange, lease, or value of real property. Page 3 of 4 b. Section 551.071 consultation with Town Attorney to discuss 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 the Open Meetings Act regarding: i. Bradford Farms/Steeplechase issue ii. Mahard Ranch/Forrest City project Motioned by Deputy Mayor Pro -Tern Turley, seconded by Councilmember Dugger to recess into closes session. Motion approved 7-0. Council recessed into closed session at 8:00 p.m. 13. Reconvene into regular session and take any action necessary Motioned by Councilmember Smith, seconded by Councilmember Motion approved 7-0. Council reconvened into regular session at 9:17 p.m. 14. Possibly direct Town Staff to schedule topic{sy"& Mayor Pro -Tern Bristol asked that the smoking ordinance be 15. Adjourn. Motioned by Councilmember Smith, seconded Motion approved 7-0. The meeting was adjourned at 9: Attest: TRMC Town Pro-Tem of the closed session. to regular session. uture meeting. to council. n. Charles Niswanger, Mayor Page 4 of 4 ,, Niv:} a To: Mayor and Town Council From: Chris Copple, Senior Planner PARKS AND RECREATION Cc: Hulon T. Webb, Jr., P.E., Director of Development Services/Town Engineer Re: Town Council Meeting — August 28, 2007 Date: August 24, 2007 Agenda Item: An update on the Town's sports fields and/or the construction of future sports fields. Description of Agenda Item: At the June 12, 2007 meeting, a request was made by Councilmember Wadsworth to have an update the Town's sports fields and/or the construction of future sports fields on future agendas. Currently, the Parks and Recreation Board (PARBd) and Town staff are considering the following options at Folsom Park and on the 57 acre community park site. 1. Folsom Park (located next to Folsom Elementary in the La Cima subdivision): The PARBd discussed future improvements to Folsom Park at their June 21, 2007 meeting. The development of Folsom Park would provide between three (3) to six (6) youth soccer/multi-purpose permanent fields. Town staff and members of the PARBd have submitted two (2) applications for grants to assist in the funding of the improvements to Folsom Park. The first grant application to Collin County requesting $390,000 in matching funds was sent out on July 3, 2007. The second grant application to the Texas Parks & Wildlife requesting $390,000 in matching funds was sent out on July 29, 2007. Both grants are 50% matching funds for the reimbursement of expenditures on park development; therefore, the existing Park Improvement Fees and the recently received $500,000 park grant fund, must be available to not only receive the grant(s), but pay for the improvements. If grant(s) are awarded, the reimbursement of the 50% matching funds will be received by the Town after completion of the development of Folsom Park. On June 27, 2007, Town staff met with a design consultant to discuss the proposed scope of work for the project. At their August 23, 2007 meeting, the PARBd reviewed proposals for the design of Folsom Park. The Parks Board directed Town staff to meet with Prosper ISD, Prosper Sports Association (PSA), and Prosper Area Soccer Organization (PASO) to discuss the proposed design. Town staff will be coordinating meetings with these organizations to discuss the proposed design. It is anticipated that the design contract will be considered by the PARBd at their September 20, 2007 meeting. The PARBd anticipates that these permanent fields could be ready for play at Folsom Park for the fall season in 2008. 2. 57 acre community park site (adjacent to the future Prosper ISD athletic stadium, south side of Frontier Parkway, west of the BNSF Railroad): On May 31, 2007 the PARBd discussed the possibility of adding six (6) temporary fields on this property and was provided a cost estimate of approximately $350,000 for this construction. It was decided Agenda Item No. 4b - Page 1 of 2 by the PARBd that in order to better utilize those funds, the site needed to be master planned so the improvements on the site could be designed in a manner to maximize the permanent improvements, limiting the money spent on temporary improvements. Due to the limited existing funding resources, the development of any temporary fields could eliminate the development of permanent improvements to Folsom Park and the matching funds necessary for the grant applications. Staff was directed to move forward with obtaining a scope of work from a design consultant. At the June 18, 2007 Joint Work Session with the PISD and Town Council, staff was directed to look at the possibility of adding temporary fields to the remaining acreage of the school's adjacent property since the construction of the stadium was not planned for the immediate future. Staff updated the PARBd at their June 21, 2007 meeting and they agreed to expand the scope of design work to include the addition of temporary fields adjacent to the 57 acre community park. On June 27, 2007, Town staff met with a design consultant to discuss the proposed scope of work for the project. At their August 23, 2007 meeting, the PARBd reviewed proposals for the design of 57 acre community park site. The Parks Board directed Town staff to meet with Prosper ISD, Prosper Sports Association (PSA), and Prosper Area Soccer Organization (PASO) to discuss the proposed design. Town staff will be coordinating meetings with these organizations to discuss the proposed design. At this time it is unclear on whether or not the fields will be ready for play at the 57 acre community park for the fall season in 2008. Attached Documents: No attachments. Town Staff Recommendation: No action needs to be taken on this item. Agenda Item No. 4b - Page 2 of 2 1'4CC W N! f ti k SPE To: Mayor and Town Council From: Mike Land, Town Manager ADMINISTRATION Re: Town Council Meeting — August 28, 2007 Date: August 21, 2007 Agenda Item: Consider and act upon a Resolution denying the request of Atmos Energy Corp. for an annual Gas Reliability Infrastructure Program (GRIP) Rate increase. Description of Agenda Item: By law, all cities that suspended the effective date of the GRIP 4 surcharge must take final action on or before September 13, 2007. (Attached to this communication is a list of cities that have adopted suspension resolutions.) After review of Atmos Mid-Tex's GRIP filing for the 2006 rate year, Geoffry Gay the Atmos Cities Steering Committee's (ACSC) attorney, recommends that member cities adopt the attached resolution denying the requested surcharge on or before September 13, 2007. ACSC's rate consultant, Karl Nalepa, has identified approximately $3.4 million in expenses that are inconsistent with the statute and/or the Railroad Commission's order in the Company's most recent rate case. Please review Mr. Gay's memorandum and supporting materials dated August 7, 2007 and the attached GRIP analysis performed by Karl Nalepa with RJC dated August 3, 2007.. Mr. Nalepa is a consultant for ACSC specifically hired to review the rate request by Atmos. Budget Impact: There is no budgetary impact related to adopting this Resolution. Legal Obligations and Review: The documents submitted were prepared by Mr. Gay on behalf of the ACSC members. Agenda Item No. 4c - Page 1 of 2 Attached Documents: 1. A resolution denying Atmos request. 2. A cover memo from Mr. Gay dated August 7, 2007 and supporting documentation. 3. A memo from Mr. Nalepa with RJC providing a rate request analysis. 4. A list of 128 municipalities who have passed suspension resolutions for the GRIP request. Town Staff Recommendation: Town staff recommends that the Town Council approve the Resolution. Agenda Item No. 4c - Page 2 of 2 RESOLUTION NO. A RESOLUTION OF THE TOWN OF PROSPER, TEXAS, DENYING THE REQUEST OF ATMOS ENERGY CORP., MID-TEX DIVISION, FOR AN ANNUAL GAS RELIABILITY INFRASTRUCTURE PROGRAM (GRIP) RATE INCREASE IN THIS MUNICIPALITY, AS A PART OF THE COMPANY'S STATEWIDE GAS UTILITY DISTRIBUTION SYSTEM; SUPPORTING STATUTORY REFORM OF THE TEXAS GRIP STATUTE, FINDING THAT THE MEETING AT WHICH THIS RESOLUTION IS PASSED IS OPEN TO THE PUBLIC; AND PROVIDING FOR NOTICE OF THIS RESOLUTION TO ATMOS ENERGY CORP., MID-TEX DIVISION AND THE TOWN'S LEGISLATIVE DELEGATION. WHEREAS, the Town of Prosper, Texas ("Town") is a gas utility customer of Atmos Energy Corp., Mid -Tex Division ("Atmos Mid -Tex" or "the Company"), and a regulatory authority with an interest in the rates and charges of Atmos Mid -Tex; and WHEREAS, Atmos Mid -Tex made filings with the Town and the Railroad Commission of Texas ("Railroad Commission") on or about May 31, 2007, proposing to implement interim rate adjustments ("GRIP rate increases"), pursuant to Texas Utilities Code § 104.301, on all customers served by Atmos Mid -Tex, cffective July 30, 2007; and WHEREAS, the Gas Reliability Infrastructure Program (GRIP) statute approved in the 2003 Regular Session of the 78th Legislature changes 100 years of Texas law and allows a natural gas utility to implement annual surcharges for increases in investment without having to account for the offsetting decreases in costs or increases in revenue experienced by the utility; 77,Tq1 WHEREAS, Texas is the only state out of the twelve states served by Atmos that has a GRIP statute that allows for piecemeal recovery for any change to invested capital; and 25571021res070807kpd 2006 GRIP denial 1 WHEREAS, Atmos has implemented four GRIP surcharges and collected more than $20 million in GRIP surcharges from customers since the utility acquired the TXU Gas system in 2004; WHEREAS, the Town supports the statutory reform of the GRIP statute to ensure fairness to ratepayers and to eliminate piecemeal recovery for any change to invested capital; and WHEREAS, Atmos Mid -Tex was recently granted a rate increase as a result of its filing in GUD No. 9670, in which the Final Order was only signed on March 29, 2007; and WHEREAS, in GUD No. 9670, it was determined that Atmos Mid -Tex had inappropriately included certain expenditures in its prior GRIP rate increases for rate years 2003, 2004, and 2005; and WHEREAS, the Town, as a regulatory authority, suspended the July 30, 2007, effective date to examine this latest GRIP filing to determine its compliance with the Texas Utilities Code and Railroad Commission final order in the most recent Atmos Mid -Tex rate case; and WHEREAS, the Town has joined with other cities to review the Company's filing, said coalition being known as Atmos Cities Steering Committee ("ACSC"); WHEREAS, the consultant hired by Steering Committee has reviewed the GRIP surcharge application and has issued a final report finding that the Company has included millions of dollars of expenses in the current GRIP surcharge that are inconsistent with the Texas Utilities Code and Railroad Commission final order in the most recent Atmos Mid -Tex rate case and not related to ensuring the safety and reliability of the system; WHEREAS, counsel for the Steering Committee, upon review of the Company's filing and the consultant's report, recommends finding that the Company's proposal is unjustified and unreasonable; and 25571021res070807kpd 2006 GRIP denial 2 WHEREAS, ratepayers of Atmos Mid -Tex, including the Town and its residents, will be adversely impacted by the proposed GRIP rate increases. NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS: SECTION 1. That the Company's GRIP rate increase request is found to be unreasonable and inconsistent with the Texas Utilities Code and Railroad Commission final order in GUD 9670, Atmos Mid -Tex most recent rate case, and is therefore denied in all respects. _ SECTION 2. This Resolution shall become effective immediately from and after its passage, as the law and charter in such cases provide. SECTION 3. That the Town hereby advocates statutory reform of the Texas GRIP statute to ensure fairness to ratepayers and to eliminate piecemeal recovery for any change to invested recovery. SECTION 4. That the Town calls upon its state representatives and senator to support legislation in the 81" Regular Session of the Texas Legislature that would reform the Texas GRIP statute to ensure fairness for ratepayers and eliminate piecemeal recovery for any changes to invested capital. SECTION 5. That it is hereby officially found and determined that the meeting at which this Resolution is passed is open to the public as required by law and that public notice of the time, place and purpose of said meeting was given as required. SECTION 6. A copy of this Resolution, constituting final action on the Company's application, be forwarded to the following: 25571021res070807kpd 2006 GRIP denial 3 Charles R. Yarbrough, II Atmos Energy Corporation 5420 LBJ Freeway, Suite 1800 Dallas, Texas 75240 Lloyd Gosselink Blevins Rochelle & Townsend c/o Geoffrey Gay P.O. Box 1725 Austin, Texas 78767-1725. SECTION 7. A copy of the resolution shall be sent to the elected lawmakers representing the Town's interests in the Texas House and Senate. DULY PASSED and approved by the Town Council of the Town of Prosper, Texas, on this the day of 12007. APPROVED: ATTEST: APPROVED AS TO FORM: Town Attorney 25571021res070807kpd 2006 GRIP denial 4 Lloyd Gosselink +AS ATTORNEYS AT LAW Ms. Doyle's Direct Line: (512) 322-5820 Email: kdoylc@lglawfirm.com MEMORANDUM TO: All Atmos Mid -Tex Gas Cities FROM: Geoffrey Gay Kristen Doyle DATE: August 7, 2007 RE: Atmos GRIP 4 Filing CONFIDE Tl11L/ATT RNE -0.1EI T COMMUNICATION ATION By law, all cities that suspended the effective date of the GRIP 4 surcharge must take final action on or before September 13, 2007. (Attached to this communication is a list of cities that have provided suspension resolutions to our office.) After review of Atmos Mid-Tex's GRIP filing for the 2006 rate year, we recommend that Atmos Cities Steering Committee (ACSC) cities adopt the attached resolution denying the requested surcharge on or before September 13, 2007. ACSC's rate consultant, Karl Nalepa, has identified approximately $3.4 million in expenses that are inconsistent with the statute and/or the Railroad Commission's order in the Company's most recent rate case. As discussed in the attached report, some of the inappropriate expenses included by the Company are expenses related to furniture and office fixtures. Atmos Mid -Tex has acknowledged that the Commission has excluded furniture expenses from the GRIP surcharge, and has removed some of the furniture and fixture expense from the current filing. The filing offers no explanation why any furniture or fixture expense remains part of the GRIP surcharge. In addition, Mr. Nalepa has identified expenses included in the surcharge that occurred prior to 2006, and are thus ineligible for inclusion in the 2006 GRIP surcharge. The ACSC Executive Committee has recommended that all ACSC members pass resolutions indicating support for legislative change to the GRIP statute to ensure fairness for ratepayers and eliminate piecemeal ratemaking for any change in invested capital. The denial resolution includes language consistent with the Executive Committee's recommendation. As always, if you have any questions regarding anything we send to you or need additional information, please feel free to contact us. Attachments: List of ACSC Cities Suspending GRIP 4 Surcharge Model Resolution Denying GRIP 4 Surcharge Model Staff Report Karl Nalepa's Report Regarding GRIP 4 Surcharge 25571021sent to citieslmmo070807kpf Lloyd Gosselink Blevins Rochelle & Townsend, P.C. MODEL STAFF REPORT ON ATMOS MID-TEX GRIP DENIAL RESOLUTION Purpose of the Resolution: Atmos Mid -Tex filed its fourth surcharge request under the Gas Reliability Infrastructure Program ("GRIP") statute, seeking to implement monthly surcharges of $0.59 (average residential customers), $1.47 (average commercial customers), and $28.74 for industrial customers. The resolution denies Atmos Mid -Texas 2006 surcharge request on the grounds that it does not comply with the law and is not reasonable. The resolution also indicates the City's support for statutory changes to the Texas GRIP statute to ensure fairness for ratepayers and to eliminate piecemeal ratemaking for any change in invested capital. What is GRIP? GRIP is piecemeal ratemaking and would be illegal under traditional ratemaking that is in the public interest. Atmos, TXU Gas, and other gas utilities persuaded the legislature in 2003 to make an exception to the prohibition against piecemeal ratemaking to encourage increased investment in transmission and distribution pipe by allowing prompt recovery of investment, despite the possibility that increased revenues and declining expenses could more than offset increased investment. Unfortunately, utilities have used the GRIP filings to include other costs unrelated to infrastructure improvements. GRIP surcharges are reconciled in a general rate case that the utility may not file for another five years. Did the Legislature Address the GRIP Statute in the Recent Legislative Session? The GRIP statute violates fundamental standards of regulatory ratemaking because it eliminates a basic aspect of fairness for ratepayers that has been part of the ratemaking process for decades. During the most recent legislative session, the Senate Business and Commerce Committee unanimously approved a bill that would have repealed the GRIP statute, largely in response to the abuses of the GRIP surcharge by Atmos Mid -Tex. However, by the end of the session, the gas utility lobby was successful in killing meaningful reform and the legislation died. It is important to start building support for legislative reform of the GRIP statute now. Issues regarding utility ratemaking and GRIP surcharges are very technical and can be difficult to effectively communicate during the heat of a legislative session. Cities can build on the effective information campaign that started in the recent session that recently concluded and prepare for the next session by communicating with the legislators about this GRIP filing. The Executive Committee has recommended that ACSC members adopt a resolution supporting legislative changes to protect natural gas ratepayers and opposing GRIP surcharges. This denial resolution includes that information and will be forwarded to the City's legislative delegation. Observations on the Filing Pursuant to its statutory authority, the City suspended the effective date of the Company's surcharge request to evaluate the filing, determine whether the filing complies with law, and if 2557/2/oth07o8o7kpd Stf Rpt - Deny Page 1 unlawful, to determine what further strategy to pursue. Review of the Company's surcharge request is particularly important given that the City, as part of the Atmos Cities Steering Committee, initiated a rate case (GUD No. 9670) in which the Railroad Commission determined that Atmos had included inappropriate expenditures in its previous GRIP surcharges for rate years 2003, 2004, and 2005. But for the investigation by the Cities, through ACSC, the impropriety of these expenditures and of their inclusion in the GRIP surcharges, would not have been exposed, and the refund of $2.5 million would not have been ordered. ACSC's rate consultant, Karl Nalepa, has identified approximately $3.4 million in expenses included in the 2006 GRIP surcharge request that are inconsistent with the statute and/or the Railroad Commission's order in GUD 9670. For example, the Company's surcharge request is based in part on inappropriate expenses related to furniture and office fixtures. The Commission excluded furniture expenses from the Atmos Mid -Tex GRIP surcharge in GUD 9670. The Company acknowledges this and has removed some of the furniture and fixture expense from the current filing. The filing offers no explanation why any furniture or fixture expense remains part of the GRIP surcharge. In addition, Mr. Nalepa has also identified expenses included in this surcharge request that occurred prior to 2006, and are thus ineligible for inclusion in the 2006 GRIP surcharge. Finally, Atmos Mid -Tex has just received a rate increase of approximately $5 million and should be collecting sufficient revenues to earn its allowed return without the necessity for a surcharge to recover incremental investment. NOTE: IT IS CRITICAL THAT ALL CITIES PASS THE RESOLUTION TO DENY ON OR BEFORE SEPTEMBER 13, 2007. Explanation of "Be It Resolved" Paragraphs: 1. This paragraph sets out the finding that the Company's request is unreasonable, and inconsistent with Railroad Commission precedent and the statute. 2. This paragraph provides for an immediate effective date. 3. This paragraph states the City's support for legislative reform of the GRIP statute to ensure fairness to ratepayers and to eliminate piecemeal recovery for any change in invested capital. 4. The paragraph requests the City's legislative delegation to support legislation in the 81" Regular Session of the Texas Legislature that would reform the GRIP statute to ensure fairness for ratepayers and eliminate piecemeal recovery for any change to invested capital. 5. This paragraph cites conformance with the Open Meetings Act. 6. This paragraph directs that a copy of the signed ordinance be sent to a representative of the Company and a representative of the coalition of cities. 2557/2/oth070807kpd Stf Rpt - Deny Page 2 August 3, 2007 MEMOTO: Geoffrey Gay, Kristen Doyle, Georgia Crump FROM: Karl Nalepa SUBJECT: Atmos Energy Mid Tex 2006 GRIP Review On May 31, 2007, Atmos Energy Mid Tex (Atmos or Company) filed its latest request for an interim rate adjustment for calendar year 2006 under the Gas Reliability Infrastructure Program (GRIP). The Company's proposed increase to current customer or meter charges is summarized in Table 1: Table 1 Rate Schedule Charge per Month Rate R -- Residential Sales $0.59 Rate C — Commercial Sales $1.48 Rate I — Industrial Sales $28.90 Rate T — Transportation $2890 RJ Covington Consulting (RJC) has reviewed this GRIP filing and has confirmed that Atmos has removed certain costs that were disallowed by the Texas Railroad Commission (RRC) in Atmos' most recent rate proceeding.' However, RJC has identified several other items which we believe are inappropriate to be recovered from ratepayers through this interim rate adjustment. Costs Removed The costs removed by Atmos in this filing2 consistent with the RRC order in the most recent rate proceeding are summarized in Table 2: Table 2 Adjustment Amount Remove SSU 2006 Additions for Ancillary $ (107,520) Equipment office furniture) Remove Mid -Tex 2006 Additions for Ancillary (100,317) Equipment artwork, office furniture, equipment) .Adjustment for Changes in SSU Cost Centers (2,764,894) 2006 Overhead Allocations to Mid-Tex3 GUD No, 9670, Order on Rehearing, June 13, 2007. 2 Workpaper/Schedule A R.J. Covington Consulting, LLC (512) 331-4949 11044 Research Boulevard, Suite A-325 Fax: (512) 331-5743 Austin, Texas 78759 www. RJCovington. com August 8, 2007 Reduction of Mid -Tex 2006 Capitalized (20,718,589) Overheads to 13.5% Remove Direct Expense Account Costs Included (254,511) in SSU 2006 Additions (see Table 3 for details) Remove Direct Expense Account Charges (26,130) Included in Mid -Tex 2006 Additions see Table 3 Remove Expense Account Charges within SSU (219,956) Overheads Included in Mid -Tex 2006 Additions (see Table 3) Remove Expense Account Charges within (235,404) Business Unit Overheads Included in Mid -Tex 2006 Additions (see Table 3) Total $ (24,427,321 The amount of capitalized expense removed from the filing, detailed by type of expenditure,4 is shown in Table 3: Table 3 Meals & Misc. Other Personal Travel Total Mid -Tex Lodging Entertain. Expenses Expenses Vehicle E ense Ca ital) Allocated SSU 243,162 119,196 51,818 11,916 2,134 224,832 653,059 254,511 Direct Mid -Tex 10,986 9,210 0 2,545 1,095 2,294 26,130 26,130 Direct SSU 333,567 505,954 395,624 10,967 0 654,093 585,196 219,956 Overhead Mid -Tex 45,445 51,369 13,987 4,551 49,139 70,913 235,404 235,404 Overhead Additional Adjustments While Atmos did remove significant categories of costs disallowed by the Order in GUD 9670, it still included other costs that should be removed. These costs are summarized in Table 4: Table 4 Project Number Description Amount 080.19238 Purchase and install $46,638 telecommunication and security system for the Hillsboro Service Center 080.19239 Purchase and install $48,267 telecommunication and security system for the Gainesville Service Center 3 1203 - Amarillo Customer Support Center, 1210 - Waco Customer Support Center, 1904 - Dallas Performance Plan, 1908 - Dallas Supplemental Executive Benefits Plan 4 Response to ACSC 1-5. 2 August 8, 2007 080.19806 Purchase furniture for the Boyd Facility $147,382 010.11055 Purchase computer equipment — hardware & software $555,187 ADMIN 080 retirement Asset transfer from Atmos Pipeline & Stomp to Mid -Tex $1,964,272 Adjustments General Office $140,756 Adjustments Customer Service $493,791 Total $3,396,293 Project 080.19238 According to Atmos' response to ACSC 1-12, this project is actually to purchase furniture and fixtures for the Hillsboro Service Center. Atmos has removed similar costs and hasn't shown why these particular costs remain in the filing. Project 080.19239 According to Atmos' response to ACSC 1-12, this project is actually to purchase furniture and fixtures for the Gainesville Service Center. Atmos has removed similar costs and hasn't shown why these particular costs remain in the filing. Project 080.19806 Atmos has removed similar furniture purchases, and hasn't shown why these particular costs should remain in the filing. Project 010.11055 According to Atmos' response to ACSC 1-23, this project relates to the purchase of computer equipment allocated to Mid Tex. The project was described as items purchased during the Mid Tex integration. While no invoices were provided, the acquisition of Mid Tex occurred in October 2004, with the transition occurring through 2005 - at least a year prior to the 2006 GRIP year. Based on the description of the assets, these purchases were made prior to the GRIP test year and should be removed. Project ADMIN 080 This project involves the transfer of existing assets from Atmos Pipeline to Mid -Tex. First, these plant casts were incurred prior to the GRIP test year, and are therefore ineligible under the GRIP statute.5 Second, even if the costs should be included, they represent the cost of retirement. Transferring an asset that is no longer used and useful to Mid -Tex just so its customers can bear the cost of retirement is not reasonable. s TEX UTIL CODE § 104.301 (b). August 8, 2007 Adjustments to General Office and Customer Service According to Atmos' responses to ACSC 1-28 and 31, Atmos claims adjustments to General Office and Customer Service plant in the amounts of $140,756 and $493,791, respectively, for a total adjustment of $634,547. This adjustment is the result of the change in the shared services allocations factors between 2005 and 2006. The 2005 factors for General Office and Customer Service were 36.95% and 48.50%, while the 2006 factors were 36.88% and 49.02%. Atmos revised the allocation factors based on changes in the component factors for 2006.E This raises the question of whether allocation factors can be revised under GRIP. All other factors (such as return, depreciation, taxes, and class allocations) are fixed until the next full rate proceeding,7 so it would be reasonable to expect that the factors used to allocate shared services expenses also be fixed from the last proceeding. Results Removing these additional categories of costs results in a reduction to 2006 net plant investment of $3.4 million. Applying this reduction to the rates as proposed by Atmos yields the revised charges reflected in Table 5: Table 5 Rate Schedule Revised Charge per Month Difference Rate R — Residential Sales $0.57 $0.02 Rate C — Commercial Sales $1.44 ($0.04) Rate I — Industrial Sales $28.07 ($0.83) Rate T — Transportation $28.07 ($0.83) Atmos also proposed a revised methodology to calculate ad valorem taxes based on actual 2006 tax payments due to the recent changes in property tax law. If this alternative methodology is adopted, property -related taxes are reduced by $67,368, and the interim adjustment is reduced by a further $0.01 for commercial customers and $0.16 for industrial and transportation customers. The adjustment is too small to materially affect residential customers. Let me know if you have any questions. 6 Response to ACSC 1-6. TEX UTIL CODE § 104.301 (d). 4 CITY SUSPENSION RESOLUTIONS Suspending Atmos' System -Wide Rate Increase (GRIP 4) city 1. Abilene 2. Addison 3. Allen 4. Alvarado 5. Angus 6. Arlington 7. Bedford 8. Bellmead 9. Benbrook 10. Blue Ridge 11. Bowie 12. Boyd 13. Bridgeport 14. Brownwood 15. Burkburnett 16. Burleson 17. Carrollton 18. Cedar Hill 19. Celeste 20. Celina 21. Cleburne 22. Cl de 23. College Station 24. Colleyville 25. Colorado City 26. Comanche 27. Co ell 28. Corinth 29. Corral City 30. Crandall 31. Crowley 32. Denison 33. DeSoto 34. Duncanville 35. Eastland 36. Ed ecliff Village 37. Emory 38. Ennis 39. Everman 40. Fairview 41. Farmers Branch 42. Farmersville 43. Fate CADocuments and Settings0ougTocal Settingffemporary Internet FileslContent.0utlooklZTIXTCLL\070807 Suspending Cities.doc 1 CITY SUSPENSION RESOLUTIONS Suspending Atmos' System -Wide Rate Increase (GRIP 4) 0tv _ Flower Mound 44.1 45. Forest Hill 46. Fort Worth 47. Frisco 48. Frost 49. Gainesville 50. Garland 51. Garrett 52. Grapevine 53. Haltom City 54. Harker Heights 55. Haskell 56. Haslet 57. Heath 58. Hewitt 59. Highland Park 60. Highland Village 61. Honey Grove 62. Hurst 63. Iowa Park 64. Irvin 65.1 Justin 66. Kaufman 67. Keene 68. Keller 69. -.Kemp 70. Kennedale 71. Kerrville 72. Killeen 73. Krum 74. Lakeside 75. Lake Worth 76. Lancaster 77. Lewisville 78. Lincoln Park 79. Little Elm 80. Malakoff 81. Mansfield 82. McKinney 83. Mesquite 84. Midlothian 85. MuThy 86. Newark 87. Nocona Mocuments and Settings\DouglLocal SettingMemporary Internet FileslContent.OutlooklZTIXTCLL\070807 Suspending Cities.doc 2 CITY SUSPENSION RESOLUTIONS Suspending Atmos' System -Wide Rate Increase (GRIP 4) City 88. North Richland Hills 89. Northlake 90. Ovilla 91. Palestine 92. Pante o 93. Paris 94. Pecan Hill 95. Plano 96. Pottsboro 97. Prosper 98. Red Oak 99. Richardson 100 Robinson 101 Rockwall 102 Roscoe 103 Rowlett 104 Sachse 105 Saginaw 106 San Angelo 107 Seagoville 108 Sherman 109 Snyder 110 Southlake lll Stamford 112 Stephenville 113 Sulphur Springs 114 Sweetwater 115 The Colon 116 Trophy Club 117 Tyler 118 University Park 119 Vernon 120 Waco 121 Watauga 122 Waxahachie 123 Westlake 124 Whitesboro 125 White Settlement 126 Wichita Falls 127 Woodway 1281 Wylie C:1Documents and Settings\Doug%ocal SettingslTemporary Internet FileslContent.Outlook1ZTIXTCLLI070807 Suspending Cities.doc 3 PLANNING 51, i \ F f- { P-i, a S To: Mayor and Town Council From: Chris Copple, Senior Planner Cc: Hulon T. Webb, Jr., P.E., Director of Development Services/Town Engineer Re: Town Council Meeting — August 28, 2007 Date: August 22, 2007 Agenda Item: A public hearing to consider and act upon an amendment to the Old Town Core District of the Town's Future Land Use Plan. (CA07-2). Description of A enda Item: A comprehensive plan is a guide, in that its recommendations are area -wide rather than site specific. A comprehensive plan is not a zoning plan, although it contains recommendations that affect the zoning and subdivision ordinances. The Town of Prosper's Comprehensive Plan does not make recommendations concerning the location of different uses in the Old Town Core District. During the process of rezoning portions of downtown earlier this year, it was recommended Town staff draft an amendment to the Comprehensive Plan to provide more direction to the Planning & Zoning Commission and Town Council for considering zoning requests located in the Old Town Core District. Town staff is proposing to add an inset to the Future Land Use Plan for the Old Town Core District providing a guide for future zoning requests for properties located in the Old Town Core District. The proposed inset is attached and is titled "Old Town Core District Inset." The proposed amendment supports: • Commercial development along the east side of the BNSF Railroad. • Retail development in the original downtown of Prosper. • Office development along Broadway Street, a state road with 100' of right-of-way, between Coleman Street and Craig Street. • Office development along First Street, a future thoroughfare, between McKinley Street and Craig Street. • Retail development along Preston Road. • Office development between Fifth Street and Sixth Street on the west side of Coleman Street to act as a buffer between the retail to the south and the residential to the north. • Single family residential development north of Broadway Street, east of Coleman Street. • Single family residential development south of Broadway Street, north of First Street, between Coleman Street and Craig Street (excluding the office between Church Street and Parvin Street). • Single family residential development north of Sixth Street, west of Coleman Street. Planninci & Zoning Commission Recommendation: The Planning & Zoning Commission held a public hearing to consider and act upon an amendment to the Old Town Core District of the Town's Future Land Use Plan at their August 7, Agenda Item No. 6 - Page 1 of 2 2007 meeting. The Planning & Zoning Commission recommended approval of the amendment to the Old Town Core District of the Town's Future Land Use Plan by a vote of 5-0 subject to the following conditions: 1. The 5.5± acres on the west side of Coleman Street, 100± feet north of Seventh Street shall be shown as Retail on the Old Town Core District Inset. 2. The 8.0± acres on the west side of Coleman Street, north of Sixth Street shall be shown as Office on the Old Town Core District Inset. Town staff has prepared an exhibit titled "Old Town Core District Inset — Planning & Zoning Commission Recommendation" that reflects the recommendation. Budnet Impact: There are no significant budget implications associated with amending the Old Town Core District of the Town's Comprehensive Plan. Le al Obligations and Review: The public hearing has been notified in the Dallas Morning News in accordance with state law. Town staff notified all citizens in the Old Town Core District area by mail that a public hearing would be held by the Planning & Zoning Commission on August 7, 2007 to consider and act upon amending the Old Town Core District of the Town's Future Land Use Plan. Several citizens attended the public hearing on August 7, 2007 and were made aware that a public hearing would be held by the Town Council to consider and act upon amending the Old Town Core District of the Town's Future Land Use Plan on August 28, 2007. Attached Documents: 1. The current Future Land Use Plan — Old Town Core District Map 2. Proposed Future Land Use Amendment — "Old Town Core District Inset" 3. Proposed Future Land Use Amendment — "Old Town Core District Inset — Planning & Zoning Commission Recommendation" 4. Zoning Map of the Old Town Core District Area Town Staff Recommendation: Town staff recommends that the Town Council approve the proposed amendment to the Old Town Core District of the Town's Future Land Use Plan. Agenda Item No. 6 - Page 2 of 2 Z Q J W U) O Z Q J W rr H !L F- Z W cr cr D U �U N A Q} E E (u m O UCL U _ C CU (D Ui]'N o C N Lr O C!) (n 0 E 1111 LI,0 Off o N U N N r_ O U) 0L Cn C7 I 1111111 L Exhibit A I SF-10 SF-1102.5 : PD-12 PD- +3 �.ii ^PRo�Pl_R1'4� .. I .. . SF=12.b 1 $TEf I;A{v'_ Litiy PI?-30, 2 BRYAN s3ff SF-E SF-1 s Oil t Pb-6 L�DnVETRi- -� EAG'-- -!-N J SF-15. SF-1$. SF- r3ASFARKiR _ SF-15 SF-15 SF-15 +I I I. {' CEY VIF%fq k4F ..^F-1 dTSF _IGHTMfS7_� PD 37 ` i j x SF-15 SF-15 -� -1--- Ir 10 I .. S-15 1FY�1 F S7. .� l �I I —1 SF-150. P PD-21 P-:I r1=�'.b'A�Y. 81 +.7 LU z �E}TF ' I�Ir3 P 17 P 7 t—A SECOND ST PD 1.7 FIRS F ST D — C C 9F-��. IPA C DTO I R PD-3 RfCfO SFF iF SF 1 SF -I4' SF 'I PD- 1 TOWN OF. PROSPER Existing Zoning - Downtown Source: Town of Prosper Planning Date: July 12, 2007 tt� P' 1 inch equals 750 feet N 0 500 1,000 y Feet 1 '1 Legend -••- City Limits ETJ Parcels Q Existing Zoning Boundaries August 15, 2007 Dear Honorable Mayor and Council Members: I am pleased to present the proposed FY 2007-2008 budget for the Town of Prosper for your consideration. Prosper is at an exciting time in its history, faced with the possibilities and challenges offered by the explosive growth confronting it. Located in the fastest growing county in Texas and one of the fastest growing counties in the United States, Prosper must balance the infrastructure demands and citizen and business expectations of service against the Town's ability to fund these needed items. It is also an opportunity for today's leaders to lay the solid foundation for the Town to promote the sustainable, quality development necessary to improve the quality of life of future generations. This budget is an important step in that direction. One way to look at the Town government is to consider it a parent company operating many different and diverse subsidiary businesses. All of these "businesses" should be operated in a business -like manner, but not necessarily as a private sector business would. For example, some of the subsidiaries, like the water system, are true enterprise operations and should rely on their program income and not operate at a loss. Other subsidiary operations, such as parks or streets, generate little or no revenue and rely on funding from other non -program. sources. The FY 2007-2008 budget process was different from recent years in that the Business Manager and other department heads were involved throughout the process and the budget workshops were in a different format. In addition to these changes, the lack of continuity in the Town Manager's office added extra complexity to the process. Council and staff are commended for handling the process without missing a step. In this letter I will establish the context of the budget and highlight significant revenue and expenditure items. Overview The proposed budget includes several items that affect multiple departments, including 1. Salary Study — Waters Consulting presented the results of a salary and benefits study to the Council in July 2007. The plan calls for a three-phase implementation that will bring all positions to the base salary identified by the study within 12 months. The study compared each individual position with comparable positions in a selected group of cities with which Prosper competes for labor. The study determined that, on average, non-public safety related positions were 16.1 percent below market and public safety (i.e. fire and police personnel) were 28.4 percent below market. The net fiscal impact of following the recommended plan is $152,364. 2. Group Insurance — Request for proposals were received for group medical, dental, accidental death & dismemberment, and life insurance. After careful evaluation Council decided to change carriers for a net savings of $38,672 while at the same time improving the level of coverage in certain areas. 3. Mileage Reimbursement — Effective January 2008, the proposed budget allows for increasing the Town's mileage reimbursement rate to $0.55 per mile to possibly match the Internal Revenue Service's rate increase published in January or each year. 4. Copier Leases — Currently each department makes its own arrangements for photocopiers. In FY 2007-2008 it is proposed that all copiers come under a single lease in order to take advantage of volume pricing and to simplify administration. 5. Telephone System. City offices are currently located at six locations, each with their own phone system. This fractured telecommunications arrangement inhibits customer service and reduces efficiency because each office can only be accessed by a ten digit phone number (rather than a three digit extension) and requires at least three telephone attendants. Some of these systems also have maintenance issues. A new, unified telephone systerf; is proposed that is portable, allow easy transfer of calls to di cYeil, tccai;ons, tniiform and enhanced voicemail capabilities, and can be operated by as few as on:: attemdant; if necessary. 6. Growth Rate — Based on historical data, including building permits, new water meters, and growth studies, the budget assumes a 16 percent annual growth rate. This assumption d.i ;ts certain revenue and expenditure line items such a utility franchise payments. maintenance and operations costs, etc. 7. Contingency — Section 7.08 of the Charter requires that a minimum of ten percent of total general fund expenditures be budgeted for use on unforeseen expenditures. This requirement was established by the Charter adopted in November 2006 and has not been part of the Town's budget in the past. After evaluation by the Town. Attorney, Auditor, and other Town staff, the contingent expenses will be offset by contingent revenues of the same amount. Revenue Ad Valorem. Ad valorem (property) taxes represent the largest single revenue source (41 percent) for the General Fund. According to the Collin County Appraisal District, as of January 1, 2007, Prosper had added $112,400,000 in new construction and $12,100,000 through annexation in 2006 for a total taxable value of $762,250,305. During calendar year 2006 the average residential homestead value increased from $280,800 to $316,400. The proposed tax rate of $0.52 exceeds the effective rate of $0.426053 and the rollback rate of $0.487886. Prospers ad valorem value per capita is $93,751 compared to the area average of $80,688 while the ad valorem revenue per capita is $468 compared to the average of $411. Sales Taxes. At 22 percent sales tax is the second largest source of revenue for the General Fund. In FY 2006-2007 the Town unexpectedly lost two large sales tax providers, causing sales tax revenue to drop by about 20.84 percent. Although there is currently some commercial retail development in various stages of construction or planning, sales tax is predicted to grow a modest 2.4 percent. Even with the anticipated growth sales tax revenue will still be lower than what was received in FY 2005-2006. Utility Rates. No changes in water, wastewater, or sanitation rates are proposed. A residential water customer in Prosper who consumes 5,000 gallons will still pay $27.46 while the area average is $22.47. A 50,000 gallon commercial customer will pay $289.37 in Prosper where the average is $202.63. The residential wastewater pays $22.38 for 5,000 gallons and the average for the same consumption is $22.06; 50,000 gallon commercial customers pay $66.30 to Prosper and average $146.38 in the area. Interest Income. Due to a reduction in the fund balance, interest income is anticipated to be lower by 26.7 percent ($22,720). Expenses Highlights of each department's appropriations are detailed below: 1. Administration a. 5340Building repairs. The Prosper Economic Development Coipo, ation. is expected to move from their current location in Town Hall, an oppoit city to expand the utility billing office to a%:.G minodatc Llie second utility billing clerk proposed in the budget. b. 5410/Professional Services. Engaging a consultant to assist with development of a strategic plan. c. 5480/Contracted Services. Posting of Code of Ordinances on the Internet to improve citizen access. 2. Police a. 5110/Salaries. Two new positions are proposed. Currently, when the Court Clerk (the only civilian employee) is out on an errand, on vacation, etc., the Municipal Court and Police Department must be closed to the public. The addition of an Administrative Assistant will improve customer service by allowing Municipal Court and Police Department to be open when the Court Clerk is out. The position will also improve department administration. The second position is a Patrolman. Adding another officer will help meet the demands of a growing population. Future Considerations Over FY 2007-2008 several issues will require investigation and planning. First, there is no doubt that the retail sector in Prosper is poised for very high growth, particularly along the Highway 380 and Preston Road corridors. The sooner retail outlets develop, the quicker pressure on ad valorem revenue can be reduced by replacing it with increasing sales tax revenue. Indeed, construction, agreements, and planning for several projects are already underway. The United States and north Texas economies appear to be entering more uncertain times, as evidence by slower home sales, increasing supplies of lots, higher home foreclosure rates, etc. To date Prosper has not felt the full negative impact of a slowing economy as some of our neighbors have; however, our local economy should be monitored closely throughout the entire year and adjustments made to the budget accordingly. Second, most of the debt for water and wastewater is being covered by the General Fund. This arrangement is not necessarily wrong but it does mask the true cost of operating these utilities. For example, even without the debt included, wastewater system revenues are not sufficient to meet the systems expenditures. Additionally, until sales tax revenues increase significantly, the Town is very reliant on ad valorem revenue. If ad valorem revenue has to be used to subsidize enterprise operations, that means there is less money available to meet the increasing demands on General Fund programs such as streets, parks, and emergency services. A fairness argument can also be made that all citizens are being charged for part of the utility system, regardless of their consumption of the service, when the cost of the service should be borne by those who consume the service. Careful consideration should be given to charging water and sewer debt to their respective enterprise funds and adjusting the customer rate structures so that they can pay for all system costs. Third, a major area of concern operationally is the lack of any semblance of a purchasing system or policies. Currently each department buys material, equipment, and services individually, frequently without the prior knowledge of the Finance/Business Manager or Town Manager. Significant economies of scale are lost and the inability to properly manage the budget throughout the year, at a minimum, jeopardizes the efficiency and effectiveness of the government and at worst can potentially imperil the soundness of the overall budget. Fourth, as described earlier, the proposed budget includes implementation of the Waters Consulting Group salary study; however, as also noted, it only brings salaries to the base level identified in the study. If the Town is to be competitive in the labor market and attract and retain the quality employees required to provide the level of service demanded by our citizens, then it will be necessary to consider additional increases to raise salaries to the average range identified in the study. Fifth, research and planning should begin in FY 2007-2008 for transition to dispatching emergency services ourselves. Currently the City of Frisco provides dispatching for the Town but, at their request, the Town has committed to leaving Frisco dispatch sooner rather than later. It is possible the Collin County Sheriff's Office would dispatch Prospers emergency services; however, this is likely a short to medium term solution. Prospers call volume does not meet the minimum criteria to qualify for its own public safety answering point (PSAP) but is predicted to do so by late in calendar year 2008. For Prosper to operate its own dispatch service will require an annual budget commitment of over $250,000 in personnel costs, plus a few hundred thousand dollars in initial capital costs, and expenses related to additional space in facilities that do not presently exist. The General Fund will not be able to absorb such a large expense in the short term but beginning research and planning now will ensure an orderly and responsible transition. Lastly, the current format of the budget needs to be revised to improve readability, understanding, and usefulness. Closing _ I would like to thank Finance/Business Manager Ron Butler for the many late nights and hard work running the numbers and adapting to a different way to do the budget process. The Department Heads also deserve kudos for preparation of their respective budgets and willingness to thoroughly participate in the process. I would also be remiss if I did not thank the Mayor and Council for their patience and thoughtful consideration and input. I have enjoyed my brief tenure with the Town of Prosper and know that incoming Town Manager Mike Land will provide valued leadership throughout the implementation of this budget. Please do not hesitate to contact me if you have any questions regarding this document. Respectfully submitted, Kevin Carruth Interim Town Manager MEMORANDUM TO: MAYOR AND COUNCIL FROM: MIKE LAND, TOWN MANAGER DATE: AUGUST 23, 2007 RE: 2004, 2006 Bond Activity Report Included with your monthly financial report is a copy of the bond activity report for the two bonds referenced to above that you have typically received in the past. In order for you and staff to get a better understanding of the remaining funds, with and without interest, and the status of current or planned projects, we have prepared the additional spreadsheets. These spreadsheets capture the same basic information regarding funds expended to date and expand on planned expenditures and related interest earned. The new spreadsheets for the 2004 and 2006 bond programs begin with their issued amount (highlighted in yellow in the upper left hand corner of the first sheet for each bond), a defined time frame for coverage (listed under the title of each spreadsheet), a summary list of expenditures already accounted for, and a list of projects that are either on -going and/or committed to. The 2006 bond planned expenditure spreadsheet for the coming year, over and above already committed or on -going projects, is provided for discussion purposes only. Column 5 of the spreadsheets gives you the running remaining balance of the specific bond without interest. That number is then forwarded to the beginning of the next fiscal year and those funds, without interest, are used for either the on -going or committed projects. At the conclusion of these projects interest is then added to the remaining balance to generate the particular bond balance with interest, which is highlighted in yellow in the lower right hand portion of the spreadsheet. After all committed projects are taken into account, the 2004 bond balance with interest at the end of Fiscal year 2007-2008, without any additional planned projects (staff is still generating a list), is projected to be $994,397. The 2006 bond program balance with interest at the end of Fiscal year 2007- 2008, without any additional planned projects, is projected to be $4,337,872. The selected planned projects for the 2006 Bond, if selected, total $2,451,000. This will reduce the 2006 remaining bond fund balance to $1,886,872 with interest. $ !, 7 | !, e fp 2 . - ! Im ® \ (® ƒ | ( � \ 4 & § |2 § R k K k � ,2( p jk\ § 7 , . {\ f} ( Q~ L V •'. o d s p Op pOp A O p d V' C 411 A +� 6 a .'. m P � 9 O21 a n �• � � � � m i- S n � s � a $ s ti m 3 � •� m W S N � S S R V x w N 0 0 0 $ o 0 to in - N N V� i^ a vs an an � 00 �a o a is W o o � c � a a a O CL a yp pN � p V v V m 2 m ippP !0 1 A R m � s= a J O O O g; Ctl � ^ yy T 666 N m O G O p O O V pppp M W � O � m pO d a pqp 4 S T ` - f&J - § � i | ■ ! � a to"�o k | \i {ƒ � !§ ,■ (�£ \ � �� 0 A W N 4 9 N 3 N � ri O e S y % ti a � A ° � l� f 9 � � S S S ° O R H W � p T � N •f d N � p r d � �� S � n rV N � — H H V! i/s 4} U> - N A a W� a a `� o m rt `.i y ° a a° 5 6. 3 7 v> 1n N V+ l/i sn an art — an � O q p O O C J m % N N N N 6 n YpN to to in 1n � u N y p $ $ S $ 8 L q s 8 8 8 $ 8 A N N II a„ oW �s= 0 u o 8 C O 0 � 9 O C R N po y 'n A � $ r w 8 ti N o CV T cn G W O Q O W k ƒ� �■� � � ( \§k � ( { �■�� �` } %� ( £ 2 | ■ E Ef § e /} LF \ ( � ■ � � |§ » i EZ B@ ■ § ■ B Ba B k a }�\ #� � �k\ _ 7 '($ . ! , 7 § ■ ® k k' I � 0 » � 0 3 CL 6 d 2. W w 40 M O O 40 n yo n m p 4s r r h CL 71 cc OD 9 T cc 3 S pp Q � � :F iF Q• O. h 0 0 0 C3 b O C 0 b O r k h c r. a m N N Of N N N N N P � h t Oa N m A3 N N Qf O? fA fn 60 4A At Ep 49 to to C 7 W pi N' O - p m [.W 4 it SM 4 4 O O 0 0 O Q fA 61 fR to At f9 fa fA fA r 3 h O p m _ D Q pO O rl Q .cm N LT O O © 0 p 0 m Y A q N A a A N A A d� Q G G QO O y OO O p� (R O O b O O O 0 T h z x � � 3 m � a N A to W N � fA ca w cn cH w = 0 CT fh CT � to � fa a 0 v a o o b C]b f] O (A fA fo W W 69 LA w so A SO SO 0 0 0 a o p O G C O p �1 0 0 CD .0 O ' • a O dA bA N to fA of ow to CD m to CA 0 0 IN U G b a P O O G b b C7 O 0 0 0 0 [a b b o 0 0 0 k B B - _a tw f2�E■¢ }� 22 � $ & � 2 f . �K� : ■ k. ■ 2lie It 13 # k/ k i i g * - - t g k k £ E £ is # e 7j234: e g > # # E e § & $ § ■ � I2r I]■ « § 6 # # § & I � ■ g � w 2 � - § $ M 8 ■ 2 � S2 2 T � � � r k 13 w A C is n D 9 T 01 N A A W O p O m x o > > m m o 9 m 0 m m m �p S Q L" w 03 A �o N w m m A A m m N m w � a n o 0 04 0 fA (9 0 w , • O O O O f:� fA fy 6A W A W � OQ 0 0 f/! fa 69 69 fo O a mm to n p Q O O c o a o 0 a n m D W N N N Z m 0 0 N O b C. � m 0) a .0 a f) a m o " 3 ok m_ n m x. W U N U [m11 (D Cl A m m m m Co m m Im 6A fA fR 0 0 0 0 fa fA fn v, N A O A# O C. AO O O 0 a 0 0 00 a 0 a fn m G 4 CD m 49 10 (A iA oai 4 g o 0 0 0 0 0 N m N U 8 w w w O O W IM m N W N Q m d m m m m m m m m m m m m m m co m w te m m m w w w w w w W w w t1r O © O t)r w cn O D a d is n o o n v� f» fe m fn v+ w fH m [T Of m CIS N ...a i0 a a m V 0 A V i 0 a o o vs o a w w p� rn w o a a a a O o o p P fo f9 O O O O O O 6N fA 64 L! fp 69 fA bi W V W CID N W m O a O 69 m m fR fA [A m fn m m m w m C-D A 1V fyT O 0 V 8 co m i 0 o a o. p o 0 0 m 00 0 0 0 r- 3 a § § I % � § � i I 9. 2 � , g.g 9 #.I./. 2 its I ; « Is * kk�kk§i s � # # -_ E E ■ I a £ --�»--� a ■ s & � � s � k k k k k § § . G , P, S. . E § £ # k & 6 q § E■#,a■■ 2 § § & I I § k w r& L� FY 2007m2OO8 Proposed Budget *"This budget will raise more total property taxes than last year's budget by $1 267,257, 44.92%, and of that amount $651,388.98 is tax revenue to be raised from new property added to the roll this vea r." *Indudes Debt Service and General Fund expenditures Rev 8115107 F PROPOSED BUDGET FY 2007 - 2008 October 1, 2007 - September 30, 2008 R Rev 08/15/07 FY 2007 - 2008 PROPOSED BUDGET SUMMARIES October 1, 2007 - September 30, 2008 xevosnsro7 y� R�bi T'.'N ()rR Town of Prosper Fiscal Year 2007 - 2008 Proposed Budget CONSOLIDATED STATEMENT A B C D Projected Proposed Actual 2005- Budgeted 2006- Year End Budget 2006 2007 2006-2007 2007-2008 GENERALFUND REVENUES 4,339,447 4,328,761 4,135,495 5,357,419 EXPENDITURES 3,231,084 4,277,455 4,045,544 5,357,418 WATER 1 SEWER FUND REVENUES 3,742,356 3,266,665 3,266,500 3,867,000 EXPENDITURES 1,087,687 3,438,653 3,295,019 3,851,914 DEBT SERVICE FUND REVENUES 926,276 1,791,055 1,813,656 1,965,930 EXPENDITURES 834,524 1,706,684 1,916,092 1,866, 948 CAPITAL PROJECTS FUND REVENUES 12,453,373 165,500 660,312 206,100 EXPENDITURES 158,380 19,491,238 9,615,152 8,404,244 PARKS FUND REVENUES 271,301 607,000 378,000 614,000 EXPENDITURES 183,304 - 31,000 35,000 IMPACT FEES FUND REVENUES EXPENDITURES 1,288,762 - 1,208,744 1,090,188 1,403,400 287,600 2,223,500 449,200 INE71 REVENUES OVER (UNDER) EXPENDITURES 0 1,288,7621 118,5561 1,115,8001 1,774,300 ECONOMIC DEVELOPMENT CORP, REVENUES 540,089 520,000 468,000 440,000 EXPENDITURES 230,308 324,943 218,351 319,066 R -t,R Town of Prosper FY 2007 - 2008 Town Budget General Fund Summary Fund Balance/ Reserves Proposed Account FY 05106 I FY 06/07 I FY 06107 I FY 07 / 08 I Description Actual Budgeted Projected Budget GENERALFUND REVENUES Taxes: Property Sales Franchise Licenses, fees, and permits Charges for services Grants Investment Income Fines, warrants and seizures - Contributions Miscellaneous EXPENDITURES Current: General Government Police Department Fire Department Streets Parks and Recreation Inspections Engineering Planning Capital Outlay $ 762,200 $ 1,050,041 $ 1,087,841 $ 2,179,403 $ 1,508,786 $ 1,603,800 $ 1,173,744 $ 1,202,000 $ 201,064 $ 202,980 $ 236,980 $ 269,065 $ 960,326 $ 1,147,040 $ 1,212,280 $ 1,144,950 $ 303,660 $ 143,700 $ 152,750 $ 148,820 $ 33,089 $ 30,000 $ 32,250 $ 184,000 $ 74,363 $ 43,200 $ 85,150 $ 62,430 $ 106,481 $ 105,000 $ 105,500 $ 120,000 $ 33,462 $ - $ - $ - $ 355,887 $ 3,000 $ 49,000 $ 46,750 Total Revenues $ 4,339,318 $ 4,328,761 $ 4,135,495 $ 5,357,419 $ 601,398 $ 796,781 $ 832,000 $ 912,461 $ 785,210 $ 990,119 $ 903,545 $ 1,196,475 $ 909,617 $ 1,170,412 $ 1,073,130 $ 1,367,129 $ 209,309 $ 339,339 $ 332,449 $ 285,059 $ 29,561 $ 86,418 $ 74,248 $ 200,441 $ 294,691 $ 476,148 $ 444,732 $ 562,771 $ - $ - $ - $ 130,716 $ 158,360 $ 211,709 $ 175,560 $ 288,288 $ 242,937 $ 206,529 $ 209,879 $ 414,078 Total Expenses $ 3,231,084 $ 4,277,455 $ 4,045,544 $ 5,357,418 Excess $ 1,108,235 $ 51,306 $ 89,951 $ 0 OTHER FINANCING SOURCES(USES) Capital Leases $ $ $ _ $ Transfers (out) $ $ $ $ Transfer Out for Debt Service $ $ - $ $ Total Other Financing Sources (uses) $ - $ $ $ - Net change in fund balances $ 1,108,235 $ 51,306 $ 89,951 $ 0 Fund Balance, beginning (as stated) $ 1,820,709 $ 2,587,322 $ 2,587,322 $ 2,677,273 Fund Balance, ending $ 2,928,944 $ 2,638,628 $ 2,677,273 $ 2,677,274 16% Reserve Calculation: Less Restricted Funds -Contributions Police & Fire Donations -Utility 8 Escrow for sideways, etc $ {6',230) S $ $ Court Security Fund S f,867) S $ S Court Technology Fund 5 (212} 8 8 5 (341.821) 8 S 8 Balance of Unrestricted Funds $ 2,587,322 $ 2,638,628 $ 2,677,273 $ 2,677,274 16% Reserve $ 516,973 $ 684,393 $ 647,287 $ 857,187 Amount over / (under) Reserve $ 2,070,349 $ 1,954,235 $ 2,029,986 $ 1,820,087 Actual Reserve % Pa e 1 80.08% 61.69% 66.18% 49.970/c .I. 0 V6 f 1V {-} I� , SR Town of Prosper Fiscal Year 2007 - 2008 Summary of Revenues By Department Proposed Account FY 05/06 FY 06107 FY 06 / 07 FY 07108 Description Actual Budgeted Projected Budget General Fund Administration Police Court Fire Streets Parks / Recreation Communication Inspections Planning Water & Sewer Fun d 4,339,447 $ 4,328,761 $ 4,135,495 $ 5,357,419 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 Parks Fund Park Dedication Fees $ 99,146 $ 255,000 $ 258,000 $ 259,500 Park Improvement Fees $ 172,155 $ 352,000 $ 120,000 $ 354,500 Parks Fund Totals $ 271,301 $ 607,000 $ 378,000 $ 614,000 Impact Fees Fund Interest Income $ 51,206 $ - $ - $ - Water Impact Fees $ 463,687 $ 419,696 $ 516,000 $ 678,750 Wastewater Impact Fees $ 361,462 $ 363,648 $ 458,000 $ 514,250 Thoroughfare Impact Fees $ 412,407 $ 425,400 $ 429,400 $ 1,030,500 Impact Fees Fund Totals $ 1,288,762 $ 1,208,744 $ 1,403,400 $ 2,223,500 Capital Projects Fund Series 2004 Bond $ 432,711 $ 100,000 $ 175,000 $ 6,100 Series 2006 Bond $ 12,020,662 $ 65,500 $ 485,312 $ 200,000 Capital Projects Fund Totals $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 Totals $ 23,021,515 $ 11,367,725 $ 11,657,363 $ 14,233,948 EDC Fund $ 540,089 $ 520,000 $ 468,000 $ 440,000 Totals Funds $ 23,561,604 $ 11,887,725 $ 12,125,363 $ 14,673,948 Page 1 p 1, SR Town of Prosper Fiscal Year 2007 - 2008 Summary of Expenditures By Department Proposed Account FY 05106 FY 06107 I FY 06107 FY 07108 Description Actual Budgeted Projected Budget General Fund Administration $ 618,950 $ 776,745 $ 811,964 $ 892,641 Police $ 786,107 $ 977,988 $ 887,770 $ 1,146,625 Court $ 111,686 $ 111,466 $ 115,110 $ 157,610 Fire $ 971,401 $ 1,255,762 $ 1,158,830 $ 1,595,479 Streets $ 223,774 $ 339,339 $ 332,449 $ 331,059 Parks / Recreation _ $ 29,561 $ 86,418 $ 74,248 $ 221,549 Communication $ 6,905 $ 22,016 $ 22,016 $ 25,500 Inspections $ 324,090 $ 494,212 $ 462,796 $ 567,951 Engineering $ - $ - $ - $ 130,716 Planning $ 158,610 $ 213,509 $ 180,360 $ 288,288 General Fund Totals $ 3,231,084 $ 4,277,455 $ 4,045,544 $ 5,357,418 Water & Sewer Fund $ 1,087,687 $ 3,438,653 $ 3,295,019 $ 3,851,914 Interest & Sinking Fund $ 834,524 $ 1,706,684 $ 1,916,092 $ 1,866,948 Parks Fund Park Dedication Fees $ - $ - $ - $ - Park Improvement Fees $ 183,304 $ - $ 31,000 $ 35,000 Parks Fund Totals $ 183,304 $ - $ 31,000 $ 35,000 Impact Fees Fund Water Impact Fees $ 1,160,542 $ 796,888 $ 144,700 $ 329,200 Wastewater Impact Fees $ - $ - $ 56,900 $ - Thoroughfare Impact Fees $ - $ 293,300 $ 86,000 $ 120,000 Transfer of Capital Assets �1,16.0,64 } $ - $ - $ Impact Fees Fund Totals $ - $ 1,090,188 $ 287,600 $ 449,200 Capital Projects Fund Series 2004 Bond $ 158,380 $ 7,425,738 $ 6,042,573 $ 368,312 Series 2006 Bond $ - $ 12,065,500 $ 3,572,579 $ 8,035,932 Capital Projects Fund Totals $ 158,380 $ 19,491,238 $ 9,615,152 $ 8,404,244 Totals $ 5,494,979 $ 30,004,218 $ 19,190,406 $ 19,964,724 EDC Fund $ 230,308 $ 324,943 $ 218,351 $ 319,066 Totals Funds $ 5,725,287 $ 30,329,161 $ 19,408,757 $ 20,283,789 Page 1 1� :!§ rl-i -;z.. P r FY 2007 - 2008 PROPOSED BUDGET GENERAL FUND October 1, 2007 - September 30, 2008 Rev Q8/15107 T 0 W iV' OF SPER'. PROPOSED BUDGET FY 2007 - 2008 GENERAL FUND FUND 10 -1 ` CDP NAF I sp FY 2007 - Zoos PROPOSED BUDGET ADMINISTRATION October 1, 2007 - September 30, 2008 Rev 08/15/07 ,y Town of Prosper 4° Proposed Departmental Budget Fiscal Year, 2007-2008 R. S P L R Summary of Revenue Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 Year 2006-2007 200+-2007 1 FY 2006-2007 4030 Miscellaneous 4035 3% Construction Insp Fees 184,081 295,000 275,000 250,000 4060 NSF Fees 325 300 60 - 4105 Tax Revenue - Delinquent 4,764 2,000 34,000 15,000 4110 Tax Revenue - Current 748,261 1,043,841 1,043,841 2,159,223 4115 Penalty & Interest 9,175 4,200 10,000 5,180 4120 Sales Tax - Gen. Fund 1,506,516 1,602,000 1,171,944 1,200,000 4130 Mixed Beverage Sales Tax 2,270 1,800 1,800 2,000 4140 Franchise Fee - Electric 142,898 143,200 172,800 202,400 4150 Franchise Fee - Telephone 23,808 24,180 24,180 20,985 4160 Franchise Fee - Gas 26,682 30,000 30,500 32,880 4180 Franchise Fee - Other - - - - 4190 Franchise Fee - Cable 7,676 5,600 9,500 12,800 4200 T-Mobile 18,000 18,000 18,000 18,000 4205 Internet America 19,500 18,000 18,000 18,000 4215 Annexation Fees 4,000 2,500 1,500 2,500 4218 Administrative Fees-EDC 1,500 1,500 1,500 12,000 4536 Child Safety Fee -Special Rev 5,079 4610 Interest Income 74,182 43,000 85,000 62,230 4910 Other Revenues 136,645 2,000 45,000 2,000 4915 Escrow 209,670 4995 Transfer in Totals $ 3,125,032 $ 3,237,121 $ 2,942,625 $ 4,015,199 Page 1 Town of Prosper ' Proposed Departmental Budget Fiscal Year, 2007-2008 `� " E R Summary of Expenditures Fund: GENERAL" FUND 10 Department: ADMINISTRATION 10 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 6110 Salaries & Wages 217,473 275,201 289,990 334,012 5116 Salaries - Overtime 405 400 865 1,500 5120 Salaries - Leave Time 4,242 - - - 5140 Salaries - Longevity 1,725 1,875 1,725 2,325 6145 Social Security Expense 14,267 17,204 17,621 20,845 5150 Medicare Expense 3,337 4,023 4,336 4,875 5165 SUTA Expense 567 2,350 840 1,418 5160 Health Insurance 13,184 22,167 19,765 32,788 5165 Dental 1,193 1,996 1,397 2,955 5170 Life Insurance 1 A D & D 443 725 1,636 236 5173 AD & D 79 - - 758 5175 TML Expense (Insurance) 96,965 115,700 115,700 118,900 5180 TMRS Expense 13,313 17,367 26,172 34,366 5185 ShortfLong Term Disability 1,199 3,781 2,112 2,244 5190 Contract Labor 3,675 5,200 5,200 5,100 5191 Hiring Cost - 80 8,200 480 5193 Record Retention 1,136 15,000 10,000 15,000 5210 Supplies 9,699 12,060 10,000 11,645 5212 Building Supplies 2,065 2,100 1,500 1,500 5220 Office Equipment 1,643 2,720 2,700 2,720 5230 Dues School Subscriptions 2,612 4,770 4,770 6,710 5240 Postage & Delivery 1,770 2,916 2,916 4,930 5250 Publications 932 875 875 1,945 5260 Advertising - - - 300 5270 Bank Charges 23 270 270 575 5280 Printing & Reproduction 1,107 2,380 3,400 3,380 5290 Miscellaneous 4,652 - - - 5310 Rental Expense 1,003 1,200 1,500 1,300 5312 Equipment Lease - - - - 5320 Repair & Maintenance - - - - 5325 Copier Lease 5,250 7,200 7,200 9,480 5330 Copier Expense 1,282 300 300 300 5335 Radio 1 Vedio Repairs - - - - 5340 Building Repairs 319 5,000 51000 7,700 5350 Vehicle Expense 7,500 5,250 5,500 - 5410 Professional Services - 24,900 40,000 10,000 5412 Audit Fees 20,000 23,000 21,400 26,000 5414 Tax Fees 12,821 15,860 15,860 29,600 5416 Engineering Fees 42,779 21,000 1,000 - Page 1 Fund: GENERAL FUND 10 Department: ADMINISTRATION 10 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5418 IT Fees 13,637 20,870 20,870 26,020 5430 Legal Fees 39,829 45,000 45,000 40,705 5435 Legal Notices/ Filings 12,438 7,200 7,200 81500 5460 Election Expense 3,910 10,000 30,000 15,000 5480 Contracted Services 8,927 21,540 21,540 17,400 5520 Telephone 8,395 9,920 9,920 21,193 5521 Cell Phones 2,273 3,600 3,600 3,800 5522 Pagers 116 - 14 - 5525 Electricity 8,282 11,520 11,520 14,400 5530 Travel/Meals/Lodging Expense 1,545 6,710 6,710 10,340 5532 Entertainment 127 100 100 3,800 5533 Mileage Expense 1,474 4,100 4,100 4,735 5536 Training I Seminars 3,833 9,060 9,060 10,880 5538 Training I Seminars - Council 1,047 4,600 4,600 5,350 5600 Special Events - 5,675 6,000 8,950 6110 Capital Expenditures - - - - 6140 Capital Expenditures -Equip 24,457 1,980 1,980 5,680 6160 Capital Expenditures -Vehicles - - - - 7142 Transfers to W/S - Totals $ 618,950 $ 776,745 $ 811,964 $ 892,641 Page 2 0 T- 1 FY 2007 - 2008 PROPOSED BUDGET COMMUNICATION October 1, 2007 - September 30, 2008 Rev 08/15/07 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 P '. Summary of Expenditures Fund: GENERAL FUND 10 Department: Communication 95 A B C D Expenditures Actual Budgeted Projected Proposed Account Expense FY Current FY Expense Current Budget for Code Title of Account 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 5190 Contract Labor 3,823 4,800 4,800 8,800 5210 Supplies 196 1,916 1,916 1,900 5230 Dues School Subscriptions - - - - 5240 Postage & Delivery 540 1,250 1,250 1,250 5250 Publications _ 216 40 40 40 5265 Promotional Expense 1,673 2,500 2,500 2,000 5280 Printing & Reproduction - 10,170 10,170 10,170 5290 Miscellaneous 102 - - - 5530 Travel/Meals/Lodging Expense 355 845 845 845 5536 Training / Seminars - 495 495 495 6140 Capital Expend itu res-Eq ulp - - - - Totals $ 6,905 $ 22,016 $ 22,016 $ 25,500 Page 1 \: OS PER FY 2007 - 2008 PROPOSED BUDGET POLICE October 1, 2007 - September 30, 2008 Rev 08/16/07 Town of Prosper Proposed Departmental Budget '" Fiscal Year, 2007-2008 Summary of Revenue Fund: GENERAL FUND 10 Department: Police 20 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 1 Year 2006-2007 2006-2007 1 FY 2007-2008 4030 Miscellaneous 4230 Other Permits - - 130 - 4440 Accident Reports - 220 200 250 220 4450 Alarm Permits 7,641 5,500 7,500 7,600 4510 Grants - - - - 4520 Resource Officer Reimb. 28,010 30,000 30,000 31,200 4530 Contributions 17,057 - - - 4910 Other Revenues - - - - 4920 Lease I Purchase Proceeds - - - - Totals $ 52,928 $ 35,700 $ 37,880 $ 39,020 Page 1 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 R Summary of Expenditures Fund: GENERAL FUND 10 Department: Police 20 A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 317,701 422,970 393,701 515,441 5115 Salaries - Overtime 25,992 17,500 17,500 22,844 5120 Salaries - Leave 2,256 - 25,000 - 5125 Salaries - Sick - 1,175 - - 5140 Salaries - Longevity 4,500 5,750 5,625 6,725 5145 Social Security Expense 21,612 27,666 26,211 33,991 5150 Medicare Expense 5,054 6,470 6,130 7,950 5155 SUTA Expense 496 2,430 860 2,970 5160 Health Insurance 29,296 37,684 35,932 42,097 5165 Dental 2,745 3,394 2,728 3,219 5170 Life Insurance 854 1,383 1,557 473 5171 Life Insurance Supplemental 8,759 9,819 9,819 - 5173 (Life/AD&D (Standard Insur. Policy) 154 - - 1,404 5180 TMRS Expense 23,599 27,894 29,504 45,669 5185 ShortfLong Term Disability 2,005 5,673 3,182 4,318 5190 Contract Labor 1,960 5,520 5,520 7,440 5191 Hiring Cost 74 1,580 500 2,960 5192 Physical & Psychological - 3,400 750 2,700 5205 Contributions 21,054 - - - 5210 Supplies 8,527 9,300 9,000 12,000 - 5212 Building Supplies 1,250 2,525 1,600 2,500 5214 Tactical Supplies 160 800 730 600 5215 Ammunition 5,092 5,500 5,000 5,500 5220 Office Equipment - 800 800 5,300 5230 Dues and Subscriptions 1,663 2,500 1,500 2,500 5240 Postage & Delivery 237 750 750 750 5250 Publications 267 1,225 900 750 5260 Advertising 1,113 850 - 1,400 5265 Promotional Expense - 2,250 2,000 2,250 5280 Printing & Reproduction 479 2,300 1,500 2,300 5290 Miscellaneous 3,175 - - - 5310 Rental Expense 7,900 9,620 9,620 12,270 5320 Repair & Maintenance 613 5,900 5,900 5,000 5325 Copier Lease 2,368 3,000 3,000 3,500 5330 Copier Expense 547 - - 1,000 Page 1 Fund: GENERAL FUND 10 Department: Police 20 A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 5335 Radio/Video Repairs - 6,250 4,000 6,250 5340 Building Repairs 320 1,000 1,000 1,000 5350 Vehicle Expense 12,894 20,000 18,000 20,000 5353 Gas/Grease/Oil/Inspections 25,525 35,000 24,000 31,995 5400 Uniform Expense 8,332 7,300 7,300 13,500 5410 Professional Services 1,154 1,500 500 2,000 5418 IT Fees 13,049 9,750 3,900 15,000 5430 Legal Fees 7,925 3,500 6,000 10,000 5450 Dispatch Expense_ 60,445 92,750 49,000 90,000 5480 Contracted Services 13,945 29,900 29,900 29,900 5520 Telephone 6,524 9,800 9,000 12,900 5521 Cell Phones 3,465 5,000 5,000 9,250 5522 Pagers 464 - 164 - 5524 Gas 374 900 700 750 5525 Electricity 3,670 3,000 2,800 3,000 5530 Travel Expense 3,875 4,000 2,500 4,500 5533 Mileage Expense 636 1,000 750 1,000 5536 Training 1 Seminars 9,332 14,500 11,000 17,500 5600 Special Events - 3,950 3,000 11,000 5630 Safety Equipment - 1,350 1,350 - 5640 Signs & Hardware - 1,750 1,750 1,500 6110 Capital Expenditures 46,097 3,725 3,725 - 6140 Capital Expenditures -Equip 17,458 18,200 18,200 21,350 6160 Capital Expenditures -Vehicles 47,944 77,410 77,410 86,410 Totals $ 786,107 $ 977,988 $ 887,770 $ 1,146,625 Page 2 Fz Pr%iER FY 2007 - 2008 PROPOSED BUDGET COURT . IP` P. AL 431 October 1, 2007 - September 30, 2008 Rev 08/15/07 Town of Prosper k6, Proposed Departmental Budget b'"SPER. `'�`'Fiscal Year, 2007-2008 P R! Summary of Revenue Fund: GENERAL FUND 10 Department: Court 70 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current F Y Current FY Budget for Code Title of Account 2005-2006 1 2006-2007 1 2006-2007 1 FY 2007-2008 4410 Fines 106,481 105,000 105,500 120,000 Security Fee 4610 Interest Income 181 200 150 200 4910 Other Revenues - 4995 Transfer In Totals $ 106,662 $ 105,200 $ 105,650 $ 120,200 Page 1 Town of Prosper Proposed Departmental Budget �Ai- - �}' � Fiscal Year, 2007-2008 V Summary of Expenditures Fund: GENERAL FUND 10 Department: Court 70 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 1 2006-2007 1 2006-2007 FY 2007-2008 5110 Salaries & Wages 35,289 38,930 37,461 38,959 5115 Salaries - Overtime 5,992 800 7,852 8,000 5120 Salaries - Leave 693 - - - 5125 Salaries - Sick - - - 750 5140 Salaries - Longevity 1,000 1,000 1,000 1,000 5145 Social Security Expense 2,629 2,525 2,997 2,973 5150 Medicare Expense 615 591 670 695 5155 SUTA Expense 63 270 200 270 5160 Health Insurance 4,309 4,433 4,433 4,074 5165 Dental 392 399 399 312 5170 Life Insurance 125 165 165 45 5173 AD&D 23 - - 123 5180 TMRS Expense 2,851 2,540 3,500 3,995 5185 Short/Long Term Disability 292 323 388 343 5190 Contract Labor 1,920 5210 Supplies 1,481 3,000 2,000 3,000 5212 Building Supplies 624 600 20 500 5230 Due and Subscriptions 146 350 175 350 5240 Postage & Delivery 988 1,100 800 1,200 5250 Publications 35 150 50 100 5270 Bank Charges - - - 100 5280 Printing & Reproduction 1,448 1,500 900 1,000 5290 Miscellaneous 250 - - 200 5310 Rental Expense - - - 8,550 5353 Gas/Oil/Inspections - - - - 5400 Uniform Expense 478 300 150 150 5418 IT Fees 1,120 1,500 1,500 2,500 5420 Municipal Court/Judge Fees 6,050 9,500 8,500 9,750 5425 State Fine Expense 42,682 38,000 40,000 60,000 5430 Legal Fees 72 690 300 500 5520 Telephone 75 200 600 650 5525 Electricity 3,600 5530 Travel/Meals/Lodging Expense 215 1,000 400 1,000 5533 Mileage Expense 483 600 350 500 5536 Training 1 Seminars 185 1,000 300 500 6140 Capital Expenditures -Equip 1,084 - - - Totals $ 111,686 $ 111,466 $ 115,110 $ 157,610 Page 1 0 I - 1p F , FY 2007 - 2008 PROPOSED BUDGET FIRE October 1, 2007 - September 30, 2008 Rev 08116/07 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Fund: GENERAL FUND 10 Department: Fire 30 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current F Y Current FY Budget for Code Title of Account 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 4030 Miscellaneous 4230 Other Permits 4310 Charges for Services 289,680 134,000 134,000 135,000 4315 Fire Inspections - 225 4,000 - 5,000 4410 Fines - - - - 4411 Collin Co. Fire Association 6,069 4,000 11,000 6,000 4440 Accident Reports 50 - - - 4510 Grants - - 2,250 152,800 4530 Contributions 16,405 - - - 4610 Interest Income - - - - 4910 Other Revenues Totals $ 312,429 $ 142,000 $ 147,250 $ 298,800 Page 1 ROSPER Fund: GENERAL FUND 10 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Fire 30 A B C D Expenditures Budgeted Projected Proposed Account Actual Expense Current FY Expense Current Budget for Code Title of Account FY 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 5110 Salaries & Wages 407,856 539,732 454,043 663,864 5115 Salaries - Overtime 127,442 112,908 112,908 115,000 5120 Salaries - Leave Time 2,533 - - - 5125 Salaries -Sick Time 865 - - - 5140 Salaries - Longevity 5,175 6,975 6,775 7,600 5145 Social Security Expense 33,116 40,896 38,376 49,799 5150 Medicare Expense 7,745 9,564 5,557 11,647 5155 SUTA Expense 738 4,320 2,485 5,130 5160 Health Insurance 39,902 44,334 41,404 46,850 5165 Dental 3,448 3,992 3,194 3,582 5170 Life Insurance 1,310 1,250 1,628 518 5171 Life Insurance Supplement 7,565 7,566 8,626 8,626 5173 AD & D 235 - - 1,860 5180 TMRS Expense 32,624 41,253 40,921 61,470 5185 Short/Long Term Disability 3,353 6,022 4,353 4,460 5190 Contract Labor 974 2,320 2,320 2,320 5191 Hiring Cost 536 200 200 1,525 5193 Record Retention - 240 - 250 5194 Fire Dept Annual Phy & Health Screening 9,735 16,200 16,200 16,200 5205 Contribution 8,536 - - - 5210 Supplies 10,645 11,000 11,000 8,400 5212 Building Supplies 4,223 4,700 4,700 5,550 5220 Office Equipment 522 1,500 1,500 1,500 , 5221 Fire Marshall Expense 8,000 5230 Dues and Subscriptions 1,092 1,790 1,790 1,785 5240 Postage & Delivery 316 500 500 500 5250 Publications 131 250 250 350 5260 Advertising - 500 500 500 5280 Printing & Reproduction - 500 500 500 5290 Miscellaneous 1,185 - - - 5320 Repair & Maintenance 10,973 18,400 18,400 13,400 5326 Copier Lease - - - - 5330 Copier Expense 147 250 250 250 5335 Radio / Video Repairs 755 21,450 21,450 37,950 5340 Building Repairs 1,605 13,350 13,350 6,750 5350 Vehicle Expense 11,374 9,650 9,650 14,000 5353 Gas/Grease/Oil/Inspections 19,882 20,350 20,350 20,345 5400 Uniform Expense 4,965 8,000 8,000 8,800 5410 Professional Services 1,044 15,000 15,000 15,000 5418 IT Fees 6,600 5430 Legal Fees 18 - - - Page 1 Fund: GENERAL FUND 10 Department: Fire 30 A B C D Expenditures Budgeted Projected Proposed Account Actual Expense Current FY Expense Current Budget for Code Title of Account FY 2005-2006 2006-2007 FY 2006-2007 FY 2007-2008 5440 EMS Expense 55,755 75,610 75,610 79,204 5450 Dispatch Expense 10,084 11,140 11,140 10,150 5465 Public Relations - - - - 6480 Contracted Services 17,703 28,660 28,660 23,524 5520 Telephone 4,616 5,720 5,720 8,020 5521 Cell Phones 5,181 4,500 4,500 7,700 5522 Pagers 1,473 1,800 1,800 2,100 5523 Water - - - - 5524 Gas 4,712 5,600 5,600 7,000 5525 Electricity 18,827 24,000 24,000 20,600 5530 Travel Expense - 851 1,000 2,500 2,000 5533 Mileage Expense 778 1,500 1,500 1,500 5536 Training 1 Seminars 7,467 9,000 9,000 11,950 5610 Fire Fighting Equipment 3,515 12,670 12,670 18,250 5630 Safety Equipment 16,090 24,250 24,250 24,250 6110 Capital Expenditures 4,661 - - - 6140 Capital Expenditures -Equip 57,123 17,250 17,600 108,350 6160 Capital Expenditures -Vehicles - 68,100 68,100 120,000 Totals $ 971,401 $ 1,265,762 $ 1,158,830 $ 1,595,479 Page 2 FY 2007 - 2008 PROPOSED BUDGET STREETS October 1, 2007 - September 30, 2008 Rev 08/15/07 fi Town of Prosper 10 ` Proposed Departmental Budget r'. Fiscal Year, 2007-2008 S R Summary of Expenditures Fund: GENERAL. FUND 10 Department: Streets 40 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 1 2006-2007 1 2006-2007 LFY 2007-2008 5110 Salaries & Wages 55,610 57,373 57,373 71,018 5115 Salaries - Overtime 3,412 5,000 5,000 5,000 5120 Salaries - Leave Time 1,072 - - - 5140 Salaries - Longevity 1,825 2,000 1,450 2,000 5145 Social Security Expense 3,872 3,991 3,991 4,837 5150 Medicare Expense 905 933 933 1,131 5155 SUTA Expense 268 540 540 540 5160 Health insurance 8,617 8,867 8,867 8,148 5165 Dental 784 798 798 623 5170 Life Insurance 1 AD & D 204 250 250 90 5173 AD & D 44 - - 191 5180 TMRS Expense 4,046 4,009 4,009 6,499 5185 Short/Long Term Disability 451 788 788 532 5190 Contract Labor - - - - 5191 Hiring Cost - 40 40 - 5210 Supplies 1,729 7,000 5,000 4,400 5220 Office Equipment 3,600 5230 Dues & subscriptions 500 5290 Miscellaneous - - - - 5310 Rental Expense 2,500 5320 Repair & Maintenance - 6,000 5,000 10,500 5321 Signal Light Repairs 180 - - - 5340 Building Repairs 6,000 5350 Vehicle Expense 5,908 6,000 5,000 4,800 5353 Gas/Grease/Oil/inspections 215 8,000 6,000 5,500 5400 Uniform Expense 309 1,400 1,400 1,670 5480 Contracted Services 31,125 128,000 128,000 32,800 5520 Telephone - 510 510 500 5521 Cell Phones 472 2,000 1,500 1,300 5525 Electricity 39,090 40,000 45,000 50,000 5530 Travel/Lodging/Meals Expense 600 5536 Training I Seminars 600 5620 Tools & Equipment 6,773 5,840 6,000 5,700 5630 Safety Equipment - 2,000 2,000 980 5640 Signs & Hardware 12,376 8,000 8,000 8,500 Page 1 Fund: GENERAL FUND 10 Department: Streets 40 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 1 2005-2006 1 2006-2007 2006-2007 FY 2007-2008 5650 Maintenance Materials 30,024 40,000 35,000 44,000 6110 Capital Expenditures 6,715 - - - 6140 Capital Expenditures -Equip 7,750 - - 18,000 6160 Capital Expenditures -Vehicles - - - 28,000 Totals $ 223,774 $ 339,339 $ 332,449 $ 331,059 Page 2 AI'' +r,'#'••� di yf 0) 1%14vd Kid Town of Prosper Proposed Departmental Budget irx' 4 ' ;: `'' Fiscal Year, 2007-2008 "' . P, E Summary of Expenditures Fund: GENERAL FUND 10 Department: Parks 60 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 1 2006-2007 1 2006-2007 1 FY 2007-2008 5110 Salaries & Wages 5115 Salaries - Overtime 5140 Salaries - Longevity 5145 Social Security Expense 5150 Medicare Expense- 5155 SUTA Expense 5160 Health Insurance 5165 Dental 5170 Life Insurance 1 AD & D 5173 AD & D - Standard 5180 TMRS Expense 5185 Short/Long Term Disability 5190 Contract Labor 5210 Supplies 5212 Building Supplies 5230 Dues & Subscriptions 5240 Postage & Delivery 5280 Printing & Reproduction 5290 Miscellaneous 5320 Repair & Maintenance 5350 Vehicle Expense 5353 Gas/OiVGreaseAnspection 5400 Uniforms 5430 Legal Fees 5480 Contracted Services 5520 Telephone 5521 Cell Phone 5523 Water 5525 Electricity 5530 Travel/Lodging/Meals Expense 5536 Train!ng/Seminars 5600 Special Events 5630 Safety Equipment 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles - 25,690 18,500 45,433 - 3,000 2,000 2,000 - 75 75 775 - 1,783 1,783 2,989 - 417 400 699 - 270 270 540 - 4,433 2,200 7,129 - 399 250 545 - 45 20 90 - - - 225 - 1,802 1,000 4,016 - 354 200 500 2 150 150 900 1,800 400 - 500 400 500 6,596 9,000 9,000 16,300 313 - 500 2,600 1,650 3,000 2,000 4,500 - 300 300 1,650 918 - - - - 4,000 4,000 72,500 - 900 900 500 1,250 - - - 12,000 20,082 30,000 30,000 19,000 400 400 300 300 800 - - - 21,108 Totals $ 29,561 $ 86,418 $ 74,248 $ 221,549 Page 1 0 T DSR FY 2007 - 2008 PROPOSED BUDGET INSPECTIONS 1 CODE ENFORCEMENT October 1, 2007 - September 30, 2008 Rev OB115/07 Town of Prosper Proposed Departmental Budget i� "' ` Fiscal Year, 2007-2008 S LA Summary of Revenues Fund: GENERAL FUND 10 Department; Inspections/Code Enforcement 80 A B C D Revenue Projected Budgeted Revenue Proposed Account Actual Revenue Current F Y Current FY Budget for Code Title of Account FY 2005-2006 1 2006-2007 2006-2007 FY 2007-2008 4011 Permit Application Fee - - 100 - 4012 Saturday Inspection Fee - - - - 4013 Permit Expiration Fee - - - - 4014 Electronic Map Sub. Fee - - - - 4016 Public Inconvenience Fee - - - - 4017 Registration Fee - - 600 - 4030 Miscellaneous - - - - 4210 Building Permits 536,647 606,630 625,250 638,020 4230 Other Permits 95,146 112,290 95,140 89,935 4240 Plumb/Elect/Mech. Permits 3,412 7,120 11500 3,245 4242 Re -Inspection Fees 31,595 15,000 41,000 15,000 4245 Health Inspection Fees 1,504 1,700 5,500 3,000 4910 Other Revenues - - - 44,000 Totals $ 668,304 $ 742,740 $ 769,090 $ 793,200 Page 1 R Town of Prosper fJ Proposed Departmental Budget Fiscal Year, 2007-2008 Rf E R Summary of Expenditures Fund: GENERAL FUND 10 Department: Inspections 80 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 1 2006-2007 2006-2007 1 FY 2007-2008 5110 Salaries & Wages 186,122 290,968 261,905 336,716 5115 Salaries - Overtime 9,120 10,000 15,000 15,000 5140 Salaries - Longevity 1,075 2,325 2,000 4,725 5145 Social Security Expense 12,172 18,804 16,553 22,122 5150 Medicare Expense 2,847 4,398 3,871 5,174 5155 SUTA Expense 1,000 2,160 1,622 2,700 5160 Health Insurance 15,504 26,600 26,600 28,517 5165 Dental 1,574 2,395 2,395 2,181 5170 Life Insurance / AD&D 461 800 1,022 315 5173 AD & D - Standard 83 - - 1,034 5180 TMRS Expense 12,433 17,317 17,317 27,337 5185 Short/Long Term Disability 1,091 3,633 2,000 2,603 5190 Contract Labor 1,814 2,300 - - 5191 Hiring Cost 39 160 160 80 5210 Supplies 5,357 7,200 7,200 7,200 5212 Building Supplies 818 480 500 520 5220 Office Equipment 2,982 5,300 5,500 6,134 5230 Dues & Subscriptions 1,750 4,527 4,527 5,000 5240 Postage & Delivery 145 400 400 400 5250 Publications 161 550 550 500 5260 Advertising - 500 500 500 5270 Bank Charges - 200 200 200 5280 Printing & Reproduction 1,748 5,255 5,300 5,300 5290 Miscellaneous 60 - - 100 5320 Repair & Maintenance 236 1,500 1,500 1,500 5340 Building Repairs 1,870 5,000 5,000 9,115 5350 Vehicle Expense 2,254 1,500 1,000 1,500 5353 Gas/Grease/OilAnspections 5,756 10,000 7,000 10,000 5400 Uniform Expense 1,528 3,000 3,000 3,730 5410 Professional Services 4,784 4,500 5,500 6,500 5416 Engineering Fees 600 1,000 1,000 1,000 5418 IT Fees 3,293 4,000 7,000 6,000 5430 Legal Fees 632 2,000 3,000 3,000 5465 Public Relations 196 500 500 300 5480 Contracted Services - 13,660 13,660 13,660 Page 1 Fund: GENERAL FUND 10 Department: Inspections 80 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 1 2006-2007 1 FY 2007-2008 5520 Telephone 5,081 5,280 5,400 7,360 5521 Cell Phones 3,970 5,200 4,500 10,897 5525 Electricity 286 500 500 500 5524 Gas (Building) - - - - 5530 Travel I Lodging I Meals Expense - 1,500 1,500 2,000 5533 Mileage Expense - 250 100 250 5536 Training I Seminars 4,973 3,850 4,500 5,850 5620 Tools & Equipment 475 5,686 4,000 4,000 5630 Safety Equipment - 403 950 950 1,250 6110 Capital Expenditures 846 1,200 1,200 600 6140 Capital Expenditures -Equip - - - 4,580 6160 Capital Expenditures -Vehicles 28,552 16,864 16,864 - Totals 324,090 494,212 462,796 567,951 Page 2 W, s 3 F IPFJ-�Z, FY 2007 -- 2008 PROPOSED BUDGET ENGINEERING & PLANNING October 1, 2007 - September 30, 2008 Rev 08/15/07 Town of Prosper . 5• Proposed Departmental Budget �;' iOp Fiscal Year, 2007-2008 SPER Summary of Expenditures Fund: GENERAL FUND (ENGINEERING) Department: Engineering _ A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 91,936 6115 Salaries - Overtime - 5120 Salaries - Leave Time - 5125 Salaries - Sick - 5140 Salaries - Longevity 475 5145 Social Security Expense 5,729 5150 Medicare Expense 1,340 5155 SUTA Expense 270 5160 Health Insurance 4,074 5165 Dental 312 5170 Life Insurance / AD & D 45 5173 AD & D - Standard 162 5180 TMRS Expense 7,698 5185 Short/Long Term Disability 585 5189 Administrative Fees - 5190 Contract Labor - 5191 Hiring Cost - 5193 Record Retention - 5210 Supplies 1,000 5212 Building Supplies 300 5220 Office Equipment 950 5230 Dues & Subscriptions 750 5240 Postage & Delivery 150 5250 Publications - 5260 Advertising - 5280 Printing & Reproduction 125 5290 Miscellaneous 200 5310 Rental Expense - 5320 Repair & Maintenance - 5325 Copier Lease - 5330 Copier Expense - 5340 Building Repairs 1,000 5350 Vehicle Expense - 5353 Gas/Grease/Oil/Inspections - 5400 Uniform Expense 60 5410 Professional Services - 5412 Audit Fees - 5416 Engineering Fees - 5418 IT Fees 850 5430 Legal Fees 5,000 5480 Contracted Services - Page 1 Fund: GENERAL FUND (ENGINEERING) Department: Engineering _ A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5520 Telephone 1,725 5521 Cell Phones 1,580 5525 Electricity 500 5530 Travel/Lodging/Meals Expense 1,200 5533 Mileage Expense 1,000 5536 Training / Seminars 1,500 5620 Tools & Equipment 200 6110 Capital Expenditures - 6140 Capital Expenditures -Equip - 6160 Capital Expenditures -Vehicles - Totals $ - $ $ - $ 130,716 Page 2 r: Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 ER Summary of Revenue Fund: GENERAL FUND Department: Planning 90 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 1 2005-2006 1 Year 2006-2007 2006-2007 1 FY 2007-2008 4030 Miscellaneous 4220 Zoning Fees 4225 Plat Fees - 4230 Other Permits 4910 Other Revenues 9,701 1,000 4,000 750 18,130 25,000 45,000 25,000 46,261 40,000 80,000 60,000 - - 4,000 5,000 - - - 250 Totals $ 74,092 $ 66,000 $ 133,000 $ 91,000 Page 1 x Town of Prosper k Proposed Departmental Budget P' '; Fiscal Year, 2007-2008 sP.E R Summary of Expenditures Fund: GENERAL FUND 10 Department: Planning 90 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 1 FY 2007-2008 5110 Salaries & Wages 75,213 106,000 71,154 123,859 5115 Salaries - Overtime - - - 2,000 5120 Salaries - Leave Time 4,924 - - - 5140 Salaries - Longevity 650 275 25 450 5145 Social Security Expense 5,009 6,595 4,413 7,831 5150 Medicare Expense 1,171 1,542 1,032 1,831 5155 SUTA Expense 755 540 418 810 5160 Health Insurance 3,704 8,867 6,548 10,185 5165 Dental 337 798 532 779 5170 Life Insurance I AD&D 161 190 256 113 5173 AD & D - Standard 29 - - 334 5180 TMRS Expense 3,377 6,664 4,771 10,522 5185 ShortlLong Term Disability 269 1,458 521 884 5190 Contract Labor 1,300 1,950 5,000 1,950 5191 Hiring Cost - 40 40 40 5210 Supplies 2,916 2,400 4,500 3,000 5212 Building Supplies 218 300 300 300 5220 Office Equipment 187 2,500 2,500 6,200 5230 Dues I Subscriptions 678 600 600 1,125 5240 Postage & Delivery 58 200 510 250 5250 Publications - - - 125 5260 Advertising - - - 40 5280 Printing & Reproduction 495 1,000 500 500 5290 Miscellaneous - - - - 5310 Rental Expense - - - - 5320 Repair & Maintenance - - - - 5325 Copier Lease 2,486 2,400 2,400 5,200 5330 Copier Expense - - - - 5340 Building Repairs 505 3,000 3,000 2,500 5350 Vehicle Expense - - - - 5410 Professional Services 38,000 38,000 38,000 41,026 5416 Engineering Fees - - - - 5418 IT Fees 1,013 6,470 6,470 850 5430 Legal Fees 8,578 8,000 10,000 45,000 5435 Legal Notices I Filings 296 2,000 1,750 2,000 Page 1 Fund: GENERAL FUND 10 Department: Planning 90 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 1 2006-2007 FY 2007-2008 5480 Contracted Services 5520 Telephone 5521 Cell Phones 5525 Electricity 5530 MealstLodging Expense 5533 Mileage Expense 5536 Training 1 Seminars 5640 Signs and Hardware 6110 Capital Expenditures 6140 Capital Expenditures -Equip 6160 Capital Expenditures -Vehicles 4,835 5,380 5,380 8,940 1,055 1,440 1,440 3,000 - 500 500 500 - 1,000 1,000 1,000 140 600 750 1,500 - 1,000 1,250 3,645 250 - 3,000 - - 1,800 1,800 - Totals $ 158,610 $ 213,509 $ 180,360 $ 288,288 Page 2 -U. C-,vv. 1 :) S P I , FY 2007 - 2008 PROPOSED BUDGET PUBLIC WORKS October 1, 2007 - September 30, 2008 Rev 08/15/07 It T 0 W` ICI 0 F s p PROPOSED BUDGET FY 2007 - 2008 PUBLIC WORKS FUND 20 �: N 3l_ . C�7�.f: P R. Town of Prosper FY 2007 - 2008 Town Budget Public Works Fund Summary Net Assets I Reserves Proposed Account FY 05106 FY 06/07 I FY 06107 I I FY 07 / 08 Description Actual Budgeted Projected Budget WATER / SEWER FUND OPERATING REVENUES Water and Sewer charges $ 2,407,911 $ 2,045,000 $ 2,055,000 $ 2,370,000 Sanitation charges $ 282,266 $ 2403000 $ 300,000 $ 348,000 Water and Sewer connections $ 435,395 $ 300,000 $ 245,000 $ 400,000 Service initiation fees $ 477,656 $ 655,165 $ 575,000 $ 667,000 Miscellaneous $ 81,500 $ 1,500 $ 1,500 $ 1,000 Total Operating Revenues $ 3,684,729 $ 3,241,665 $ 3,176,500 $ 3,786,000 NON -OPERATING REVENUES Interest Income $ 57,627 $ 25,000 $ 90,000 $ 81,000 TRANSFERSIN Operating transfers $ - $ - $ - $ - Transfers in from other funds $ - $ - $ - Total transfers in $ $ $ - Total Revenues $ 3,742,356 $ 3,266,665 $ 3,266,500 $ 3,867,000 OPERATING EXPENSES Personnel services $ 327,687 $ 449,163 $ 458,404 $ 526,401 Materials and supplies $ 418,266 $ 820,250 $ 1,280,250 $ 838,563 Contractual services $ 1,354,905 $ 1,908,600 $ 1,526,060 $ 2,102,290 Depreciation $ 188,747 $ 168,000 $ 282,234 $ 300,000 Total Operating Expenses $ 2,289,605 $ 3,346,013 $ 3,546,948 $ 3,767,254 NON -OPERATING EXPENSES Interest expense and fiscal charges $ 362,714 $ 92,640 $ 478,514 $ 84,660 Net Income (loss) before operating transfers $ 1,090,037 c (171.967) $ (76%982) $ 15,086 TRANSFERS Transfers in (out) for debt service $ 404,090 $ - $ 443,379 $ - Transfers in (out) for capital assets $ 1,160,542 $ - $ 287,064 $ - Total transfers $ 1,5642632 $ - $ 730,443 $ - Change in Net Assets $ 2,654,669 $ (171,g97) $ (23,519} $ 15,086 Net Assets, beginning (as stated) $ 3,996,963 $ 6,651,632 $ 6,651,632 $ 6,623,113 Net Assets, ending $ 6,651,632 $ 6,479,645 $ 6,623,113 $ 6,638,199 16% Reserve $ 366,337 $ 535,362 $ 567,512 $ 602,761 Page 1 Town of Prosper Proposed Departmental Budget Pr ' '''= r Fiscal Year, 2007-2008 I PER Summary of Revenue Fund: WATER FUND (PUBLIC WORKS) Department: Public Works _ A B C D Projected Revenue Budgeted Revenue Proposed Account Actual Revenue Current Fiscal Year Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 4000 Water 1 Sewer Initiation Fee 31,077 12,000 22,000 25,520 4005 Water 2,339,995 2,000,000 2,000,000 2,320,000 4006 Sewer 446,579 643,165 553,000 641,480 4007 Sanitation 282,266 240,000 300,000 348,000 4009 Late Fees - 67,916 45,000 55,000 50,000 4010 Tap/ Meter Fees 435,395 300,000 245,000 400,000 4011 Permit Application Fee - - - - 4012 Saturday Inspection Fee - - - - 4013 Permit Expiration Fee - - - - 4014 Electronic Map Sub. Fee - - - - 4016 Public Inconvenience Fee - - - - 4017 Registration Fee - - - - 4030 Miscellaneous - - - - 4060 NSF Fees 75 500 500 500 4610 Interest Income 57,627 25,000 90,000 81,000 4910 Other Revenues 81,425 - - - 4911 SalvagetRecycle Materials - 11000 1,000 500 Totals $ 3,742,356 $ 3,266,665 $ 3,266,600 $ 3,867,000 Page 1 Town of Prosper n Proposed Departmental Budget ' ` '` t, ' P Fiscal Year, 2007-2008 P E R Summary of Expenditures Fund: WATER FUNDS PUBLIC WORKS Department: Public Works _ A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5110 Salaries & Wages 227,970 335,854 335,854 367,386 5115 Salaries - Overtime 18,818 10,000 17,276 40,100 5120 Salaries - Leave Time 4,533 - - - 5125 Salaries - Sick 1,677 - - - 5140 Salaries - Longevity 1,300 3,375 3,150 3,775 5145 Social Security Expense 15,160 21,778 21,778 25,081 5150 Medicare Expense 3,546 5,093 5,093 5,866 5155 SUTA Expense 1,117 3,930 3,930 2,700 5160 Health Insurance 30,490 39,901 39,901 39,720 5165 Dental 2,736 3,593 3,593 3,037 5170 Life Insurance/ AD & D 724 1,095 1,095 439 5173 AD & D - Standard 132 - - 971 5175 TML Expense (Insurance) - - - - 5180 TMRS Expense 17,451 21,972 21,972 34,258 5185 ShortlLong Term Disability 1,795 4,642 4,642 2,748 5189 Administrative Fees - - - - 5190 Contract Labor - - - - 5191 Hiring Cost 239 120 120 320 5193 Record Retention - 5,000 5,000 2,100 5210 Supplies 6,326 6,000 3,000 4,600 5212 Building Supplies 785 1,200 1,200 1,600 5220 Office Equipment 3,357 5,450 5,450 11,700 5230 Dues & Subscriptions 1,804 2,850 2,850 5,175 5240 Postage & Delivery 7,512 8,500 8,500 9,500 5250 Publications - - - 400 5260 Advertising 241 1,700 1,700 1,000 5270 Bank Charges 50 500 500 600 5280 Printing & Reproduction 5,312 2,550 2,550 6,980 5290 Miscellaneous 1,817 - - 2,500 5310 Rental Expense 3,750 2,500 2,500 13,000 5320 Repair & Maintenance 232 3,000 3,000 2,900 5321 Signal Lights Repairs - 500 500 - 5325 Copier Lease - - - - 5330 Copier Expense 83 500 500 2,200 5335 Radio / Video Repairs - - - 2,500 5340 Building Repairs 8,043 8,000 8,000 10,000 5350 Vehicle Expense 4,959 7,000 7,000 11,000 5353 Gas/Grease/ODI/Inspections 16,083 20,000 20,000 25,500 5400 Uniform Expense 1,332 3,000 3,000 6,510 5410 Professional Services 29,804 21,810 21,810 30,000 5412 Audit Fees 500 600 600 1,500 Page 1 Fund: WATER FUND (PUBLIC WORKS) Department: Public Works _ A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5416 Engineering Fees 62,775 25,000 25,000 17,000 5418 IT Fees 89 14,300 14,300 38,470 5430 Legal Fees 23,525 20,000 30,000 11,500 5470 Trash Collection 297,314 283,300 283,300 312,100 5480 Contracted Services 1,228 6,000 6,000 35,000 5620 Telephone 4,098 3,200 4,600 12,720 5521 Cell Phones 3,536 5,400 6,650 8,900 5522 Pagers 255 - - - 5524 Gas- Building 2,104 4,300 4,300 4,000 5525 Electricity 425,408 400,000 400,000 405,100 5530 Travel/Lodging/Meals Expense - 900 900 2,650 5533 Mileage Expense 258 500 500 2,248 5536 Training / Seminars 790 6,500 6,500 5,200 5540 Water Testing 16,539 15,000 15,000 20,500 5545 Meter Purchases 59,011 50,000 50,000 198,000 5550 Water Purchases 446,383 489,500 489,500 600,000 5560 Sewer Management Fees 41,346 225,000 225,000 605,500 5590 Interest Expense 320,798 - 376,527 - 5620 Tools & Equipment 1,185 5,200 5,200 10,000 5630 Safety Equipment - 2,500 2,500 16,600 5640 Signs & Hardware 4,224 2,400 2,400 1,000 5650 Maintenance Materials 25,355 40,000 40,000 60,000 5660 Chemical Supplies 13,842 31,000 31,000 25,000 5670 System Improvements 221,467 80,000 150,000 142,500 5680 Lift Stations - - - 26,000 5910 Depreciation 188,747 168,000 282,234 300,000 5911 Amortization 5,047 7,200 16,547 17,000 6110 Capital Expenditures 27,666 792,000 792,000 29,600 6140 Capital Expenditures -Equip 2,782 38,000 38,000 57,000 6160 Capital Expenditures -Vehicles - 86,000 86,000 143,000 6175 1999 Bond Payment 1,968 17,283 17,283 - 6180 2001 Bond Payment 34,901 68,157 68,157 67,660 7145 Transfer from I & S. 7146 Transfer from Bond Fund (404,090) (443,379) 7147 Transfer to GF - 7148 Transfer to IM Fees Water (1,160,542) (287,004) Totals $ 1,087,687 $ 3,438,663 $ 3,295,019 $ 3,851,914 Page 2 IG�it�'i�w • E r-41.1 FY 2007 - 2008 PROPOSED BUDGET INTEREST & SINKING October 1, 2007 - September 30, 2008 Rev 08/15/07 P,.,.TO-W'Nr�R. PROPOSED BUDGET FY 2007 - 2008 INTEREST & SINKING FUND 30 L C) N)v 'N � 1 i sPER, Town of Prosper Fiscal Year 2007 - 2008 Debt Service Summary Proposed Account FY 05/06 FY 06/07 FY 06107 I I FY 07108 Description Actual Budgeted Projected Budget DEBT SERVICE FUND REVENUES Taxes: Property $ 911,377 $ 1,783,055 $ 1,789,656 $ 1,940,430 Investment Income (Interest) $ 14,899 $ 8,000 $ 24,000 $ 25,500 Total Revenues $ 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 EXPENDITURES Debt Service: Principal $ 177,357 $ 336,206 $ 336,206 $ 805,192 Interest $ 251,100 $ 490,683 $ 490,683 $ 1,061,756 Total Expenditures $ 428,457 $ 826,888 $ 826,889 $ 1,866,948 Excess of revenues over expenditures $ 497,819 $ 964,167 $ 986,767 $ 98,982 OTHER FINANCING SOURCES (USES) Administrative Fees (1,978) 8 (6.400) $ (6,400) $ Transfers in for debt service $ - $ - $ - $ - Transfers out for debt service 404,090 $ (873.395} $ (1.0B2,803) $ - Total other financing sources (406,068) (87$,795) $ (1,089,203) $ Net change in fund balances $ 91,751 $ 84,371 $ (102.436) $ 98,982 Fund Balance, beginning (as stated) $ 222,807 $ 314,558 $ 314,558 $ 212,122 Fund Balance, ending $ 314,558 $ 398,930 $ 212,122 $ 311,104 8/14107 Rev Page 1 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 -I- Summary of Revenue Fund: DEBT SERVICE FUND 30 Department: Int._& Sinking 10 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 1 Year 2006-2007 2006-2007 FY 2007-2008 4105 Tax Revenue - Delinquent 4110 Tax Revenue - Current 4115 Penalty & Interest - 4610 Interest Income 4910 Other Revenues Transfer In 6,385 2,500 38,000 5,000 895,379 1,777,555 1,738,156 1,929,430 9,613 3,000 13,500 6,000 14,899 8,000 24,000 25,500 Totals $ 926,276 $ 1,791,055 $ 1,813,656 $ 1,965,930 Page 1 Town of Prosper � Prop osed Departmental Budget p p 9 Fiscal Year, 2007-2008 '' Summary of Expenditures Fund: DEBT SERVICE FUND 30 Department: Int. & Sinking 10 A B C D Expenditures Projected Budgeted Expense Proposed Account Actual Expense Current FY Current FY Budget for Code Title of Account FY 2005-2006 2006-2007 2006-2007 FY 2007-2008 5270 Bank Charges - 500 500 - 6180 2001 Bond Payment 135,839 136,334 136,334 137,368 6185 1996 Bond Payment - - - 70,313 6190 1998 Bond Payment - - - 63,990 6195 2002 Tax Note Payment 50,656 50,656 50,656 - 6196 2003 Tax Note Payment 75,066 75,066 75,066 75,067 6197 2004 Bond Payment 166,895 225,796 225,796 838,000 6198 2006 Bond Payment - 338,537 338,537 682,210 6200 Bond Administrative Fees 1,978 6,400 6,400 - 7142 Transfer to W/S 404,090 873,395 873,395 - 7144 Transfer to Bond Fund -Cap Proj 209,408 - 7149 Transfer to Debt Service Fund Totals $ 834,524 $ 1,706,684 $ 1,916,092 $ 1,866,948 Page 1 r F> FY 2007 - 2008 PROPOSED BUDGET CAPITAL PROJECTS October 1, 2007 - September 30, 2008 Rev 08/15/07 Is TOWN O F S P ER PROPOSED BUDGET FY 2007 - 2008 CAPITAL PROJECT FUND 75 2004 BOND 12006 BOND O WN Rb S Jam- R Town of Prosper Proposed Budget Fiscal Year, 2007-2008 Capital Projects Fund Balance / Reserves Proposed Account FY 05/06 FY 06107 FY 06107 FY 07 / 08 Description Actual Budgeted Projected Budget CAPITAL PROJECTS REVENUES Proceeds From Bond Issuance $ 12,000,000 $ - $ - $ - Miscellaneous $ - $ - $ $ - Investment Income (Interest) $ 453,373 $ 165,500 $ 660,312 $ 206,100 Total Revenues $ 12,453,373 $ 165,500 $ 660,312 $ 206,100 EXPENDITURES Current: General Government $ 500 $ 68,500 $ 531,541 $ - Capital Outlay $ - $ 19,422,738 $ 9,083,610 $ 8,404,244 Total Expenditures $ 500 $ 19,491,238 $ 9,615,152 $ 8,404,244 Excess of revenues over expenditures $ 12,452,873 (19.325,738) (8,954.840) (8,198.144) OTHER FINANCING SOURCES (USES) Bonds Issue $ - $ - $ - $ _ Bond issuance cost 8 (157,880) $ $ $ - Due From Water Sewer $ - $ - $ - $ - Transfers In - Impact fees $ - $ - $ - $ - Transfers Out $ $ - $ - $ - Total other financing sources 3 (157.880) $ - $ - $ _ Net change in fund balances $ 12,294,993 $ (19,325,738) $ (8,954,840) $ (8,198.144) Fund Balance, beginning $ 7,321,385 $ 19,616,378 $ 19,616,378 $ 10,661,539 Fund Balance, ending $ 19,616,378 $ 290,640 $ 10,661,539 $ 2,463,395 Page 1 * Town of Prosper r. Proposed Departmental Budget ''' ^` �' Fiscal Year, 2007-2008 -, S E Summary of Revenue Fund: Capital Projects 75 Department: Bonds 10 A B C D Revenue Budgeted Projected Proposed Budget Account Actual Revenue Current Fiscal Revenue Current for Code Title of Account FY 2005-2006 Year 2006-2007 FY 2006-2007 1 FY 2007-2008 4611 Interest Inc-2004 Bond $ 432,711 $ 100,000 $ 4612 Interest Inc-2006 Bond $ 20,662 $ 65,500 $ 4910 Other Revenues - - 4995 Transfers In 175,000 $ 6,100 485,312 $ 200,000 4999 Bond Proceeds-2006 $ 12,000,000 $ - $ - $ - Totals $ 125453,373 $ 165,500 $ 660,312 $ 206,100 Page 1 t• T- i'4141-y`�' N P. Fund: Capital Projects 75 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Bonds 10 A B C D Actual Expenditures Projected Proposed Budget Account Expense FY Budgeted Current Expense Current for Code Title of Account 2005-2006 1 FY 2006-2007 FY 2006-2007 FY 2007-2008 5290 Miscellaneous Expense-2004 500 - - 5411 Professional Services-2004 Bond - 68,500 148,223 5412 Professional Services-2006 Bond $ 383,318 6110 Capital Expenditures 6111 Capital Expenditures-2004 Bond - 7,357,238 5,894,350 6112 Capital Expenditures-2006 Bond - 12,065,500 3,189,260 6160 Capital Expend itu res-Veh icies - - - 6210 Bond Costs 157,880 7150 Transfer to General Fund - 20,690 347,622 8,035,932 Totals $ 158,380 $ 19,491,238 $ 9,615,152 $ 8,404,244 Page 1 PSPER PROPOSED BUDGET FY 2007 - 2008 PARKS FUND 60 Parks Dedication Parks Improvement RLSP'E" R Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Park Summary Fund Balance Proposed Account FY 05/06 FY 06/07 FY 06107 FY 07108 Description Actual Budgeted Projected Budget PARK FUND REVENUES Park Improvement Fees $ 172,000 $ 352,000 $ 118,000 $ 352,000 Park Dedication Fees $ 98,400 $ 255,000 $ 255,000 $ 255,000 Park Improvement -Interest $ 155 $ - $ 2,000 $ 2,500 Park Dedication -Interest $ 746 $ - $ 3,000 $ 4,500 Total Revenues $ 271,301 $ 607,000 $ 378,000 $ 614,000 EXPENDITURES General government -Parks Improv $ 183,304 $ - $ 31,000 $ 35,000 General government -Parks Dedication $ - $ - $ - $ - Total Expenses $ 183,304 $ - $ 31,000 $ 35,000 Excess / (Deficat) $ 87,998 $ 607,000 $ 347,000 $ 579,000 OTHER FINANCING SOURCES (USES) Total Other Financing Sources (uses) $ - $ - $ - $ - Net change in fund balances $ 87,998 $ 607,000 $ 347,000 $ 579,000 Fund Balance, beginning (as stated) $ 336,398 $ 424,396 $ 424,396 $ 771,396 Fund Balance, ending $ 424,396 $ 1,031,396 $ 771,396 $ 1,350,396 Page 1 !',01SER Fund: Parks 60 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department: Parks 60 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 1 Year 2006- 1 2006-2007 FY 2007-2008 4045 Park Fees -Dedication 4055 Park Fees - Improvements 4615 Interest Income -Park Ded 98,400 255,000 172,000 352,000 746 - 255,000 255,000 118,000 352,000 3,000 4,500 4620 Interest Income -Park Imp 155 - 2,000 2,500 Totals $ 271,301 $ 607,000 $ 378,000 $ 614,000 Fund. Parks Fund 60 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Parks 60 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 J 2006-2007 FY 2007-2008 5410 Professional Services -Pk Ded 5411 Professional Services -Pk Imp 6120 Capital Expenditures -Park Improv 6140 Capital Expenditures -Park Ded 6160 Capital Expend itu res-Vehicies 7141 Transfer to Parks & Rec Fund 40,304 - 31,000 - 35,000 143,000 - - - Totals $ 183,304 $ - $ 31,000 $ 35,000 Page 1 .4 For . ............ WAWV PROPOSED BUDGET FY 2007 - 2008 IMPACT FEES FUND 65 Water Impact Sewer Impact Thoroughfare Impact ly f�111_ . R PER Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Impact Fees Summary Account Description FY 05/06 Actual FY 06/07 I Budgeted FY 06 / 07 I Projected Proposed FY 07 / 08 Budget IMPACT FEES REVENUES Impact Fees $ - $ - $ - $ - Water $ 463,687 $ 409,696 $ 490,000 $ 648,750 Sewer $ 361,462 $ 353,648 $ 440,000 $ 494,250 Thoroughfare $ 412,407 $ 415,400 $ 415,400 $ 1,014,500 Investment income $ 51,206 $ 30,000 $ 58,000 $ 66,000 Total Revenues $ 1,288,762 $ 1,208,744 $ 1,403,400 $ 2,223,500 EXPENDITURES General Government $ - $ - $ - $ - General Government -water $ - $ - $ 17,700 $ - General Government -sewer $ - $ - $ 17,700 $ - General Government -thoroughfare $ - $ - $ 12,000 $ - Capital Outlay -water $ - $ 796,888 $ 127,000 $ 329,200 Capital Outlay -sewer $ - $ - $ 39,200 $ - Capital Outlay -thoroughfare $ - $ 293,300 $ 74,000 $ 120,000 Total Expenses $ - $ 1,090,188 $ 287,600 $ 449,200 Excess /; ; %: ; : "i $ 1,288,762 $ 118,556 $ 1,115,800 $ 1,774,300 OTHER FINANCING SOURCES (USES) Transfers In $ - Transfers Out (1,i60.542) Total Other Financing Sources (uses) (1,160.542) $ Net change in fund balances $ 128,220 $ 118,556 $ 1,115,800 $ 1,774,300 Fund Balance, beginning (as stated) $ 1,273,769 $ 1,401,989 $ 1,401,989 $ 2,517,789 Fund Balance, ending $ 1,401,989 $ 1,520,545 $ 2,517,789 $ 4,292,089 Page 1 r PR,bspt . Fund: Impact Fee Fund 65 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Revenue Department: Impact Fees 99 A B C D Revenue Actual Budgeted Current Projected Proposed Account Revenue FY Fiscal Year 2006- Revenue Current Budget for Code Title of Account 2005-2006 2007 FY 2006-2007 1 FY 2007-2008 4015 Impact Fees - Water 463,687 409,696 490,000 648,750 4020 Impact Fees - Sewer 361,462 353,648 440,000 494,250 4040 Impact Fees - Thorfare 412,407 415,400 415,400 1,014,500 4030 Miscellaneous - - - - 4610 Interest Income 51,206 - - - 4615 Interest -Water Impact - 10,000 26,000 30,000 4620 Interest -Sewer Impact - 10,000 18,000 20,000 4640 Interest-Thorfare Impact - 10,000 14,000 16,000 4910 Other Revenues - - - - Totals $ 1,288,762 $ 1,208,744 $ 1,403,400 $ 2,223,500 , 76t.wP t Fund: Impact Fees Fund 65 Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: Impact Fees 99 A B C D Expenditures Projected Budgeted Expense Proposed Budget Account Actual Expense Current FY Current FY for Code Title of Account FY 2005-2006 1 2006-2007 2006-2007 FY 2007-2008 5410 Professional Services 204,391 - - - 5416 Professional Services -Water - - 17,700 - 5420 Professional Services -Sewer - - 17,700 - 5440 Professional Services-Thorfare - - 12,000 - 6110 Capital Expenditures 956,151 - - - 6115 Capital Expenditures -Water - 796,888 127,000 329,200 6120 Capital Expenditures -Sewer - - 39,200 - 6140 Capital Expenditures-Thorfare - 293,300 74,000 120,000 6160 Capital Expenditures -Vehicles - - - - 7144 Transfer to Capital Assets (1.160.542) - - - Totals $ - $ 1,090,188 $ 287,600 $ 449,200 Page 1 0 FY 2007 - 2008 PROPOSED BUDGET SPECIAL REVENUES October 1, 2007 - September 30, 2008 Rev 08/15/07 it TOWN OF I SPE.. PROPOSED BUDGET FY 2007 - 2008 SPECIAL REVENUE FUND 67 r } Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 R, Summary of Revenue Fund: SPECIAL REVENUE FUND 67 Department; So Re V 10 A B C D Revenue Projected Actual Budgeted Revenue Proposed Account Revenue FY Current Fiscal Current FY Budget for Code Title of Account 2005-2006 1 Year 2006-2007 1 2006-2007 FY 2007-2008 4530 Police Donation 8,420 15,000 8,500 13,000 4531 Fire Dept Donations - 15,000 10,300 13,000 4532 Health & Safety Fair Donations - - 6,100 3,000 4535 Child Safety Donations - - 4,710 3,000 4536 Court Security Revenue - - 1,870 1,500 4537 Court Technology Revenue - - 2,160 1,800 4610 Interest Income 13 - - - 4915 Escrow Income - - 290,000 - Totals $ 8,433 $ 30,000 $ 323,640 $ 35,300 Page 1 Town of Prosper Proposed Departmental Budget r'n Fiscal Year, 2007-2008 r`''-•` , R Summary of Expenditures Fund: Special Revenue Fund 67 Department: Spec Rev 10 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 J 2006-2007 2006-2007 FY 2007-2008 5203 Court Technology Expense 5204 Court Security Expense - - - - 5205 Police Donations Expense 1,107 15,000 3,600 7,000 5206 Fire Dept Donations Expense 8,748 8,500 39,060 13,000 5207 Health & Safety Fair Expense - - - 3,000 5208 Child Safety Expense - _ _ _ 5209 Escrow Expense - _ _ _ 5290 Miscellaneous - - 7,570 - 5291 Special Operation - - 1,400 1,000 Totals $ 9,855 $ 23,500 $ 51,630 $ 24,000 Page 1 ` CrN.1 C F P 1?4�6 :§ V, F--.r ll�z. FY 2007 - Zoos PROPOSED BUDGET ECONOMIC DEVELOPMENT CORP October 1, 2007 - September 30, 2008 Rev 08/15/07 1'"SPER WN .CrP, 1' Town of Prosper FY 2007 - 2008 Town Budget Economic Development Corporation Net Assets / Reserves Proposed Account FY 05/06 I FY 06/07 I FY 06 / 07 I FY 07 / 08 Description Actual Budgeted Projected Budget ECONOMIC DEVELOPMENT OPERATING REVENUES Sales Tax $ 502,172 $ 500,000 $ 411,000 $ 390,000 Interest _ $ 37,881 $ 20,000 $ 57,000 $ 50,000 Other Income $ 36 $ - $ - $ - Total Operating Revenues $ 540,089 $ 520,000 $ 468,000 $ 440,000 OPERATING EXPENSES Total Operating Expenses $ 230,308 $ 324,943 $ 218,351 $ 319,066 Total Expenses $ 230,308 $ 324,943 $ 218,351 $ 319,066 INCOME (LOSS) $ 309,781 $ 195,057 $ 249,649 $ 120,934 Change in Net Assets $ 309,781 $ 195,057 $ 249,649 $ 120,934 Fund Balance, beginning (as stated) $ 761,458 $ 1,071,239 $ 1,071,239 $ 1,320,888 Fund Balance, ending $ 1,071,239 $ 1,266,296 $ 1,320,888 $ 1,441,822 Page 1 i TQI.N. N ,,.1 ` S. Fund: Economic Development Town of Prosper Proposed Departmental Budget Fiscal Year, 2007-2008 Summary of Expenditures Department: EDC 65 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5001 Master Plan - Other 5110 Salaries & Wages $ 96,519 $ 105,042 $ 88,317 $ 111,520 5115 Salaries - Overtime 149 - 100 3,000 5140 Salaries - Longevity 250 850 850 175 5145 Social Security Expense 5,991 6,565 5,515 7,111 5150 Medicare Expense 1,401 1,535 1,290 1,663 51555 SUTA Expense 155 540 814 540 5160 Health Insurance 8,546 8,867 7,051 4,254 5165 Dental 701 798 399 312 5170 Life Insurance 253 90 134 45 5173 AD&D 55 - 135 162 5180 TMRS Expense 6,603 6,626 7,264 9,554 5186 Short/Long Term Disability 658 1,443 511 500 5189 Administrative Fee 1,500 1,500 1,500 12,000 5190 Contract Labor - 1,300 1,165 1,000 5191 Hiring Cost 39 117 117 - 5193 Record Retention - 200 200 200 5210 Supplies 2,847 3,700 3,700 3,700 5212 Building Supplies - 300 300 700 5220 Office Equipment 1,303 3,200 3,200 3,200 5230 Dues School Subscriptions 360 1,825 1,825 1,825 5240 Postage & Delivery 156 1,500 1,500 1,500 5250 Publications 196 425 425 425 6260 Advertising - 300 - - 6265 Promotional Expenses 33,607 50,000 20,500 41,950 6270 Bank Charges 30 200 - - 5280 Printing & Reproduction 1,120 1,200 1,200 1,200 5290 Miscellaneous 145 - - - 5310 Rental Expense 70 75 75 100 5312 Equipment Lease - - - - 5320 Repair & Maintenance - - 63 - 5325 Copier Lease 468 - - - 5330 Copier Expense 2,469 4,000 4,000 4,000 5340 Building Repairs - 1,000 100 1,000 5350 Vehicle Expense - - - - 54410 Professional Services 42,145 30,000 30,000 20,000 5412 Audit Fees 500 500 1,200 1,500 5416 Engineering Fees 10,000 10,000 10,000 7,000 5418 IT Fees 176 500 500 4,000 Page 1 Fund: Economic Development Department: EDC 65 A B C D Expenditures Projected Actual Budgeted Expense Proposed Account Expense FY Current FY Current FY Budget for Code Title of Account 2005-2006 2006-2007 2006-2007 FY 2007-2008 5430 Legal Fees 2,485 8,400 8,400 9,000 5435 Legal Notices/ Filings - 700 700 700 5480 Contracted Services - - - - 5520 Telephone 3,039 3,300 3,300 3,300 5521 Cell Phones 829 900 900 1,700 5524 Gas - 500 - - 5525 Electricity - 2,400 1,600 1,700 5530 Travel Expense 1,659 5,500 5,500 5,500 5533 Mileage Expense 979 5,045 2,000 4,000 6536 Training 1 Seminars 2,905 4,000 2,000 4,030 6015 Leverage Fund Principal - 50,000 - 45,000 6140 Capital Expenditures -Equip - - - - Totals $ 230,308 $ 324,943 $ 218,351 $ 319,066 Page 2 Salary Account 5110 Last I Firgt Administration Butler Ronald Land * Mike Denton Matthew Gill Karen Open - Admin Asst New - 25 °•_ Police Dept V Total Administration Baxter Jason Gardner John Golden Robert Goodman Michael Jones Brandon Lightfoot David McFarlin Kirk McHone ** Gary Norris Paul New Admin Aiw-10 mos New P0I16e Officer-6 rnos Total Police Fire Tucker Ronnie Open Blasingame Stuart Diliberto Scott Graham Thomas Harris William Himes Scott Morgan Eric Norvell Dwayne Smith William Tyson Doug New 6 mos New 6 mos New 6 mos Taylor Michael Currie William Level Theresa Smith Rich Open Wendling Ben Total Fire 10 10 10 10 10 10 20 20 20 20 20 20 20 20 20 20 20 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 Cudl A n�$T Sarary ACdlust 0T�8 4% Raise 1 +4`Y��rd!Eel p us adl f Out;1�'teM I rr_ �1 t� � � 4% PI IT rt Wnl. 48,672.00 1,946.88 50,618.88 9,680.02 60,298.90 128,000.00 6,000.00 - 134,000.00 134,OOO.00 57,200.00 2,288.00 59,488.00 59,488.00 37,440.00 1,497.60 38,937.60 38,937.60 34,008.00 - 34,008,00 34,008.00 7,280.00 - - 7,280.00 - 7,280.00 312,600.00 6,000.00 5,732.481 324,332.481 9,680.02 334,{ 12,50 42,203.20 1,688,13 43,891.33 1,157.50 45,048.83 37,502.40 663.50 38,165.90 652.77 38,818.67 41,974.40 1,678.98 43,653.38 1,327.24 44,980.62 41,225.60 1,649.02 42,874.62 1,882.76 44,757.38 37,502,40 663.50 38,165.90 652.77 38,818.67 48,000.00 1,920.00 49,920.00 2,373.97 52,293.97 78,000.00 3,456.00 3,120.00 84,576.00 84,576.00 67,600.00 3,456.00 2,704.00 73,760.00 73,760.00 40,435.20 1,617.41 42,052.61 3,461.00 45,513.61 28,122.00 - 28,122.00 28,122.00 18,751.20 - - 18,751.20 - 18,751.20 481,316.40 6,912.00 15,704.54L 503,932.94 11,508,01 515,440.95 37,547.90 - 37,547.90 37,547.90 48,662.64 - 48,662.64 48,662,64 48,662.64 1,946.51 50,609.15 7,959.98 58,569.13 38,918.88 1,556.76 40,475.64 3,594.03 44,069.67 38,918.88 1,556.76 40,475.64 3,594,03 44,069.67 46,023.12 1,840.92 47,864.04 47,864.04 38,918.88 1,556.76 40,475.64 3,594.03 44,069.67 38,918.88 1,556.76 40,475.64 3,594.03 44,069.67 38,918.88 1,556.76 40,475.64 3,594.03 44,06'9.67 48,662.64 1,946.51 50,609.15 7,959.98 58,569.13 60,000.00 738.48 60,738.48 7,784.26 68,522.74 19,500.00 - 19,500.00 19,500.00 19,500.00 - 19,500.00 19,500.00 19,500.00 - 19,500.00 19,500.00 10,880.00 - 10,880.00 10,880.00 10,880.00 - 10,880.00 10,880.00 10,880.00 - 10,880.00 10,880.00 10,880.00 - 10,880.00 10,880.00 10,880.00 - 10,880.00 10,880.00 10 880.00 - 10,880.00 10,880.00 607,933.34 14,256.191 622,189.531 41,674.37 663,863.90 Streets Alejos Roberto 40 29,972.80 1,198.91 31,171.71 31,171.71 Parga Manuel 40 38,313.60 - 1,532_.54 39,846.14 - 39,846.14 Total Streets 68,286.40 - 2,731.461 71,017.861 71,017,$ Salary Account 5110 LaOt rlrst Dept 0 Armuaf Salory Salary Adjust 4% Rmmo sarary prus 4% r$isc rslm a(91 Adi to N1In 8:tlary rood III . 4% plus Mill. Parks Benitez Saul 60 27,185.60 1,087.42 28,273.02 28,273.02 New Packs Position 60 17,160.00 - - 17,160.00 - 17,160.00 Total Parks 44,345.60 - 1,087.421 45,433.02 - 1 45;433.Q Court Lightfoot Amy 70 37,460.80 - 1,498.43 j 38,959.231 38,959.23- Inspections Ausenbaugh Jessie 80 62,985.00 2,519.40 65,504.40 65,504.40 Doolin Morris 80 35,006.40 538.56 35,544.96 921.66 36,466.62 Freeman Steven 80 46,966.40 1,878.66 48,845.06 48,845.06 Ledwitz David 80 38,230.40 1,529.22 39,759.62 39,759.62 Sandoval Larry 80 40,000.00 1,600.00 41,600.00 41,600.00 Snell Jr Wayne 80 40,000.00 1,600.00 41,600.00 41,600.00 Evans Pam 80 13,000.00 520.00 13,520.00 13,520.00 Lindgren Trudy 80 13,520.00 540.80 14,060.80 14,060.80 New Plans Examinor. 6 mo 80 20,800.00 - 20,800.00 20,800.00 New Admin Asst-6 mos 80 14,560.00 - - 14,560.00 - 14,560,00 Total Inspections 325,068.20 - 10,726.631 335,794.831 921.661 336,716.49 Planning Copple Christopher 90 55,000.00 2,200.00 57,200.00 57,200.00 New Planner 90 50,000.00 153.85 50,153.85 50,153.85 Now Permil Tech 90 16,504.80 - 16,504.80 16,504.80 Total Planning 121,504.80 - 2,353.85 123,858.651 123,858.655 Engineering Webb Hulon 56 88,400.00 - 3,536.00 91,936.00 - 91,936.0 2,086,915.54 12,912.00 57,627.00 2,157,454.54 63,784.06 2,221,238.60 * Land $6,000.00 car allowance McFarlin "* $3,456.00 supplemental insuranc adjustment McHone ** $3,456.00 supplemental insuranc adjustment Section 7.11 of the Town Charter requires a Five Year Capital Program be included in the budget. In accordance with this requirement the following information is provided for Water, Wastewater, and Thoroughfare. A list of all capital improvements which are proposed to be undertaken during the five fiscal years succeeding the budget year, with appropriate supporting information as to the necessity for such improvements. -- Cost estimates, method of financing, and recommended time schedules for each improvement; and, The estimated annual cost of operating and maintaining the facilities to be constructed or acquired. The proposed projects provided are based on information contained within the approved Town of Prosper Capital Improvement Plan and Town staff recommendations on projected development. 5 3 A .00 zw N eq 'R Ell s il 1-b uj E sE .9 '46:: �2 1�1 L, —owl. I I I ml �) 2 $ ; r N r r IE P R Gp ;ip :e;Y5( t I P, Ln. sv w Lfj Q2 R Q fo fo P 3y PL 71 uj LU LU N 12 W2: LLI gr LxLL�7117 _a' Ct m HZI m J W 0 w a Z m � m C 5 Z LL V o C m I U Z� IL C j II LL ci EL [�L li W CL E i E 7 E Q �I Z an o c`�i rj o v o 0 aaoo 0000 0 00 0 co 0 o O Loo o c% P9 ' N o cO h cO aO & OI l\ uJ t: r� _ - ' I ('1 •G co chi sC ai w o o �_ ul N [+1 Cl [� r- N a N jl T I Cl) s a�i+_ M W In +- r- Oi�i F li 1. £O - [QV Y I r— iV W r1 tf7 cD r N r F Ln ,.^_ KJ — w F Ui F dJ w Z W 0 C.1 Z o_ rLU J p rj m m m d Q Im h WI- 0 i 0 U Z 0 e0 •n n Lu o F E Z— U I ~ I yI o a I o w w U. (C i a o wl C b d, LU ¢n� a �o ? m- m d �a Iw „ F F z W 113 LU 'r " EL a 4 d lip.'= m cl N LL L1. m� I'In R.�N ip mb W �uJ [o 'm �'C om mom' a 4t IV6 � � � � Q 5 it U a S IZ A, nova LL T LL T� J. LL F ciZI N Lr�E N N N M M H a. W 0 CL 0 N LW r �l z 0 F-L uj LL i° 0 U z 0 L) U 0 U olL L W r° U) w W W Y. L] h LLil H 0, LU z z W a ifU u pp { WW � li- ki� E i N M N N N Y4 9� rh d} :1} 9f4 %OL I?t qh_ fn r9 140 O CF 6 O 4 O 1 t`J p o C O O g Ap uqy o f❑ N i c M CD N O �] o N r vi ry d! R4 ab LR VF {M1 YF 4} !S ,h rM ?n ff f/ V! 13 _X W r rd� w N v. w lA 4p 4! # N 0 u{ M yr a. t Cs I- i " D.. ? F F m t4 .W t4 rn 8i a m dS 0}m Ca' a! r.i r: O r 6 S 8$ 8 8 8 8$$$ o �p vi a y lb N m N us w ✓, an .ry to .n Up to (n v3 r N h o U Z G p C d G € ❑ ❑ O`� r pp m Ld � � m m m F LL z O O Ix Y J1 VF H LLI }� zI' 11 w rp a M r waZ .. O of EU LL W a H W w W W Z a Z W F 2 W 2Lli LLI LU W r IL w n N N : N c) W O N o c p p m° m m v m v m o m o m$ o m 0 m mo n C mo n mo C N - LL LL ll 1i IL LL LL ll ll !l f 7 d 7 m N sU5U50 o a a cLL cLL c E E E O U O O U U O O W O O O o p O o o O O O o R p p W O M o 40 m O S l[3 O S lS5 O O O o 4 O �ofl O eJ O CO o Ki o pp O O O pp YOl O op 0 0 o 0 0 0 0 0 OO oOtiOOOo o o 'OD m O O p Op fp M M m ooOpo poO 0 0 oo W0o1 NhcNho i00 C) N f In 0 w m C Lo a M N (V cV 11 V N N N n na O O O O O S o O O O O O O o0 o p cl N m O c O o c ppR O o O o O O o o o O O R q m eNn ai $ g o umi 0 om o ro Ui lc o rn R ui M g n M N SO c•1 [V M OI N 69 co co f9 fo 69 ui V! Io M Eo vi [9 Nf eA M m m 4 R o a L z¢ m m O m m r m m m F m w m W O m m N N tll d � L L L L L L C C C C E EEEOEEOEEEOOE E OESFN N N N Q� N O m m m m m R F F F F m m 12 m a❑�7 F- Fm- F o $ O 0 o O O p p o 0 ri o o R 0 o o Cl g C IS c N o $ 0 N 0 N fo di di M fo 69 m V3 d9 Io !o w w w V3 t- N OO O6i 00 ry 00 i i i 00 O 0 opo C] 0 pa o O a m o O o p O m Yf (Np t9 ¢9 v9 49 wf 69 O yy Y3 tl! po fo pp f9 fR V9 N N y � c [ u cs g g o asap J m m j 3 7 j O g O 0 ❑ O ❑ ❑ m F H H d C d a '4 a ISm m Fm- fm- F O m m m m ❑ H a` IL a 2 IL❑ Om ❑ IL�Er C m V r9 L mp h O O � of rr O of O W 0 R r N 'c �s2ddpm 7 o C p O] o o 0 0 o my,W $ v ^, o- �cas cy a d a m n ns "� a m d � v 2 ma v�a� m am �i L u, 3a? m m m m m v aFiyE'�oj `. CWm o o 0 0 Ocd 0 o O �o A m d U M C- m IL •fi\ l' ENGINEERING P F-11" R To: Mayor and Town Council From: Hulon T. Webb, Jr., P.E., Director of Development Services/Town Engineer CC: Mike Land, Town Manager Re: Town Council Meeting — August 28, 2007 Date: August 24, 2007 Agenda Item: Consider and act upon a change order to Red River Construction Company, Inc., for the Pump Station and 3 MG Ground Storage Tank Project. Description of Agenda Item: On July 19, 2007, a site meeting was held with Town staff, Red River Construction, TPC Electric, Macaulay Controls and Freese & Nichols to review the following observed issues: The current operation does not provide the results expected by Town staff, namely an automated chemical addition to maintain desired chlorine residual in the water pumped from the new facility to the Town's water distribution system. Chlorine residual measured in water leaving the station appears to be unchanged through the pumping cycle and is similar to the residual measured prior to chemical addition even though the sodium hypochlorite feed pumps appear to operating at maximum frequency. 2. The high pressure cutoff switches for the sodium hypochlorite system have corroded and begun to leak. The plastic 90-degree elbows installed to connect the switches to the instrumentation are broken as well. The pressure switches were corroding and leaking prior to the plastic elbow fitting breaking. The intent of the sodium hypochlorite feed controls are to maintain a target chlorine residual in the water leaving the facility. This is accomplished by measurement of the finished residual and comparison to an operator -adjustable setpoint. A continuous sample is piped from the effluent flow meter vault into the chemical feed room where an online chlorine residual analyzer proved a continuous measurement and signal. However, while the sample pipe is V diameter, designed to deliver 5 gallons per minute from the vault to the building, the flow is restricted at the instrumentation to 0.18 gallons per minute, resulting in a delay of approximately 39 minutes from the time the sample is diverted until it is measured. Solutions include increasing the sample flow and relocating the measurement location to reduce the travel distance. Increasing the sample flow could be accomplished by providing an instrument bypass line near the instrument, allowing most of the sample flow to bypass the restriction, reducing the sampling delay to about 80 seconds. Also, the various sensors could be mounted within the meter vault and chemical injection manhole to shorten the sample time. Agenda Item No. 8 - Page 1 of 2 Based on discussions between Town staff and Freese & Nichols, the following improvements are recommended: 1. Relocate the discharge -side chlorine residual analyzer (probe only) to the Town of Prosper meter vault and the suction -side chlorine residual analyzer (probe only) to the chemical injection manhole to provide rapid monitoring of the chlorine residual at each location. LCD displays and control panels shall remain in chemical room. 2. Add a'/" bypass line from the sample pump discharge line to the sodium hypochlorite injection line inside the chemical injection manhole to reduce the sampling delay time. 3. Replace the corroded sodium hypochlorite switches with new switches compatible with sodium hypochlorite and plastic 90-degree elbows. Also included in this change order is the Town's reimbursement of the associated electrical charges the contractor paid after the project was substantially complete. Budget Impact: The cost to complete the relocation of sensors, installation of the bypass line on the discharge pump, and replacement of the corroded pressure switches is $6,078. Since the specified pressure switches were not compatible for use with sodium hypochlorite, Freese and Nichols will deduct $2,000 from its Engineering Services Agreement to reimburse the Town of Prosper for the cost of replacing the pressure switches. Therefore, the remaining $4,078 will be funded by the 2004 CO Bonds. The reimbursement to the contractor for the electrical bills paid is $6,592.81 and will be funded by the Public Works Water Fund Acct. # 20-5525-50. Le al Obligations and Review: No legal review of this request by the Town's attorney is required. Attached Documents: The following documentation is being provided for review: • Change Order — 7 pages Board, Committee and/or Staff Recommendation: Town staff recommends that the Town Council approve a change order to Red River Construction Company, Inc., in the amount of $12,670.81 for the Pump Station and 3 MG Ground Storage Tank. Agenda Item No. 8 - Page 2 of 2 rim CHANGE ORDER PROJECT: Prosper Pump Station & 3 MG GST PROJECT NUMBER OWNER: Town of Prosper PRP05200 CONTRACTOR: Red River Construction Company ENGINEER: Freese & Nichols, Inc, CHANGE ORDER NO.: 6 DATE: 10-Auq-07 Make the following additions, modifications or deletions to the work described in the Contract Documents: Relocate the discharge -side chlorine residual analyzer (probe only) to the Town of Prosper meter vault. Relocate the suction -side chlorine residual analyzer (probe only) to the chemical injection manhole. LCD displays and control panels shall remain in chemical room. 1 } Add a 1/2" bypass line from the sample pump discharge line to the NaOCI $ 6,078.00 injection line inside the chemical injection manhole. Replace corroded NaOCI pressure switches with new switches compatible with NaOCI. Part number shall be AP-7021-153-39. Reimburse Contractor for electrical charges to pump station from 3/15/07 2) to 4/16107, statement Date 4123107. $ 2,520.36 Reimburse Contractor for electrical charges to pump station from 4/16/07 3) to 5110/07, statement Date 5/181107. $ 3,888.56 Reimburse Contractor for electrical charges to meter vault from 4/16/07 to 4} 5/16/07, statement Date 6/22/07. $ 85.49 Reimburse Contractor for electrical charges to meter vault from 5/16/07 to 5) 6/15/07, statement Date 6121/07. $ 48.71 Reimburse Contractor for electrical charges to meter vault from 6/15/07 to 6) 7/16/07, statement Date 7/24/07. $ 49.69 The compensation agreed upon in this Change Order is full, complete and final payment for all costs the Contractor may incur as a result of or relating to this change whether said costs are known, unknown, foreseen or unforeseen at this time, including without limitation, any cost for delay, extended overhead, ripple or impact cost, or any other effect on changed or unchanged work as a result of this Change Order. Original Contract Amount Previously Approved Change Order Amount Adjusted Contract Amount Proposed Change Order Amount Revised Contract Amount Previous Contract Time Previous Substantial Completion Date Previous Final Completion Date Net Change in Contract Time $ 5,119,620.00 $ 46,595.00 $ 5,166,216.00 $ 12,670.81 $ 5,178,885.81 NIA March 28, 2007 April 18, 2006 NIA Revised Contract Time Revised Substantial Completion Date Revised Final Completion Date Recommended by FREESE AND NICHOLS, INC. By Date Approved by [OWNER] By Date Approved by [CONTRACTOR] By NIA March 28, 200T September 3, 2007 Date 069267- `213 1371344 _ STATEMENT 77015, W"'s . Codnllk Texas 78710.1842 ice• REI3 RIVER CONSTRUCTION COMPANY 2804 CAPITAL ST Statement„Date' Custot dumber: 04/23/0' Account h0mber: 200004293( 00007433.; Bill Number: Total Amount Due: 829630; Current Bill Due Date: $2520. 3E 5/10/0 �i1+e HaC1r: uyti H CUSTER RD Win four tickets to watch the Fris ouaiiRidPrs in actionl Enter the contest at Vvwtiu.cvserv.com>CoSery Electric ervice>Community>Rough Ticket Contest: Entry deadline is July 31, Zat W- Member and Customer Electric Usage Statement Service From: Previous Reading: 3/15/07 S€rvice To: KWH Used: 10 7900 Current Reading: KW Demand: Meter Multiplier: Rate Code: 300. Q00 Tndustoial Meter Number: Days of Service: and Responsibility information Is available 0 Jon request. Electric Servlce Detail 4/16/07 36 216.00 17231.4 32 KWh Usage -Rolling 13 Month History b885 Electric Energy Charge: Customer Charge: Demand Charge: PCRF: 0.0400 City Sales Tax State Sales Tax RECEIVED APR 26 2007 Account Summary $269.49 $35.00 $1825.20 $312.00 $48.83 S152.61 o Previous Statement Balance: $790.05 Payments) Received: $-570.51 Other t(s) Charges: & a �` Transfer to Electric AR S-162. 31 Deposit Awing - Electric $-180.00 Current Charges; �Gu=rgEr oct'fc irar a erb o I totS9'� I #a:p inapt"f Account Balance: $2643.13 ftulFelyad:r:urrentw:;tdLm da#. fi2520.36 tech lrayment cou on and return with.y ear check DO Nq h SEN[} CASH! ..................._.....,................................................. ....... 000111-001.000111 CST$ 1379644 a_ STATEMENT Statement Date: o � f 1810 7 FINAL # Customer Number: 2DO0042936 Account Number: 0000274315 Bill Number: 8378715 7701 S. Stemmons-Codnth,Taxas76210.1842 Total Amount Due: $3888 . 56 Due Upon Receipt ----� RED RIVER CONSTRUCTION COMPANY r= 2804 CAPITAL ST WYLIE TX 75098 Service Addr: 990 B CUSTER RD CoSery will be closed May 28 for Memorial Day. Visit www.coserv.com to take the Energy Star. Change a Light Pledge. Choose-CoSery Electric Service, and click the story, -Take the Energy Star Pledge., Member and Customer Rights and Responsibility information is available upon request, Electric Usage Statement Electric Service Detall Service From: 4/16/07 Previous Reading: 36 KWH used: 20100 Meter Multiplier: 300.000 Rate Code: Industrial Service To: 5/10/07 Current Reading: 103 KW Demand: 195.00 Meter Number: 172314 Days of Service: 24 KWh Usage - Rolling 13 Month History 0120 5090 D060 - 5030 ` — 0 !! o `0 1O a 10 10 LL A o Apply Electric Deposit to AR $-180.00 Final Interest On Deposit $-0.78 Electric Energy Charge: $694.46 Customer Charge: $28.00 Demand Charge: $2232.75 PCRF: D.04 $804.00 City Sales Tax $75.19 State Safes Tax $234.95 Account Summary Previous Statement Balance: $2520.36 Payment(s) Received: $-2520.36 Other Misc Charges: Deposit Payment - Membership $0.00 Current Charges: $3889. 56 Account Balance: $3888.56 FItfAL �llr�. . - Eletach paymenf coupon and return wtth ynur check. DO NOT SEND CASHI PAYMENT COUPON Service Addr. 990 8 CUSTER RD RED RIVER CONSTRUCTION COMPANY 2804 CAPITAL ST FSMV- wYLIE Tx 75098 7701 ``5-ftStemmonrra - CaNnth, Texas 762117-1842 RECEIVED MA' 231017 MAIL PAYMENTS TO: COSERV POST OFFICE BOX 650785 DALLAS, TX 75265-0785 IlrrrlrlrlrrrlrlrllrrllrLllrlrlrr�111J1r111111rLrIJrrllJl Customer Number: 2000042936 Account Number: 0000274315 Total Amount Due: $3888.56 AMOUNT PAID: Please write your account number on your check. CoSery shall not be held responsible for requests or notifications written on your payment coupon, 2U.00 4E9360000274315000388856200706039 r- roLn,lwr- 0 MC� to rf q 1. NNtoM11i(c �ory40*1.MICO� 000 !� �O 00 N O OZ = L.. �. r �Cic�00H-U r a. a L) 0 a tn. to Oo udul, F r• R LL, O O —I LJ C7D � CV M00:2ti� M N �-i IA i+► � iq 64 EA GI '� t►S CT G .0 IM 'u a cu Ci 11 W ,,� ?� = tn M v I W sC ' V E �6 � J9 2d € w 5 i i Wu'04; 21 z i o u � � no.minM0 In en \NMN N N u L u U R .,�. N C 08 r- .r.r e ~ N a m2: tn as E �,w�,►. u A ua 10 N .� of fV 2 i�d C-4NG 1^➢ `0 (1� c, Q LA LM u to ur.Q� Zd=a°' tl? 0MVCMPM n^i rri w en NN0000 4 r641/1 H4 5 10 uw15 {lNIdM �E 0 CE0.ua sa-Avw tg 9D-7nC 9D�91N1 0 I 9D-d35 rn 9a-17a 90-AON � 90-73q V /O-NYC Lo-M21 3 co-aYw cD>tiaY aM o f1opp � o !� in P► H C"+1 M. Cm LLI LLI U LU nwlflqorlL- aattoN[�.v \ (Nn e4 ui \ N a� Lo V Q \ONLfIt4\ toOO W r- O G. O NO c'EL)ocm[°c'.) W W F- F- LO X • p u i Atq� a a t,a z 0 �M W W 00 a tjQLA [� W00%- OCe439. �d Iw�.pN010pq fOp W;Ln to O N aC14 7tAH g a a m, r. (P 'd 4 W & Lm �.• u ri'..uQ 90-mc � 90-1E1[ a ; 9D-911V T ss W-d3S 0 90-110 90-A0N 90-330 LO-NVC LO-1333 La avw LO-adV co-Avw LO-Nnc � o t-toentr0t- ototoinwo tll ri r•1 !QINLoCoM0 mvr- iV!H O tit t, Q. � .:..t-O d co w 000 N o IV 5 E, C3 cl wE=EE �Oa.a.�Cc v 0z air z E F z a r.� l~ rV) Do 01 r1 d Ln Ix F- n U � liJ � � 00O[VNt• MOtnplCC 4tAtCON qa rn a � Q• � L1 to m a wEl W di U im wU Fn •Q w m a C L EE Vl y �a�a euU�Uvl s, © a � rn � °� .. :2 U) c m~ N piinny�LAm ow r♦ rd N u 0 R Nry r_ o aaE� r_ y A a m E c ca ��Z u CL p m a 0 -o -a S to [J se A oa I� tR m O r _ rG E W co qD CD P,, '-i O u vI V L!? rN-� r4 m Fn aj © l ca CD o u c Q- I L •rn t� L,G cG -0 � a w o m'� y N� O uo�>~u 2m 943 � V, DE q r-t ri m m h h to to co 00 (n al mt d u m a no -W y t- y Eumu fd aaa,c 41 Ln � b u m in +1 rC oa�� Eio, a aU¢ go --Inc � 9a-anv O 90-d3S S c 90-lao 90-AGN (Y) 90-Aa cn 10-NVC [o-m:l co-BVN co-adv to ,AVw 10-ME ED-InC O Q A Q O r � lq ri r � to s! � 44� d U� CL ff � z o0 OZ fl o M o f- QfH8dLO �w�r Elorcau, N >- o =a E IL �l 4+ ADMINISTRATION S P Fd�', N, To: Mayor and Town Council From: Mike Land, Town Manager CC: Re: Town Council Meeting — August 28, 2007 Date: August 23, 2007 Agenda Item: Per my previous e-mail the Mayor and I visited last week about having the Council form three Council Committees. He would like to appoint to the following committees at the meeting Tuesday night: a. Finance Committee — David Bristol, David Turley b. Utility Committee — Kevin Drown, Kenneth Dugger c. Economic Development Committee — Ray Smith, Mike Wadsworth The Mayor would serve as the third member of each committee or be able to slide a third council member in his place if he is not available or chooses to not be part of a particular discussion. As we go through the next nine (9) months and in preparation for next year's budget, the Finance and Utility committees will be instrumental in recommending to the Council as a whole, multiple core policies. The Economic Development Committee will serve as the point Council Committee to assist staff in negotiating with the development community on a variety of projects or other economic development related issues. The committee structure does not preclude complete participation by the Council in any of these activities. It does though give staff an opportunity to have policy makers involved in the development of draft policies, procedures and development issues that eventually will be considered by the full Council. Description of Agenda Item: No Resolution or ordinance is necessary for this action. The committees do not become standing committees with any final authority. Meetings arc not scheduled for any specific time. When a meeting is held though, the meeting date and time will be posted at Town Hall. These meetings do not require a published public notice. Budget Impact• There are no budgetary impacts related to this action. Agenda Item No. 9 - Page 9 of 2 Legal Obligations and Review: Legal review is not necessary for this action. Attached Documents: There are no attached documents. Town Staff Recommendation: Town staff recommends that the Town Council approve the Mayors request to establish the Finance, Utility, and Economic Development Committees with their corresponding council members. Agenda Item No. 9 - Page 2 of 2 w (:)' 'v`' I`I (F' R ADMINISTRATION To: Mayor and Town Council From: Mike Land, Town Manager CC: Re: Town Council Meeting — August 28, 2007 Date: August 23, 2007 Agenda Item: Consider and act upon Resolution authorizing the Mayor to submit someone as the Town's candidate for the Collin Central Appraisal District Board of Directors. Description of Agenda Item: Per Chief Appraiser Honea's letter dated August 20tH, the Town of Prosper will have 8 votes to cast in the election of Board of Directors for the Central Appraisal District of Collin County. Prior to casting said votes, the District accepts nominations for candidates to serve as directors. These nominations must be made in a public meeting and submitted to the District prior to October 15, 2007. Each voting entity may nominate up to five (5) candidates. According to the information provided, a director must reside within the appraisal district for at least two years prior to serving on the board. The person may also serve on the governing body of a taxing unit within the district. The attached letter further defines who may or may not serve on the board if elected. Budget Impact: There is no budgetary impact as a result of approving this resolution. Legal Obliciations and Review: There are no legal obligations or required review associated with this Resolution. Agenda Item No. Lq- Page 1 of 2 Attached Documents: 1. A Resolution authorizing the Mayor to submit the name of a person to be a candidate for the Collin Central Appraisal District Board of Directors. 2. A letter dated August 20, 2007 from Chief Appraiser Honea. Town Staff Recommendation: Town staff recommends that the Town Council consider nominating a candidate from within the ranks of the Council. Agenda Item No. — - Page 2 of 2 RESOLUTION NO. A RESOLUTION AUTHORIZING THE MAYOR TO SUBMIT THE NAME OF AS THE TOWN OF PROSPER CANDIDATE FOR THE COLLIN CENTRAL APPRAISAL DISTRICT BOARD OF DIRECTORS. WHEREAS, each voting unit may nominate a maximum of five candidates for a position on the Collin Central Appraisal District Board of Directors; and WHEREAS, in accordance with the provisions and qualifications required of said nominees, the Town of Prosper hereby submits the name of NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, MEETING IN REGULAR SESSION ON AUGUST 28, 2007: Section 1 That the Mayor, for and on behalf of the Town of Prosper, Texas hereby submits as a nominee to the Collin Central Appraisal District Board of Directors the name of PASSED AND APPROVED THIS 28TH DAY OF AUGUST, 2007 BY THE FOLLOWING VOTE: _AYES NAYS _ABSENCES AND _ABSTENTIONS CHARLES NISWANGER, MAYOR ATTEST: MATTHEW DENTON, CITY SECRETARY Collin Central Appraisal District Charles Niswanger, Mayor City of Prosper P. 0. Box 307 Prosper, TX 75078 August 20, 2007 RE: Election of Central Appraisal District of Collin County Board of Directors. *-**CORRECTED ALLOCATION OF VOTES DUE To ADDITION Of NEW ENTITIES PER: # 57010*' ` Dear Mayor Niswanger: Please be advised that the City of Prosper will have 8 votes to cast in the election of the Board of Directors for the Central Appraisal District of Collin County. The terms will be for two years beginning January 1, 2008. Each voting unit may nominate fron, one to five candidates. Nominations must be made. in an open rneoting. vv+ ten resolution from the presiding officer should Include the nal-ne and address of each candidate nominated. The resolution must be delivered to the Chief Appraiser before October 15, 2007, Sincerely, Jimmie Honea Chief Appraiser JCH/mlr Enclosure www.callincatt_org 250 W. Eldorado Pkwy. Metro 469-742-9200 Admin Fax 469-742-9209 McKinney, Texas 75069 Toll Free 866-467-1110 Appraisal Fax 469-742-9205 Collin Central Appraisal District DIRECTOR QUALIFICATIONS An appraisal district director must reside in the appraisal district for at least two years immediately preceding the date he or she takes office. A person may serve on the governing body of a taxing unit in the appraisal district that is; a city councilman, school board trustee, county commissioner, or other board member, and still be eligible to serve as a director. The common-law doctrine of incompatibility (holding offices that have conflicting demands on the holder) does not prohibit the same person from holding both offices. There is no limit to the number of elected officials that may serve on the board. An employee of a taxing unit within the appraisal district may not serve as a director. The only time that a taxing unit's employee may serve is if that employee is also an elected official or member of the governing body. For example, a city councilman who is employed as the school business manager may serve as a director. A person may not serve as a director if he or she is related to someone who appraises property for use in proceedings before the appraisal review board or in subsequent court proceedings, or represents property owners in such proceedings. A person may not serve on the board of directors if that person has a substantial interest in a business entity which has a contract with the appraisal district or, in the -case of a taxing unit, has a contract related to the performance of an activity governed by the Tax Code. (Example- a partner in a law firm engaged in collecting delinquent taxes for a taxing unit.) In considering individuals to serve as directors, taxing units should look for expertise in such areas as accounting, finance, management, personnel administration, contracts, computers, real estate, or taxation. www.collincad_org 250 W Eldorado Pkwy McKinney, Texas 76069 Metro 469-742-9200 Toll -Free 866-467-1110 Admin Fax 469-742-9209 Appraisal Fax 469-742-9206 fi� '` s s : ' ADMINISTRATION PR To: Mayor and Town Council From: Mike Land, Town Manager CC: Hulon Webb, Re: Town Council Meeting — August 28, 2007 Date: August 21, 2007 Agenda Item: Consider and act upon a Resolution authorizing the Mayor to execute a boundary agreement with the Town of Little Elm. Description of Agenda Item: The Town of Little Elm has annexed an area between Savannah and Paloma Creek. The northern boundary of that annexation is in line with Savannah's northern boundary. The area due north of the annexed area is not in anyone's particular ETJ. This is the result of a boundary agreement signed with the Town of Little Elm in August of 2005. In that agreement the Town of Little Elm's ETJ for this specific area was restricted to only encompass an area as far north as Fishtrap Road. (See attached Exhibit from the 2005 Agreement) Because this area falls outside of both Prosper's and Little Elm's ETJ, only the county rules for development have application. Thus the need to have the area covered by Little Elm's ETJ. This agreement proposes to allow Little Elm to extend its ETJ north of Fishtrap Road between their existing ETJ and the Town of Prosper's. The most important section of this agreement is Section 9. This section in summary states that should the Town of Prosper desire to extend its ETJ or corporate boundaries into this area, Little Elm upon the request of Prosper will relinquish those portions to the Town of Prosper. Budget Impact: There is no budgetary impact to this action. Legal Obligations and Review: It is my understanding from staff that this agreement has been reviewed by Mr. Abernathy. Agenda Item No. 11 - Page 1 of 2 Attached Documents: A resolution authorizing the Mayor to execute the boundary agreement between the Town of Prosper and the Town of Little Elm. 2. A copy of the Exhibit contained in the first boundary agreement with the Town of Little Elm signed in 2005. 3. A boundary agreement for the Mayor's signature. The agreement includes an exhibit depicting the area being added to the Town of Little Elm's ETJ. 4. Town Staff Recommendation: Town staff recommends that the Town Council approve the boundary agreement with the Town of Little Elm. Agenda Item No. 11 - Page 2 of 2 m TOWN OF PROSPER, TEXAS RESOLUTION NO. 07- A RESOLUTION OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, HEREBY AUTHORIZING THE MAYOR OF THE TOWN OF PROSPER, TEXAS, TO EXECUTE A BOUNDARY AGREEMENT BETWEEN THE LITTLE ELM, TEXAS AND THE TOWN OF PROSPER, TEXAS. NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS: SECTION 1: The Mayor of the Town of Prosper, Texas, is hereby authorized to execute, on behalf of the Town Council of the Town of Prosper, Texas, a Boundary Agreement between the Town of Little Elm, Texas and the Town of Prosper, Texas. SECTION 2: This Resolution shall take effect immediately upon its passage. RESOLVED THIS THE 281h day of August, 2007. Charles Niswanger, Mayor ATTEST TO: Shanae Jennings, Town Secretary TOWN OF LITII-E ELM Mayor's Off 'Ice Little l:lin, TX 7 8- 0 0 14,97 5 2 ym'.1ittlec im,org June 19, 2007 Charles Niswanger, Mayor Town of Prosper P.O. Box 307 Prosper, Texas 75078 Dear Mayor Niswanger, Please find enclosed three executed originals of the Boundary Adjustment Agreement between the Town of Prosper and Town of Little Elm. This is the same agreement previously presented to you by Richard Abernathy. Once your Council has concurred, please execute all three copies. One original is for your official records. Please return the remaining two — we will forward one to Denton County for recording and the other for our records. Should you have any questions, please do not hesitate to contact me. Sincerely, Frank Kastner, Mayor Mayor Frank Kastner, To)m of Little El,n 1.00 West Eldorado Parkway 14�9'75 40 Lnay gr littictelrn,� 1-1 STATE OF TEXAS ) ) BOUNDARY ADJUSTMENT AGREEMENT BETWEEN COUNTIES OF DENTON) THE TOWNS OF LITTLE ELM AND PROSPER AND COLLIN ) WHEREAS, the Town of Little Elm, Texas ("Little Elm"), is a home -rule municipality created pursuant to Article 11, Section 5 of the Texas Constitution, and located in Denton County, Texas; and WHEREAS, the Town of Prosper, Texas ("Prosper"), is home -rule municipality created pursuant to Article 11, Section 5 of the Texas Constitution, and located in Collin County, Texas; and WHEREAS, both Little Elm and Prosper are empowered to enter into agreements concerning their respective extraterritorial jurisdiction ("ETJ") boundaries and corporate limit boundaries by, but necessarily limited to, the authority granted them pursuant to Chapter 791 of the Texas Government Code, known as the Interlocal Cooperation Act, to enter into agreements with one another to perform governmental functions such as the determination of ETJ boundaries and corporate limit boundaries; and WHEREAS, Little Elm and Prosper are empowered pursuant to Section 42.023 of the Local Government Code to reduce their respective ETJ boundaries by ordinance or resolution; and WHEREAS, Little Elm and Prosper, by virtue of Section 43.021 of the Local Government Code and their respective home -rule charters, are empowered to fix their respective ETJ boundaries and corporate limit boundaries, extend their ETJ boundaries and corporate limit boundaries, and exchange areas with each other; and WHEREAS, Little Elm and Prosper desire to identify mutually agreeable annexation boundaries and the resulting ETJ boundaries and corporate limit boundaries between the two Doc #490316 1 communities, and provide a mechanism designed to ensure, to the extent legally permissible, that areas of common interest are subject to municipal control and regulation; WHEREAS, it is necessary to determine an optimum location for such boundaries so as to eliminate future boundary disputes, and; WHEREAS, Little Elm and Prosper agree that it is in the best interest of the residents of their respective communities to establish mutually agreeable annexation and ETJ boundaries by agreement, and; WHEREAS, Little Elm and Prosper have determined that the ETJ boundaries graphically portrayed on ExhibitA, attached hereto and incorporated by reference, shall establish the limits of each town's respective ETJ boundary limits with respect to each other; and WHEREAS, Little Elm and Prosper recognize that the area shown on Exhibit as Little Elm's ETJ north of Fishtrap Road is an area of common interest to Little Elm and Prosper and an area into which Prosper may one day desire to extend its ETJ boundaries and/or corporate limit boundaries; and WHEREAS, in recognition of this common interest, Little Elm agrees that it will not annex into the area shown on Exhibit A as Little Elm's ETJ north of Fishtrap Road without Prosper's consent; and WHEREAS, in further recognition of this common interest, Little Elm agrees that it will, upon request by Prosper, relinquish those portions of the area shown on Exhibit as Little Elm's ETJ north of Fishtrap Road to Prosper to allow Prosper to extend its ETJ boundaries and/or corporate limit boundaries into the area, provided that Little Elm is satisfied that Prosper has the legal authority to accomplish such expansion into the area; and Doc #490316 2 WHEREAS, the Texas Interlocal Cooperation Act, contained in Chapter 791 of the Texas Government Code, authorizes Texas local governments to contract with one or more other local governments to perform governmental functions and services under the terms of said Act; and WHEREAS, the towns' respective home -rule charters allow them to enter into such agreements; and WHEREAS, Little Elm and Prosper wish to avail themselves of the rights and privileges afforded by the Interlocal Cooperation Act, their home -rules charters and other applicable state laws, and both have determined that this Boundary Adjustment Agreement Between the Towns of Little Elm and Prosper ("Agreement") is in each party's best interests, as well as in the best interests of their respective citizens; and WITNESSETH: NOW, THEREFORE, for and in consideration of the mutual promises and covenants herein made and the benefits to each party resulting here from, and the recitals set forth above which are made contractual provisions of this Agreement, Little Elm and Prosper do hereby contract, covenant and agree as follows with respect to the properties made subject to this Agreement: Little Elm hereby agrees to establish and limit its ETJ boundaries, with respect to Prosper's ETJ boundaries, as shown on Exhibit A. 2. Little Elm hereby releases, relinquishes and discontinues any claim or entitlement to any ETJ area that this Agreement describes and portrays as being in Prosper's exclusive ETJ area. 3. Little Elm agrees never to attempt to extend Little Elm's ETJ into any ETJ area that this Agreement describes and portrays as being in Prosper's exclusive ETJ area without first Doc 9490316 receiving a fully executed resolution or ordinance of the governing body of Prosper amending this Agreement to authorize such action. 4. Little Elm agrees to take all necessary actions, including the release of any ETJ currently within Little Elm, pursuant to Section 42.023 of the Local Government Code, to establish the common ETJ boundaries shown on Exhibit A. Little Elm agrees that it will perform all such needed actions within 90 clays of the date this Agreement is fully approved, with such full approval occurring when both Little Elm and Prosper have approved the Agreement by action of their respective governing bodies. 5. Prosper hereby agrees to establish and limit its ETJ boundaries, with respect to Little Elm's ETJ boundaries, as shown on Exhibit A. 6. Prosper hereby releases, relinquishes and discontinues any claim or entitlement to any ETJ area that this Agreement describes and portrays as being in Little Elm's exclusive ETJ area. 7. Prosper agrees never to attempt to extend Prosper's ETJ into any ETJ area that this Agreement describes and portrays as being in Little Elm's exclusive ETJ area without first receiving a fully executed resolution or ordinance of the governing body of Little Elm amending this Agreement to authorize such action. 8. Prosper agrees to take all necessary actions, including the release of any ETJ currently within Prosper, pursuant to Section 42.023 of the Local Government Code, to establish the common ETJ boundaries shown on Exhibit A. Prosper agrees that it will perform all such needed actions within 90 days of the date this Agreement is fully approved, with such full approval occurring when both Little Elm and Prosper have approved the Agreement by action of their respective governing bodies. Doc #490316 4 9. Notwithstanding the provisions of paragraphs 1— 8, above, Little Elm and Prosper recognize that the area shown on ExhibitA as Little Elm's ETJ north of Fishtrap Road is an area of common interest to Little Elm and Prosper and an area into which Prosper may one day desire to extend its ETJ boundaries and/or corporate limit boundaries. In recognition ofthis common interest, Little Elm agrees that it will not annex into the area shown on ExhibitA as Little Elm's ETJ north of Fishtrap Road without Prosper's consent. In further recognition of this common interest, Little Elm agrees that it will, upon request by Prosper, relinquish those portions of the area shown on Exhib&A as Little Elm's ETJ north of Fishtrap Road to Prosper to allow Prosper to extend its ETJ boundaries and/or corporate limit boundaries into the area, provided that Little Elm is satisfied that Prosper has the legal authority to accomplish such expansion into the area. 10. Little Elm and Prosper agree that the adoption of any ordinance or resolution by the municipalities or the taking of any other act necessary to accomplish the purpose of this Agreement shall be contingent, and neither shall be deemed effective nor enforceable by one municipality against the other, unless and until such time as each municipality has adopted such a resolution or ordinance or taken such other necessary acts. 11. The persons signing this Agreement on behalf of the municipalities have been duly authorized and empowered to do so. 12. This Agreement may not be assigned. It embodies the entire agreement between the parties and may not be amended except in writing. 13. In the event that one or more of the provisions contained in this Agreement for any reason shall be held to be invalid, illegal or unenforceable in any respect, such invalidity, illegality or unenforceability of this Agreement shall be construed as if such invalid, illegal or unenforceable Doc #490316 5 provision had never been contained herein, but shall not affect the remaining provisions of this Agreement, which shall remain in full force and effect. 14. Each party agrees and intends that this Agreement shall not benefit or create any right or cause of action in or on behalf of any person or entity other than the parties to this Agreement and their successors or assigns. 15. In the event of any dispute regarding this Agreement or the terms contained herein, the parties hereto agree that they shall submit such dispute to non -binding mediation. 16. This Agreement shall supersede and replace any and all prior agreements between the parties regarding the matters addressed in this Agreement to the extent of any conflict between this Agreement and any such prior agreements. EXECUTED this the •6 day of ATTEST:r " { Kathy Phillips, CMC, Town Secretary APPROVED AS TO FORM: Robert F. Brown, Town Attorney Doc #490316 6 2007. TOWN OF LITTLE ELM, TEXAS Frank Kastner, Mayor EXECUTED this the day of , 2007. ATTEST: TOWN OF PROSPER, TEXAS Matthew D. Denton, Town Secretary APPROVED AS TO FORM: Richard Abernathy, Town Attorney Doc #490316 7 Charles Niswanger, Mayor STATE OF TEXAS COUNTY OF DENTON This instrument was acknowledged before me on the ,V day of C1 0V f , 2007, by Frank Kastner, Mayor, Town of Little Elm, Texas, a Texas municipal corporation, on behalf of said municipal corporation. KATHY J. PHILLIPS !()MMiS810N EXPIRES *r. t: 0WXr 12, 2010 STATE OF TEXAS COUNTY OF COLLIN Notary Public( S to of Texas This instrument was acknowledged before me on the — day of 2007, by Charles Niswanger, Mayor, Town of Prosper, Texas, a Texas municipal corporation, on behalf of said municipal corporation. Notary Public, State of Texas Doc #490316 8 A pinl 81i d Parks & Recreation To: Mayor and Town Council From: Wade Harden, Sr. Planner CC: Mike Land, Town Manager Hulon T. Webb, Jr., P.E., Director of Development Services Re: 2007 Parks, Recreation and Open Space Master Plan Date: August 23, 2007 Agenda Item: Discussion of the 2007 Parks, Recreation and Open Space Master Plan. Description of Agenda Item: During the August 10' Town Council meeting staff received comments from the Council regarding the Parks, Recreation and Open Space Master Plan. Staff has met with Halff & Associates to begin necessary revisions regarding grammatical errors, chart discrepancies, omissions, and other minor issues. A few reoccurring topics have been noted by multiple Council Members and stakeholders in their revision notes. It is Staff's request that the Council give direction on the following items; 1. Preservation of Grain Silos 2. Platting vs. Zoning (re: Implementation of the Plan) 3. Conservation Planning 4. Creek Buffers 5. Land Reclamation 6. Downtown Overlay District (Vista Park) 7. Single Loaded Roads (60% current ordinance vs. 75% per plan recommendation) 8. Fees & Land Dedication The key to the attached document is that the specific subject matter from the plan to be discussed is identified under the title. The commentator is identified in the first column with the second column representing the area of revision causing the concern. The text in this column represents the language in the plan (BLACK as is) with BLUE print representing language to be deleted and RED to be added. The third and final column represents the actual notes from everyone regarding the specific issue to be addressed and needing consensus on. Budget Impact: There are no significant budget implications associated with the approval of this. Legal Obli ations and Review: No legal review of this request by the Town's attorney is required. Attached Documents: Revision notes on reoccurring topics, per Council Members mark-ups. Board, Committee and/or Staff Recommendation: Town staff is requesting that the Town Council review and give direction to allow staff to proceed with revisions to the Parks, Recreation and Open Space Plan as directed. Qm ww ce �- UtA wQ ce k LU W. z tD W Z� dad Ud :10 NNLO1 C 0 CL 'q CL to c as o O Y } O CL ED J; C 0 0 fa O a� F �a a co .E N Y U CL (0)(DC E� U(D � O C U c cu o QC N mooC E0E C— V N O LN o co E- o L 2.2 ca O O p U tm 3 L C:E � O cL N W Q1 � O N p (D — C O '� .0 C_ O O w O E C E M C" O E°D°�r�ooC q� E N w- = s C� O N T� p-2 3� ca ; O 2 C_ 0 C-f' �� o �•c+ o a— C L OCO 'j m O C C Q. N v X N Cca� CD O x 3 C Q. N dj 0-cn, O p p to Co N► UO O O 0 N �. 0'0 p ram3 ca N' —0-6 E m C C +' .2 fa i � " ui Q N O C O CL O C-0 Q U 0 O ri ('� N O O C N (D= N m C. �•� Y p Jn- C �, C a, C y% o C m ='� S o QC cao�CE0E C— — V N p `? N C m O_ m O p U N N CM'FA 7� C-EE2 C O 0),_' O02 N N O co C O t� C C_— N O E ca p) w ~— L O �.Ea�iN=�o�C •C (D W = .0 ,O N co o E L fl-v C. N Cy O N. V O C. = c N p)+ N O Q N ���--N'-(D C ca L � D"m M a>> o x :E3 m CL (D ai C31.� N O N y L 0 O O D N O 'p YO 'w O O C 0N C L, , m C N o N ca QI f�6 N L C O C- O J- '2 CLU O N 'y C6 3 C L C CL C a, C m C C M C r sr- 0 c ` a1 O O E 2 m -v :3 a j Q f (A O ❑ O ❑ ca ❑ 1 04 1 ce) 11 ru c w Ln c o � m CL -u h p, N (1)` {V r� N Z ¢ w o c` C9 0 _ E e Q .�. r 0 � � w ` ai M or 'o W LU o o m F— Z � N car (6 a' O 0 cu 0 N c .S EO E CD 6 N Q] �' N 2 N fo . t {4 -- GL, � 4? M O N O _N O ps 0 O N .O i U 0)0 O CoN 7 Q O � O N o O c aw m 0 C "= E N N U N C D O O 'y N f0 C N N �' ._ L-tO N C (n rq C ) N O 7,N EU ~ QN O� V) ram` Q N lye (0 d L V 0 O❑ C_ O C3 5 % Cf V) �. N. O N N m w'M Z p •j N O M .Q Q N i- `� v c i tif#- N C m N i C F, C O i LU N >� a) CD ca U �d m —0. w Qm o jL � O N M X 3 O O_ N aj O aC. 0 � N 0 � ?�• CA 0 0—- � 'N C O 3 (D U jv 0 O � r 3 i Q> .0-3� C N O rnN O n Qv O �O a- p N N N N O U O D {] p O N O _ o �, c �� m o m rn3 a' a aD 2 0 O N O N +3� a 41 N (a Q NMj jK s EmF- o Q7 aE u, w CLo w e Lr' > N O C CD o � wAn 75 0 o E e V Y � o m a co A � v u� cD ti O O N Z N Q to Z {� o J CL a h- Qce. W W fY F— U tA LU W Y CL f. Z W Q IL N LMMMJ r I H3dSO id d0 NMGi y C 61, Q} -C Si j r-- .5 4) i!] :5' a) C1 C 02 0 cs mom' � ar o Cn `o L 0 6 o � 3 in m x � -C o m ° a`0i iD ° as U c` � 7 O CL 4 . Z 40 o�ttm�r, o oCL 't,=_ tc+S L O E E C V Y W M "" 43 I � � �RCL E I 0 0) }y CL to Fl C U , M C' p N ate. ~ x Z G) p Nr .. 15' aF- 0_ o cn cm N -0 CLD�3t W W, ��- Z U� W Q ix ui U ; IL z ,- LL y, y � : W /' 1 1 4 M. Ii y 4L1 tA fr C_M I rY/ I aid OHd r� .10 Nkl Z I Z L 'L ram+ � c E Q E CD C � N 0 0 Q N - z N N z �0� at—CL Q o ww ce. F- U v w CLu Z O LU UY LU 0 fl 'i aad'S ld :10 NMOi t i rr {qj CL 0 - r CN M p � as P Q 4 {] H E 0 Cq CL CL 0 U� o U o 0 L C CL MM0 0 a. N 0 - � N w C O ;= O Q) o y U U�p U O O O C N U " U (tlCL U CL- 75 p (0 ) L '� U C O C 2 V c c6 C cu Q} 02 3 O f0 U) N D c 0 L a O O -D w C M CAA r= 3 CO C O N 01 OEL O N a co C c o c (D 3 (D c CL m0 E- t� Y (O �w U� 7 O O r,- o� U O 'O C ram+ R3 cn a) O 7 0) CZ O p -E O E0 [� Y �m U a) °� -a ouE)m E � E 0 E = U ca Ec Q CO ca) m Co L c ca c O 0 O- O rn Y E "� `) v) O � (n N 7 E r 0 a) O] O C O 'E — N O L G1 O_ (, O C U LO = f0 O' IY O ca 044) :1:- N y C N y N E O O 2 0 2 E 0 N Y_ N Y U O en 0 nL CL m 0 E iC 0. 2 CL 0 47 0 a) 7 N m 7 c (D N ate) U E f0 Q L W 0 3 � C = -0 � z� Q O 7 3 a) ` U ❑ w �r_ o m f� U (m O ? Q. CL N 0 Qa `0 c 0 a)oc w 3 �. 4) E v E U Q cOi 75 N I N N O O 0 TJi Q m 4 W W oc F Lu O CL LA N z UJ r O NJ 0: a3doad JO NMO1 Gp ai o KD N c � — N Q O❑ o 7 p a]L G L _ w b G m 7 O O <3 Q1 Q} (D o} [4 LD �CD a o v c { c °' - C. r CL M u _b O r ur ayl o L N e - a� F- Emu Q V N N fn N.� N CL M dCLM KE O w I V C C o 0 ., M0-0L U C m � .-. C C fq w *. QI C m C y Q i O 7 �n N } E7 c,} .� coa m N� E d) �` Q �'m vi EMwa"�o CL o- ¢� c ma 3 -0 C o b C 3 _oEcar_ O p O N S� cp � 4 C to O 3 L N y U (} O ua 0 E rn v � c o �,� 0 m m V a N m L a CD m r, W U7 } m F C to C m o 7 L y O p O 41 W C Q .0_ m m •C 4 mJ�dd Q {1'i � c(D O W- maa)0co� C C U N-J _ — Q; d ? sA m += N 0 O C C L O m � C m -0OC3 C O �cv� � p C� OTC M FL a}c Qi DN C.) O C=NMO C C,C M . Q Q- E 0 Q () Q O U n 4> m O N O U N CN N 0- O lla) (D C) to V 10 4) s 'C ch N i 3 ch y y y y 3 E 2 2 2 2 2 m 2 CD m C 0) 4. OD0) 7 ` q} ) OL C .� � ro C 0 ru p C V , � •� C � {]1 QJ � � � O_ C r- L �} 7 N �.. Z m ,u w E m 3 cn Z a, `°' a° 0 cru aE- LL C' M ww - 0 rD�0)�V"a, w0 �+�0)a- F- Z c—i'r0 u L � rJ z V v) Lu < v1 w C CL N z Loll o f, 0 LU Q CL W ' O_ :10 N AA O I z L y0+ c E d O N O O 0 N �z N �nZZ O :3 CL M W W Ln lx %� LU V! u CL CL f OLLJ C:) CL rq O u3dsc J0 N IV Hd 101 Ya: c E E I Cc cx N ur p .-R CL u cr If i rC m o W Qs ° E o CLyr p E 8 E W v, N qj L7I O d C C rr O N O N O L O N C ;_ 'o m O N U C O- N � � x Y CL0)(if 7, O C OQ { t 0? N m U U O m V1 - @ a) CLO 0 k) CLry fG in 0c� Q M 4? y O Q y 4 C O � U U Ui QL O 0 O C N C C .N �N U a NNaO U E-O Oa E o Er° �7 L N_U o O w(D O N "O O N "OUN-0 U Q L ° o{, O 3 O C B O O N fC N 3,-0--� �y N r+ i T C 0 !� 7 N ,� 70 w U fC (A•� QI 01 S O Ln O CL fw N. O O OT O N �D —� 0 L C N N n ,� O 4 y Q O rq O j .0 O N N M C N •fA C N O p 3 ai E ] -0 7 7 O O C O 7 O U C 0 O U fa q) N E O '� L O y N 7 :� I� a) < o L VJ U% p rr aL '0 L 0-070 0 ° E p C � ° ML+r� Q-0 O CDp T O N C iti � Q.N _U - Y W (D � w(n a-Q O N O 0-0 O O U D C O am- L C O :5 N E m G 0(D N p CL E p E a- N O C U f-06 N E0oNn0� 0-0 U 0 -0 U O C L Q) O � O N CO "^ to 0-0 o (D Q U .� 7 U N O p N M 0- N t � N y O c N C p tq 4--0 N 3 t O y a> C C O t O m C O N ,0 O .0 4- 0 9 U U �Y v ME Q= 'L ,L Q �� V -0 cy ° o C aD 3 O E 2 S 2� ( Y_ 7 T N / ul ❑ Q: I ❑ ❑ 2 r N I -) I v I LO p L7 E cR U) v] CO 0 0 M N � c U) ° °'. CDOJ - .CL m �- Q ' Q H (D 3: mc- W W ZCD F— cu o �� m �- aD .N 3 L m m -0 CD c 2 E L 3 s .2 a 3 Q £� L CD (D -0 } a) O fA " N .- O r y x p O O >' N N O O 0 N y N .0V O O L 7 NQ m N �� E CL m cu _ C L N O a) a1 N CL VI�_U f/f N 0 .N Z _ N m 6 = Q m D N O a) _� W �, C (D 0m C C O N O N QOj "d "a O N UJ th'. L I1 7 0 N Y m V "O O a) � :a a) ` � a3 N A � N a) -0 3 O LLI N "" O U m m `'- m E U a1 O N m p w 4? o 0 0 rpm N c -p C rn O N N O N 'p N O N } a) 0 .L3 y L �CO N � OQE C a N � UO QG NONL v r N -E E a� ad o CDmo 0- N Lo 0 0= w 0 IV JO iwll oG Q E-0 c.E v 000 U aoo C L m v N rmn 3 um, U)i i = to 3 = E 2 2 2 m im QJ a) 3 cm ( ❑ ❑ ❑ ❑ c+7 T � T LL7 T CO T I� T :► O N Z N M Lyl LU u_ h- LV Ln Lu M u LIZ OL N Z C) LU O N , O l CL 0ci LLI i 1 a3dad JO NMO.1 EMEMd .. 0 Q1 {h CO ~ [O} M [ O - U} ... � a O C3 -C3 ' 0 u 3c -F S 02 E O Ko CS ir7 CL :.mv_ry c C j N 4 Z7 t4 4— O $ CD Mgr `r o uui U c M t M — La-n�tcCn-19joMZt o' o� 'L i� 1 Q O N f0 � w � C N a 3 a� as a)a N O p O O O U ("gyp D O Q) ,S E > w Z= CL C CD 0,0 p C O CD 0 O tell 0 O ° E g ❑ E c O o 0o w T T O r� ti 0 o p N Z - N cn Z �— °' a t— W W U L,l;,! ac LU 3 CL Q N. Z 0 LLJ td , La! N O M .3! LMMMJ 8 3 d S'O ad Jo Nm 1 MIO .. c CD L O E O 0 o � cl•° QL°CL _ 0 O L CL O is! ,n E C x fA R F n E b} eh F L L 0 � c Q} {A w L c ++. M 2 Q0 0 CL 0; > c ,vr EftL nL,2co F 0 -.EjE-5� ' a Lod, c V1 n o O , ° ' co o C G c {L1 CU 0 (a c m O L c �. O � f4 CD L +- w c C Q Q O C� (6 O r% C O O N d m E 0 m m O O c N 'u -O f6 CD U -p V r -B E N M -0 Q} O o: m� � o � o iF — a� 5 r r tOA m 'N O •g m a)0-0 C c a) 3 } CD m ca .r o °c �. o W -0 a v C V -0 "a 3 c N c O O N Y O U o c N L N L N 6 0 m O c CD (] c O O m U m U O co com N M -0U O ca W' CD+' — N N 0.0 O 0 to 0 O p O M "d 3 N L O c c M cat ca a CD `- m O Q QN.y N C'¢ c .LO -0 0O E ro O CL �k O > O d; N'- (n O T3 U c 3 0 c >@ U CO] O E cll ' QI O .- An L c :3 y , < — O O 7 N j N 3 C� C � fa �_ O O O c O ti O 00 -z N vi Z 0O..j -- CL a I— Qm W W V Lu y W •i/s CLwl N C C� W W. �. C3 CL >,,�� W �# O LMMMJ i r aid OMd Jo N of L ' �y}r L 0 , ♦+ 6 s Q O ;e tl v, aoEE C-10w ❑ 04C4vJO o, E� p, qua o mrVra�o� m E f:: fA E 4D o , 'w cL 0. � j {� m , �. C Vi � Qf-- m ow A co �� dm y 2. CDo cam o o=o>a Z z Q ° ° cw o co U O O (6 — L f6 co ca 2.0 7, O C Q CD T a) Q 3 > a) o �c Q O 0 0 o -0 o c m L O i6 L U O 3 = O N N m N O U U .y 3 N M U (D m a)`J 'a O U i a, Q -0ow z z F N 7 E 2 o V o Y ?.L�1 h O 0 N ' Z F� z N z Q �0-1 O — CL a F- Ill W _ UV l ujui ; ti 4s} Nd n < '; D- , .. CL fal N Z 0 CL FJ 0 MW li 83d OUd :1c0 NAAOI N. _ U} Z 0 {}1 axcn' 0 over; v ai c fii 4� o m O C O C w O W t =_ C •� O 'a ..�..+ O i :? C is C =--Co 3c2�a �0 u, -- o � � a 0 .r mc`�vmro -c m 3 ca ar N p O o N O o ID o - m 3 C O' n 3 f0 U Q ar C 3 N w •N 01 -0 3 C O f6 .N C �, o Q tm O p O LA - C Nv° E0o �a�_��0 �O E' C C N� C T 7'- t3 �O .LO t Y i0 0. Q ��� o c N c�� 3 N Ca -0 (6 ca � p C .6 E 03 C p a5 UvN C O O Q•- (D y O w Ur N •N ca N O 3 En C ,� N oL>a o—N cam C N �-. 3� V-0o C 3aD3 7+ C f4 O U 7 CD "6 N— U �O p Q0 y0 C 0 (D3m a Y0w. >,.` (DM0 � cc�• �-= o Qom¢ O co..—CDm v N�� @ m o ©��.�'3� N 3� C---0 ca0 3`m 3 Q--r mmc—rn i i o.O °oc m —u N O p +m.0� N p (� a d N �. Q j W C q, ar N U} a) a) Q) > N ar o N O d 3 C U Q� a 0 E U � m c w�� O c _ O c arm Co c° 3 E 3 mo rn o a) �,Ca 3ai 33aU)at° � 3-0)ayimo o `y o c6 —_ 0 0 0 0 0 �. Q O C ca ai . y O C C C �a) 3�3: a,2 �- (p ���cc� uJ c0'coi v F- N a � H H .� 3 H a w f6 O co rn ca F as 2 2 E E C0 © o° a �- N M n 0 o ❑ N Z Q N N Z mo-1 -- CL a F- <� LULU CLOH uv) Lu w w V CL QLv/ ,,^^ Z LLB CL > N i� uj U3d OMd :10 N M O I c E Ali 1 k c �y o. CL >0 CD 0 CD z13-1 v c N CDa- 3 3 (D m a L O (D CD dl? a 0 O U ) N d) o i (D •� G y 0 rn 0 C -a o cc a� c0 'aa CD -0 (D CL9 m a) �� arc G L 3 L N^^ O CL �(D �o 0 -Eo -a2 aso ❑ '�.. :3 cU 7 o +cn `3 3 (DO G O N 0, c� 9, 4 i N O .0 V L O O d N c 3 ca � L •—m te a, (mM O G a) a) a) .a c) 0 3 G io O O p N 7 L N U a3 0 a� w � 3 E rn m O •- f6 (6 �r �n cfl 0 LLF o CL r-4 f aid -0Hd 30 N Oi Q)CL saw CO Q 0 vi c }{ C 1 m c �} V {d O CD 0 m c CO O ur uvs + off 0 . m a 4n O a1fn LIDa L 4-6 mm caoy Q U-0 3 •' 0 c Co 7 N 7 O O p N p m p 0-0 'I m c00 �� c w O v `o '� Qcl(D 3 'c6 '` p u7 O 3 J Q R. p ai m ca c 2� w C-0 0 7 0 •6 U N U� E ; p M C U 1 oCYOC,c ca m wcvca J a@i CD ci in 'a� .X 3 wc— _ � (D CL C ai m . NU C C CA'fi C E a N m U 0 fq•`i CD CD CDO (a E d U m_ C CO D p 0 0 (s p 0 a U a) C O C U ` N `~ r� C fU L N m C Cri Y E N O '� N -6 C } a°�mrnaafc3 U3c (D °per rn c ' Y> >-0 0, 0 L _`p fn N U Qi (D N m co c�-0,00 ado tCa a�no C. Co L QI C M C N LL ` y.+ p �, C -0 CD C Co (D O L Q) j ` c0 p C O iU N 0 4- 030 (D-0o c`aopQ -0OL ` C +r .y 3 Se n �� CD �� m Q C° N v, �a.0m-� U.G° w'u,� s oc� 3 ¢ 3 3 3 E E 7 01 3 o� o o a°� 1 04 1 cr1 I CL , ❑ g C} {4 f4 O QD F- -r._. m'7 0 �} CL 4 N i P ❑ r A 0� + C> vO 0 } CD > 0 Z -, as Ms _ m 0 r o� ~ N �Z Q d [ T C dS ink E ojo Z5 C ._J ass c p,.:. coo-=gym - m an r CD o mac; o a to M zgo BCD ooco CD c� c� m�(L) 's 0mo 5 E �D cu � N 0 -he ouro Z $° Hai CD C C N U 0 : O au CL E Y N Co LU � 04— f W O:Oct. -c c o ( + Co f 0 Ya O LO C a CD {4 E o E (`U .0 o r- :3 °NE •E Q`:3 L 'C � O +n U) 3 E Q E Y_ c_ 10 10 ti O op N Z N vs Z �o� Q� WW [m V Lu LU CL f!i � Z r � O aid OHd :1Q N M 1 C� fh yOy o CC s .. x as a �a a o {# CLc 0 2 z5 4 0� j Z •--• N C1 .0 Q} C "- � TI _ O +n O O O O +A 3 O _ E E N O. Z ° @ Cl 0? N N 42 42 E_ �_ t m m rn rn rn ao o ... c o c 0 c 0 3 ro ca wo m m m C m C O co s c w s ' N cLa o o qCL QI p N o N CA (A N to fn N O CL O a. O 4D r L d 0 2 N f6 Co = Q Ql f6 r N (0 >+ >1 7.0` co CL 0 O +�'' O 7 7 CL N 1� N D " 0- CL CLfn [6 (0 N � N iC N 1� ki wi Q c Y O n N N N O ((A Y 0 N C L c L L O O N p E N E N CL C) CL U O,. U } O �' O 7 C {nI [p _ c m N CU� c m y M M Co 0)w p p O O C L ` (A L c o o �� �� cr - a 0 .� � f, a v a O O d O p p O E 2 m =1 , V 0 0 r N Co 'o CO O O ❑ N . Z N U)Z¢ (3o-1 ~ CL Q w W , l.j Mb: vi w < CL Ri �y CL Ln N Z ..� Ul EL W Uls H3 d O d dO NOl 21 O rrr c o r,� � o o � c ti CD fn O O' C cs � c G) '0 V ,,, O O 4 r W ti = O M � E O {�4 co w CD4 :3 _ !�L�[ > MMc CL Cyo �rnc '� CL ��CsE _ c CDs' 76 KD M. a O rz 'O O� m O Gk 0 c O O {4 9k {+1 W O Vi o E C J C� "-' f O- CL O M 'a c :s U X c O� Q O N N m E a o o C7 O ro N O O OQL 0 E c p O Q O Q O, CL 0 O t6 C N `n V -.;S as :3 o � 5 r o c aj o c a' L y N-j- c a a 0 co O •0 r� •0 a N i r N Q_ O O i� N N O N C N M �Q O D b Q N C= 0)ao c ,¢ N o 00 N � a �o Q ° ° N Q E N N N(D O W•ul dp Y + 7s r CL O Y .0a 0 d N N r lC 7 O z OcL CL V U Q N Q_ ° O Ul Q_ cn " O N Q_ i) .0 M O w m co N � Co � � E (D 0 ,un m cb U N'0 l0 fly �O�- U) m N �' 0 Q. — 0 Q. fY�6 +-� c 00 I'd(q Q C" Q r :� C j N U1 O N t4 O C O +� to a N N (Q L -0w EZ �A` °R' a a O a�i O o i U) 3 rna) Y M- (Dr° + ��� N�om c t r El �0� ca c m 3 O a� 4= 3 ° o ow3 �°� �' raj coOc7 o"-a) o ca o N.° 0 Y Cp N M O N�� �_ q�j It � 12 N o c�M:3 • °t ��cUna10 O _C W Q Q. Q. L C "_' L O "-' c 0 C� c 0 U O w O o LL ) .° LL n 0 O E T a O 75 7 cn � 7 0) CD Y_ CD T C* h O O N Z N Z I-- =� c5O ~LML a F- Q� ww m F- U 'o') uj Ce U 0- CL N z .O 0 Lu Nd.. C:, N a O W M d3dSOdd :10 N MOO s�0. CD m 0 mom, a) U oAff E•� O 0 ' o m 17- 0 , CL M m y--+ L {1'} {% C 0 . CL 0 � Fes. r-�# °8 CD z 0)CL E 0UnCl Q r_ o C: Y N 'o 43 w' N U_ U 7 i N tC6 U {} � .0 O C {] "� aka NN( C Y fly m 3 '3 a) = 2 CL R1 L °_ o�� °° 0YmO0000 amC -0 �c6 3 o-a Goo �*'�m mi-a3o°�°mom w -� Z-0 N m p O (D N 2.0N- 8} C '8 U o c O— a)-o a C6 C + LA C C C C m} -C Q OCL U M C N o U 0 a O Q O '� �`�3o c o�+ht}a3 m E� CD y c w �vm�O M �>mo•°U` 0 N N N E 2 23: 0 C7 3 Q1 Y CD N :3 �[ U o o°� T T (�{ r CM T rn Nr w w� aFi x ch Eb 0 N o qt �codr F Z rLLn m � } L� 4, ¢� W W Z 3c ri) 0 P Z a) � A N p 0 � V W Q �, L Q D) w U) y E °3E C C,o c� 30 l o 03 c M' wl CD0 a T 7+ .o .N w o .S , N N O LLI .N E E -E- Q av E L V) ( a v IC c 5- L 0 U F O C ► c_:3 OE t, QD O U (VCL Cl o Ea) oo* o�d) � Q- 0C:) Lo c E CO Z NO -0O LLB= � vOi �'L _p0 �'N* O ! mT o c E aD— "` y N QO O C 'p N C (CL N ❑�L ' Q �1 N` ° L6 d o o aEicac ca m o 'c LLB c 0) rn CD CD cm •ro W.0 N N cv (D a[ 75t O a L Y a. caCl) U) 'o {n 3 O O a��� a m Y +N+ U a 3 co ,� L U fU 7, C O (D U) m a 7 o _p E O UU) U ,C ,G C Had OHd j m o 4M C .` v �,CN LL a)N_ �� N w Q r- J NMOi cnwm T .- ��,ocn � ¢0 LL.''n O Z EC 0) /� ^CD T T O N OJ � ih L I LL C'tl t� L E 43 [ p CL U N Q Q {ypE ,X 00 Z 4) - Cco E W is N UL as m g cr +- Z � � OQ1 ? = 0 0 cy o Q J - +� E'` � r s -- CL �03 c o 611 a�-M CLX C co Q CO -r- CD M, W W +' mom. v CGa E� F— Z a U7 z m ri W 0 u U '4 . -0-0-0 Q p C N N_ 0 Y N (D U � O d Cn -a(D O ul Co N c m ro v} O 'a, Q 7 D— CL0 fn. U Q(i •� N CL7. Q O Ln C d z O m M Ql 2- C+ CL U� Q "0 v Y C v 0 -0 � O C q0,} Gi 0} LLJ C} ovate �o Eo w m M / C C C 7 u U R. i, CL >%�+i j Y 7 '� C " N 0} E # OC L Q�3v,� CL -0 CD Ec.� 3 a O �� O H C o '� "a Y m dl 2 .r. 'O CO O <D a) N M .0 � CL7 0 E c O C U C N m o o r-cu U N ?+ @ C A to In 'T O f fA •� N o cu "c� N" e Q •- +O a)C N� o ter a0 0 N � U aid OHd L O C U U� 'D E d +, d NMOi a' �z.0 oz'3 s 6i �-aCo O O y y C cn w Q1 E 2 2 :3 a) CY f 01 Y :3 o ca ti co N N Z N to Z Ito0 J �-- a H o" W W LL F- lJ Lij ui CL Z C 0 O W N C, r O oc LMMMJ Had OMd { :10 Nmol 0 m E E O o rr� O C C CL } 79 w — asp � of 2'N-o� o2 Tu 46 O� a0 x M W Q fu 65 N N ti 0 N Z N N Z (0O� 0 — CL a F. <ex W W u r! Lu Ne itl IL W Z Z .0 it f WE C) L W r'i f o% i n aAdHd i :10 N Oi .. {a N i0 Q Q r D !U lu -Q M 7 f. f; 3 o C C 07 `p ' E E C qy 02) 0 0 Q E M E i a ca> Ida a a ,a, ZI 0 dos 'C W M Q o Q .. a) Q M M c (ia 4) wf� 6 C CL0- (0 �' � 0 � Q C co O U O p Ill a a O (Do L T a)L Co s3 Q_ E mom' oC cy T >+ C _ �} M)'0O N .0 O (.) 1O. F ' O -� } cn U OO rj} (0 (D ,LD N 0-0L CoCL fl1 Q c N o Q �}Co N .D Ca 0� O Its 3 a rn r M C La V- Od V C Co0 O COfn E in O O NM U C N O c � s a a) Q 'D ^ N ca O fA Q (C '� O _ € L O O CD C L Id mo N c� = E 0° rn N N 7i O "O 0 0 O U C N rn CD ME � E �H -V a m x L 3 FO 0) ti N a) '' - GCS o L M OO ro U ❑ (0 (0 L 'w r C} Q U w P O O O N N (OA CA f3jy co fah) M3: 3: 2 2 3: 2 2 CF) (D a)0)CY) (D CF) 0) 3 Y 3 3 Y 3 3 (O ti co 0) 0 T T T N T M N