Loading...
10.22.2013 Town Council PacketPage 1 of 3 ] Prosper is a place where everyone matters. 1. Call to Order/Roll Call. 2. Invocation, Pledge of Allegiance and Pledge to the Texas Flag. 3. Announcements of upcoming events. 4. CONSENT AGENDA: (Items placed on the Consent Agenda are considered routine in nature and non- controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda by the request of Council Members or staff.) 4a. Consider and act upon minutes from the following Town Council meeting. (RB)  Regular Meeting – October 8, 2013 4b. Consider and act upon whether to direct staff to submit a written notice of appeal on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on any site plan or preliminary site plan. (CC) 4c. Consider and act upon canceling the November 26, 2013, and the December 24, 2013, Prosper Town Council meetings. (RB) 4d. Receive the August 2013 Financial Report. (KA) 5. CITIZEN 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 “Speaker Request Form” and present it to the Town Secretary prior to the meeting.) 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 item will be recognized on a case-by-case basis, at the discretion of the Mayor and Town Council.) AGENDA Meeting of the Prosper Town Council Prosper Municipal Chambers 108 W. Broadway, Prosper, Texas Tuesday, October 22, 2013 6:00 p.m. Page 2 of 3 DEPARTMENT ITEMS: 6. Consider and act upon an ordinance approving a negotiated resolution between the Atmos Cities Steering Committee and Atmos Energy Corporation, Mid-Tex Division, regarding the Company’s 2013 annual rate review mechanism filing in all cities exercising original jurisdiction. (KA) 7. Consider and act upon a resolution accepting and approving the 2013 Tax Roll. (KA) 8. Consider and act upon a resolution updating the Town authorized signers list. (KA) 9. Update from the Upper Trinity Regional Water District (UTRWD) on the design and construction of the Doe Branch Regional Wastewater Treatment Plant. (HW) 10. Consider and act upon an ordinance amending Section 1 and Section 7 of the Comprehensive Parks Ordinance of the Town of Prosper, Texas, establishing the Prosper Youth Sports Commission. (WM) 11. Discussion on Park Development & Open Space Opportunities. (HW) 12. Update on the design of Cockrell Park. (PN) 13. EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: 13a. Section 551.087. To discuss and consider economic development incentives. 13b. Section 551.072. To discuss and consider purchase, exchange, lease or value of real property for municipal purposes and all matters incident and related thereto. 13c. Section 551.074 To discuss and review the Town Manager’s performance evaluation. 13d. Section 551.071. Consultation with Town Attorney regarding legal issues associated with proposed extraterritorial jurisdiction release, and all matters incident and related thereto. 14. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. 15. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting.  Roadway lighting standards and policy discussion. (HW)  Downtown development standards and incentives. (CC) 16. Adjourn. Page 3 of 3 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, 121 W. Broadway Street, Prosper, Texas, a place convenient and readily accessible to the general public at all times, and said Notice was posted on the following date and time: On October 18, 2013, at 5:00 p.m. and remained so posted at least 72 hours before said meeting was convened. ________________________________________ ____________________ Robyn Battle, Town Secretary Date Noticed Removed If during the course of the meeting covered by this Notice, the Town Council should determine that a closed or executive meeting or session of the Town Council or a consultation with the attorney/special counsel for the Town should be held or is required, then such closed or executive meeting or session or consultation with the attorney/special counsel as authorized by the Texas Open Meetings Act, Texas Government Code, §551.001, et seq., will be held by the Town Council at the date, hour and place given in this Notice or as soon after the commencement of the meeting covered by this Notice as the Town Council may conveniently meet in such closed or executive meeting or session or consult with the attorney/special counsel for the Town concerning any and all subjects and for any and all purposes permitted by the Act, including, but not limited to, the following sections and purposes: Texas Government Code: §551.071 - Consultation with the attorney/special counsel for the Town. §551.072 - Discussion regarding the purchase, exchange, lease or value of real property. §551.074 - Discussion regarding personnel matters. NOTICE Pursuant to Town of Prosper Ordinance Number 07-04, all speakers other than Town of Prosper Staff are limited to three (3) minutes per person, per item, which may be extended for an additional two (2) minutes with approval of a majority vote of the Town Council. 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) 569-1011. BRAILLE IS NOT AVAILABLE. Page 1 of 5 ] Prosper is a place where everyone matters. 1. Call to Order/Roll Call. The meeting was called to order at 6:04 p.m. Council Members Present: Mayor Ray Smith Mayor Pro Tem Meigs Miller Deputy Mayor Pro Tem Kenneth Dugger Council Member Michael Korbuly (arrived at 6:06 p.m.) Council Member Curry Vogelsang Council Member Danny Wilson Council Member Jason Dixon Staff Members Present: Harlan Jefferson, Town Manager Robyn Battle, Town Secretary Terrence Welch, Town Attorney Hulon T. Webb, Jr., Executive Director of Development and Community Services Chris Copple, Director of Development Services Kent Austin, Finance Director Kirk McFarlin, Police Chief Gary McHone, Assistant Police Chief Baby Raley, Human Resources Director 2. Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Pastor Ed Upton of Prestonwood Baptist Church led the invocation. The Pledge of Allegiance and the Pledge to the Texas Flag were recited. 3. Announcements of upcoming events. Deputy Mayor Pro Tem Miller made the following announcements: The Cory Ausenbaugh Memorial 5k and 1-Mile Fun Run will be held on Saturday, October 12, at Frontier Park. Registration begins at 8:00 a.m. Proceeds will benefit the Cory Ausenbaugh Memorial Scholarship Foundation for a deserving Prosper High School Senior who is pursuing a degree in education. Contact Assistant Fire Chief Stuart Blasingame for more information. The Town will present a composting seminar in conjunction with the Texas A&M Agri- Life program on Monday, October 14, starting at 6:30 p.m. at the Prosper Community Library. The composting seminar teaches participants about the different types and methods of composting, and how composting can improve soil conditions and decrease water consumption for landscaping. MINUTES Regular Meeting of the Prosper Town Council Prosper Municipal Chambers 108 W. Broadway, Prosper, Texas Tuesday, October 8, 2013 Item 4a Page 2 of 5 The Prosper Chamber of Commerce will hold its annual banquet on Tuesday, October 15, from 6:30-8:30 p.m. at Gentle Creek Golf Club. Collin County Commissioner Matt Shaheen is the guest speaker, and an awards ceremony honoring outstanding Chamber members will be held at the end of the evening. Tickets are available online at www.prosperchamber.org The community is invited to join the fun at Prosper’s Homecoming Parade, to be held on Wednesday, October 16, starting at 5:30 p.m. Come see a variety of floats and participants from community and school groups at one of Prosper’s biggest Fall events. 4. Presentations.  Proclamation presented to members of the Prosper Police Department declaring October 23-31, 2013, as Red Ribbon Week. Mayor Smith presented a Proclamation to Police Chief Kirk McFarlin, Assistant Police Chief Gary McHone, and Officer Goodman from the Prosper Independent School District Police Department proclaiming October 23-31, 2013, as Red Ribbon Week.  Presentation of Certificates of Appreciation to former members of the Town’s Boards and Commissions. Mayor Smith presented Certificates of Appreciation to the following former Town of Prosper Board and Commission members: Chris Keith – Planning & Zoning Commission Chuck Stuber – Parks & Recreation Board Bryan Dennis – Board of Adjustment/Construction Board of Appeals Hope Malone – Parks & Recreation Board 5. CONSENT AGENDA: (Items placed on the Consent Agenda are considered routine in nature and non- controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda by the request of Council Members or staff.) 5a. Consider and act upon minutes from the following Town Council meeting. (RB)  Work Session – September 24, 2013  Regular Meeting – September 24, 2013 5b. Consider and act upon whether to direct staff to submit a written notice of appeal on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on any site plan or preliminary site plan. (CC) 5c. Consider and act upon authorizing the Town Manager to execute a Service Agreement between DFW Communications, Inc., and the Town of Prosper, Item 4a Page 3 of 5 Texas, related to the service of Motorola communications equipment for the Town. (JC) 5d. Receive the July 2013 Financial Report. (KA) Council Member Wilson made a motion and Council Member Vogelsang seconded the motion to approve all items on the Consent Agenda. The motion was approved by a vote of 7-0. 6. CITIZEN 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 “Speaker Request Form” and present it to the Town Secretary prior to the meeting.) There were no Citizen Comments. 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 item will be recognized on a case-by-case basis, at the discretion of the Mayor and Town Council.) DEPARTMENT ITEMS: 7. Consider and act upon authorizing the Town Manager to execute a Lease Agreement between Modular Space Corporation, and the Town of Prosper, Texas, related to the lease of a temporary modular building. (JC) Kent Austin, Finance Director, presented this item before the Town Council. The Town of Prosper has experienced significant growth in Town staff during the last two years. The Town Manager, Town Secretary, and Executive Assistant/Deputy Town Secretary are currently housed in the Prosper Economic Development Corporation offices, and Town Hall is at capacity, with no room available to accommodate additional staff. After exploring alternative solutions, staff recommends that the Town Council approve the proposal from Modular Space Corporation for the lease of a modular building to be located in the vacant lot behind Town Hall. The Town Manager, Town Secretary, and Executive Assistant/Deputy Town Secretary will relocate to Town Hall, and staff members currently in Town Hall will be relocated to the temporary modular building. After discussion, Mayor Pro Tem Miller made a motion and Deputy Mayor Pro Tem Dugger seconded the motion to authorize the Town Manager to execute a Lease Agreement with Modular Space Corporation, for the lease of a temporary modular building. The motion was approved by a vote of 7-0. 8. Consider and act upon setting a fee for Prosper Lacrosse’s use of Frontier Park to conduct a league play date on Sunday, October 20, 2013. (HW) Item 4a Page 4 of 5 This item was withdrawn by Prosper Lacrosse and no action was taken. Mayor Smith skipped to Item 10. 10. EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: 10a. Section 551.087. To discuss and consider economic development incentives. 10b. Section 551.072. To discuss and consider purchase, exchange, lease or value of real property for municipal purposes and all matters incident and related thereto. 10c. Section 551.074. To discuss appointments to the Board of Adjustment/ Construction Board of Appeals, Library Board, Parks and Recreation Board, Planning and Zoning Commission, and Prosper Economic Development Corporation. 10d. Section 551.074 To discuss and review the Town Manager’s performance evaluation. 10e. Section 551.071. Consultation with Town Attorney regarding legal issues associated with proposed extraterritorial jurisdiction release, and all matters incident and related thereto. The Town Council recessed into Executive Session at 6:30 p.m. 11. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. The Regular Session was reconvened at 8:07 p.m. No action was taken as a result of Executive Session. 9. Consider and act upon appointments to fill expiring terms and vacancies on the following Boards and Commissions: Board of Adjustment/Construction Board of Appeals, Library Board, Parks and Recreation Board, Planning and Zoning Commission, and Prosper Economic Development Corporation. (RB) Mayor Pro Tem Miller made a motion and Deputy Mayor Pro Tem Dugger seconded the motion to appoint the following individuals to fill expiring terms and vacancies on the following Town Boards and Commissions: Planning & Zoning Commission Place 5 – Chris Keith Board of Adjustment/Construction Board of Appeals Place 1 (Alternate) – Kevin Drown Item 4a Page 5 of 5 The motion was approved by a vote of 7-0. 12. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting.  Cancel the November 26, 2013, Town Council meeting  Discuss street lighting on Coit Road  Discuss the Zoning Ordinance regarding Downtown Office  Set the date for the Strategic Planning Work Session in January 2014  Cancel the December 24, 2013, Town Council meeting Mayor Smith reopened Item 9. 9. Consider and act upon appointments to fill expiring terms and vacancies on the following Boards and Commissions: Board of Adjustment/Construction Board of Appeals, Library Board, Parks and Recreation Board, Planning and Zoning Commission, and Prosper Economic Development Corporation. (RB) Mayor Pro Tem Miller made a motion and Deputy Mayor Pro Tem Dugger seconded the motion to appoint the following individuals to fill expiring terms and vacancies on the following Town Boards and Commissions: Library Board Place 1 – Lucy Towle The motion was approved by a vote of 7-0. 13. Adjourn. Deputy Mayor Pro Tem Dugger made a motion and Mayor Pro Tem Miller seconded the motion to adjourn the meeting at 8:26 p.m., on Tuesday, October 8, 2013. The motion was approved by a vote of 6-1. These minutes approved on the 22nd day of October, 2013. APPROVED: Ray Smith, Mayor ATTEST: Robyn Battle, Town Secretary Item 4a To: Mayor and Town Council From: Chris Copple, AICP, Director of Development Services Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon whether to direct staff to submit a written notice of appeal on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on any site plan or preliminary site plan. Description of Agenda Item: Attached are the site plans and/or preliminary site plans acted on by the Planning & Zoning Commission at their October 15, 2013 meeting. Per the Town’s Zoning Ordinance, the Town Council has the ability to direct staff to submit a written notice of appeal on behalf of the Town Council to the Development Services Department for any site plan or preliminary site plan acted on by the Planning & Zoning Commission. Attached Documents: 1. Preliminary site plan for Stone Creek Commercial 2. Site plan for Stone Creek Commercial, Block C, Lot 3R and 3RX Town Staff Recommendation: Town staff recommends the Town Council take no action on this item. Prosper is a place where everyone matters. PLANNING Item 4b 0GRAPHIC SCALE( IN FEET )1 inch = ft.STATE REGISTRATION NUMBER: F-399289380PROSPERItem 4b 0GRAPHIC SCALE( IN FEET )1 inch = ft.STATE REGISTRATION NUMBER: F-399289380PROSPERItem 4b Page 1 of 1 To: Mayor and Town Council From: Robyn Battle, Town Secretary Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon canceling the November 26, 2013, and the December 24, 2013, Prosper Town Council meetings. Description of Agenda Item: Due to the upcoming holiday schedule, Town staff is proposing that the following Prosper Town Council meetings be cancelled:  November 26, 2013  December 24, 2013 Proposed Motion: I make a motion to cancel the November 26, 2013, and December 24, 2013, Prosper Town Council meetings. Prosper is a place where everyone matters. ADMINISTRATION Item 4c Item 4d . glbase_pfn1 kaustin Town of Prosper Page 1 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4035-10-00 3% Construction Fee 75,000.00- 75,000.00- 151,679.16- 49,574.30- 202.239 76,679.16 10-4060-10-00 NSF Fees 50.00- 50.00- 10.00- 20.000 40.00- 10-4061-10-00 Notary Fees 150.00- 150.00- 435.00- 12.00- 290.000 285.00 10-4105-10-00 Property Taxes -Delinquent 35,000.00- 35,000.00- 66,972.04- 18,301.39- 191.349 31,972.04 10-4110-10-00 Property Taxes -Current 4,254,802.00- 4,254,802.00- 4,223,281.00- 9,508.43- 99.259 31,521.00- 10-4115-10-00 Taxes -Penalties 20,000.00- 20,000.00- 37,431.59- 1,204.63- 187.158 17,431.59 10-4120-10-00 Sales Taxes 1,400,000.00- 1,400,000.00- 2,440,084.64- 472,806.28- 174.292 1,040,084.64 10-4130-10-00 Sales Tax-Mixed Beverage 4,500.00- 4,500.00- 4,473.08- 99.402 26.92- 10-4140-10-00 Franchise Taxes - Electric 270,000.00- 270,000.00- 254,928.51- 94.418 15,071.49- 10-4150-10-00 Franchise Taxes - Telephone 85,000.00- 85,000.00- 127,492.13- 34,070.38- 149.991 42,492.13 10-4160-10-00 Franchise Taxes - Gas 58,000.00- 58,000.00- 105,798.48- 182.411 47,798.48 10-4170-10-00 Franchise Taxes - Road Usage 2,000.00- 2,000.00- 3,231.68- 161.584 1,231.68 10-4190-10-00 Franchise Fee-Cable 19,500.00- 19,500.00- 18,050.54- 5.07- 92.567 1,449.46- 10-4200-10-00 T-Mobile Fees 20,700.00- 20,700.00- 18,975.00- 1,725.00- 91.667 1,725.00- 10-4201-10-00 Tierone Converged Network 30,000.00- 30,000.00- 23,825.00- 1,500.00- 79.417 6,175.00- 10-4202-10-00 NTTA Tag Sales 150.00- 150.00- 105.00- 70.000 45.00- 10-4205-10-00 Internet America 18,000.00- 18,000.00- 15,000.00- 1,500.00- 83.333 3,000.00- 10-4218-10-00 Administrative Fees-EDC 2,400.00- 2,400.00- 2,200.00- 200.00- 91.667 200.00- 10-4610-10-00 Interest Income 60,000.00- 60,000.00- 55,881.13- 5,532.78- 93.135 4,118.87- 10-4910-10-00 Other Revenue 20,000.00- 20,000.00- 60,030.87- 45,711.12- 300.154 40,030.87 10-4930-10-00 Insurance Proceeds 4,009.51- 4,009.51 10-4990-10-00 Gain/Loss on Sale of Fixed Ass 7,755.00- 7,755.00 10-4995-10-00 Transfer In 801,700.00- 801,700.00- 790,535.99- 122,452.69- 98.607 11,164.01- Subtotal: 7,176,952.00- 7,176,952.00- 8,412,185.35- 764,104.07- 117.211 1,235,233.35 Program number: 7,176,952.00- 7,176,952.00- 8,412,185.35- 764,104.07- 117.211 1,235,233.35 Department number: 10 Administration 7,176,952.00- 7,176,952.00- 8,412,185.35- 764,104.07- 117.211 1,235,233.35 . glbase_pfn1 kaustin Town of Prosper Page 2 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 20 Police Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4230-20-00 Other Permits 125.00- 25.00- 125.00 10-4440-20-00 Accident Reports 500.00- 500.00- 447.90- 89.580 52.10- 10-4450-20-00 Alarm Fee 13,000.00- 13,000.00- 26,497.00- 3,670.00- 203.823 13,497.00 10-4910-20-00 Other Revenue 1,210.00- 75.00- 1,210.00 Subtotal: 13,500.00- 13,500.00- 28,279.90- 3,770.00- 209.481 14,779.90 Program number: 13,500.00- 13,500.00- 28,279.90- 3,770.00- 209.481 14,779.90 Department number: 20 Police 13,500.00- 13,500.00- 28,279.90- 3,770.00- 209.481 14,779.90 . glbase_pfn1 kaustin Town of Prosper Page 3 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 30 Fire/EMS Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4030-30-00 Miscellaneous 2,718.30- 2,718.30 10-4310-30-00 Charges for Services 177,000.00- 177,000.00- 134,910.46- 300.00- 76.221 42,089.54- 10-4510-30-00 Grants 15,000.00- 15,000.00- 31,276.25- 208.508 16,276.25 Subtotal: 192,000.00- 192,000.00- 168,905.01- 300.00- 87.971 23,094.99- Program number: 192,000.00- 192,000.00- 168,905.01- 300.00- 87.971 23,094.99- Department number: 30 Fire/EMS 192,000.00- 192,000.00- 168,905.01- 300.00- 87.971 23,094.99- . glbase_pfn1 kaustin Town of Prosper Page 4 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 35 Fire Marshall Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4315-35-00 Fire Review/Inspect Fees 5,500.00- 5,500.00- 9,000.00- 525.00- 163.636 3,500.00 Subtotal: 5,500.00- 5,500.00- 9,000.00- 525.00- 163.636 3,500.00 Program number: 5,500.00- 5,500.00- 9,000.00- 525.00- 163.636 3,500.00 Department number: 35 Fire Marshall 5,500.00- 5,500.00- 9,000.00- 525.00- 163.636 3,500.00 . glbase_pfn1 kaustin Town of Prosper Page 5 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 45 Public Library Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4064-45-00 Printing/Coping Fees 25.00- 25.00- 25.00- 10-4065-45-00 Book Fines 50.00- 50.00- 50.00- 10-4510-45-00 Grants 15,250.00- 15,250.00- 18,086.82- 118.602 2,836.82 10-4910-45-00 Other Revenue 3,000.00- 3,000.00- 125.00- 4.167 2,875.00- Subtotal: 18,325.00- 18,325.00- 18,211.82- 99.382 113.18- Program number: 18,325.00- 18,325.00- 18,211.82- 99.382 113.18- Department number: 45 Public Library 18,325.00- 18,325.00- 18,211.82- 99.382 113.18- . glbase_pfn1 kaustin Town of Prosper Page 6 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 60 Parks and Recreation Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4056-60-00 Field Rental Fees 8,000.00- 8,000.00- 17,390.73- 60.00- 217.384 9,390.73 10-4057-60-00 Pavilion User Fees 2,130.00- 145.00- 2,130.00 10-4058-60-00 Park Program Fees 1,750.00- 1,750.00- 1,750.00 10-4910-60-00 Other Revenue 250.00- 250.00- 25,298.00- ############### 25,048.00 Subtotal: 8,250.00- 8,250.00- 46,568.73- 1,955.00- 564.469 38,318.73 Program number: 8,250.00- 8,250.00- 46,568.73- 1,955.00- 564.469 38,318.73 Department number: 60 Parks and Recreation 8,250.00- 8,250.00- 46,568.73- 1,955.00- 564.469 38,318.73 . glbase_pfn1 kaustin Town of Prosper Page 7 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 70 Municipal Court Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4030-70-00 Miscellaneous 1,861.68- 1,861.68 10-4410-70-00 Fines 280,000.00- 280,000.00- 127,100.65- 13,399.40- 45.393 152,899.35- 10-4610-70-00 Interest Income 100.00- 100.00- 164.55- 19.47- 164.550 64.55 Subtotal: 280,100.00- 280,100.00- 129,126.88- 13,418.87- 46.100 150,973.12- Program number: 280,100.00- 280,100.00- 129,126.88- 13,418.87- 46.100 150,973.12- Department number: 70 Municipal Court 280,100.00- 280,100.00- 129,126.88- 13,418.87- 46.100 150,973.12- . glbase_pfn1 kaustin Town of Prosper Page 8 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 80 Inspections Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4011-80-00 Permit Application Fee 174.00- 174.00 10-4012-80-00 Saturday Inspection Fee 100.00- 100.00 10-4013-80-00 Permit Expiration Fee 780.00- 150.00- 780.00 10-4017-80-00 Registration Fee 32,000.00- 32,000.00- 38,400.00- 2,800.00- 120.000 6,400.00 10-4210-80-00 Building Permits 1,275,000.00- 1,275,000.00- 1,466,809.93- 290,711.95- 115.044 191,809.93 10-4230-80-00 Other Permits 100,000.00- 100,000.00- 99,023.90- 9,165.00- 99.024 976.10- 10-4240-80-00 Plumb/Elect/Mech Permits 15,000.00- 15,000.00- 16,640.00- 2,360.00- 110.933 1,640.00 10-4242-80-00 Re-inspection Fees 8,000.00- 8,000.00- 22,505.00- 2,800.00- 281.313 14,505.00 10-4910-80-00 Other Revenue 3,000.00- 3,000.00- 124,862.90- 710.00- 4,162.097 121,862.90 Subtotal: 1,433,000.00- 1,433,000.00- 1,769,295.73- 308,696.95- 123.468 336,295.73 Program number: 1,433,000.00- 1,433,000.00- 1,769,295.73- 308,696.95- 123.468 336,295.73 Department number: 80 Inspections 1,433,000.00- 1,433,000.00- 1,769,295.73- 308,696.95- 123.468 336,295.73 . glbase_pfn1 kaustin Town of Prosper Page 9 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 85 Code Enforcement Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4245-85-00 Health Inspections 10,000.00- 10,000.00- 6,050.00- 75.00 60.500 3,950.00- 10-4910-85-00 Other Revenue 14,598.16- 14,598.16 Subtotal: 10,000.00- 10,000.00- 20,648.16- 75.00 206.482 10,648.16 Program number: 10,000.00- 10,000.00- 20,648.16- 75.00 206.482 10,648.16 Department number: 85 Code Enforcement 10,000.00- 10,000.00- 20,648.16- 75.00 206.482 10,648.16 . glbase_pfn1 kaustin Town of Prosper Page 10 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 90 Planning Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-4220-90-00 Zoning Permits 10,000.00- 10,000.00- 28,702.27- 15,906.08- 287.023 18,702.27 10-4225-90-00 Plat Fees 15,000.00- 15,000.00- 48,710.00- 2,340.00- 324.733 33,710.00 10-4230-90-00 Other Permits 100.00- 100.00 10-4910-90-00 Other Revenue 283,348.54- 283,046.74- 283,348.54 Subtotal: 25,000.00- 25,000.00- 360,860.81- 301,292.82- 1,443.443 335,860.81 Program number: 25,000.00- 25,000.00- 360,860.81- 301,292.82- 1,443.443 335,860.81 Department number: 90 Planning 25,000.00- 25,000.00- 360,860.81- 301,292.82- 1,443.443 335,860.81 Revenue Subtotal ----------- 9,162,627.00- 9,162,627.00- 10,963,082.39- 1,393,987.71- 119.650 1,800,455.39 . glbase_pfn1 kaustin Town of Prosper Page 11 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-10-00 Salaries & Wages 618,300.00 70,000.00- 548,300.00 460,884.14 38,436.76 84.057 87,415.86 10-5115-10-00 Salaries - Overtime 6,000.00 6,000.00 4,727.63 1,858.40 78.794 1,272.37 10-5140-10-00 Salaries - Longevity Pay 1,015.00 1,015.00 790.00 77.833 225.00 10-5141-10-00 Salaries - Incentive 6,000.00 6,000.00 650.00 10.833 5,350.00 10-5145-10-00 Social Security Expense 36,500.00 36,500.00 27,465.09 2,344.60 75.247 9,034.91 10-5150-10-00 Medicare Expense 9,400.00 9,400.00 6,424.41 549.47 68.345 2,975.59 10-5155-10-00 SUTA Expense 2,430.00 2,430.00 1,523.46 62.694 906.54 10-5160-10-00 Health Insurance 34,875.00 34,875.00 21,485.36 2,947.40 61.607 13,389.64 10-5165-10-00 Dental Insurance 2,250.00 2,250.00 1,095.16 9.37 48.674 1,154.84 10-5170-10-00 Life Insurance/AD&D 850.00 850.00 516.17 53.66 60.726 333.83 10-5175-10-00 Liability (TML) Workers' Comp 3,100.00 3,100.00 2,087.40 67.335 1,012.60 10-5176-10-00 TML Prop. & Liab. Insurance 80,000.00 14,909.00 94,909.00 94,908.71 100.000 .29 10-5180-10-00 TMRS Expense 67,100.00 67,100.00 47,251.94 4,234.66 70.420 19,848.06 10-5185-10-00 Long Term/Short Term Disabilit 2,700.00 2,700.00 1,140.83 42.253 1,559.17 10-5186-10-00 WELLE-Wellness Prog Reimb Empl 1,075.00 1,075.00 1,097.50 35.00 102.093 22.50- 10-5190-10-00 Contract Labor 35,000.00 23,500.00 58,500.00 71,734.50 14,606.25 122.623 13,234.50- 10-5191-10-00 Hiring Cost 15,000.00 15,000.00 3,589.82 23.932 11,410.18 10-5193-10-00 Records Retention 1,000.00 1,000.00 867.30 86.730 132.70 10-5210-10-00 Office Supplies 5,000.00 1,500.00 6,500.00 7,610.09 1,195.99 117.078 1,110.09- 10-5212-10-00 Building Supplies 1,500.00 236.00 1,736.00 1,776.99 41.57 102.361 40.99- 10-5220-10-00 Office Equipment 5,500.00 14,000.00 19,500.00 15,957.39 3,339.00 81.833 3,542.61 10-5230-10-00 Dues,Fees,& Subscriptions 10,000.00 10,000.00 9,870.65 98.707 129.35 10-5240-10-00 Postage and Delivery 3,000.00 3,000.00 1,733.58 57.786 1,266.42 10-5250-10-00 Publications 500.00 500.00 30.00 30.00 6.000 470.00 10-5260-10-00 Advertising 300.00 300.00 300.00 10-5270-10-00 Bank Charges 200.00 200.00 511.66 255.830 311.66- 10-5280-10-00 Printing and Reproduction 2,000.00 2,000.00 1,295.30 78.51 64.765 704.70 10-5290-10-00 Miscellaneous Expense 1,090.00 1,090.00 715.78 65.668 374.22 10-5305-10-00 Chapt 380 Program Grant Exp 10,000.00 2,306.00 12,306.00 12,305.48 99.996 .52 10-5310-10-00 Rental Expense 4,000.00 4,000.00 3,510.58 174.95 87.765 489.42 10-5330-10-00 Copier Expense 27,000.00 27,000.00 23,396.71 1,710.00 86.654 3,603.29 10-5340-10-00 Building Repairs 2,500.00 2,500.00 686.71 125.00 27.468 1,813.29 10-5352-10-00 Fuel 35.00 35.00- 10-5410-10-00 Professional Services 45,000.00 27,432.00 72,432.00 83,181.69 10,750.00 114.841 10,749.69- 10-5412-10-00 Audit Fees 40,000.00 40,000.00 31,850.00 79.625 8,150.00 10-5414-10-00 Appraisal / Tax Fees 53,000.00 53,000.00 51,273.49 11,122.32 96.742 1,726.51 10-5415-10-00 Tuition Reimbursement 493.33 493.33 493.33- 10-5418-10-00 IT Fees 135,000.00 135,000.00 105,790.60 10,723.78 78.363 29,209.40 10-5419-10-00 IT Licenses 10,000.00 1,775.00 11,775.00 11,774.50 1,502.00 99.996 .50 10-5430-10-00 Legal Fees 40,000.00 27,000.00 67,000.00 68,593.87 6,820.70 102.379 1,593.87- 10-5435-10-00 Legal Notices/Filings 8,500.00 8,500.00 2,491.50 225.50 29.312 6,008.50 10-5460-10-00 Election Expense 15,000.00 6,000.00 21,000.00 21,056.72 62.76 100.270 56.72- 10-5480-10-00 Contracted Services 8,000.00 4,878.00 12,878.00 13,783.20 1,080.15 107.029 905.20- . glbase_pfn1 kaustin Town of Prosper Page 12 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5520-10-00 Telephones 18,000.00 18,000.00 11,365.06 1,163.49 63.139 6,634.94 10-5521-10-00 Cell Phone Expense 6,000.00 6,000.00 2,852.96 47.549 3,147.04 10-5524-10-00 Gas-Building 500.00 500.00 418.08 36.73 83.616 81.92 10-5525-10-00 Electricity 10,000.00 10,000.00 4,629.86 479.68 46.299 5,370.14 10-5526-10-00 Data Network 15,000.00 13,711.00 28,711.00 31,548.28 2,938.05 109.882 2,837.28- 10-5530-10-00 Travel/Lodging/Meals Expense 8,000.00 8,000.00 4,423.12 128.55 55.289 3,576.88 10-5532-10-00 Entertainment 750.00 750.00 750.00 10-5533-10-00 Mileage Expense 5,000.00 5,000.00 3,500.46 893.27 70.009 1,499.54 10-5536-10-00 Training/Seminars 40,000.00 912.00- 39,088.00 9,539.82 2,634.05 24.406 29,548.18 10-5538-10-00 Council/Public Official Expens 20,000.00 20,000.00 6,874.20 361.21 34.371 13,125.80 10-5600-10-00 Special Events 38,000.00 18,300.00- 19,700.00 18,947.18 96.179 752.82 10-6110-10-00 Capital Expenditure 20,000.00 20,000.00 20,000.00 10-6140-10-00 Capital Expenditure - Equipmen 20,000.00 15,000.00- 5,000.00 4,944.00 98.880 56.00 10-7000-10-00 Contingency 26,707.00 23,500.00- 3,207.00 3,207.00 10-7143-10-00 Transfer to Internal Serv. Fd 17,000.00 17,000.00 15,583.35 1,416.65 91.667 1,416.65 Subtotal: 1,592,477.00 11,700.00 1,604,177.00 1,332,590.61 124,602.81 83.070 271,586.39 Program number: 1,592,477.00 11,700.00 1,604,177.00 1,332,590.61 124,602.81 83.070 271,586.39 Department number: 10 Administration 1,592,477.00 11,700.00 1,604,177.00 1,332,590.61 124,602.81 83.070 271,586.39 . glbase_pfn1 kaustin Town of Prosper Page 13 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 20 Police Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-20-00 Salaries & Wages 886,700.00 886,700.00 748,587.94 68,713.88 84.424 138,112.06 10-5115-20-00 Salaries - Overtime 35,000.00 35,000.00 21,883.34 4,075.95 62.524 13,116.66 10-5127-20-00 Salaries-Certification Pay 11,800.00 11,800.00 11,308.01 1,080.00 95.831 491.99 10-5140-20-00 Salaries - Longevity Pay 3,900.00 3,900.00 3,785.00 97.051 115.00 10-5141-20-00 Salaries - Incentive 250.00 250.00- 10-5145-20-00 Social Security Expense 57,500.00 57,500.00 47,073.62 4,411.58 81.867 10,426.38 10-5150-20-00 Medicare Expense 13,450.00 13,450.00 11,009.15 1,031.74 81.852 2,440.85 10-5155-20-00 SUTA Expense 4,050.00 4,050.00 3,922.88 96.861 127.12 10-5160-20-00 Health Insurance 69,800.00 69,800.00 49,976.18 6,942.60 71.599 19,823.82 10-5165-20-00 Dental Insurance 4,500.00 4,500.00 3,613.52 362.10 80.300 886.48 10-5170-20-00 Life Insurance/AD&D 4,750.00 4,750.00 3,934.59 386.90 82.833 815.41 10-5175-20-00 Liability (TML) Workers' Comp 26,000.00 26,000.00 17,781.40 68.390 8,218.60 10-5180-20-00 TMRS Expense 101,900.00 101,900.00 81,702.36 7,763.92 80.179 20,197.64 10-5185-20-00 Long Term/Short Term Disabilit 5,420.00 5,420.00 2,901.83 53.539 2,518.17 10-5186-20-00 WELLE-Wellness Prog Reimb Empl 1,000.00 1,000.00 1,160.00 72.50 116.000 160.00- 10-5190-20-00 Contract Labor 5,760.00 5,760.00 4,560.00 380.00 79.167 1,200.00 10-5191-20-00 Hiring Cost 900.00 400.00 1,300.00 831.10 63.931 468.90 10-5192-20-00 Physical & Psychological 825.00 575.00 1,400.00 1,100.00 78.571 300.00 10-5210-20-00 Office Supplies 10,000.00 10,000.00 2,261.20 19.96 22.612 7,738.80 10-5212-20-00 Building Supplies 2,500.00 2,500.00 836.69 134.85 33.468 1,663.31 10-5214-20-00 Tactical Supplies 22,000.00 22,000.00 19,208.48 1,445.77 87.311 2,791.52 10-5215-20-00 Ammunition 6,500.00 6,500.00 1,522.85 23.428 4,977.15 10-5220-20-00 Office Equipment 5,100.00 5,100.00 3,965.20 77.749 1,134.80 10-5230-20-00 Dues,Fees,& Subscriptions 1,700.00 6,000.00 7,700.00 2,295.41 51.99 29.811 5,404.59 10-5240-20-00 Postage and Delivery 600.00 200.00 800.00 709.88 14.45 88.735 90.12 10-5250-20-00 Publications 500.00 500.00 43.49 8.698 456.51 10-5260-20-00 Advertising 250.00 250.00 250.00 10-5265-20-00 Promotional Expense 500.00 500.00 500.00 10-5280-20-00 Printing and Reproduction 500.00 500.00 1,078.50 733.50 215.700 578.50- 10-5310-20-00 Rental Expense 3,300.00 3,300.00 3,563.85 309.90 107.995 263.85- 10-5320-20-00 Repairs & Maintenance 750.00 750.00 203.54 27.139 546.46 10-5335-20-00 Radio/Video Repairs 3,000.00 3,000.00 119.00 3.967 2,881.00 10-5340-20-00 Building Repairs 1,000.00 1,000.00 29.94 2.994 970.06 10-5350-20-00 Vehicle Expense 32,000.00 8,000.00 40,000.00 34,089.60 1,046.74 85.224 5,910.40 10-5352-20-00 Fuel 80,000.00 21,417.95- 58,582.05 42,608.38 5,875.94 72.733 15,973.67 10-5353-20-00 Oil/Grease/Inspections 1,500.00 900.00 2,400.00 2,175.61 119.25 90.650 224.39 10-5400-20-00 Uniform Expense 26,000.00 26,000.00 13,136.12 3,285.38 50.524 12,863.88 10-5410-20-00 Professional Services 750.00 750.00 566.15 300.50- 75.487 183.85 10-5415-20-00 Tuition Reimbursement 4,800.00 4,800.00 4,800.00 1,600.00 100.000 10-5418-20-00 IT Fees 4,450.00 6,000.00 10,450.00 1,975.00 18.900 8,475.00 10-5419-20-00 IT Licenses 900.00 900.00 900.00 10-5430-20-00 Legal Fees 15,000.00 15,000.00 9,716.09 64.774 5,283.91 10-5480-20-00 Contracted Services 20,000.00 20,000.00 15,839.72 21.48 79.199 4,160.28 . glbase_pfn1 kaustin Town of Prosper Page 14 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 20 Police Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5520-20-00 Telephones 8,000.00 8,000.00 6,262.09 817.31 78.276 1,737.91 10-5521-20-00 Cell Phone Expense 5,000.00 5,000.00 2,665.34 53.307 2,334.66 10-5525-20-00 Electricity 9,500.00 9,500.00 8,352.91 945.72 87.925 1,147.09 10-5526-20-00 Data Network 4,700.00 4,700.00 8,773.82 569.85 186.677 4,073.82- 10-5530-20-00 Travel/Lodging/Meals Expense 3,000.00 3,000.00 1,858.80 61.960 1,141.20 10-5533-20-00 Mileage Expense 1,000.00 1,000.00 95.60 9.560 904.40 10-5536-20-00 Training/Seminars 24,000.00 24,000.00 9,045.91 1,022.87 37.691 14,954.09 10-5600-20-00 Special Events 2,000.00 2,000.00 1,278.97 63.949 721.03 10-5630-20-00 Safety Equipment 1,000.00 20,000.00 21,000.00 11,354.54 54.069 9,645.46 10-5640-20-00 Signs & Hardware 500.00 500.00 39.65 7.930 460.35 10-6110-20-00 Capital Expenditure 11,200.00 11,200.00- 10-6140-20-00 Capital Expenditure - Equipmen 25,000.00 25,000.00- 10-6160-20-00 Capital Expenditure - Vehicles 70,000.00 9,742.95 79,742.95 79,742.95 100.000 Subtotal: 1,635,955.00 1,635,955.00 1,305,596.20 112,935.63 79.806 330,358.80 Program number: 1,635,955.00 1,635,955.00 1,305,596.20 112,935.63 79.806 330,358.80 Department number: 20 Police 1,635,955.00 1,635,955.00 1,305,596.20 112,935.63 79.806 330,358.80 . glbase_pfn1 kaustin Town of Prosper Page 15 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 25 Dispatch Department Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-25-00 Salaries & Wages 317,200.00 1,150.00- 316,050.00 232,568.77 20,399.80 73.586 83,481.23 10-5115-25-00 Salaries - Overtime 15,000.00 15,000.00 11,869.59 1,957.58 79.131 3,130.41 10-5127-25-00 Salaries-Certification Pay 2,500.00 2,500.00 7,343.64 553.84 293.746 4,843.64- 10-5140-25-00 Salaries - Longevity Pay 700.00 700.00 570.00 81.429 130.00 10-5145-25-00 Social Security Expense 20,700.00 20,700.00 14,792.87 1,310.90 71.463 5,907.13 10-5150-25-00 Medicare Expense 4,850.00 4,850.00 3,459.63 306.56 71.333 1,390.37 10-5155-25-00 SUTA Expense 4,050.00 4,050.00 1,298.53 32.062 2,751.47 10-5160-25-00 Health Insurance 32,550.00 32,550.00 22,793.31 3,634.64 70.026 9,756.69 10-5165-25-00 Dental Insurance 2,100.00 2,100.00 1,522.35 144.84 72.493 577.65 10-5170-25-00 Life Insurance 660.00 660.00 507.86 47.28 76.948 152.14 10-5175-25-00 Liability (TML) Workers' Comp 750.00 750.00 426.39 56.852 323.61 10-5180-25-00 TMRS Expense 32,600.00 32,600.00 25,424.91 2,255.77 77.991 7,175.09 10-5185-25-00 Long Term/Short Term Disabilit 2,520.00 2,520.00 837.31 33.227 1,682.69 10-5186-25-00 WELLE-Wellness Prog Reimb Empl 672.50 47.50 672.50- 10-5191-25-00 Hiring Cost 300.00 1,150.00 1,450.00 697.00 48.069 753.00 10-5192-25-00 Physical & Psychological 300.00 300.00 300.00 100.000 10-5210-25-00 Supplies 3,000.00 3,000.00 2,012.43 67.081 987.57 10-5212-25-00 Building Supplies 1,500.00 1,500.00 1,022.80 266.99 68.187 477.20 10-5220-25-00 Office Equipment 2,196.84 2,196.84- 10-5230-25-00 Dues,Fees,& Subscriptions 750.00 750.00 1,062.24 58.98 141.632 312.24- 10-5240-25-00 Postage and Delivery 100.00 100.00 100.00 10-5250-25-00 Publications 100.00 100.00 272.73 272.73 272.730 172.73- 10-5280-25-00 Printing and Reproduction 100.00 100.00 100.00 10-5320-25-00 Repairs & Maintenance 500.00 500.00 85.00 17.000 415.00 10-5340-25-00 Building Repairs 750.00 750.00 750.00 10-5352-25-00 Fuel 250.00 250.00 250.00 10-5400-25-00 Uniform Expense 2,500.00 2,500.00 2,180.10 87.204 319.90 10-5418-25-00 IT Fees 10,000.00 10,000.00 1,140.00 11.400 8,860.00 10-5430-25-00 Legal Fees 5,000.00 5,000.00 5,000.00 10-5480-25-00 Contracted Services 155,000.00 155,000.00 143,031.04 92.278 11,968.96 10-5520-25-00 Telephones 2,500.00 2,500.00 1,574.56 143.58 62.982 925.44 10-5521-25-00 Cell Phone Expense 600.00 600.00 512.91 85.485 87.09 10-5524-25-00 Gas-Building 400.00 400.00 371.62 36.73 92.905 28.38 10-5526-25-00 Data Network 4,600.00 4,600.00 3,984.38 358.12 86.617 615.62 10-5530-25-00 Travel/Lodging/Meals Expense 2,000.00 2,000.00 1,106.81 55.341 893.19 10-5533-25-00 Mileage Expense 1,250.00 1,250.00 866.65 60.12 69.332 383.35 10-5536-25-00 Training/Seminars 7,500.00 7,500.00 1,806.54 24.087 5,693.46 10-5600-25-00 Special Events 500.00 500.00 321.12 64.224 178.88 10-6110-25-00 Capital Expenditure 10,600.00 10,600.00- Subtotal: 635,680.00 635,680.00 499,232.43 31,855.96 78.535 136,447.57 Program number: 635,680.00 635,680.00 499,232.43 31,855.96 78.535 136,447.57 . glbase_pfn1 kaustin Town of Prosper Page 16 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 25 Dispatch Department Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget Department number: 25 Dispatch Department 635,680.00 635,680.00 499,232.43 31,855.96 78.535 136,447.57 . glbase_pfn1 kaustin Town of Prosper Page 17 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 30 Fire/EMS Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-30-00 Salaries & Wages 1,269,050.00 1,269,050.00 1,135,034.30 99,968.35 89.440 134,015.70 10-5115-30-00 Salaries - Overtime 230,000.00 230,000.00 197,837.06 13,164.60 86.016 32,162.94 10-5127-30-00 Salaries-Certification Pay 16,000.00 16,000.00 13,551.84 1,126.24 84.699 2,448.16 10-5140-30-00 Salaries - Longevity Pay 6,000.00 6,000.00 6,650.00 110.833 650.00- 10-5145-30-00 Social Security Expense 95,000.00 95,000.00 80,570.61 6,760.24 84.811 14,429.39 10-5150-30-00 Medicare Expense 22,000.00 22,000.00 18,843.10 1,580.98 85.650 3,156.90 10-5155-30-00 SUTA Expense 8,400.00 8,400.00 5,754.64 68.508 2,645.36 10-5160-30-00 Health Insurance 93,000.00 93,000.00 71,645.64 10,375.21 77.038 21,354.36 10-5165-30-00 Dental Insurance 6,000.00 6,000.00 5,074.50 482.80 84.575 925.50 10-5170-30-00 Life Insurance/AD&D 6,300.00 6,300.00 5,543.28 525.20 87.989 756.72 10-5171-30-00 Life Insurance-Supplemental 7,000.00 7,000.00 7,921.00 113.157 921.00- 10-5175-30-00 Liability (TML) Workers Comp 31,000.00 31,000.00 17,623.98 56.852 13,376.02 10-5180-30-00 TMRS Expense 162,500.00 162,500.00 133,909.52 11,552.74 82.406 28,590.48 10-5185-30-00 Long Term/Short Term Disabilit 7,200.00 7,200.00 4,111.34 57.102 3,088.66 10-5186-30-00 WELLE-Wellness Prog Reimb Empl 4,977.50 1,252.50 4,977.50- 10-5190-30-00 Contract Labor 1,100.00 1,100.00 120.00 10.909 980.00 10-5191-30-00 Hiring Cost 1,000.00 1,000.00 195.00 19.500 805.00 10-5194-30-00 FD Annual Phy & Screening 16,000.00 16,000.00 9,566.50 59.791 6,433.50 10-5210-30-00 Office Supplies 3,500.00 3,500.00 2,393.50 160.16 68.386 1,106.50 10-5212-30-00 Building Supplies 4,000.00 4,000.00 4,245.71 230.65 106.143 245.71- 10-5220-30-00 Office Equipment 600.00 5,500.00 6,100.00 9,129.21 149.659 3,029.21- 10-5230-30-00 Dues,Fees,& Subscriptions 3,500.00 3,500.00 5,345.00 258.91- 152.714 1,845.00- 10-5240-30-00 Postage and Delivery 250.00 250.00 34.61 13.844 215.39 10-5250-30-00 Publications 350.00 350.00 90.00 90.00 25.714 260.00 10-5280-30-00 Printing and Reproduction 500.00 500.00 126.50 25.300 373.50 10-5320-30-00 Repairs & Maintenance 6,500.00 2,500.00 9,000.00 7,580.17 1,628.00 84.224 1,419.83 10-5335-30-00 Radio/Video Repairs 20,000.00 8,000.00- 12,000.00 3,607.80 2,651.20 30.065 8,392.20 10-5340-30-00 Building Repairs 20,000.00 20,000.00 10,774.56 310.00 53.873 9,225.44 10-5350-30-00 Vehicle Expense 30,000.00 30,000.00 27,753.32 1,292.65 92.511 2,246.68 10-5352-30-00 Fuel 45,000.00 500.00- 44,500.00 19,155.64 2,259.84 43.046 25,344.36 10-5353-30-00 Oil/Grease/Inspections 500.00 500.00 174.48 34.896 325.52 10-5400-30-00 Uniform Expense 21,000.00 21,000.00 19,155.65 91.217 1,844.35 10-5410-30-00 Professional Services 7,500.00 7,500.00 60.00 .800 7,440.00 10-5418-30-00 IT Fees 7,500.00 7,500.00 4,043.84 235.88 53.918 3,456.16 10-5419-30-00 IT Licenses 375.00 375.00- 10-5430-30-00 Legal Fees 2,676.95 2,676.95- 10-5440-30-00 EMS 74,000.00 74,000.00 51,198.02 5,910.74 69.187 22,801.98 10-5480-30-00 Contracted Services 10,000.00 10,000.00 2,057.00 60.00 20.570 7,943.00 10-5520-30-00 Telephones 14,498.00 14,498.00 8,317.73 763.09 57.372 6,180.27 10-5521-30-00 Cell Phone Expense 8,000.00 8,000.00 4,644.01 58.050 3,355.99 10-5522-30-00 Pagers 250.00 250.00 250.00 10-5524-30-00 Gas - Building 7,000.00 7,000.00 2,243.68 133.30 32.053 4,756.32 10-5525-30-00 Electricity 22,000.00 22,000.00 14,026.92 1,438.08 63.759 7,973.08 . glbase_pfn1 kaustin Town of Prosper Page 18 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 30 Fire/EMS Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5526-30-00 Data Network 12,442.00 12,442.00 19,176.33 1,885.73 154.126 6,734.33- 10-5530-30-00 Travel/Lodging/Meals Expense 3,000.00 3,000.00 718.12 23.937 2,281.88 10-5533-30-00 Mileage Expense 1,500.00 1,500.00 844.37 56.291 655.63 10-5536-30-00 Training/Seminars 18,000.00 2,755.00 20,755.00 9,209.59 44.373 11,545.41 10-5610-30-00 Fire Fighting Equipment 18,000.00 18,000.00 17,761.47 98.675 238.53 10-5630-30-00 Safety Equipment 25,000.00 25,000.00 19,417.92 5,336.65 77.672 5,582.08 10-6140-30-00 Capital Expenditure - Equipmen 7,000.00 7,000.00 5,479.00 78.271 1,521.00 10-6160-30-00 Capital Expenditure - Vehicles 550,000.00 550,000.00 550,000.00 100.000 Subtotal: 2,368,440.00 552,755.00 2,921,195.00 2,540,745.91 170,915.92 86.976 380,449.09 Program number: 2,368,440.00 552,755.00 2,921,195.00 2,540,745.91 170,915.92 86.976 380,449.09 Department number: 30 Fire/EMS 2,368,440.00 552,755.00 2,921,195.00 2,540,745.91 170,915.92 86.976 380,449.09 . glbase_pfn1 kaustin Town of Prosper Page 19 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 35 Fire Marshall Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-35-00 Salaries & Wages 80,700.00 80,700.00 71,702.40 6,208.00 88.851 8,997.60 10-5115-35-00 Salaries - Overtime 1,500.00 1,500.00 587.41 39.161 912.59 10-5140-35-00 Salaries - Longevity Pay 510.00 510.00 510.00 100.000 10-5145-35-00 Social Security Expense 5,200.00 5,200.00 3,932.32 335.39 75.622 1,267.68 10-5150-35-00 Medicare Expense 1,200.00 1,200.00 919.65 78.44 76.638 280.35 10-5155-35-00 SUTA Expense 270.00 270.00 261.00 96.667 9.00 10-5160-35-00 Health Insurance 4,650.00 4,650.00 4,284.02 547.68 92.129 365.98 10-5165-35-00 Dental Insurance 300.00 300.00 259.93 24.14 86.643 40.07 10-5170-35-00 Life Insurance/AD&D 315.00 315.00 283.79 26.26 90.092 31.21 10-5175-35-00 Liability (TML) Workers' Comp 1,550.00 1,550.00 881.20 56.852 668.80 10-5180-35-00 TMRS Expense 9,100.00 9,100.00 7,574.01 662.34 83.231 1,525.99 10-5185-35-00 Long Term/Short Term Disabilit 360.00 360.00 288.79 80.219 71.21 10-5186-35-00 WELLE-Wellness Prog Reimb Empl 262.50 100.00 262.50- 10-5193-35-00 Records Retention 250.00 250.00 250.00 10-5194-35-00 FD Annual Phy & Screening 650.00 650.00 828.50 127.462 178.50- 10-5210-35-00 Supplies 300.00 300.00 224.94 189.99 74.980 75.06 10-5220-35-00 Office Equipment 150.00 150.00 341.78 199.76 227.853 191.78- 10-5230-35-00 Dues,Fees,& Subscriptions 600.00 600.00 185.00 30.833 415.00 10-5240-35-00 Postage and Delivery 60.00 60.00 28.06 18.40 46.767 31.94 10-5250-35-00 Publications 550.00 550.00 158.48 28.815 391.52 10-5280-35-00 Printing and Reproduction 500.00 500.00 500.00 10-5320-35-00 Repairs & Maintenance 161.29 161.29- 10-5350-35-00 Vehicle Expense 1,953.00 700.00- 1,253.00 256.85 20.499 996.15 10-5352-35-00 Fuel 2,000.00 2,000.00 1,534.38 188.58 76.719 465.62 10-5353-35-00 Oil/Grease/Inspections 500.00 500.00 500.00 10-5400-35-00 Uniform Expense 1,050.00 400.00 1,450.00 1,443.00 99.517 7.00 10-5418-35-00 IT Fees 200.00 200.00 200.00 10-5430-35-00 Legal Fees 2,000.00 2,000.00 1,755.17 87.759 244.83 10-5520-35-00 Telephones 900.00 900.00 900.00 10-5521-35-00 Cell Phone Expense 1,200.00 1,200.00 787.46 65.622 412.54 10-5530-35-00 Travel/Lodging/Meals Expense 500.00 500.00 190.00 38.000 310.00 10-5536-35-00 Training/Seminars 3,200.00 3,200.00 1,373.50 42.922 1,826.50 10-5620-35-00 Tools & Equipment 150.00 150.00 150.00 10-5630-35-00 Safety Equipment 1,000.00 300.00 1,300.00 401.10 373.50 30.854 898.90 10-5640-35-00 Signs & Hardware 1,250.00 1,250.00 514.01 41.121 735.99 10-6110-35-00 Capital Expenditure 1,250.00 1,250.00 1,250.00 Subtotal: 125,868.00 125,868.00 101,930.54 8,952.48 80.982 23,937.46 Program number: 125,868.00 125,868.00 101,930.54 8,952.48 80.982 23,937.46 Department number: 35 Fire Marshall 125,868.00 125,868.00 101,930.54 8,952.48 80.982 23,937.46 . glbase_pfn1 kaustin Town of Prosper Page 20 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 40 Streets Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-40-00 Salaries & Wages 84,200.00 84,200.00 77,997.80 7,062.40 92.634 6,202.20 10-5115-40-00 Salaries - Overtime 4,000.00 4,000.00 2,335.09 53.88 58.377 1,664.91 10-5140-40-00 Salaries - Longevity Pay 880.00 880.00 820.00 93.182 60.00 10-5145-40-00 Social Security Expense 5,525.00 5,525.00 4,958.62 431.30 89.749 566.38 10-5150-40-00 Medicare Expense 1,290.00 1,290.00 1,159.68 100.86 89.898 130.32 10-5155-40-00 SUTA Expense 540.00 540.00 432.09 80.017 107.91 10-5160-40-00 Health Insurance 9,300.00 9,300.00 6,337.25 847.68 68.142 2,962.75 10-5165-40-00 Dental Insurance 600.00 600.00 519.86 48.28 86.643 80.14 10-5170-40-00 Life Insurance/AD&D 189.00 189.00 170.42 15.76 90.169 18.58 10-5175-40-00 Liability (TML) Workers Comp 5,300.00 5,300.00 3,213.13 60.625 2,086.87 10-5180-40-00 TMRS Expense 9,800.00 9,800.00 8,487.03 749.85 86.602 1,312.97 10-5185-40-00 Long Term/Short Term Disabilit 720.00 720.00 385.72 53.572 334.28 10-5186-40-00 WELLE-Wellness Prog Reimb Empl 675.00 25.00 675.00- 10-5191-40-00 Hiring Cost 50.00 50.00 50.00 10-5210-40-00 Office Supplies 600.00 600.00 189.84 65.85 31.640 410.16 10-5220-40-00 Office Equipment 400.00 400.00 100.00 25.000 300.00 10-5230-40-00 Dues,Fees,& Subscriptions 200.00 200.00 61.00 30.500 139.00 10-5250-40-00 Publications 50.00 50.00 50.00 10-5310-40-00 Rental Expense 6,000.00 6,000.00 2,799.92 224.92 46.665 3,200.08 10-5320-40-00 Repairs & Maintenance 4,000.00 4,000.00 497.99 12.450 3,502.01 10-5321-40-00 Signal Light Repairs 8,000.00 8,000.00 2,185.00 27.313 5,815.00 10-5340-40-00 Building Repairs 2,500.00 2,500.00 156.98 6.279 2,343.02 10-5350-40-00 Vehicle Expense 5,200.00 5,200.00 2,923.34 297.02 56.218 2,276.66 10-5352-40-00 Fuel 9,300.00 9,300.00 3,942.03 269.26 42.387 5,357.97 10-5353-40-00 Oil/Grease/Inspections 500.00 500.00 147.06 29.412 352.94 10-5400-40-00 Uniform Expense 2,500.00 2,500.00 1,449.88 314.40 57.995 1,050.12 10-5435-40-00 Legal Notices/Filings 342.00 342.00- 10-5480-40-00 Contracted Services 40,000.00 40,000.00 15,508.00 38.770 24,492.00 10-5520-40-00 Telephones 200.00 200.00 200.00 10-5521-40-00 Cell Phone Expense 800.00 800.00 834.42 104.303 34.42- 10-5525-40-00 Electricity 95,000.00 95,000.00 88,647.96 8,916.92 93.314 6,352.04 10-5530-40-00 Travel/Lodging/Meals Expense 800.00 800.00 328.84 41.105 471.16 10-5536-40-00 Training/Seminars 800.00 800.00 800.00 10-5620-40-00 Tools & Equipment 2,500.00 2,500.00 1,609.80 26.89 64.392 890.20 10-5630-40-00 Safety Equipment 1,200.00 1,200.00 506.41 42.201 693.59 10-5640-40-00 Signs & Hardware 25,000.00 145,000.00 170,000.00 61,967.29 1,528.84 36.451 108,032.71 10-5650-40-00 Maintenance Materials 60,000.00 60,000.00 38,519.65 14,140.96 64.199 21,480.35 10-6140-40-00 Capital Expenditure - Equipmen 6,350.00 6,350.00- Subtotal: 387,944.00 145,000.00 532,944.00 336,559.10 35,120.07 63.151 196,384.90 Program number: 387,944.00 145,000.00 532,944.00 336,559.10 35,120.07 63.151 196,384.90 . glbase_pfn1 kaustin Town of Prosper Page 21 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 40 Streets Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget Department number: 40 Streets 387,944.00 145,000.00 532,944.00 336,559.10 35,120.07 63.151 196,384.90 . glbase_pfn1 kaustin Town of Prosper Page 22 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 45 Public Library Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-45-00 Salaries & Wages 21,000.00 21,000.00 16,906.16 1,714.52 80.506 4,093.84 10-5145-45-00 Social Security Expense 1,400.00 1,400.00 1,048.17 106.30 74.869 351.83 10-5150-45-00 Medicare Expense 325.00 325.00 245.14 24.86 75.428 79.86 10-5155-45-00 SUTA Expense 270.00 270.00 169.97 62.952 100.03 10-5175-45-00 Liability (TML)/Workers' Comp 100.00 100.00 56.85 56.850 43.15 10-5190-45-00 Contract Labor 48,000.00 48,000.00 40,054.10 8,010.82- 83.446 7,945.90 10-5210-45-00 Supplies 1,500.00 1,500.00 30.44 2.029 1,469.56 10-5212-45-00 Building Supplies 500.00 500.00 121.58 24.316 378.42 10-5220-45-00 Office Equipment 500.00 500.00 144.97 28.994 355.03 10-5230-45-00 Dues,Fees,& Subscriptions 4,500.00 4,500.00 3,010.09 66.891 1,489.91 10-5240-45-00 Postage and Delivery 400.00 400.00 400.00 10-5281-45-00 Book Purchases 8,500.00 3,750.00 12,250.00 8,863.10 471.17 72.352 3,386.90 10-5430-45-00 Legal Fees 38.00 38.00 38.00- 10-5525-45-00 Electricity 5,500.00 5,500.00 5,500.00 10-5530-45-00 Travel 700.00 700.00 700.00 10-5533-45-00 Mileage Expense 600.00 600.00 600.00 10-5536-45-00 Training/Seminars 500.00 500.00 500.00 100.000 10-5600-45-00 Special Events 600.00 600.00 348.78 58.130 251.22 Subtotal: 94,895.00 3,750.00 98,645.00 71,537.35 5,655.97- 72.520 27,107.65 Program number: 94,895.00 3,750.00 98,645.00 71,537.35 5,655.97- 72.520 27,107.65 Department number: 45 Public Library 94,895.00 3,750.00 98,645.00 71,537.35 5,655.97- 72.520 27,107.65 . glbase_pfn1 kaustin Town of Prosper Page 23 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 60 Parks and Recreation Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-60-00 Salaries & Wages 375,000.00 39,292.97 414,292.97 306,245.20 35,309.59 73.920 108,047.77 10-5115-60-00 Salaries - Overtime 9,000.00 9,000.00 8,624.65 743.24 95.829 375.35 10-5140-60-00 Salaries - Longevity Pay 1,700.00 1,700.00 1,120.00 65.882 580.00 10-5141-60-00 Salaries - Incentive 334.01 334.01- 10-5145-60-00 Social Security Expense 24,500.00 2,436.16 26,936.16 18,595.53 2,087.69 69.036 8,340.63 10-5150-60-00 Medicare Expense 5,700.00 569.75 6,269.75 4,348.95 488.24 69.364 1,920.80 10-5155-60-00 SUTA Expense 3,000.00 270.00 3,270.00 1,716.23 52.484 1,553.77 10-5160-60-00 Health Insurance 41,850.00 1,815.36 43,665.36 36,189.25 5,807.48 82.879 7,476.11 10-5165-60-00 Dental Insurance 2,700.00 150.00 2,850.00 2,338.01 265.54 82.035 511.99 10-5170-60-00 Life Insurance/AD&D 850.00 850.00 765.37 86.68 90.044 84.63 10-5175-60-00 Liability (TML) Workers Comp 6,500.00 6,500.00 4,595.35 70.698 1,904.65 10-5180-60-00 TMRS Expense 40,200.00 4,125.76 44,325.76 32,903.95 3,807.09 74.232 11,421.81 10-5185-60-00 Long Term/Short Term Disabilit 3,250.00 3,250.00 1,148.61 35.342 2,101.39 10-5186-60-00 WELLE-Wellness Prog Reimb Empl 1,317.50 205.00 1,317.50- 10-5190-60-00 Contract Labor 18,500.00 18,500.00- 10-5191-60-00 Hiring Cost 195.00 195.00- 10-5210-60-00 Office Supplies 1,500.00 160.00 1,660.00 1,106.50 65.14 66.657 553.50 10-5212-60-00 Building Supplies 1,500.00 1,500.00 278.93 18.595 1,221.07 10-5220-60-00 Office Equipment 5,470.00 5,470.00 3,635.79 2,073.00 66.468 1,834.21 10-5230-60-00 Dues,Fees,& Subscriptions 2,000.00 2,000.00 636.71 31.836 1,363.29 10-5240-60-00 Postage and Delivery 175.00 175.00 47.57 27.183 127.43 10-5260-60-00 Advertising 100.00 100.00- 10-5280-60-00 Printing and Reproduction 300.00 300.00 334.18 111.393 34.18- 10-5290-60-00 Miscellaneous Expense 1,500.00 1,500.00 1,500.00 10-5310-60-00 Rental Expense 20,400.00 20,400.00 20,278.68 1,735.00 99.405 121.32 10-5320-60-00 Repairs & Maintenance 48,000.00 84,200.00 132,200.00 106,633.71 32,859.87 80.661 25,566.29 10-5350-60-00 Vehicle Expense 2,500.00 1,500.00 4,000.00 3,246.35 81.159 753.65 10-5352-60-00 Fuel 15,000.00 15,000.00 10,380.01 1,227.99 69.200 4,619.99 10-5353-60-00 Oil/Grease/Inspections 2,000.00 2,000.00 844.70 183.80 42.235 1,155.30 10-5400-60-00 Uniform Expense 4,500.00 4,500.00 4,218.34 731.50 93.741 281.66 10-5410-60-00 Professional Services 10,000.00 10,000.00- 4.10 4.10- 10-5418-60-00 IT Fees 1,300.00 1,300.00 1,052.50 562.50 80.962 247.50 10-5419-60-00 IT Licenses 220.00 220.00 1,511.00 1,511.00 686.818 1,291.00- 10-5430-60-00 Legal Fees 2,000.00 8,000.00 10,000.00 8,193.76 323.00 81.938 1,806.24 10-5480-60-00 Contracted Services 135,000.00 10,000.00- 125,000.00 97,530.92 19,336.20 78.025 27,469.08 10-5520-60-00 Telephones 45.00 45.00- 10-5521-60-00 Cell Phone Expense 3,900.00 350.00 4,250.00 3,353.56 78.907 896.44 10-5525-60-00 Electricity 63,000.00 50,000.00 113,000.00 84,498.72 7,686.83 74.778 28,501.28 10-5526-60-00 Data Network 500.00 500.00 422.40 84.48 84.480 77.60 10-5530-60-00 Travel/Lodging/Meals Expense 800.00 800.00 13.11 1.639 786.89 10-5533-60-00 Mileage Expense 800.00 800.00 302.23 33.00 37.779 497.77 10-5536-60-00 Training/Seminars 1,250.00 1,250.00 476.98 38.158 773.02 10-5600-60-00 Special Events 4,400.00 8,300.00 12,700.00 7,455.80 2,770.00 58.707 5,244.20 . glbase_pfn1 kaustin Town of Prosper Page 24 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 60 Parks and Recreation Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5630-60-00 Safety Equipment 1,600.00 1,600.00 779.34 48.709 820.66 10-5640-60-00 Signs & Hardware 2,800.00 2,800.00 3,487.52 124.554 687.52- 10-6110-60-00 Capital Expenditure 56,100.00 56,100.00 17,459.00 5,959.00 31.121 38,641.00 10-6140-60-00 Capital Expenditure - Equipmen 7,644.00 7,644.00- 10-6160-60-00 Capital Expenditure - Vehicles 400.00- 400.00- 18,016.02 -4,504.005 18,416.02- Subtotal: 833,675.00 249,860.00 1,083,535.00 824,425.04 125,942.86 76.087 259,109.96 Program number: 833,675.00 249,860.00 1,083,535.00 824,425.04 125,942.86 76.087 259,109.96 Department number: 60 Parks and Recreation 833,675.00 249,860.00 1,083,535.00 824,425.04 125,942.86 76.087 259,109.96 . glbase_pfn1 kaustin Town of Prosper Page 25 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 70 Municipal Court Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-70-00 Salaries & Wages 58,610.00 58,610.00 43,585.86 1,452.23 74.366 15,024.14 10-5140-70-00 Salaries - Longevity Pay 105.00 105.00 100.00 95.238 5.00 10-5145-70-00 Social Security Expense 3,650.00 3,650.00 2,575.67 90.04 70.566 1,074.33 10-5150-70-00 Medicare Expense 860.00 860.00 602.37 21.06 70.043 257.63 10-5155-70-00 SUTA Expense 270.00 270.00 261.00 96.667 9.00 10-5160-70-00 Health Insurance 4,650.00 4,650.00 2,954.10 63.529 1,695.90 10-5165-70-00 Dental Insurance 300.00 300.00 186.15 62.050 113.85 10-5170-70-00 Life Insurance/AD&D 95.00 95.00 61.57 64.811 33.43 10-5175-70-00 Liability (TML) Workers Comp 140.00 140.00 79.59 56.850 60.41 10-5180-70-00 TMRS Expense 6,500.00 6,500.00 4,518.89 152.48 69.521 1,981.11 10-5185-70-00 Long Term/Short Term Disabilit 360.00 360.00 188.67 52.408 171.33 10-5190-70-00 Contract Labor 4,800.00 4,800.00 2,535.00 555.00 52.813 2,265.00 10-5191-70-00 Hiring Cost 54.07 54.07 54.07- 10-5210-70-00 Office Supplies 1,500.00 1,500.00 481.22 32.081 1,018.78 10-5212-70-00 Building Supplies 1,000.00 1,000.00 1,031.11 103.111 31.11- 10-5220-70-00 Office Equipment 990.00 990.00 990.00- 10-5230-70-00 Dues,Fees,& Subscriptions 330.00 330.00 263.33 79.797 66.67 10-5240-70-00 Postage and Delivery 1,000.00 1,000.00 339.51 50.00 33.951 660.49 10-5250-70-00 Publications 100.00 100.00 100.00 10-5280-70-00 Printing and Reproduction 1,000.00 1,000.00 43.14 43.14 4.314 956.86 10-5310-70-00 Rental Expense 24,000.00 24,000.00 22,475.56 1,995.51 93.648 1,524.44 10-5320-70-00 Repairs & Maintenance 430.29 430.29- 10-5400-70-00 Uniform Expense 60.00 60.00 909.95 1,516.583 849.95- 10-5418-70-00 IT Fees 500.00 500.00 480.00 480.00 96.000 20.00 10-5420-70-00 Municipal Court/Judge Fees 9,600.00 9,600.00 8,625.00 750.00 89.844 975.00 10-5425-70-00 State Fines Expense 106,800.00 106,800.00 60.00 .056 106,740.00 10-5430-70-00 Legal Fees 19.00 19.00- 10-5480-70-00 Contracted Services 2,000.00 2,000.00 60.00 30.00 3.000 1,940.00 10-5481-70-00 Cash Over/Short 719.65- 719.65 10-5520-70-00 Telephones 300.00 300.00 1,268.82 118.45 422.940 968.82- 10-5524-70-00 Gas-Building 900.00 900.00 347.32 37.40 38.591 552.68 10-5525-70-00 Electricity 2,000.00 2,000.00 843.64 94.64 42.182 1,156.36 10-5530-70-00 Travel/Lodging/Meals Expense 800.00 800.00 580.23 72.529 219.77 10-5533-70-00 Mileage Expense 1,500.00 1,500.00 1,500.00 10-5536-70-00 Training/Seminars 1,000.00 1,000.00 880.00 630.00 88.000 120.00 Subtotal: 234,730.00 234,730.00 97,111.41 7,544.02 41.372 137,618.59 Program number: 234,730.00 234,730.00 97,111.41 7,544.02 41.372 137,618.59 Department number: 70 Municipal Court 234,730.00 234,730.00 97,111.41 7,544.02 41.372 137,618.59 . glbase_pfn1 kaustin Town of Prosper Page 26 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 80 Inspections Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-80-00 Salaries & Wages 360,000.00 4,341.17- 355,658.83 306,454.88 25,925.77 86.165 49,203.95 10-5115-80-00 Salaries - Overtime 12,000.00 12,000.00 5,521.14 24.09 46.010 6,478.86 10-5125-80-00 Salaries-Sick Time Buy-Out 2,560.80 2,560.80- 10-5126-80-00 Salaries-Vacation Buy-Out 1,676.47 1,676.47- 10-5140-80-00 Salaries - Longevity Pay 1,600.00 1,600.00 1,285.00 80.313 315.00 10-5141-80-00 Salaries - Incentive 3,234.01 3,234.01- 10-5145-80-00 Social Security Expense 22,750.00 1,941.70 24,691.70 19,203.21 1,526.72 77.772 5,488.49 10-5150-80-00 Medicare Expense 5,350.00 453.04 5,803.04 4,491.08 357.06 77.392 1,311.96 10-5155-80-00 SUTA Expense 2,450.00 540.00 2,990.00 1,899.44 63.526 1,090.56 10-5160-80-00 Health Insurance 32,550.00 186.43 32,736.43 27,368.19 3,520.92 83.602 5,368.24 10-5165-80-00 Dental Insurance 2,100.00 2,100.00 1,855.60 168.98 88.362 244.40 10-5170-80-00 Life Insurance/AD&D 670.00 670.00 599.86 55.16 89.531 70.14 10-5175-80-00 Liability (TML) Workers Comp 1,970.00 1,970.00 1,419.98 72.080 550.02 10-5180-80-00 TMRS Expense 38,150.00 38,150.00 33,333.71 2,733.38 87.375 4,816.29 10-5185-80-00 Long Term/Short Term Disabilit 2,520.00 2,520.00 1,173.79 46.579 1,346.21 10-5186-80-00 WELLE-Wellness Prog Reimb Empl 1,082.50 82.50 1,082.50- 10-5190-80-00 Contract Labor 1,200.00 1,200.00 1,440.00 120.00 120.000 240.00- 10-5191-80-00 Hiring Cost 60.00 60.00 80.00 133.333 20.00- 10-5210-80-00 Office Supplies 7,000.00 1,000.00 8,000.00 2,602.54 143.68 32.532 5,397.46 10-5212-80-00 Building Supplies 500.00 500.00 888.47 219.94 177.694 388.47- 10-5220-80-00 Office Equipment 7,530.00 7,530.00 6,137.01 5,341.94 81.501 1,392.99 10-5230-80-00 Dues,Fees,& Subscriptions 35,500.00 5,750.00 41,250.00 37,446.00 2,991.00 90.778 3,804.00 10-5240-80-00 Postage and Delivery 50.00 50.00 7.49 14.980 42.51 10-5280-80-00 Printing and Reproduction 2,000.00 2,000.00 595.86 29.793 1,404.14 10-5290-80-00 Miscellaneous Expense 79.00 79.00- 10-5320-80-00 Repairs & Maintenance 500.00 500.00 500.00 10-5340-80-00 Building Repairs 150.00 150.00 167.45 111.633 17.45- 10-5350-80-00 Vehicle Expense 1,500.00 1,500.00 4,249.77 283.318 2,749.77- 10-5352-80-00 Fuel 9,000.00 750.00 9,750.00 5,930.09 773.20 60.821 3,819.91 10-5353-80-00 Oil/Grease/Inspections 1,200.00 1,200.00 1,406.34- -117.195 2,606.34 10-5400-80-00 Uniform Expense 2,000.00 500.00 2,500.00 1,085.48 43.419 1,414.52 10-5415-80-00 Tuition Reimbursement 5,100.00 5,100.00 4,028.77 78.995 1,071.23 10-5418-80-00 IT Fees 4,000.00 350.00 4,350.00 1,442.50 1,027.50 33.161 2,907.50 10-5430-80-00 Legal Fees 4,000.00 4,000.00 275.14 6.879 3,724.86 10-5465-80-00 Public Relations 500.00 500.00 500.00 10-5480-80-00 Contracted Services 750.00 750.00 660.00 60.00 88.000 90.00 10-5520-80-00 Telephones 1,200.00 1,200.00 1,220.32 115.52 101.693 20.32- 10-5521-80-00 Cell Phone Expense 2,000.00 350.00 2,350.00 1,742.75 74.160 607.25 10-5525-80-00 Electricity 6,500.00 6,500.00 4,357.74 433.06 67.042 2,142.26 10-5526-80-00 Data Network 2,760.00 2,760.00 2,340.67 227.94 84.807 419.33 10-5530-80-00 Travel/Lodging/Meals Expense 600.00 600.00 600.00 10-5533-80-00 Mileage Expense 6,000.00 2,760.00- 3,240.00 1,705.14 52.628 1,534.86 10-5536-80-00 Training/Seminars 7,975.00 550.00 8,525.00 7,969.00 1,690.00 93.478 556.00 . glbase_pfn1 kaustin Town of Prosper Page 27 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 80 Inspections Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5630-80-00 Safety Equipment 800.00 800.00 173.80 173.80 21.725 626.20 10-5640-80-00 Signs & Hardware 1,258.63 1,258.63- 10-6110-80-00 Capital Expenditure 10,000.00 8,780.00- 1,220.00 1,220.00 10-6160-80-00 Capital Expenditure - Vehicles 18,500.00 18,500.00 18,333.00 18,333.00 99.097 167.00 Subtotal: 592,195.00 25,280.00 617,475.00 517,969.94 66,045.16 83.885 99,505.06 Program number: 592,195.00 25,280.00 617,475.00 517,969.94 66,045.16 83.885 99,505.06 Department number: 80 Inspections 592,195.00 25,280.00 617,475.00 517,969.94 66,045.16 83.885 99,505.06 . glbase_pfn1 kaustin Town of Prosper Page 28 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 85 Code Enforcement Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-85-00 Salaries & Wages 46,400.00 46,400.00 41,032.00 3,568.00 88.431 5,368.00 10-5115-85-00 Salaries - Overtime 1,500.00 1,500.00 168.64 11.243 1,331.36 10-5140-85-00 Salaries - Longevity Pay 145.00 145.00 145.00 100.000 10-5141-85-00 Salaries - Incentive 750.00 750.00- 10-5145-85-00 Social Security Expense 3,000.00 3,000.00 2,537.07 216.98 84.569 462.93 10-5150-85-00 Medicare Expense 700.00 700.00 593.35 50.75 84.764 106.65 10-5155-85-00 SUTA Expense 270.00 270.00 261.00 96.667 9.00 10-5160-85-00 Health Insurance 4,650.00 4,650.00 2,930.85 292.56 63.029 1,719.15 10-5165-85-00 Dental Insurance 300.00 300.00 259.93 24.14 86.643 40.07 10-5170-85-00 Life Insurance/AD&D 95.00 95.00 85.21 7.88 89.695 9.79 10-5175-85-00 Liability (TML) Workers' Comp 280.00 280.00 159.18 56.850 120.82 10-5180-85-00 TMRS Expense 5,300.00 5,300.00 4,398.73 375.95 82.995 901.27 10-5185-85-00 Long Term/Short Term Disabilit 360.00 360.00 166.95 46.375 193.05 10-5186-85-00 WELLE-Wellness Prog Reimb Empl 362.50 12.50 362.50- 10-5190-85-00 Contract Labor 19,000.00 19,000.00 675.00- 675.00- -3.553 19,675.00 10-5210-85-00 Office Supplies 500.00 500.00 85.11 17.022 414.89 10-5230-85-00 Dues,Fees,& Subscriptions 120.00 120.00 149.85 124.875 29.85- 10-5240-85-00 Postage and Delivery 400.00 400.00 245.54 61.385 154.46 10-5280-85-00 Printing and Reproduction 500.00 500.00 1,490.35 298.070 990.35- 10-5350-85-00 Vehicle Expense 500.00 500.00 5.81 1.162 494.19 10-5352-85-00 Fuel 1,000.00 1,000.00 755.53 83.02 75.553 244.47 10-5353-85-00 Oil/Grease/Inspections 100.00 100.00 100.00 10-5400-85-00 Uniform Expense 200.00 200.00 109.90 54.950 90.10 10-5430-85-00 Legal Fees 15,000.00 15,000.00 3,086.42 20.576 11,913.58 10-5435-85-00 Legal Notices/Filings 500.00 500.00 500.00 10-5480-85-00 Contracted Services 65,500.00 65,500.00 87,789.00 350.00 134.029 22,289.00- 10-5520-85-00 Telephones 300.00 300.00 406.75 38.50 135.583 106.75- 10-5521-85-00 Cell Phone Expense 500.00 500.00 333.21 66.642 166.79 10-5536-85-00 Training/Seminars 500.00 500.00 140.00 140.00 28.000 360.00 10-5600-85-00 Special Events 1,000.00 1,000.00 1,000.00 10-5620-85-00 Tools & Equipment 250.00 250.00 129.82 57.90 51.928 120.18 10-5640-85-00 Signs & Hardware 500.00 500.00 21.87 21.87 4.374 478.13 Subtotal: 169,370.00 169,370.00 147,924.57 4,565.05 87.338 21,445.43 Program number: 169,370.00 169,370.00 147,924.57 4,565.05 87.338 21,445.43 Department number: 85 Code Enforcement 169,370.00 169,370.00 147,924.57 4,565.05 87.338 21,445.43 . glbase_pfn1 kaustin Town of Prosper Page 29 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 90 Planning Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-90-00 Salaries & Wages 183,300.00 25,621.04- 157,678.96 132,855.87 15,790.18 84.257 24,823.09 10-5115-90-00 Salaries - Overtime 500.00 500.00 75.72 15.144 424.28 10-5140-90-00 Salaries - Longevity Pay 620.00 620.00 620.00 100.000 10-5141-90-00 Salaries - Incentive 984.01 984.01- 10-5145-90-00 Social Security Expense 11,410.00 1,588.51- 9,821.49 7,845.30 904.27 79.879 1,976.19 10-5150-90-00 Medicare Expense 2,700.00 371.51- 2,328.49 1,834.78 211.48 78.797 493.71 10-5155-90-00 SUTA Expense 810.00 270.00- 540.00 482.60 89.370 57.40 10-5160-90-00 Health Insurance 13,950.00 2,358.73- 11,591.27 10,496.09 2,130.62 90.552 1,095.18 10-5165-90-00 Dental Insurance 900.00 150.00- 750.00 568.82 72.42 75.843 181.18 10-5170-90-00 Life Insurance/AD&D 289.00 289.00 186.18 23.64 64.422 102.82 10-5175-90-00 Liability (TML) Workers Comp 564.00 564.00 320.64 56.851 243.36 10-5180-90-00 TMRS Expense 20,250.00 2,690.21- 17,559.79 14,012.64 1,662.96 79.800 3,547.15 10-5185-90-00 Long Term/Short Term Disabilit 1,080.00 1,080.00 457.61 42.371 622.39 10-5186-90-00 WELLE-Wellness Prog Reimb Empl 410.00 47.50 410.00- 10-5190-90-00 Contract Labor 1,300.00 1,300.00 1,440.00 120.00 110.769 140.00- 10-5191-90-00 Hiring Cost 50.00 50.00 40.00 80.000 10.00 10-5210-90-00 Office Supplies 3,500.00 3,500.00 1,245.02 80.67 35.572 2,254.98 10-5212-90-00 Building Supplies 250.00 250.00 12.00 4.800 238.00 10-5220-90-00 Office Equipment 3,000.00 3,000.00 1,692.29 56.410 1,307.71 10-5230-90-00 Dues,Fees,& Subscriptions 5,000.00 5,000.00 815.05- 14.95 -16.301 5,815.05 10-5240-90-00 Postage and Delivery 200.00 200.00 89.96 44.980 110.04 10-5280-90-00 Printing and Reproduction 162.43 162.43- 10-5400-90-00 Uniform Expense 300.00 300.00 223.80 74.600 76.20 10-5410-90-00 Professional Services 45,000.00 45,000.00 45,000.00 100.000 10-5418-90-00 IT Fees 387.50 387.50- 10-5419-90-00 IT Licenses 110.00 110.00- 10-5430-90-00 Legal Fees 20,000.00 20,000.00 25,008.72 836.00 125.044 5,008.72- 10-5435-90-00 Legal Notices/Filings 1,500.00 1,500.00 526.50 35.100 973.50 10-5520-90-00 Telephones 2,200.00 2,200.00 1,262.72 114.95 57.396 937.28 10-5521-90-00 Cell Phone Expense 1,200.00 1,200.00 612.81 51.068 587.19 10-5526-90-00 Data Network 8,250.00 8,250.00 7,556.29 687.71 91.591 693.71 10-5530-90-00 Travel/Lodging/Meals Expense 1,200.00 1,200.00 445.82 37.152 754.18 10-5533-90-00 Mileage Expense 1,500.00 1,500.00 390.46 26.031 1,109.54 10-5536-90-00 Training/Seminars 3,000.00 3,000.00 1,033.14 34.438 1,966.86 Subtotal: 333,823.00 33,050.00- 300,773.00 257,574.67 22,697.35 85.638 43,198.33 Program number: 333,823.00 33,050.00- 300,773.00 257,574.67 22,697.35 85.638 43,198.33 Department number: 90 Planning 333,823.00 33,050.00- 300,773.00 257,574.67 22,697.35 85.638 43,198.33 . glbase_pfn1 kaustin Town of Prosper Page 30 16:56 10/16/13 Monthly Budget Report Fund: 10 General Department: 98 Engineering Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 10-5110-98-00 Salaries & Wages 114,800.00 70,060.52 184,860.52 116,655.03 17,459.00 63.104 68,205.49 10-5140-98-00 Salaries - Longevity Pay 380.00 380.00 380.00 100.000 10-5141-98-00 Salaries - Incentive 234.01 234.01- 10-5145-98-00 Social Security Expense 6,870.00 4,343.75 11,213.75 6,559.23 1,010.82 58.493 4,654.52 10-5150-98-00 Medicare Expense 1,700.00 1,015.88 2,715.88 1,534.01 236.40 56.483 1,181.87 10-5155-98-00 SUTA Expense 270.00 270.00 540.00 261.00 48.333 279.00 10-5160-98-00 Health Insurance 4,650.00 4,413.50 9,063.50 6,488.95 1,552.04 71.594 2,574.55 10-5165-98-00 Dental Insurance 300.00 150.00 450.00 284.07 48.28 63.127 165.93 10-5170-98-00 Life Insurance/AD&D 150.00 150.00 143.66 21.74 95.773 6.34 10-5175-98-00 Liability (TML) Workers Comp 265.00 265.00 150.66 56.853 114.34 10-5180-98-00 TMRS Expense 12,700.00 7,356.35 20,056.35 12,203.71 1,834.51 60.847 7,852.64 10-5185-98-00 Long Term/Short Term Disabilit 360.00 360.00 367.49 102.081 7.49- 10-5186-98-00 WELLE-Wellness Prog Reimb Empl 250.00 12.50 250.00- 10-5191-98-00 Hiring Cost 40.00 40.00- 10-5210-98-00 Office Supplies 300.00 200.00 500.00 1,184.82 340.65 236.964 684.82- 10-5212-98-00 Building Supplies 350.00 250.00- 100.00 100.00 10-5220-98-00 Office Equipment 8,200.00 8,200.00 6,398.98 2,224.00 78.036 1,801.02 10-5230-98-00 Dues,Fees,& Subscriptions 300.00 300.00 235.00 78.333 65.00 10-5240-98-00 Postage and Delivery 20.00 20.00 13.30 66.500 6.70 10-5250-98-00 Publications 108.00 108.00 108.00- 10-5280-98-00 Printing and Reproduction 421.20 218.28 421.20- 10-5400-98-00 Uniform Expense 349.98 78.20 349.98- 10-5418-98-00 IT Fees 250.00 1,475.00 1,725.00 1,012.50 562.50 58.696 712.50 10-5419-98-00 IT Licenses 330.00 330.00 422.00 422.00 127.879 92.00- 10-5430-98-00 Legal Fees 8,500.00 8,500.00 9,462.96 969.00 111.329 962.96- 10-5520-98-00 Telephones 720.00 720.00- 10-5521-98-00 Cell Phone Expense 660.00 700.00 1,360.00 634.23 46.635 725.77 10-5530-98-00 Travel/Lodging/Meals Expense 750.00 750.00 28.95 3.860 721.05 10-5533-98-00 Mileage Expense 1,000.00 1,000.00 43.97 43.97 4.397 956.03 10-5536-98-00 Training/Seminars 3,000.00 1,295.00 4,295.00 4,295.00 10-5620-98-00 Tools & Equipment 50.00 50.00 92.96 59.99 185.920 42.96- Subtotal: 157,575.00 99,610.00 257,185.00 166,680.67 27,201.88 64.810 90,504.33 Program number: 157,575.00 99,610.00 257,185.00 166,680.67 27,201.88 64.810 90,504.33 Department number: 98 Engineering 157,575.00 99,610.00 257,185.00 166,680.67 27,201.88 64.810 90,504.33 Expense Subtotal ----------- 9,162,627.00 1,054,905.00 10,217,532.00 8,199,878.44 732,723.22 80.253 2,017,653.56 Fund number: 10 General 1,054,905.00 1,054,905.00 2,763,203.95- 661,264.49- -261.939 3,818,108.95 . glbase_pfn1 kaustin Town of Prosper Page 31 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 50 Water Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-4005-50-00 Water Revenue 4,690,000.00- 4,690,000.00- 4,323,673.33- 607,673.07- 92.189 366,326.67- 20-4010-50-00 Water Tap & Construction 200,000.00- 200,000.00- 352,113.00- 65,913.00- 176.057 152,113.00 20-4012-50-00 Saturday Inspection Fee 600.00- 600.00- 3,300.00- 300.00- 550.000 2,700.00 20-4018-50-00 Internet Cr. Card Fees(Global) 8,000.00- 8,000.00- 13,935.77- 1,656.59- 174.197 5,935.77 20-4019-50-00 Cr. Card Pmt Fees(auth.net) 1,200.00- 1,200.00- 1,985.49- 309.88- 165.458 785.49 20-4060-50-00 NSF Fees 500.00- 500.00- 1,000.00- 25.00- 200.000 500.00 20-4242-50-00 Re-Inspection Fees 200.00- 200.00- 1,575.00- 150.00- 787.500 1,375.00 20-4610-50-00 Interest Income 30,000.00- 30,000.00- 77,591.80- .08 258.639 47,591.80 20-4910-50-00 Other Revenue 25,000.00- 25,000.00- 83,773.57- 13,154.90- 335.094 58,773.57 Subtotal: 4,955,500.00- 4,955,500.00- 4,858,947.96- 689,182.36- 98.052 96,552.04- Program number: 4,955,500.00- 4,955,500.00- 4,858,947.96- 689,182.36- 98.052 96,552.04- Department number: 50 Water 4,955,500.00- 4,955,500.00- 4,858,947.96- 689,182.36- 98.052 96,552.04- . glbase_pfn1 kaustin Town of Prosper Page 32 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 55 Sewer Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-4006-55-00 Sewer Revenue 2,043,500.00- 2,043,500.00- 2,063,371.98- 209,182.07- 100.972 19,871.98 20-4010-55-00 Sewer Tap & Construction 100,000.00- 100,000.00- 157,600.00- 38,800.00- 157.600 57,600.00 Subtotal: 2,143,500.00- 2,143,500.00- 2,220,971.98- 247,982.07- 103.614 77,471.98 Program number: 2,143,500.00- 2,143,500.00- 2,220,971.98- 247,982.07- 103.614 77,471.98 Department number: 55 Sewer 2,143,500.00- 2,143,500.00- 2,220,971.98- 247,982.07- 103.614 77,471.98 . glbase_pfn1 kaustin Town of Prosper Page 33 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 57 Utility Billing Department Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-4000-57-00 W/S Service Initiation 32,000.00- 32,000.00- 47,510.00- 5,295.00- 148.469 15,510.00 20-4007-57-00 Sanitation 720,000.00- 720,000.00- 753,789.64- 70,402.51- 104.693 33,789.64 20-4009-57-00 Late Fee-W/S 50,000.00- 50,000.00- 59,084.40- 6,373.82- 118.169 9,084.40 Subtotal: 802,000.00- 802,000.00- 860,384.04- 82,071.33- 107.280 58,384.04 Program number: 802,000.00- 802,000.00- 860,384.04- 82,071.33- 107.280 58,384.04 Department number: 57 Utility Billing Department 802,000.00- 802,000.00- 860,384.04- 82,071.33- 107.280 58,384.04 Revenue Subtotal ----------- 7,901,000.00- 7,901,000.00- 7,940,303.98- 1,019,235.76- 100.497 39,303.98 . glbase_pfn1 kaustin Town of Prosper Page 34 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 50 Water Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-5110-50-00 Salaries & Wages 409,680.00 409,680.00 349,337.56 32,916.15 85.271 60,342.44 20-5115-50-00 Salaries - Overtime 21,000.00 21,000.00 21,713.74 3,791.07 103.399 713.74- 20-5140-50-00 Salaries - Longevity Pay 1,575.00 1,575.00 1,330.00 84.444 245.00 20-5145-50-00 Social Security Expense 26,810.00 26,810.00 22,367.72 2,178.55 83.431 4,442.28 20-5150-50-00 Medicare Expense 6,285.00 6,285.00 5,231.19 509.50 83.233 1,053.81 20-5155-50-00 SUTA Expense 2,430.00 2,430.00 2,094.11 86.177 335.89 20-5160-50-00 Health Insurance 41,850.00 41,850.00 26,104.42 4,125.08 62.376 15,745.58 20-5165-50-00 Dental Insurance 2,700.00 2,700.00 2,119.43 205.19 78.497 580.57 20-5170-50-00 Life Insurance/AD&D 895.00 895.00 763.44 77.90 85.301 131.56 20-5175-50-00 Liability (TML) Workers' Comp 12,416.00 12,416.00 7,858.69 63.295 4,557.31 20-5176-50-00 TML Prop. & Liab Insurance 30,000.00 30,000.00 28,384.36 94.615 1,615.64 20-5180-50-00 TMRS Expense 47,600.00 47,600.00 38,816.88 3,871.59 81.548 8,783.12 20-5185-50-00 Long Term/Short Term Disabilit 3,260.00 3,260.00 1,346.64 41.308 1,913.36 20-5186-50-00 WELLE-Wellness Prog Reimb-Empl 2,077.50 165.00 2,077.50- 20-5190-50-00 Contract Labor 15,000.00 15,000.00 15,000.00 20-5191-50-00 Hiring Cost 540.00 540.00 120.00 22.222 420.00 20-5210-50-00 Office Supplies 2,500.00 2,500.00 1,159.57 1.93- 46.383 1,340.43 20-5212-50-00 Building Supplies 1,200.00 1,200.00 2,596.51 216.376 1,396.51- 20-5220-50-00 Office Equipment 8,500.00 8,500.00 1,773.23 20.862 6,726.77 20-5230-50-00 Dues,Fees,& Subscriptions 6,000.00 6,000.00 9,710.32 15.18 161.839 3,710.32- 20-5240-50-00 Postage and Delivery 1,000.00 1,000.00 196.36 19.636 803.64 20-5250-50-00 Publications 100.00 100.00 100.00 20-5280-50-00 Printing and Reproduction 7,000.00 7,000.00 3,259.63 366.00 46.566 3,740.37 20-5290-50-00 Miscellaneous Expense 310.13 310.13- 20-5310-50-00 Rental Expense 5,000.00 5,000.00 144.95 2.899 4,855.05 20-5320-50-00 Repairs & Maintenance 3,500.00 3,500.00 12,650.00 361.429 9,150.00- 20-5340-50-00 Building Repairs 3,900.00 3,900.00 1,753.75 44.968 2,146.25 20-5350-50-00 Vehicle Expense 30,000.00 30,000.00 12,461.52 2,421.12 41.538 17,538.48 20-5352-50-00 Fuel 31,500.00 31,500.00 25,019.14 4,013.16 79.426 6,480.86 20-5353-50-00 Oil/Grease/Inspections 2,400.00 2,400.00 996.99 80.28 41.541 1,403.01 20-5400-50-00 Uniform Expense 8,000.00 8,000.00 4,868.00 1,460.36 60.850 3,132.00 20-5410-50-00 Professional Services 5,000.00 40,000.00 45,000.00 38,708.49 86.019 6,291.51 20-5412-50-00 Audit Fees 1,000.00 1,000.00 1,000.00 20-5416-50-00 Engineering Fees 2,000.00 2,000.00 2,000.00 20-5418-50-00 IT Fees 18,000.00 18,000.00 12,366.02 1,000.00 68.700 5,633.98 20-5419-50-00 IT Licenses 1,000.00 1,000.00 7,657.50 765.750 6,657.50- 20-5430-50-00 Legal Fees 5,000.00 5,000.00 298.60 5.972 4,701.40 20-5475-50-00 Credit Card Fees 12,000.00 12,000.00 16,442.02 137.017 4,442.02- 20-5480-50-00 Contracted Services 35,000.00 35,000.00 15,662.03 130.00 44.749 19,337.97 20-5520-50-00 Telephones 6,300.00 6,300.00 3,880.73 341.12 61.599 2,419.27 20-5521-50-00 Cell Phone Expense 8,200.00 8,200.00 3,032.28 145.00 36.979 5,167.72 20-5524-50-00 Gas-Building 2,000.00 2,000.00 2,055.56 36.73 102.778 55.56- 20-5525-50-00 Electricity 200,000.00 200,000.00 117,364.11 12,340.99 58.682 82,635.89 . glbase_pfn1 kaustin Town of Prosper Page 35 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 50 Water Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-5526-50-00 Data Network 6,800.00 6,800.00 3,341.10 551.82 49.134 3,458.90 20-5530-50-00 Travel/Lodging/Meals Expense 1,000.00 1,000.00 95.11 95.11 9.511 904.89 20-5533-50-00 Mileage Expense 600.00 600.00 946.82 157.803 346.82- 20-5536-50-00 Training/Seminars 6,750.00 6,750.00 1,418.90 21.021 5,331.10 20-5540-50-00 Water Testing 3,000.00 3,000.00 3,000.00 20-5545-50-00 Meter Purchases 80,000.00 70,000.00 150,000.00 148,882.09 99.255 1,117.91 20-5550-50-00 Water Purchases 1,420,000.00 1,420,000.00 1,280,525.59 123,906.27 90.178 139,474.41 20-5620-50-00 Tools & Equipment 7,500.00 7,500.00 6,080.32 81.071 1,419.68 20-5630-50-00 Safety Equipment 6,750.00 6,750.00 2,466.32 36.538 4,283.68 20-5640-50-00 Signs & Hardware 2,200.00 2,200.00 832.68 37.849 1,367.32 20-5650-50-00 Maintenance Materials 10,000.00 10,000.00 2,030.36 20.304 7,969.64 20-5660-50-00 Chemical Supplies 3,500.00 3,500.00 206.11 5.889 3,293.89 20-5670-50-00 System Improvements/Repairs 78,000.00 78,000.00 64,066.02 15,227.26 82.136 13,933.98 20-6110-50-00 Capital Expenditure 3,000.00 3,000.00 3,000.00 20-6160-50-00 Capital Expenditure - Vehicles 50,000.00 50,000.00 47,175.90 94.352 2,824.10 20-6192-50-00 2011 Refd Bond Pmt 283,269.00 283,269.00 283,268.74 10,713.12 100.000 .26 20-6193-50-00 2012 CO Bond Payment 160,377.00 160,377.00 160,377.01 50,685.00 100.000 .01- 20-6197-50-00 04 CO Bond Payment 539,155.00 539,155.00 549,340.00 444,064.01 101.889 10,185.00- 20-6198-50-00 06 CO Bond Payment 491,555.00 491,555.00 491,554.72 382,277.36 100.000 .28 20-6199-50-00 08 CO Bond Payment 119,491.00 119,491.00 119,490.62 34,980.00 100.000 .38 20-6200-50-00 Bond Administrative Fees 3,000.00 3,000.00 3,000.00 20-7143-50-00 Transfer to Internal Serv. Fd 2,160.00 2,160.00 1,980.00 180.00 91.667 180.00 20-7147-50-00 Transfer to GF 494,610.00 494,610.00 453,392.50 41,217.50 91.667 41,217.50 Subtotal: 4,800,858.00 110,000.00 4,910,858.00 4,421,504.03 1,174,085.49 90.035 489,353.97 Program number: 4,800,858.00 110,000.00 4,910,858.00 4,421,504.03 1,174,085.49 90.035 489,353.97 Department number: 50 Water 4,800,858.00 110,000.00 4,910,858.00 4,421,504.03 1,174,085.49 90.035 489,353.97 . glbase_pfn1 kaustin Town of Prosper Page 36 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 55 Sewer Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-5110-55-00 Salaries & Wages 140,200.00 140,200.00 92,137.29 8,809.00 65.718 48,062.71 20-5115-55-00 Salaries - Overtime 12,000.00 12,000.00 8,355.11 789.02 69.626 3,644.89 20-5140-55-00 Salaries - Longevity Pay 300.00 300.00 465.00 155.000 165.00- 20-5145-55-00 Social Security Expense 9,500.00 9,500.00 5,918.08 556.60 62.296 3,581.92 20-5150-55-00 Medicare Expense 2,240.00 2,240.00 1,384.08 130.18 61.789 855.92 20-5155-55-00 SUTA Expense 1,080.00 1,080.00 680.07 62.969 399.93 20-5160-55-00 Health Insurance 18,600.00 18,600.00 9,742.44 1,234.34 52.379 8,857.56 20-5165-55-00 Dental Insurance 1,200.00 1,200.00 714.64 72.42 59.553 485.36 20-5170-55-00 Life Insurance/AD&D 380.00 380.00 233.93 23.64 61.561 146.07 20-5175-55-00 Liability (TML) Workers' Comp 6,500.00 6,500.00 4,095.35 63.005 2,404.65 20-5180-55-00 TMRS Expense 13,450.00 13,450.00 10,602.11 1,014.09 78.826 2,847.89 20-5185-55-00 Long Term/Short Term Disabilit 1,440.00 1,440.00 353.81 24.570 1,086.19 20-5186-55-00 WELLE-Wellness Prog Reimb-Empl 985.00 60.00 985.00- 20-5191-55-00 Hiring Cost 200.00 200.00 200.00 20-5210-55-00 Office Supplies 600.00 600.00 523.80 87.300 76.20 20-5212-55-00 Building Supplies 500.00 500.00 602.98 82.83 120.596 102.98- 20-5220-55-00 Office Equipment 5,000.00 2,000.00- 3,000.00 334.71 11.157 2,665.29 20-5230-55-00 Dues,Fees,& Subscriptions 700.00 700.00 96.19 15.09 13.741 603.81 20-5240-55-00 Postage and Delivery 900.00 900.00 900.00 20-5250-55-00 Publications 100.00 100.00 100.00 20-5260-55-00 Advertising 600.00 600.00 600.00 20-5280-55-00 Printing and Reproduction 1,000.00 1,000.00 102.72 10.272 897.28 20-5310-55-00 Rental Expense 10,500.00 10,500.00 10,500.00 20-5320-55-00 Repairs & Maintenance 400.00 400.00 29.20 29.20 7.300 370.80 20-5335-55-00 Radio/Video Repairs 9,000.00 9,000.00 9,000.00 20-5340-55-00 Building Repairs 2,000.00 2,000.00 2,000.00 20-5350-55-00 Vehicle Expense 6,000.00 6,000.00 4,364.14 72.736 1,635.86 20-5352-55-00 Fuel 14,000.00 14,000.00 2,999.38 535.39 21.424 11,000.62 20-5353-55-00 Oil/Grease/Inspections 1,500.00 1,500.00 1,500.00 20-5400-55-00 Uniform Expense 5,600.00 5,600.00 1,622.55 471.60 28.974 3,977.45 20-5412-55-00 Audit Fees 500.00 500.00 500.00 20-5416-55-00 Engineering Fees 1,500.00 1,500.00 1,500.00 20-5418-55-00 IT Fees 3,700.00 3,700.00 3,700.00 20-5430-55-00 Legal Fees 500.00 500.00 500.00 20-5480-55-00 Contracted Services 20,000.00 20,000.00 321.00 1.605 19,679.00 20-5520-55-00 Telephones 1,000.00 1,000.00 665.58 92.63 66.558 334.42 20-5521-55-00 Cell Phone Expense 3,400.00 3,400.00 1,403.29 41.273 1,996.71 20-5524-55-00 Gas - Building 8.00 8.00 8.00 20-5525-55-00 Electricity 50,000.00 50,000.00 35,188.60 3,402.65 70.377 14,811.40 20-5530-55-00 Travel/Lodging/Meals Expense 800.00 800.00 800.00 20-5533-55-00 Mileage Expense 500.00 500.00 433.83 86.766 66.17 20-5536-55-00 Training/Seminars 5,100.00 5,100.00 5,100.00 20-5540-55-00 Water Testing 500.00 500.00 500.00 . glbase_pfn1 kaustin Town of Prosper Page 37 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 55 Sewer Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-5560-55-00 Sewer Management Fees 1,160,000.00 1,160,000.00 942,244.62 78,327.42 81.228 217,755.38 20-5620-55-00 Tools & Equipment 5,000.00 2,000.00- 3,000.00 588.32 252.42 19.611 2,411.68 20-5630-55-00 Safety Equipment 8,000.00 8,000.00 920.74 11.509 7,079.26 20-5640-55-00 Signs & Hardware 1,000.00 1,000.00 1,000.00 20-5650-55-00 Maintenance Materials 7,000.00 1,000.00- 6,000.00 23.87 .398 5,976.13 20-5660-55-00 Chemical Supplies 2,000.00 2,000.00 2,000.00 20-5670-55-00 System Improvements/Repairs 30,000.00 30,000.00 15,655.22 52.184 14,344.78 20-5680-55-00 Lift Station Expense 30,000.00 30,000.00 4,829.81 16.099 25,170.19 20-6140-55-00 Capital Expenditure - Equipmen 3,200.00 3,200.00- 20-6160-55-00 Capital Expenditure - Vehicles 35,000.00 5,000.00 40,000.00 34,950.71 87.377 5,049.29 20-7147-55-00 Transfer to GF 214,350.00 214,350.00 196,487.50 17,862.50 91.667 17,862.50 Subtotal: 1,845,348.00 1,845,348.00 1,383,255.67 113,761.02 74.959 462,092.33 Program number: 1,845,348.00 1,845,348.00 1,383,255.67 113,761.02 74.959 462,092.33 Department number: 55 Sewer 1,845,348.00 1,845,348.00 1,383,255.67 113,761.02 74.959 462,092.33 . glbase_pfn1 kaustin Town of Prosper Page 38 16:56 10/16/13 Monthly Budget Report Fund: 20 Water/Sewer Department: 57 Utility Billing Department Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 20-5110-57-00 Salaries & Wages 85,400.00 85,400.00 66,619.53 5,479.70 78.009 18,780.47 20-5115-57-00 Salaries - Overtime 5,000.00 5,000.00 2,853.67 479.46 57.073 2,146.33 20-5140-57-00 Salaries - Longevity Pay 715.00 715.00 715.00 100.000 20-5141-57-00 Salary-Incentive 734.02 734.02- 20-5145-57-00 Social Security Expense 5,010.00 5,010.00 4,301.19 364.71 85.852 708.81 20-5150-57-00 Medicare Expense 935.00 935.00 1,005.94 85.29 107.587 70.94- 20-5155-57-00 SUTA Expense 810.00 810.00 564.30 69.667 245.70 20-5160-57-00 Health Insurance 11,650.00 11,650.00 3,889.75 292.56 33.388 7,760.25 20-5165-57-00 Dental Insurance 750.00 750.00 515.30 36.21 68.707 234.70 20-5170-57-00 AD&D/Life Insurance 245.00 245.00 162.98 11.82 66.522 82.02 20-5175-57-00 Liability (TML) Workers' Comp 265.00 265.00 150.66 56.853 114.34 20-5180-57-00 TMRS Expense 8,950.00 8,950.00 6,832.58 589.10 76.342 2,117.42 20-5185-57-00 Long Term/Short Term Disabilit 900.00 900.00 216.55 24.061 683.45 20-5186-57-00 WELLE-Wellness Prog Reimb-Empl 397.50 35.00 397.50- 20-5190-57-00 Contract Labor 50.00 50.00 50.00 20-5191-57-00 Hiring Cost 80.00 100.00 180.00 143.13 103.13 79.517 36.87 20-5210-57-00 Office Supplies 1,500.00 200.00- 1,300.00 1,103.23 33.50 84.864 196.77 20-5212-57-00 Building Supplies 200.00 200.00 121.65 54.62 60.825 78.35 20-5220-57-00 Office Equipment 8,500.00 8,500.00 4,366.55 932.00 51.371 4,133.45 20-5240-57-00 Postage and Delivery 21,000.00 21,000.00 20,350.43 1,845.27 96.907 649.57 20-5280-57-00 Printing and Reproduction 3,000.00 3,000.00 66.28 66.28 2.209 2,933.72 20-5400-57-00 Uniform Expense 150.00 150.00 150.00 20-5415-57-00 Tuition Reimbursement 3,000.00 1,500.00- 1,500.00 1,112.23 74.149 387.77 20-5418-57-00 IT Fees 8,000.00 8,000.00 1,422.75 564.37 17.784 6,577.25 20-5470-57-00 Trash Collection 668,000.00 668,000.00 629,171.40 64,102.74 94.187 38,828.60 20-5479-57-00 Household Haz. Waste Disposal 2,500.00 2,300.00 4,800.00 3,000.00 800.00 62.500 1,800.00 20-5480-57-00 Contracted Services 10,000.00 10,000.00 7,025.08 495.50 70.251 2,974.92 20-5481-57-00 Cash Short/Over 19.61- 19.61 20-5520-57-00 Telephones 800.00 800.00 679.62 62.76 84.953 120.38 20-5530-57-00 Travel/Lodging/Meals Expense 300.00 300.00 300.00 20-5533-57-00 Mileage Expense 1,500.00 100.00- 1,400.00 73.46 5.247 1,326.54 20-5536-57-00 Training/Seminars 1,100.00 800.00- 300.00 135.00 45.000 165.00 20-7147-57-00 Transfer to GF 80,200.00 80,200.00 73,516.63 6,683.33 91.667 6,683.37 Subtotal: 930,310.00 930,310.00 831,226.80 83,117.35 89.349 99,083.20 Program number: 930,310.00 930,310.00 831,226.80 83,117.35 89.349 99,083.20 Department number: 57 Utility Billing Department 930,310.00 930,310.00 831,226.80 83,117.35 89.349 99,083.20 Expense Subtotal ----------- 7,576,516.00 110,000.00 7,686,516.00 6,635,986.50 1,370,963.86 86.333 1,050,529.50 Fund number: 20 Water/Sewer 324,484.00- 110,000.00 214,484.00- 1,304,317.48- 351,728.10 608.119 1,089,833.48 . glbase_pfn1 kaustin Town of Prosper Page 39 16:56 10/16/13 Monthly Budget Report Fund: 30 Interest and Sinking Department: 10 Administrative Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 30-4105-10-00 Property Taxes -Delinquent 30,000.00- 30,000.00- 43,614.34- 11,620.12- 145.381 13,614.34 30-4110-10-00 Property Taxes -Current 2,724,956.00- 2,724,956.00- 2,706,097.13- 6,171.77- 99.308 18,858.87- 30-4115-10-00 Taxes -Penalties 15,000.00- 15,000.00- 21,729.25- 2,769.09- 144.862 6,729.25 30-4401-10-00 Premium on Issuance of Bonds 8,137.56- 8,137.56 30-4610-10-00 Interest Income 12,000.00- 12,000.00- 15,792.77- 581.34- 131.606 3,792.77 Subtotal: 2,781,956.00- 2,781,956.00- 2,795,371.05- 21,142.32- 100.482 13,415.05 Program number: 2,781,956.00- 2,781,956.00- 2,795,371.05- 21,142.32- 100.482 13,415.05 Department number: 10 Administrative 2,781,956.00- 2,781,956.00- 2,795,371.05- 21,142.32- 100.482 13,415.05 Revenue Subtotal ----------- 2,781,956.00- 2,781,956.00- 2,795,371.05- 21,142.32- 100.482 13,415.05 . glbase_pfn1 kaustin Town of Prosper Page 40 16:56 10/16/13 Monthly Budget Report Fund: 30 Interest and Sinking Department: 10 Administrative Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 30-6189-10-00 2012 GO TX Bond Payment 12,329.79 12,329.79- 30-6191-10-00 2010 Tax Note Payment 364,620.00 364,620.00 364,620.00 11,247.50 100.000 30-6192-10-00 2011 Ref Bond Pmt 181,107.00 181,107.00 181,106.26 6,849.38 100.000 .74 30-6193-10-00 2012 GO Bond Payment 131,148.00 131,148.00 131,146.92 56,205.25 99.999 1.08 30-6197-10-00 04 CO Bond Payment 330,448.00 330,448.00 320,260.00 255,736.00 96.917 10,188.00 30-6198-10-00 2006 Bond Payment 453,743.00 453,743.00 453,742.80 352,871.40 100.000 .20 30-6199-10-00 2008 CO Bond Payment 1,075,416.00 1,075,416.00 1,075,415.63 314,820.00 100.000 .37 30-6200-10-00 Bond Administrative Fees 20,000.00 20,000.00 14,200.00 71.000 5,800.00 Subtotal: 2,556,482.00 2,556,482.00 2,552,821.40 997,729.53 99.857 3,660.60 Program number: 2,556,482.00 2,556,482.00 2,552,821.40 997,729.53 99.857 3,660.60 Department number: 10 Administrative 2,556,482.00 2,556,482.00 2,552,821.40 997,729.53 99.857 3,660.60 Expense Subtotal ----------- 2,556,482.00 2,556,482.00 2,552,821.40 997,729.53 99.857 3,660.60 Fund number: 30 Interest and Sinking 225,474.00- 225,474.00- 242,549.65- 976,587.21 107.573 17,075.65 . glbase_pfn1 kaustin Town of Prosper Page 41 16:56 10/16/13 Monthly Budget Report Fund: 40 Internal Service Fund Department: 10 General Fund Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 40-4100-10-00 Charges for Services 23,475.00- 23,475.00 40-4610-10-00 Interest Income 500.00- 500.00- 789.85- 68.63- 157.970 289.85 40-4995-10-00 Transfer In 81,800.00- 81,800.00- 15,898.35- 1,596.65- 19.436 65,901.65- Subtotal: 82,300.00- 82,300.00- 40,163.20- 1,665.28- 48.801 42,136.80- Program number: 82,300.00- 82,300.00- 40,163.20- 1,665.28- 48.801 42,136.80- Department number: 10 General Fund 82,300.00- 82,300.00- 40,163.20- 1,665.28- 48.801 42,136.80- Revenue Subtotal ----------- 82,300.00- 82,300.00- 40,163.20- 1,665.28- 48.801 42,136.80- . glbase_pfn1 kaustin Town of Prosper Page 42 16:56 10/16/13 Monthly Budget Report Fund: 40 Internal Service Fund Department: 10 General Fund Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 40-5160-10-00 MERP H & D Expense - GF 50,000.00 50,000.00 38,899.26 77.799 11,100.74 Subtotal: 50,000.00 50,000.00 38,899.26 77.799 11,100.74 Program number: 50,000.00 50,000.00 38,899.26 77.799 11,100.74 Department number: 10 General Fund 50,000.00 50,000.00 38,899.26 77.799 11,100.74 Expense Subtotal ----------- 50,000.00 50,000.00 38,899.26 77.799 11,100.74 Fund number: 40 Internal Service Fund 32,300.00- 32,300.00- 1,263.94- 1,665.28- 3.913 31,036.06- . glbase_pfn1 kaustin Town of Prosper Page 43 16:56 10/16/13 Monthly Budget Report Fund: 45 Storm Drainage Utility Fund Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 45-4001-10-00 Storm Drainage Utility Fee 208,000.00- 208,000.00- 204,080.79- 19,383.78- 98.116 3,919.21- 45-4610-10-00 Interest Storm Utility 1,000.00- 1,000.00- 2,207.30- 220.730 1,207.30 Subtotal: 209,000.00- 209,000.00- 206,288.09- 19,383.78- 98.702 2,711.91- Program number: 209,000.00- 209,000.00- 206,288.09- 19,383.78- 98.702 2,711.91- Department number: 10 Administration 209,000.00- 209,000.00- 206,288.09- 19,383.78- 98.702 2,711.91- Revenue Subtotal ----------- 209,000.00- 209,000.00- 206,288.09- 19,383.78- 98.702 2,711.91- . glbase_pfn1 kaustin Town of Prosper Page 44 16:56 10/16/13 Monthly Budget Report Fund: 45 Storm Drainage Utility Fund Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 45-5110-10-00 Salaries 28,000.00 8,000.00- 20,000.00 16,030.23 2,150.40 80.151 3,969.77 45-5115-10-00 Salaries-Overtime 2,000.00 2,000.00 349.44 40.32 17.472 1,650.56 45-5145-10-00 Social Security Expense 1,760.00 1,760.00 976.19 133.65 55.465 783.81 45-5150-10-00 Medicare Expense 425.00 425.00 228.30 31.26 53.718 196.70 45-5155-10-00 SUTA Expense 270.00 270.00 131.79 48.811 138.21 45-5160-10-00 Health Insurance 4,650.00 4,650.00 2,833.68 555.12 60.939 1,816.32 45-5165-10-00 Dental Expense 300.00 300.00 198.56 66.187 101.44 45-5170-10-00 Life Ins/AD&D 95.00 95.00 58.20 7.88 61.263 36.80 45-5175-10-00 Liability (TML) Workers Comp 1,690.00 1,690.00 960.79 56.851 729.21 45-5180-10-00 TMRS Expense 3,125.00 3,125.00 1,689.03 230.02 54.049 1,435.97 45-5185-10-00 Long Tern/Short Term Disabilit 360.00 360.00 360.00 45-5191-10-00 Hiring Cost 40.00 40.00 40.00 100.000 45-5210-10-00 Office Supplies 200.00 200.00 68.86 34.430 131.14 45-5220-10-00 Office Equipment 400.00 400.00 100.00 25.000 300.00 45-5250-10-00 Publications 50.00 50.00 50.00 45-5310-10-00 Rental Expense 8,000.00 5,000.00- 3,000.00 654.75 21.825 2,345.25 45-5320-10-00 Repairs & Maiantenance 1,000.00 5,000.00 6,000.00 6,000.00 45-5340-10-00 Building Repairs 1,000.00 1,000.00- 45-5350-10-00 Vehicle Expense 1,500.00 3,350.00 4,850.00 3,350.00 69.072 1,500.00 45-5352-10-00 Fuel 2,000.00 2,000.00 1,400.19 193.86 70.010 599.81 45-5353-10-00 Oil/Grease/Inspections 400.00 400.00 400.00 45-5400-10-00 Uniforms 1,200.00 1,200.00 541.48 282.25 45.123 658.52 45-5410-10-00 Professional Services-Storm Dr 26,105.00 24,100.00 26,105.00- 45-5430-10-00 Legal Fees 502.47 502.47- 45-5480-10-00 Contract Services 50,000.00 29,000.00 79,000.00 3,250.00 4.114 75,750.00 45-5520-10-00 Telephones 200.00 200.00 200.00 45-5521-10-00 Cell Phone Expense 250.00 250.00 306.21 122.484 56.21- 45-5530-10-00 Travel/Lodging/Meals Expense 200.00 200.00 200.00 45-5536-10-00 Training/Seminars 800.00 800.00 800.00 45-5620-10-00 Tools & Equipment 1,500.00 1,500.00 628.92 41.928 871.08 45-5630-10-00 Safety Equipment 1,000.00 1,000.00 308.49 148.49 30.849 691.51 45-5640-10-00 Signs & Hardware 1,200.00 1,200.00 1,200.00 45-5650-10-00 Maintenance Materials 5,000.00 5,000.00 6,028.42 120.568 1,028.42- 45-6140-10-00 Capital Expenditure 10,000.00 10,000.00 6,295.00 62.950 3,705.00 45-6160-10-00 Capital Expense-Vehicles 3,350.00- 3,350.00- 3,350.00- 45-6193-10-00 2012 CO Bond Payment 106,918.00 106,918.00 106,918.00 33,790.00 100.000 45-7143-10-00 Transfer to Internal Serv. Fd 240.00 240.00 240.00 45-7147-10-00 Transfer to GF 12,540.00 12,540.00 11,495.00 1,045.00 91.667 1,045.00 Subtotal: 248,313.00 20,000.00 268,313.00 191,449.00 62,708.25 71.353 76,864.00 Program number: 248,313.00 20,000.00 268,313.00 191,449.00 62,708.25 71.353 76,864.00 . glbase_pfn1 kaustin Town of Prosper Page 45 16:56 10/16/13 Monthly Budget Report Fund: 45 Storm Drainage Utility Fund Department: 10 Administration Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget Department number: 10 Administration 248,313.00 20,000.00 268,313.00 191,449.00 62,708.25 71.353 76,864.00 Expense Subtotal ----------- 248,313.00 20,000.00 268,313.00 191,449.00 62,708.25 71.353 76,864.00 Fund number: 45 Storm Drainage Utility Fund 39,313.00 20,000.00 59,313.00 14,839.09- 43,324.47 -25.018 74,152.09 . glbase_pfn1 kaustin Town of Prosper Page 46 16:56 10/16/13 Monthly Budget Report Fund: 60 Parks & Recreation Fund Department: 60 Parks and Recreation Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 60-4045-60-00 Park Dedication-Fees 75,000.00- 75,000.00- 141,622.04- 71,200.00- 188.829 66,622.04 60-4055-60-00 Park Improvement 50,000.00- 50,000.00- 239,510.00- 51,000.00- 479.020 189,510.00 60-4530-60-00 Contributions 7,502.00- 7,502.00 60-4610-60-00 Interest Income .04 .04- .04- 60-4615-60-00 Interest-Park Dedication 2,500.00- 2,500.00- 1,287.50- 57.90- 51.500 1,212.50- 60-4620-60-00 Interest-Park Improvements 1,300.00- 1,300.00- 472.67- 84.23- 36.359 827.33- Subtotal: 128,800.00- 128,800.00- 390,394.17- 122,342.17- 303.101 261,594.17 Program number: 128,800.00- 128,800.00- 390,394.17- 122,342.17- 303.101 261,594.17 Department number: 60 Parks and Recreation 128,800.00- 128,800.00- 390,394.17- 122,342.17- 303.101 261,594.17 Revenue Subtotal ----------- 128,800.00- 128,800.00- 390,394.17- 122,342.17- 303.101 261,594.17 . glbase_pfn1 kaustin Town of Prosper Page 47 16:56 10/16/13 Monthly Budget Report Fund: 60 Parks & Recreation Fund Department: 60 Parks and Recreation Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 60-5290-60-00 Miscellaneous Expense 842.15 10.00- 842.15- 60-5410-60-00 Professional Services-Pk Ded 1,816.72 1,716.72 1,816.72- 60-5411-60-00 Professional Services-Pk Imp 20,000.00 20,000.00 20,000.00 60-6002-60-00 Pk Imp'ment fee-Expense 72,187.29 183.70 72,187.29- 60-6120-60-00 Capital Exp-Pk Improvements 600,000.00 600,000.00 35,354.37 18,275.86 5.892 564,645.63 60-6140-60-00 Capital Exp-Pk Dedication 1,000,000.00 1,000,000.00 40,608.50 4.061 959,391.50 60-7144-60-00 Transfer to Capital Projects 65,500.00 65,500.00- Subtotal: 1,620,000.00 1,620,000.00 216,309.03 20,166.28 13.352 1,403,690.97 Program number: 1,620,000.00 1,620,000.00 216,309.03 20,166.28 13.352 1,403,690.97 Department number: 60 Parks and Recreation 1,620,000.00 1,620,000.00 216,309.03 20,166.28 13.352 1,403,690.97 Expense Subtotal ----------- 1,620,000.00 1,620,000.00 216,309.03 20,166.28 13.352 1,403,690.97 Fund number: 60 Parks & Recreation Fund 1,491,200.00 1,491,200.00 174,085.14- 102,175.89- -11.674 1,665,285.14 . glbase_pfn1 kaustin Town of Prosper Page 48 16:56 10/16/13 Monthly Budget Report Fund: 65 Impact Fees Department: 99 Impact Fees Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 65-4015-99-00 Impact Fees -Water 800,000.00- 800,000.00- 658,360.37- 176,090.37- 82.295 141,639.63- 65-4020-99-00 Impact Fees -Sewer 700,000.00- 700,000.00- 436,237.00- 91,675.00- 62.320 263,763.00- 65-4040-99-00 Thoroughfare Impact Fees 1,100,000.00- 1,100,000.00- 1,178,261.76- 326,929.01- 107.115 78,261.76 65-4041-99-00 West Thorfare Imp. Fees Rev 38,197.00- 38,197.00 65-4615-99-00 Interest-Water Impact Fee 4,000.00- 4,000.00- 6,443.80- 318.81- 161.095 2,443.80 65-4620-99-00 Interest-Sewer Impact Fee 4,000.00- 4,000.00- 7,060.18- 146.03- 176.505 3,060.18 65-4640-99-00 Interest-Thorfare Imp Fee 12,000.00- 12,000.00- 19,927.41- 358.88- 166.062 7,927.41 65-4641-99-00 Interest-West Thorfare imp fee 755.43- 75.96- 755.43 Subtotal: 2,620,000.00- 2,620,000.00- 2,345,242.95- 595,594.06- 89.513 274,757.05- Program number: 2,620,000.00- 2,620,000.00- 2,345,242.95- 595,594.06- 89.513 274,757.05- Department number: 99 Impact Fees 2,620,000.00- 2,620,000.00- 2,345,242.95- 595,594.06- 89.513 274,757.05- Revenue Subtotal ----------- 2,620,000.00- 2,620,000.00- 2,345,242.95- 595,594.06- 89.513 274,757.05- . glbase_pfn1 kaustin Town of Prosper Page 49 16:56 10/16/13 Monthly Budget Report Fund: 65 Impact Fees Department: 99 Impact Fees Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 65-5320-99-00 Impact Fee Reimbursement 114,292.00 114,292.00- 65-5415-99-00 Professional Serv-Water Imp Fe 1,220,000.00 1,220,000.00 217,754.77 21,584.77 17.849 1,002,245.23 65-5420-99-00 Professional Serv-Sewer Imp Fe 255,000.00 255,000.00 1,489.04- -.584 256,489.04 65-5440-99-00 Professional Serv-Thorfare Imp 60,000.00 60,000.00 13,305.00 22.175 46,695.00 65-6115-99-00 Capital Expenditure-Water 978,000.00 978,000.00 978,000.00 65-6120-99-00 Capital Expenditure-Sewer 950,000.00 950,000.00 950,000.00 65-6140-99-00 Capital Expenditure-Thorofare 2,700,000.00 2,700,000.00 2,700,000.00 65-7144-99-00 Transfer to Capital Proj Fund 2,951,000.00 2,951,000.00- 65-7145-99-00 Transfer to Escrow(Sp Rev) 891,200.00 891,200.00 891,200.00- Subtotal: 6,163,000.00 6,163,000.00 4,186,062.73 912,784.77 67.922 1,976,937.27 Program number: 6,163,000.00 6,163,000.00 4,186,062.73 912,784.77 67.922 1,976,937.27 Department number: 99 Impact Fees 6,163,000.00 6,163,000.00 4,186,062.73 912,784.77 67.922 1,976,937.27 Expense Subtotal ----------- 6,163,000.00 6,163,000.00 4,186,062.73 912,784.77 67.922 1,976,937.27 Fund number: 65 Impact Fees 3,543,000.00 3,543,000.00 1,840,819.78 317,190.71 51.957 1,702,180.22 . glbase_pfn1 kaustin Town of Prosper Page 50 16:56 10/16/13 Monthly Budget Report Fund: 67 Special Revenue-Donations Department: 10 Administrative Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 67-4030-10-00 Miscellaneous 900.00- 900.00- 900.00 67-4510-10-00 Grants 2,000.00- 2,000.00- 2,000.00- 67-4530-10-00 Police Donation Inc 16,000.00- 16,000.00- 11,598.95- 802.00- 72.493 4,401.05- 67-4531-10-00 Fire Dept-Donation Inc 12,000.00- 12,000.00- 9,315.00- 819.00- 77.625 2,685.00- 67-4532-10-00 Safety Fair Donations 2,000.00- 2,000.00- 2,000.00- 67-4535-10-00 Child Safety Inc 3,000.00- 3,000.00- 8,526.91- 284.230 5,526.91 67-4536-10-00 Court Security Revenue 2,900.00- 2,900.00- 2,415.71- 83.300 484.29- 67-4537-10-00 Technology Fd Revenue 4,000.00- 4,000.00- 3,206.83- 80.171 793.17- 67-4610-10-00 Interest Income 595.98- 595.98- 595.98 67-4721-10-00 Country Xmas Donations 10,000.00- 10,000.00- 6,405.00- 64.050 3,595.00- 67-4915-10-00 Escrow Income 5,161,770.85- 1,152,427.50- 5,161,770.85 67-4916-10-00 Cash Seizure Forfeit-PD 500.00- 500.00- 569.00- 113.800 69.00 Subtotal: 52,400.00- 52,400.00- 5,205,304.23- 1,155,544.48- 9,933.787 5,152,904.23 Program number: 52,400.00- 52,400.00- 5,205,304.23- 1,155,544.48- 9,933.787 5,152,904.23 Department number: 10 Administrative 52,400.00- 52,400.00- 5,205,304.23- 1,155,544.48- 9,933.787 5,152,904.23 Revenue Subtotal ----------- 52,400.00- 52,400.00- 5,205,304.23- 1,155,544.48- 9,933.787 5,152,904.23 . glbase_pfn1 kaustin Town of Prosper Page 51 16:56 10/16/13 Monthly Budget Report Fund: 67 Special Revenue-Donations Department: 10 Administrative Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 67-5202-10-00 Country Xmas Expense 10,000.00 10,000.00 7,307.50 73.075 2,692.50 67-5203-10-00 Court Technology Expense 12,200.00 12,200.00 3,274.60 26.841 8,925.40 67-5204-10-00 Court Security Expense 2,500.00 2,500.00 748.00 68.00 29.920 1,752.00 67-5205-10-00 Police Donation Exp 8,000.00 6,000.00 14,000.00 10,799.80 77.141 3,200.20 67-5206-10-00 Fire Dept Donation Exp 8,000.00 8,000.00 4,439.29 1,085.82 55.491 3,560.71 67-5207-10-00 Health & Safety Fair Exp 1,500.00 1,500.00 1,500.00 67-5208-10-00 Child Safety Expense 1,000.00 2,000.00 3,000.00 2,291.36 76.379 708.64 67-5209-10-00 Escrow Expense 15,500.00 15,500.00 5,559,481.01 615,248.25 ############### 5,543,981.01- 67-5211-10-00 Shattered Dreams Expense 759.43 759.43- 67-5216-10-00 Volunteer Per Diem Expense 1,330.00 150.00 1,330.00- 67-5290-10-00 Miscellaneous Expense 11,453.70 11,453.70- 67-5291-10-00 Special Operations 500.00 500.00 500.00 67-5292-10-00 PD Seizure Expense 4,000.00 4,000.00 2,743.64 68.591 1,256.36 Subtotal: 59,200.00 12,000.00 71,200.00 5,604,628.33 616,552.07 7,871.669 5,533,428.33- Program number: 59,200.00 12,000.00 71,200.00 5,604,628.33 616,552.07 7,871.669 5,533,428.33- Department number: 10 Administrative 59,200.00 12,000.00 71,200.00 5,604,628.33 616,552.07 7,871.669 5,533,428.33- Expense Subtotal ----------- 59,200.00 12,000.00 71,200.00 5,604,628.33 616,552.07 7,871.669 5,533,428.33- Fund number: 67 Special Revenue-Donations 6,800.00 12,000.00 18,800.00 399,324.10 538,992.41- 2,124.064 380,524.10- . glbase_pfn1 kaustin Town of Prosper Page 52 16:56 10/16/13 Monthly Budget Report Fund: 75 Capital Projects Department: 10 Capital Projects Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 75-4510-10-00 Grants 235,000.00- 235,000.00- 1,729,787.50- 736.080 1,494,787.50 75-4530-10-00 Contributions 3,419,724.81- 468,724.81- 3,419,724.81 75-4611-10-00 Interest-2004 Bond 1,000.00- 1,000.00- 2,410.42- 171.96- 241.042 1,410.42 75-4612-10-00 Interest-2006 Bond 1,000.00- 1,000.00- 826.99- 33.72- 82.699 173.01- 75-4613-10-00 Interest 2008 Bond 5,000.00- 5,000.00- 4,335.95- 2,486.88- 86.719 664.05- 75-4615-10-00 Interest-2011 Refd Bond 96.68- 8.11- 96.68 75-4616-10-00 Interest 2012 GO Bond 8,366.47- 881.51- 8,366.47 75-4994-10-00-1302-PK Transfer from Parks 65,500.00- 65,500.00 75-4999-10-00 Bond Proceeds 9,240,000.00- 9,240,000.00 Subtotal: 242,000.00- 242,000.00- 14,471,048.82- 472,306.99- 5,979.772 14,229,048.82 Program number: 242,000.00- 242,000.00- 14,471,048.82- 472,306.99- 5,979.772 14,229,048.82 Department number: 10 Capital Projects 242,000.00- 242,000.00- 14,471,048.82- 472,306.99- 5,979.772 14,229,048.82 Revenue Subtotal ----------- 242,000.00- 242,000.00- 14,471,048.82- 472,306.99- 5,979.772 14,229,048.82 . glbase_pfn1 kaustin Town of Prosper Page 53 16:56 10/16/13 Monthly Budget Report Fund: 75 Capital Projects Department: 10 Capital Projects Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 75-5110-10-00 Salaries & Wages 91,000.00 91,000.00 80,500.00 7,000.00 88.462 10,500.00 75-5141-10-00 Salary - Incentive 216.29 216.29- 75-5145-10-00 Social Security Expense 5,650.00 5,650.00 5,004.41 434.00 88.574 645.59 75-5150-10-00 Medicare Expense 1,325.00 1,325.00 1,170.39 101.50 88.331 154.61 75-5155-10-00 SUTA Expense 360.00 360.00 261.00 72.500 99.00 75-5412-10-00 Professional Serv-2006 Bond 19,857.50 19,857.50- 75-5413-10-00 Professional Serv-2008 Bond 661.25 661.25- 75-5419-10-00-1302-PK Professional Services 1,200.00 1,200.00- 75-5521-10-00 Cell Phone Expense 650.00 650.00 612.81 94.278 37.19 75-5533-10-00 Mileage Expense 600.00 600.00 4,036.26 902.31 672.710 3,436.26- 75-5534-10-00 Project Mgr Expense 1,500.00 1,500.00 1,500.00 75-6111-10-00 Capital Expenditures-2004 Bond 400,000.00 400,000.00 400,000.00 75-6112-10-00 Capital Expenditures-2006 Bond 500,000.00 500,000.00 12,347.50 2.470 487,652.50 75-6113-10-00 Capital Expenditure 2008 Bond 3,500,000.00 3,500,000.00 3,637,498.09 565,705.38 103.929 137,498.09- 75-6115-10-00 Capital Exp-2011 Refd Bond 3,716.65 3,716.65 3,716.65- 75-6116-10-00 Capital Expenditure - WS Prjts 1,562.50 1,562.50- 75-6117-10-00 Capital Expenditures - 2012 GO 473,005.00 210,990.00 473,005.00- 75-6210-10-00 Bond Cost 46,815.19 46,815.19- 75-6410-10-00-1301-PK Land AcquisitionROW 3,795,796.00 3,795,796.00- 75-6610-10-00-1302-PK Construction 16,655.05 16,655.05- 75-7147-10-00 Transfer to GF 55,644.36 55,644.36 55,644.36- Subtotal: 4,501,085.00 4,501,085.00 8,156,560.25 844,494.20 181.213 3,655,475.25- Program number: 4,501,085.00 4,501,085.00 8,156,560.25 844,494.20 181.213 3,655,475.25- Department number: 10 Capital Projects 4,501,085.00 4,501,085.00 8,156,560.25 844,494.20 181.213 3,655,475.25- Expense Subtotal ----------- 4,501,085.00 4,501,085.00 8,156,560.25 844,494.20 181.213 3,655,475.25- Fund number: 75 Capital Projects 4,259,085.00 4,259,085.00 6,314,488.57- 372,187.21 -148.259 10,573,573.57 . glbase_pfn1 kaustin Town of Prosper Page 54 16:56 10/16/13 Monthly Budget Report Fund: 76 Capital Projects - Water/Sewer Department: 10 Capital Projects-W/S Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 76-4610-10-00 Interest Income 54,547.58- 619.02- 54,547.58 76-4995-10-00 Transfer from CP (75) 746,974.19- 746,974.19 Subtotal: 801,521.77- 619.02- 801,521.77 Program number: 801,521.77- 619.02- 801,521.77 Department number: 10 Capital Projects-W/S 801,521.77- 619.02- 801,521.77 Revenue Subtotal ----------- 801,521.77- 619.02- 801,521.77 . glbase_pfn1 kaustin Town of Prosper Page 55 16:56 10/16/13 Monthly Budget Report Fund: 76 Capital Projects - Water/Sewer Department: 10 Capital Projects-W/S Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 76-5419-10-00-1202-WA Professional Services 9,851.45 2,959.01 9,851.45- 76-6610-10-00-1202-WA Construction 3,556,034.87 822,157.00 3,556,034.87- Subtotal: 3,565,886.32 825,116.01 3,565,886.32- Program number: 3,565,886.32 825,116.01 3,565,886.32- Department number: 10 Capital Projects-W/S 3,565,886.32 825,116.01 3,565,886.32- Expense Subtotal ----------- 3,565,886.32 825,116.01 3,565,886.32- Fund number: 76 Capital Projects - Water/Sewer 2,764,364.55 824,496.99 2,764,364.55- . glbase_pfn1 kaustin Town of Prosper Page 56 16:56 10/16/13 Monthly Budget Report Fund: 80 Economic Development Corporati Department: 65 Economic Development Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 80-4120-65-00 Sales Taxes - EDC 466,667.00- 466,667.00- 813,361.53- 157,602.09- 174.292 346,694.53 80-4610-65-00 Interest Income 20,000.00- 20,000.00- 19,829.59- 1,450.19- 99.148 170.41- 80-4910-65-00 Other Revenue 31.29- 31.29 Subtotal: 486,667.00- 486,667.00- 833,222.41- 159,052.28- 171.210 346,555.41 Program number: 486,667.00- 486,667.00- 833,222.41- 159,052.28- 171.210 346,555.41 Department number: 65 Economic Development 486,667.00- 486,667.00- 833,222.41- 159,052.28- 171.210 346,555.41 Revenue Subtotal ----------- 486,667.00- 486,667.00- 833,222.41- 159,052.28- 171.210 346,555.41 . glbase_pfn1 kaustin Town of Prosper Page 57 16:56 10/16/13 Monthly Budget Report Fund: 80 Economic Development Corporati Department: 65 Economic Development Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget 80-5110-65-00 Salaries & Wages 168,110.00 168,110.00 167,529.42 15,076.92 99.655 580.58 80-5141-65-00 Salary-Incentive 35,000.00 35,000.00 35,000.00 80-5145-65-00 Social Security Expense 8,600.00 8,600.00 9,957.12 910.30 115.780 1,357.12- 80-5150-65-00 Medicare Expense 2,450.00 2,450.00 2,328.67 212.89 95.048 121.33 80-5155-65-00 SUTA Expense 540.00 540.00 432.72 80.133 107.28 80-5160-65-00 Health Insurance 4,650.00 4,650.00 6,271.39 1,720.50 134.869 1,621.39- 80-5165-65-00 Dental Insurance 300.00 300.00 358.45 48.28 119.483 58.45- 80-5170-65-00 Life Insurance/AD&D 100.00 100.00 200.83 23.66 200.830 100.83- 80-5175-65-00 Liability (TML) Workers' Comp 765.00 765.00 434.90 56.850 330.10 80-5176-65-00 TML Prop. & Liab Insurance 1,000.00 1,000.00 847.79 84.779 152.21 80-5180-65-00 TMRS Expense 18,600.00 18,600.00 17,420.44 1,607.75 93.658 1,179.56 80-5185-65-00 Long Term/Short Term Disabilit 360.00 360.00 489.56 135.989 129.56- 80-5186-65-00 WELLE-Wellness Prog Reimb-Empl 235.00 235.00 235.00- 80-5189-65-00 Administrative Fees 2,400.00 2,400.00 2,200.00 200.00 91.667 200.00 80-5190-65-00 Contract Labor 10,000.00 700.00 10,700.00 10,636.25 170.00 99.404 63.75 80-5191-65-00 Hiring Cost 40.00 40.00 40.00 100.000 80-5210-65-00 Office Supplies 2,000.00 2,000.00 1,728.15 62.82 86.408 271.85 80-5212-65-00 Building Supplies 500.00 500.00 454.24 90.848 45.76 80-5220-65-00 Office Equipment 4,000.00 460.00 4,460.00 3,619.75 81.160 840.25 80-5230-65-00 Dues,Fees,& Subscriptions 2,500.00 3,000.00 5,500.00 4,964.15 80.94 90.257 535.85 80-5240-65-00 Postage and Delivery 500.00 500.00 257.86 5.80 51.572 242.14 80-5260-65-00 Advertising 3,000.00 3,000.00 3,000.00 100.000 80-5265-65-00 Promotional Expense 20,000.00 20,000.00 40,000.00 38,418.57 1,205.54 96.046 1,581.43 80-5280-65-00 Printing and Reproduction 3,000.00 3,000.00 1,936.94 153.45 64.565 1,063.06 80-5305-65-00 Chapt 380 Program Grant Exp 10,000.00 3,000.00- 7,000.00 6,134.00 87.629 866.00 80-5310-65-00 Rental Expense 27,500.00 500.00 28,000.00 26,891.67 2,498.85 96.042 1,108.33 80-5330-65-00 Copier Expense 1,000.00 2,500.00 3,500.00 3,150.00 400.47 90.000 350.00 80-5340-65-00 Building Repairs 500.00 300.00- 200.00 181.50 90.750 18.50 80-5410-65-00 Professional Services 25,000.00 16,000.00- 9,000.00 7,918.06 3,227.66 87.978 1,081.94 80-5412-65-00 Audit Fees 1,500.00 1,500.00 1,500.00 80-5418-65-00 IT Fees 4,000.00 4,000.00 1,974.65 81.00 49.366 2,025.35 80-5419-65-00 IT Licenses 45.00 45.00 44.35 98.556 .65 80-5430-65-00 Legal Fees 10,000.00 16,955.00 26,955.00 21,599.57 80.132 5,355.43 80-5480-65-00 Contracted Services 100.00 100.00 55.00 55.000 45.00 80-5520-65-00 Telephones 4,800.00 4,800.00 3,996.26 436.90 83.255 803.74 80-5521-65-00 Cell Phone Expense 900.00 1,000.00 1,900.00 1,900.00 80-5524-65-00 Gas-Building 500.00 500.00 191.18 14.82 38.236 308.82 80-5525-65-00 Electricity 2,000.00 2,000.00 1,584.63 232.69 79.232 415.37 80-5530-65-00 Travel/Lodging/Meals Expense 4,000.00 5,000.00 9,000.00 8,425.85 231.56 93.621 574.15 80-5533-65-00 Mileage Expense 2,000.00 2,000.00 770.05 38.503 1,229.95 80-5536-65-00 Training/Seminars 2,500.00 3,000.00 5,500.00 4,334.45 78.808 1,165.55 80-6015-65-00 Project Incentives 104,000.00 396,000.00 500,000.00 755,900.00 255,900.00 151.180 255,900.00- 80-7143-65-00 Transfer to Internal Serv. Fd 405.00 405.00 405.00 . glbase_pfn1 kaustin Town of Prosper Page 58 16:56 10/16/13 Monthly Budget Report Fund: 80 Economic Development Corporati Department: 65 Economic Development Program: Period Ending: 8/2013 Account Description Current Current Currrent Current Current Percent YTD Current Year Year Year YTD Month % Remaining Adopted Budget Amendments Amended Budget Actual Actual Budget Subtotal: 447,980.00 471,000.00 918,980.00 1,116,913.42 284,737.80 121.538 197,933.42- Program number: 447,980.00 471,000.00 918,980.00 1,116,913.42 284,737.80 121.538 197,933.42- Department number: 65 Economic Development 447,980.00 471,000.00 918,980.00 1,116,913.42 284,737.80 121.538 197,933.42- Expense Subtotal ----------- 447,980.00 471,000.00 918,980.00 1,116,913.42 284,737.80 121.538 197,933.42- Fund number: 80 Economic Development Corporati 38,687.00- 471,000.00 432,313.00 283,691.01 125,685.52 65.622 148,621.99 ******* End of Report ********* Page 1 of 2 To: Mayor and Town Council From: Kent R. Austin, Finance Director Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon an ordinance approving a negotiated resolution between the Atmos Cities Steering Committee and Atmos Energy Corporation, Mid-Tex Division, regarding the Company’s 2013 annual rate review mechanism filing in all cities exercising original jurisdiction. Description of Agenda Item: Under state law, Texas cities have original jurisdiction over natural gas rates. The Town of Prosper and approximately 164 other cities comprise the Atmos Cities Steering Committee, or ACSC, a group that collectively reviews and responds to rate requests from Atmos Energy. On July 15 this year, Atmos filed an RRM application with ACSC member cities to increase rates $22.7 million system-wide. ACSC consultants and counsel analyzed the request and negotiated a $16.6 million increase. Action on the part of member cities is required before November 1, 2013, to approve the negotiated results. The impact on the average residential gas bill is estimated at $0.74, or 1.75%. A more detailed explanation is contained in the attached background report provided by ACSC legal counsel Lloyd Gosselink Rochelle & Townsend, P.C. Budget Impact: The Town may pay slightly more for natural gas in Gas-Building (XX-5324-XX). Last year natural gas expenses totaled $2,888. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has reviewed the ordinance as to form and legality. Attached Documents: 1. Background report 2. Ordinance Town Staff Recommendation: Town staff recommends the Town Council approve the ordinance approving the negotiated RRM rate increase. Prosper is a place where everyone matters. FINANCE Item 6 Page 2 of 2 Recommended Motion: I move to approve the ordinance approving a negotiated resolution between the Atmos Cities Steering Committee and Atmos Energy Corp., Mid-Tex Division, regarding the Company’s 2013 annual rate review mechanism filing in all cities exercising original jurisdiction. Item 6 4166249.1 1 BACKGROUND REPORT The Town, along with approximately 164 other cities served by Atmos Energy Mid-Tex Division (“Atmos Mid-Tex” or “Company”), is a member of the Atmos Cities Steering Committee (“ACSC”). On or about July 15, 2013, Atmos Mid-Tex filed with the Town an application to increase natural gas rates pursuant to the Rate Review Mechanism (“RRM”) tariff renewed by the Town in 2013 as a continuation and refinement of the previous RRM rate review process. This is the first annual RRM filing under the renewed RRM tariff. The Atmos Mid-Tex RRM filing sought a $22.7 million rate increase system -wide based on an alleged test-year cost of service revenue deficiency of $25.7 million. The Town worked with ACSC to analyze the schedules and evidence offered by Atmos Mid-Tex to support its request to increase rates. The Ordinance and attached rate tariffs are the result of negotiations between ACSC and the Company to resolve issues raised by ACSC during the review and evaluation of Atmos Mid-Tex’s RRM filing. The Ordinance resolves the Company’s RRM filing by authorizing additional revenues to the Company of $16.6 million system -wide. For purposes of comparison, this negotiated result is about $11 million less than what ACSC’s consultants calculated that Atmos would have been entitled to if Atmos had filed a case under the Gas Reliability Infrastructure Program (“GRIP”) rather than an RRM case. The settlement is expected to increase the average residential customer’s bill by approximately $0.74 per month. An Average Bill Comparison of base rates has been prepared for residential, commercial, industrial, and transportation customers. The ACSC Executive Committee and ACSC legal counsel recommend that all ACSC Cities adopt the Ordinance implementing the rate change. RRM Background: The RRM tariff was originally approved by ACSC Cities as part of the settlement agreement to resolve the Atmos Mid-Tex 2007 system-wide rate filing at the Railroad Commission. In early 2013, the Town adopted a renewed RRM tariff for an additional five years. Atmos Mid-Tex’s July 2013 filing was made pursuant to the renewed RRM tariff. The RRM tariff and the process implementing that tariff were created collaboratively by ACSC and Atmos Mid-Tex as an alternative to the legislatively-authorized GRIP surcharge process. ACSC has opposed GRIP because it constitutes piecemeal ratemaking, does not allow any review of the reasonableness of Atmos’ expenditures, and does not allow participation by cities or recovery of cities’ rate case expenses. In contrast, the RRM process has allowed for a more comprehensive rate review and annual adjustment as a substitute for GRIP filings. ACSC’s consultants have calculated that had Atmos filed under the GRIP provisions, it would have received additional revenues from ratepayers in excess of $28 million. Purpose of the Ordinance: Rates cannot change without the adoption of rate ordinances by cities. No related matter is pending at the Railroad Commission. The purpose of the Ordinance is to approve rates Item 6 4166249.1 2 (shown on “Attachment A” to the Ordinance) that reflect the negotiated rate changes pursuant to the RRM process and to ratify the recommendation of the ACSC Executive Committee. Please make sure that the tariffs are attached when the Ordinance is passed by the Town Council. As a result of the negotiations, ACSC was able to reduce the Company’s requested $22.7 million RRM increase to $16.6 million. Approval of the Ordinance will result in the implementation of new rates that increase Atmos Mid-Tex’s revenues effective November 1, 2013. Reasons Justifying Approval of the Negotiated Resolution: Consultants working on behalf of ACSC Cities have investigated the support for the Company’s requested rate increase. While the evidence does not support the $22.7 million increase requested by the Company, ACSC’s consultants agree that the Company can justify an increase in revenues of some lesser amount. The agreement on $16.6 million is a compromise between the positions of the parties. The alternative to a resolution of the RRM filing would be a GRIP filing by the Company, based upon the Railroad Commission’s decision in the 2012 rate case. A GRIP filing would entitle the Company to receive more than $28 million in additional revenues, with ACSC being precluded from reviewing the reasonableness of the GRIP filing. The ACSC Executive Committee recommends that ACSC members take action to approve the Ordinance authorizing new rate tariffs. No Changes to Residential Customer Charges: For the first annual filing under the revised RRM tariff, the Company agreed to forgo any change to the residential customer charge. Therefore, for the 2013 RRM, the result of the filing will not increase the residential customer charge, and the entirety of the increase to the residential class will be applied to the commodity (natural gas consumption) component of rates. Explanation of “Be It Ordained” Paragraphs: 1. This paragraph approves all findings in the Ordinance. 2. This section adopts the attached tariffs (“Attachment A”) in all respects and finds the rates set pursuant to the attached tariffs to be just, reasonable and in the public interest. Note that only new tariffs or existing tariffs being revised are attached to the Ordinance. Existing tariffs not being changed in any way are not attached to the Ordinance. 3. This section requires the Company to reimburse ACSC for reasonable ratemaking costs associated with reviewing and processing the RRM application. 4. This section repeals any resolution or ordinance that is inconsistent with this Ordinance. Item 6 4166249.1 3 5. This section finds that the meeting was conducted in compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. 6. This section is a savings clause, which provides that if any section(s) is later found to be unconstitutional or invalid, that finding shall not affect, impair or invalidate the remaining provisions of this Ordinance. This section further directs that the remaining provisions of the Ordinance are to be interpreted as if the offending section or clause never existed. 7. This section is a “most favored nations” clause. It provides that if the Company settles with other parties on better terms than agreed to with the ACSC Cities, the ACSC Cities (including the Town) will automatically receive the benefit of those better terms. 8. This section provides for an effective date upon passage. 9. This paragraph directs that a copy of the signed Ordinance be sent to a representative of the Company and legal counsel for ACSC. Item 6 TOWN OF PROSPER, TEXAS ORDINANCE NO. _______ AN ORDINANCE OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, APPROVING A NEGOTIATED RESOLUTION BETWEEN THE ATMOS CITIES STEERING COMMITTEE AND ATMOS ENERGY CORP., MID- TEX DIVISION REGARDING THE COMPANY’S 2013 ANNUAL RATE REVIEW MECHANISM FILING IN ALL CITIES EXERCISING ORIGINAL JURISDICTION; DECLARING EXISTING RATES TO BE UNREASONABLE; ADOPTING TARIFFS THAT REFLECT RATE ADJUSTMENTS CONSISTENT WITH THE NEGOTIATED SETTLEMENT AND FINDING THE RATES TO BE SET BY THE ATTACHED TARIFFS TO BE JUST AND REASONABLE; REQUIRING THE COMPANY TO REIMBURSE CITIES’ REASONABLE RATEMAKING EXPENSES; REPEALING CONFLICTING RESOLUTIONS OR ORDINANCES; DETERMINING THAT THIS ORDINANCE WAS PASSED IN ACCORDANCE WITH THE REQUIREMENTS OF THE TEXAS OPEN MEETINGS ACT; ADOPTING A SAVINGS CLAUSE; DECLARING AN EFFECTIVE DATE; PROVIDING A MOST FAVORED NATIONS CLAUSE; AND REQUIRING DELIVERY OF THIS ORDINANCE TO THE COMPANY AND THE STEERING COMMITTEE’S LEGAL COUNSEL. WHEREAS, the Town of Prosper, Texas (“Town”) is a gas utility customer of Atmos Energy Corp., Mid-Tex Division (“Atmos Mid-Tex” or “Company”), and a regulatory authority with an interest in the rates and charges of Atmos Mid-Tex; and WHEREAS, the Town is a member of the Atmos Cities Steering Committee (“ACSC”), a coalition of approximately 164 similarly situated cities served by Atmos Mid-Tex that have joined together to facilitate the review of and response to natural gas issues affecting rates charged in the Atmos Mid-Tex service area; and WHEREAS, pursuant to the terms of the agreement settling the Company’s 2007 Statement of Intent to increase rates, ACSC Cities and the Company worked collaboratively to develop a Rate Review Mechanism (“RRM”) tariff that allows for an expedited rate review process controlled in a three-year experiment by ACSC Cities as a substitute to the current Gas Reliability Infrastructure Program (“GRIP”) process instituted by the Legislature; and WHEREAS, the Town took action in 2008 to approve a Settlement Agreement with Atmos Mid-Tex resolving the Company’s 2007 rate case and authorizing the RRM tariff; and WHEREAS, in 2013, ACSC and the Company negotiated a renewal of the RRM tariff process for an additional five years; and WHEREAS, the Town passed an ordinance renewing the RRM tariff process for the Town for an additional five years; and WHEREAS, the RRM renewal tariff contemplates reimbursement of ACSC Cities’ reasonable expenses associated with RRM applications; and WHEREAS, on or about July 15, 2013, the Company filed with the Town its first annual RRM filing under the renewed RRM tariff, requesting to increase natural gas base rates by $22.7 million; and Item 6 Ordinance No. ____, Page 2 WHEREAS, ACSC coordinated its review of Atmos Mid-Tex’s RRM filing through its Executive Committee, assisted by ACSC attorneys and consultants, to resolve issues identified by ACSC in the Company’s RRM filing; and WHEREAS, the ACSC Executive Committee, as well as ACSC’s counsel and consultants, recommend that ACSC Cities approve the attached rate tariffs (“Attachment A” to this Ordinance), which will increase the Company’s revenues by $16.6 million; and WHEREAS, the attached tariffs implementing new rates are consistent with the negotiated resolution reached by ACSC Cities and are just, reasonable, and in the public interest. NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS: SECTION 1 That the findings set forth in this Ordinance are hereby in all things approved. SECTION 2 That the Town Council finds the existing rates for natural gas service provided by Atmos Mid-Tex are unreasonable and new tariffs which are attached hereto and incorporated herein as Attachment A, are just and reasonable and are hereby adopted. SECTION 3 That Atmos Mid-Tex shall reimburse the reasonable ratemaking expenses of the ACSC Cities in processing the Company’s RRM application. SECTION 4 That to the extent any resolution or ordinance previously adopted by the Council is inconsistent with this Ordinance, it is hereby repealed. SECTION 5 That the meeting at which this Ordinance was approved was in all things conducted in strict compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. SECTION 6 That if any one or more sections or clauses of this Ordinance is adjudged to be unconstitutional or invalid, such judgment shall not affect, impair or invalidate the remaining provisions of this Ordinance and the remaining provisions of the Ordinance shall be interpreted as if the offending section or clause never existed. Item 6 Ordinance No. ____, Page 3 SECTION 7 That if ACSC determines any rates, revenues, terms and conditions, or benefits resulting from a Final Order or subsequent negotiated settlement approved in any proceeding addressing the issues raised in Atmos’ 2013 RRM filing would be more beneficial to the ACSC Cities than the terms of the attached tariffs, then the more favorable rates, revenues, terms and conditions, or benefits shall additionally and automatically accrue to the ACSC Cities, including the Town, without the need for Town to take any further action. If this automatic adjustment occurs, Atmos Mid-Tex shall promptly thereafter file with the Town an amended tariff documenting the adjustment to rates. SECTION 8 That this Ordinance shall become effective from and after its passage with rates authorized by attached tariffs to be effective for bills rendered on or after November 1, 2013. SECTION 9 That a copy of this Ordinance shall be sent to Atmos Mid-Tex, care of Chris Felan, Manager of Rates and Regulatory Affairs, at Atmos Energy Corporation, 5420 LBJ Freeway, Suite 1862, Dallas, Texas 75240, and to Geoffrey Gay, General Counsel to ACSC, at Lloyd Gosselink Rochelle & Townsend, P.C., P.O. Box 1725, Austin, Texas 78767-1725. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THIS 22ND DAY OF OCTOBER, 2013. _________________________________ Ray Smith, Mayor ATTEST: __________________________________ Robyn Battle, Town Secretary APPROVED AS TO FORM AND LEGALITY: ___________________________________ Terrence S. Welch, Town Attorney Item 6 Item 6 Item 6 Item 6 Item 6 Item 6 Item 6 Item 6 Item 6 Item 6 Page 1 of 1 To: Mayor and Town Council From: Kent R. Austin, Finance Director Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon a resolution accepting and approving the 2013 Tax Roll. Description of Agenda Item: The Texas Property Tax Code, Section 26.09 (e) requires the Town Council to approve the Appraised Roll with tax amounts entered by the Assessor. The Collin County Tax Assessor Collector provided the attached letter and 2013 Tax Roll Summary with a taxable value of $1,534,374,707. Budget Impact: Consistent with budget Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has reviewed the resolution as to form and legality. Approval of this resolution is required by the Texas Property Tax Code, Section 26.09 (e). Attached Documents: 1. Resolution Approving the 2013 Tax Roll Town Staff Recommendation: Town staff recommends that the Town Council approve the resolution approving the 2013 Tax Roll as provided by the Assessor. Recommended Motion: I move to approve the resolution accepting and approving the 2013 Tax Roll. Prosper is a place where everyone matters. FINANCE Item 7 TOWN OF PROSPER, TEXAS RESOLUTION NO. 13-___ A RESOLUTION OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ACCEPTING AND APPROVING THE 2013 APPRAISAL ROLL WITH TAX AMOUNTS ENTERED BY THE ASSESSOR, RESOLVING OTHER MATTERS RELATING TO THE SUBJECT; AND PROVIDING AN EFFECTIVE DATE. WHEREAS, Section 26.09(e) of the Texas Property Tax Code requires the Town Council to approve the Appraisal Roll; and WHEREAS, the Town received notification from the Collin County Tax Assessor Collector as to the Tax Roll jurisdiction summary as of September 26, 2013, and WHEREAS, a summary statement of said 2013 Tax Roll is attached hereto as Exhibit A. NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 All matters stated in the preamble of this Resolution are true and correct and are hereby incorporated into the body of this Resolution as if copied in their entirety. SECTION 2 The Town Council of the Town of Prosper, Texas does hereby accept and approve the 2013 Tax Roll as submitted by the Collin County Tax Assessor Collector. SECTION 3 The attached Exhibit A constitutes the official Town of Prosper 2013 Tax Roll, containing a taxable value of $1,534,374,707. SECTION 4 This Resolution is effective on the date of passage by the Town Council. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 22nd DAY OF OCTOBER, 2013. ___________________________________ Ray Smith, Mayor ATTEST: ____________________________________ Robyn Battle, Town Secretary APPROVED AS TO FORM AND LEGALITY: ____________________________________ Terrence S. Welch, Town Attorney Item 7 EXHIBIT A Item 7 Page 1 of 1 To: Mayor and Town Council From: Kent R. Austin, Finance Director Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon a resolution authorizing various individuals as signers on specific accounts. Description of Agenda Item: Recent changes in Town Finance Department personnel necessitate an updating of the list of authorized individuals to conduct electronic funds transfers (ACH and wire transfers) and access the TexPool and TexSTAR local government investment pools. Staff proposes that Finance Director Kent Austin and Accounting Manager Patricia Featherston be authorized for these functions. Staff also proposes that Town Manager Harlan Jefferson be authorized to conduct ACH and wire transfers. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has reviewed the resolution as to form and legality. Attached Documents: Resolution authorizing various individuals as signers on specific accounts. Town Staff Recommendation: Town staff recommends that the Town Council approve the resolution authorizing signers for electronic funds transfers, TexPool access, and TexSTAR access. Recommended Motion: I move to approve the resolution authorizing various individuals as signers on specific accounts. Prosper is a place where everyone matters. FINANCE Item 8 TOWN OF PROSPER, TEXAS RESOLUTION NO. 13-___ A RESOLUTION OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, AUTHORIZING VARIOUS INDIVIDUALS AS SIGNERS ON SPECIFIC ACCOUNTS; AND PROVIDING AN EFFECTIVE DATE. WHEREAS, periodically the Town updates the list of specific individuals authorized to perform financial transactions on the Town’s behalf; and WHEREAS, it is the intent of the Town Council of the Town of Prosper, Texas, to authorize the following individuals to be signatories and take all appropriate and necessary actions relative to the following Town accounts. NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The individuals named below are hereby authorized to perform financial transactions on the Town’s behalf for the purpose or entity referenced below: Purpose or Entity Name 1 Name 2 Name 3 ACH and wire transfers Kent Austin Patricia Featherston Harlan Jefferson TexPool local government investment pool Kent Austin Patricia Featherston TexSTAR local government investment pool Kent Austin Patricia Featherston SECTION 2 This Resolution shall be effective from and after its passage by the Town Council. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 22ND DAY OF OCTOBER, 2013. ___________________________________ Ray Smith, Mayor ATTEST: ____________________________________ Robyn Battle, Town Secretary APPROVED AS TO FORM AND LEGALITY: ____________________________________ Terrence S. Welch, Town Attorney Item 8 Page 1 of 1 To: Mayor and Town Council From: Hulon T. Webb, Jr., P.E., Executive Director of Development and Community Services Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Update from the Upper Trinity Regional Water District (UTRWD) on the design and construction of the Doe Branch Regional Wastewater Treatment Plant. Description of Agenda Item: The UTRWD will be presenting an update to the Town Council on the schedule for the design and construction of the Doe Branch Regional Wastewater Treatment Plant. The Doe Branch Regional Wastewater Treatment Plant will provide wastewater treatment service for the west side of the Town of Prosper and includes construction of an initial 2 million gallons per day (MGD) treatment facility. The Town of Prosper has requested that 1 MGD be reserved for the Town’s needs. Budget Impact: The estimated $32 million dollar cost for the property, design and construction will be funded by the participants in the plant. Since the Town of Prosper is requesting approximately 50% of the capacity in the initial treatment plant, the cost to the Town of Prosper is approximately $16 million. The funding options available to the Town of Prosper are either to allow the UTRWD to sell bonds on the Town’s behalf and the Town makes annual debt payments to the UTRWD; or, the Town of Prosper sell its own bonds and pay its portion of the costs upfront to the UTRWD. Town Staff Recommendation: Town staff recommends the Town Council receive the presentation from the Upper Trinity Regional Water District and provide any necessary feedback. ENGINEERING Prosper is a place where everyone matters. Item 9 Page 1 of 3 To: Mayor and Town Council From: William Mitchell, M.S., CPRP, Parks and Recreation Manager Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Consider and act upon an ordinance amending Section 1 and Section 7 of the Comprehensive Parks Ordinance of the Town of Prosper, Texas, establishing the Prosper Youth Sports Commission. Description of Agenda Item: At the August 27, 2013, and September 24, 2013, Town Council meetings, Town staff discussed options to achieve the Town Council’s strategic goal to develop a plan to accommodate growth in youth sports. While staff received support for the establishment of the Prosper Youth Sports Commission (PYSC), concerns were raised regarding accountability. After further discussion with other municipalities, the Facility Use Agreement with the PYSC will ensure proper accountability. Through its Facility Use Agreement, the Town will be able to request, at any time, the current by-laws, records, and documentation to determine whether or not to allow PYSC to serve its recreational needs. The following are typical duties required in a Facility Use Agreement to allow the use of Town facilities and ensure solvency:  Insurance  Non-discrimination clause  Code of conduct clause  Coach certifications  Copy of financial audit and other documentation per request  Facility use requirements At the September 24, 2013, Town Council meeting, members of the Town Council raised the idea of the Town Council approving the PYSC By-Laws to provide additional accountability. As part of the ordinance amendment, the PYSC will be required to get approval from the Town Council on adoption and amendment of its by-laws. Town staff recommends amending the current Comprehensive Parks Ordinance to replace the Prosper Sports Committee (PSC) and create the Prosper Youth Sports Commission (PYSC) as follows: PARKS & RECREATION Prosper is a place where everyone matters. Item 10 Page 2 of 3 Section 1 H. League – means an association or group of teams that play one another. Section 7 C. Prosper Youth Sports Commission. There is hereby created and established within Prosper a Prosper Youth Sports Commission (PYSC). 1) Purpose – The purpose of the Prosper Youth Sports Commission (PYSC) is to govern youth sports and interpret the needs and interest of youth involved in community athletics. The PYSC, among other things, coordinates the various local athletic organizations in connection with their use of the Town of Prosper Parks in accordance with the PYSC’s By-Laws, as they currently exist or may be amended. The by-laws, as originally adopted and all amendments, shall be approved by the Town Council. 2) Members – The Prosper Youth Sports Commission (PYSC) should include a delegate from each of the sport leagues, a representative from the Prosper Independent School District (PISD), a representative of the Town of Prosper Parks and Recreation Department, and others deemed in accordance with the PYSC’s By- Laws, as they currently exist or may be amended. Board members shall include a President, Vice President, Treasurer, and Secretary that are not associated with the sports leagues. 3) Leagues – The Prosper Youth Sports Commission (PYSC) may from time to time add additional leagues to address the Town’s youth sports needs. A league rejected from the PYSC shall be able to submit a written request of appeal to the Town’s Parks and Recreation Department. The Town reserves the right to request a league be added or removed from the PYSC at any time without cause. Once the PYSC is established, the Parks and Recreation Department will solicit applications for those interested in serving as the inaugural President, Vice President, Treasurer, and Secretary. Staff recommends setting up a committee comprised of Town staff, a representative from the Prosper Independent School District (PISD), the Mayor, or Mayor’s designee of the Town Council of the Town of Prosper, and the Chair, or Chair’s designee of the Parks and Recreation Board of the Town of Prosper, to select these positions from the applicants received. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has reviewed the ordinance as to form and legality. Attached Documents: 1. Ordinance amending Section 1 and Section 7 of the Comprehensive Parks Ordinance of the Town of Prosper, Texas, establishing the Prosper Youth Sports Commission. Parks and Recreation Board Recommendation: The Parks and Recreation Board was appreciative of Town staff’s research and supports the recommendation of a centralized Board of Directors Model. Item 10 Page 3 of 3 Town Staff Recommendation: Town staff recommends the Town Council approve an ordinance amending Section 1 and Section 7 of the Comprehensive Parks Ordinance of the Town of Prosper, Texas, establishing the Prosper Youth Sports Commission (PYSC). In addition, Town staff requests the Mayor either appointment himself or another member of the Town Council to serve on the selection committee for the inaugural appointments of the President, Vice President, Treasurer, and Secretary to the PYSC. Proposed Motion: I move to adopt an ordinance amending Section 1 and Section 7 of the Comprehensive Parks Ordinance of the Town of Prosper, Texas, establishing the Prosper Youth Sports Commission. Item 10 TOWN OF PROSPER, TEXAS ORDINANCE NO. 13-__ AN ORDINANCE OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, AMENDING ORDINANCE NO. 11-52 (COMPREHENSIVE PARKS ORDINANCE) BY AMENDING THE DEFINITION OF “LEAGUE,” IN SECTION 1, “DEFINITIONS,” THEREOF; AMENDING ORDINANCE NO. 11-52 (COMPREHENSIVE PARKS ORDINANCE) BY REPEALING EXISTING SUBSECTION C, “PROSPER SPORTS ASSOCIATION,” AND SUBSECTION D, “PROSPER SPROTS COMMISSION,” OF SECTION 7, “ATHLETIC FIELDS/FACILITY,” AND REPLACING IT WITH A NEW SUBSECTION C THEREOF, ENTITLED “PROSPER YOUTH SPORTS COMMISSION”; PROVIDING A PENALTY FOR THE VIOLATION OF THIS ORDINANCE; PROVIDING REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. WHEREAS, the Town Council of the Town of Prosper, Texas (“Town Council”), has investigated and determined that Ordinance No. 11-52 of the Town of Prosper, Texas (“Prosper”) should be amended; and WHEREAS, the Town Council found and determined that it will be advantageous, beneficial and in the best interested of the citizens of Prosper to amend Ordinance No. 11-52 as set forth below. NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2 From and after the effective date of this Ordinance, Section 1, “Definitions,” of Ordinance No. 11-52 (Comprehensive Parks Ordinance) is hereby amended to read as follows: “1. Definitions * * * H. League – means an association or group of teams that play one another.” SECTION 3 From and after the effective date of this Ordinance, Subsection C, “Prosper Sports Association,” and Subsection D, “Prosper Sports Committee,” of Section 7, “Athletic Fields/Facility,” of Ordinance No. 11-52 (Comprehensive Parks Ordinance) is hereby repealed and replaced with a new Subsection C to read as follows: Item 10 Ordinance No. 13-__, Page 2 “C. Prosper Youth Sports Commission. There is hereby created and established within Prosper a Prosper Youth Sports Commission (PYSC). 1) Purpose – The purpose of the Prosper Youth Sports Commission (PYSC) is to govern youth sports and interpret the needs and interest of youth involved in community athletics. The PYSC, among other things, coordinates the various local athletic organizations in connection with their use of the Town of Prosper Parks in accordance with the PYSC’s By-Laws, as they currently exist or may be amended. The by-laws, as originally adopted and all amendments thereto, shall be approved by the Town Council. 2) Members – The Prosper Youth Sports Commission (PYSC) should include a delegate from each of the sport leagues, a representative from the Prosper Independent School District (PISD), a representative of the Town of Prosper Parks and Recreation Department, and others deemed necessary in accordance with the PYSC’s By-Laws, as they currently exist or may be amended. Board members shall include a President, Vice President, Treasurer, and Secretary that are not associated with the sports leagues. 3) Leagues – The Prosper Youth Sports Commission (PYSC) may from time to time add additional leagues to address the Town’s youth sports needs. A league rejected from the PYSC shall be able to submit a written request of appeal to the Town’s Parks and Recreation Department. The Town reserves the right to request a league be added or removed from the PYSC at any time without cause.” SECTION 4 All provisions of any ordinance in conflict with this Ordinance are hereby repealed to the extent they are in conflict; but such repeal shall not abate any pending prosecution for violation of the repealed ordinance, nor shall the repeal prevent a prosecution from being commenced for any violation if occurring prior to the repeal of the ordinance. Any remaining portion of conflicting ordinances shall remain in full force and effect. SECTION 5 If any section, subsection, sentence, clause or phrase of this Ordinance is for any reason held to be unconstitutional or invalid by a court of competent jurisdiction, such decision shall not affect the validity of the remaining portions of this Ordinance. Prosper hereby declares that it would have passed this Ordinance, and each section, subsection, clause or phrase thereof, irrespective of the fact that any one or more sections, subsections, sentences, clauses, and phrases be declared unconstitutional. Item 10 Ordinance No. 13-__, Page 3 SECTION 6 Any person, firm, corporation or business entity violating this Ordinance shall be deemed guilty of a misdemeanor, and upon conviction thereof shall be subject to a fine not to exceed the sum of FIVE HUNDRED DOLLARS ($500.00), unless the violation relates to fire safety, zoning or public health and sanitation, including dumping and refuse, in which the fine shall not exceed the sum of TWO THOUSAND DOLLARS ($2,000.00). Each continuing day's violation under this Ordinance shall constitute a separate offense. The penal provisions imposed under this Ordinance shall not preclude Prosper from filing suit to enjoin the violation. Prosper retains all legal rights and remedies available to it pursuant to local, state and federal law. SECTION 7 This Ordinance shall become effective from and after its adoption and publications as required by law. DULY PASSED, APPROVED, AND ADOPTED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 22ND DAY OF OCTOBER, 2013. _____________________________ Ray Smith, Mayor ATTEST: _________________________________ Robyn Battle, Town Secretary APPROVED AS TO FORM AND LEGALITY: _________________________________ Terrence S. Welch, Town Attorney Item 10 Page 1 of 3 To: Mayor and Town Council From: Hulon T. Webb, Jr., P.E., Executive Director of Development and Community Services Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Discussion on Park Development & Open Space Opportunities. Description of Agenda Item:  October 11, 2012, PARBd meeting – The following list of proposed parks and recreation projects for the next year was given to the board to discuss in upcoming meetings. o Completion of Windmill Playground.  Recognition Wall  Shade Sail Structures o Cockrell Park field improvements. o Parking Lot ILA with PISD for soccer field parking lot. o Coit Road (First Street – US 380) median landscaping and irrigation. o First Street (Craig Street – Coit Road) median landscaping and irrigation. o Folsom Park field improvements. o Richland Boulevard (Prosper Commons – Coit Road) median landscaping and irrigation. o Brookhollow and Meadowbrook Park Dedication and Maintenance Agreement. o Reynolds football practice field improvements. o Reynolds baseball/softball field rentals. o Pecan Grove Park improvements. o Frontier Park soccer field lighting east side. o Frontier Park Maintenance Building redesign. o Batting cages at sports fields. o Hike and bike trail connection from La Cima to First Street trailhead. o PISD field improvements (north of high school). o County grants for hike & bike trails. o Preston Lakes playground. o BMX track at Frontier Park. o Skate Park. o Tournament Ordinance. o Community Garden. Prosper is a place where everyone matters. PARKS & RECREATION Item 11 Page 2 of 3  November 8, 2012, PARBd meeting – Board members prioritized the top four proposed projects in the following order: 1. Frontier Park soccer field lighting east side. 2. Cockrell Park field improvements with lights. 3. Parking Lot ILA with PISD for soccer field parking lot (Frontier Park). 4. PISD field improvements (north of high school).  January 10, 2013, PARBd meeting – Staff took the board members on a bus tour of the Town parks.  February 13, 2013, PARBd meeting – Staff presented exhibits and cost estimates for the prioritized projects and requested PARBd’s direction on which prioritized project(s) to proceed with negotiation of a design contract. 1. Frontier Park soccer field lighting east side. 2. Cockrell Park field improvements with lights. 3. Parking Lot ILA with PISD for soccer field parking lot (Frontier Park). 4. PISD field improvements (north of high school). Town staff received the following input: 1. Frontier Park soccer field lighting east side – Move forward with lighting at Frontier Park. 2. Cockrell Park field improvements – Consider site development with regard to grading, grass, irrigation, and walkways. 3. Parking Lot ILA with PISD for soccer field parking lot – Hold a meeting with the Prosper Independent School District to discuss graveling the parking area at Frontier Park. 4. PISD field improvements (north of high school) – No support to move forward with paying for temporary field improvements on the Prosper ISD property, north of Prosper High School.  March 6, 2013, PARBd meeting – Town staff presented additional information to the Board requesting further input. Estimated costs for the prioritized projects were provided at the meeting. 1. Frontier Park soccer field lighting east side. – $400,000. 2. Cockrell Park field improvements. – $1,021,940. ($100,000 included for 4 lights at NW corner). 3. Parking Lot ILA with PISD for soccer field parking lot. – $75,000. After considering the estimated costs and discussing the needs from representatives of the Prosper Youth Sports Association (PYSA) and Prosper Little League (PLL), Town staff received the following revised priority: 1. Frontier Park parking. 2. Design of Cockrell Park. 3. Lighting at Frontier Park soccer field east side. 4. Cockrell Park field lighting. 5. Eagles Landing/Rucker Park improvements. (Coffman Field) 6. Eagles Landing/Rucker Park field lighting. (Boyer Field) Item 11 Page 3 of 3 At the May 9, 2013, Parks and Recreation Board meeting, Drake Dunn, representing Prosper Youth Sports Association (baseball and softball), made a presentation regarding field utilization and registration outlook. He reported that in 2013 there are 56 baseball teams and 12 softball teams. In 2014, he projected 66 baseball teams and 15 softball teams. Based on his projections, he anticipated all game fields being utilized to their maximum capacity by 2015 and practice fields by 2016. Mike Korbuly, representing Prosper Area Soccer Organization, also presented statistics on soccer with a projection of 1,800 players by 2014. He anticipated being good on game fields until 2016 but will need additional practice fields by fall of 2014. While these sports organizations may be able to accommodate additional practice time slots by more efficient utilization of their existing practice times and practice areas, the growing need of other sports leagues (football, lacrosse, etc,) are starting to add additional demands onto the existing developed areas. In addition to the development of Cockrell Park, Town staff has researched other available sites and is presenting the following options for consideration: Site #1: Southwest corner of Frontier Park Site #2: Open space area on the north side of Prosper High School Site #3: Open space area on the north side of Frontier Park Site #4: Sexton Park property Site #5: Open space areas within Eagles Landing Park Budget Impact: The approximate anticipated costs to develop the other available sites are as follows: Site #1: $ 292,000 - Southwest corner of Frontier Park Site #2: $ 545,000 - Open space area on the north side of Prosper High School Site #3: $ 1,222,000 - Open space area on the north side of Frontier Park Site #4: $ 592,000 - Sexton Park property Site #5: $ 159,000 - Open space areas within Eagles Landing Park The original anticipated budget for Cockrell Park in the Capital Improvement Plan was $1,050,000. $650,000 is to be funded from the Park Dedication Fee Fund and $400,000 was from the General Obligations Bond. With the current total estimate for the design and construction of the base bid items for Cockrell Park is anticipated to be around $730,000, the remaining $320,000 could be reallocated to one of these projects. Attached Documents: 1. Site #1: Southwest corner of Frontier Park 2. Site #2: Open space area on the north side of Prosper High School 3. Site #3: Open space area on the north side of Frontier Park 4. Site #4: Sexton Park property 5. Site #5: Open space areas within Eagles Landing Park Parks and Recreation Board Recommendation: At the September 12, 2013, Parks and Recreation Board (PARBd) meeting, PARBd directed Town staff to look at future opportunities to development available open space areas. Town Staff Recommendation: Town staff recommends the Town Council give direction to move forward with the following: 1. Continue development of Cockrell Park. 2. Proceed with the development of Site #1; the southwest corner of Frontier Park. 3. Wait until the Parks Master Plan is updated to identify any further open space improvements to existing parks. Item 11 Site #1: Sth tCost Estimates (SW Frontier)Item Number Description U/M Quantity Unit Cost Total1Turf Establishment S.F. 174,240 0.300$            52,272.00$            2Irrigation S.F. 174,240 0.46$               80,150.40$            3SiteGradingandDrainageLS180 000 00$80 000 00$Southwest corner of Frontier Park3Site Grading and DrainageL.S.180,000.00$    80,000.00$           4Backstops E.A. 3 5,000.00$       15,000.00$            5Design L.S. 1 30,000.00$    30,000.00$            Construction Contingency (15%) 34,113.36$            Project Total291,535.76$     Item 11 Site #2: Open SCost Estimates(North High School)Item NumberDescriptionU/M Quantity Unit Cost Total1Turf EstablishmentS.F. 392,040 0.300$            117,612.00$         2IrrigationS.F. 392,040 0.46$               180,338.40$         3SiteGradingandDrainageLS1100 000 00$100 000 00$Space area north of the High School3Site Grading and DrainageL.S.1100,000.00$ 100,000.00$        4BackstopsE.A. 4 5,000.00$       20,000.00$            5Design65,000.00$            Contingency (15%)62,692.56$            Project Total545,642.96$     Item 11 Site #3: North idfCost Estimates (NORTH FRONTIER)Item NumberDescriptionU/M Quantity Unit Cost Total1Turf EstablishmentS.F. 653,400 0.300$            196,020.00$         2IrrigationS.F. 653,400 0.46$               300,564.00$         3Site Grading and Drainage L.S. 1 250,000.00$  250,000.00$         side of Frontier Park4Gravel Parking L.S. 1 200,000.00$  200,000.00$        5BackstopsE.A 4 5,000.00$       20,000.00$            6DesignL.S. 1110,000.00$         Contingency (15%)144,987.60$         Project Total 1,221,571.60$  Item 11 Site #4: StPkCost Estimates(Sexton Park)Item NumberDescriptionU/M Quantity Unit Cost Total1Turf EstablishmentS.F. 217,800 0.300$            65,340.00$            2IrrigationS.F. 217,800 0.46$               100,188.00$         3SiteGradingandDrainageLS1200 000 00$200 000 00$Sexton Park Property3Site Grading and DrainageL.S.1200,000.00$  200,000.00$        4Gravel Parking L.S. 1 75,000.00$    75,000.00$            5Backstops E.A. 4 5,000.00$       20,000.00$            6Design L.S. 1 62,000.00$    62,000.00$            Construction Contingency (15%) 69,079.20$            Project Total591,607.20$     Item 11 Coffman  FieldldBoyer FieldSite #5: Eagles LdiPkCost Estimates(Eagles Landing)Item NumberDescriptionU/M Quantity Unit Cost Total1Turf EstablishmentS.F. 87,120 0.300$            26,136.00$            Landing Park2Irrigation S.F. 87,120 0.46$              40,075.20$           3Site Grading and Drainage L.S. 1 50,000.00$    50,000.00$            4Design 25,000.00$            Contingency (15%) 17,431.68$            Project Total158,642.88$     Item 11 Page 1 of 2 To: Mayor and Town Council From: Paul Naughton, RLA, Landscape Architect Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – October 22, 2013 Agenda Item: Update on the design of Cockrell Park. Description of Agenda Item:  October 11, 2012 - Parks and Recreation Board (PARBd) members were provided a list of proposed parks and recreation projects for the next year.  November 8, 2013 - PARBd members prioritized the top four proposed projects in the following order: 1. Frontier Park soccer field lighting east side. 2. Cockrell Park field improvements with lights. 3. Parking Lot ILA with PISD for soccer field parking lot (Frontier Park). 4. PISD field improvements (north of high school).  February 13, 2013 - PARBd members discussed Cockrell Park and asked staff to consider site development with regard to grading, grass, irrigation, and walkways.  April 11, 2013 - PARBd recommended Town Council approve the design contract with Freese and Nichols for the design of Cockrell Park.  May 9, 2013 - PARBd recommended the application for the Collin County Open Space Grant to help offset the costs of Cockrell Park.  May 28, 2013 - Town Council approved the design contract with Freese and Nichols for $81,351 for a construction budget of $950,000. This agreement included a concept plan and estimated bid items.  July 11, 2013 - Staff discussed with PARBd the naming of Cockrell Park.  July 23, 2013 - Staff discussed with Town Council an update on the design of Cockrell Park. Council gave staff direction to move forward with the design of all bids and alternates.  August 9, 2013 - Park Board members officially name Cockrell Park.  August 13, 2013 - Town Council gave Town staff direction to proceed with the design of Cockrell Park without the athletic field lighting.  October 7, 2013 - Collin County Open Space notified staff that the Parks and Open Space Board did not recommend county funding participation in Cockrell Park. Staff anticipates design drawings to be complete February 2014. Construction is anticipated to begin in May 2014, with completion to be sometime fall of 2014 and available for scheduled practices spring of 2015. Prosper is a place where everyone matters. PARKS & RECREATION Item 12 Page 2 of 2 The current estimated cost for the project is shown in the table below: Budget Impact: The $81,351 for the design of the project was awarded at the May 28, 2013, Town Council meeting and was funded from the Park Dedication Fee Fund. The original anticipated budget for Cockrell Park in the Capital Improvement Plan was $1,050,000. $650,000 is to be funded from the Park Dedication Fee Fund and $400,000 was from the General Obligations Bond. The current balances of the Park Dedication Fee Fund and Park Improvement Fee Fund are:  Park Dedication: $1,268,997  Park Improvement: $110,671 Attached Documents: 1. Preliminary Design Concept Plan Town Staff Recommendation: Town staff recommends Town Council continue moving forward with the design of Cockrell Park with all bid items and alternates. Final items to be funded at time of bid award, which is anticipated to be presented to the Town Council at the April 22, 2014, Town Council meeting. Item 12 Item 12