Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04.28.2015 Town Council Packet
Page 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. Presentations. Presentation of a Proclamation to members of the Prosper Police Department declaring May 10-16, 2015, as Police Week, and declaring May 15, 2015, as Peace Officers Memorial Day. (RB) Presentation of Certificates of Appreciation to the members of the Centennial Celebration Committee. (RB) Recognition of Steve Arbanas with Gallery Homes as Second Runner-Up, Mark Clary with Megatel Homes as First Runner-Up, and Mark Covington with Drees Homes as the recipient of the Building Inspection’s “2014 Builder of the Year Award”. (TW) 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) Regular Meeting – April 14, 2015 5b. Receive the March 2015 Financial Report. (KG) 5c. Receive the Quarterly Investment Report. (KG) 5d. Consider and act upon approving a renewal to the Bank Depository Services Agreement between Independent Bank and the Town of Prosper; and authorizing the Town Manager to execute same. (KG) 5e. Consider and act upon a resolution reviewing, updating, and adopting the Town of Prosper and Prosper EDC Investment Policy and Investment Strategy. (KG) AGENDA Meeting of the Prosper Town Council Prosper Municipal Chambers 108 W. Broadway, Prosper, Texas Tuesday, April 28, 2015 6:00 p.m. Page 2 of 3 5f. 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. (AG) 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 “Public Meeting Appearance Card” 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 “Public Meeting Appearance Card” 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.) PUBLIC HEARINGS: 7. Conduct a Public Hearing, and consider and act upon a request to amend the Future Land Use Plan, located on the northwest corner of Prosper Trail and the future Shawnee Trail, from Medium Density Residential to Dallas North Tollway District. The property is zoned Single Family-15 (SF-15) and Commercial Corridor (CC). (CA15-0002). [Companion Case Z14-0005] (JW) 8. Conduct a Public Hearing and consider and act upon a request to rezone 67.7± acres, located on the northwest corner of Prosper Trail and Dallas Parkway, from Single Family-15 (SF-15) and Commercial Corridor (CC) to Planned Development-Single Family/Office/Retail (PD-SF/O/R). (Z14-0005). [Companion Case CA15-0002] (JW) 9. 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: 9a. Section 551.087 – To discuss and consider economic development incentives. 9b. 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. 9c. Section 551.071 – Consultation with Town Attorney regarding legal issues associated with proposed extraterritorial jurisdiction release, and all matters incident and related thereto. Page 3 of 3 10. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. 11. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. Update on Town Hall / Multi-Purpose Building. (HW) 12. Adjourn. CERTIFICATION I, the undersigned authority, do hereby certify that this Notice of Meeting was posted at Prosper Town Hall, located at 121 W. Broadway Street, Prosper, Texas 75078, a place convenient and readily accessible to the general public at all times, and said Notice was posted on April 24, 2015, 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 Pursuant to Section 551.071 of the Texas Government Code, the Town Council reserves the right to consult in closed session with its attorney and to receive legal advice regarding any item listed on this agenda. NOTICE Pursuant to Town of Prosper Ordinance No. 13-63, 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. For special services or assistance, please contact the Town Secretary’s Office at (972) 569-1011 at least 48 hours prior to the meeting time. Page 1 of 8 ] Prosper is a place where everyone matters. 1. Call to Order/Roll Call. The meeting was called to order at 6:02 p.m. Council Members Present: Mayor Ray Smith Mayor Pro-Tem Meigs Miller Deputy Mayor Pro-Tem Kenneth Dugger Councilmember Curry Vogelsang, Jr. Councilmember Michael Korbuly Councilmember Mike Davis Council Members Absent: Councilmember 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 John Webb, Director of Development Services Matt Richardson, Senior Engineer Frank Jaromin, Public Works Director Tristan Cisco, Water Conservation Coordinator Will Mitchell, Parks and Recreation Manager Paul Naughton, Landscape Architect Doug Kowalski, Police Chief Gary McHone, Assistance Police Chief Natalee Warren, Dispatch Supervisor 2. Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Pastor John Herring of First Baptist Church of Prosper led the invocation. The Pledge of Allegiance and the Pledge to the Texas Flag were recited. 3. Announcements of upcoming events. Councilmember Mike Davis made the following announcements: This afternoon, the Town held a swearing-in ceremony for its newest members, Officer Carlos Riojas, Officer Jeremy Duerksen, Officer Jason Aguado, and Reserve Officer Anthony Pospick. We are proud to welcome these newest members to our Police Department. Officer Scott Lacagnin was also sworn in as the Municipal Court’s Official Bailiff. MINUTES Regular Meeting of the Prosper Town Council Prosper Municipal Chambers 108 W. Broadway, Prosper, Texas Tuesday, April 14, 2015 Item 5a Page 2 of 8 The second of three water conservation seminars will be held on Monday, April 27, at the Public Works Office, located at 601 West Fifth Street, just west of the Burlington Northern Santa Fe Rail Line. This seminar will cover basic lawn maintenance practices and selecting the right turf grass to improve the health and longevity of the landscape. Attendees will learn how to use less water, fertilizer, and pesticides. The North Texas Municipal Water District is preparing to return to twice-per-week watering beginning May 1, when Stage 3 Seasonal restrictions will be lifted. Residents are encouraged to check sprinkler heads regularly to make sure they are functioning properly, and continue basic water conservation efforts. Questions about water conservation may be directed to Prosper’s Water Conservation Coordinator, Tristan Cisco. This Saturday, April 18, the Town will celebrate “Party at the Park,” the final event of a year-long celebration of Prosper’s 100th birthday. The event will take place at Frontier Park from 2:00-6:00 p.m. and will include food, live music, a kickball tournament, the unveiling of Prosper’s 2014 time capsule, and activities for all ages. Shuttle service will be available from Prosper High School beginning at 1:30 p.m. For more information, please contact Town Secretary Robyn Battle. 4. Proclamations. Presentation of a Proclamation to members of Prosper’s Police Dispatch Personnel declaring the week of April 12-18, 2015, as Telecommunicators Week. Police Chief Doug Kowalski, Assistant Police Chief Gary McHone, and Dispatch Supervisor Natalee Warren were present to receive the proclamation. 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) Regular Meeting – March 24, 2015 Work Session – March 31, 2015 5b. Consider and act upon Ordinance No. 15-19 amending the Future Land Use Plan, on the east side of Main Street, from Third Street to First Street, from Old Town – Office to Old Town – Main Street Retail. (CA15- 0001). [Companion to Case Z15-0001] (JW) 5c. Consider and act upon Ordinance No. 15-20 rezoning 0.8± acre, located on the southeast corner of Main Street and Third Street from Commercial (C) to Downtown Retail (DTR). (Z15-0001). [Companion to case CA15-0001] (JW) 5d. Consider and act upon Resolution No. 15-21 authorizing the Town Attorney to bring a condemnation action for the purpose of obtaining Item 5a Page 3 of 8 sanitary sewer easements, consisting of approximately 5 acres of property, situated generally in the Collin County School Land Survey, Abstract No. 147, Town of Prosper, Collin County and Denton County, Texas, necessary for the construction of the Town’s West Prosper Sanitary Sewer Extension project, and for other public purposes permitted by law. 5e. 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. (AG) Councilmember Vogelsang made a motion and Mayor Pro-Tem Miller seconded the motion to approve all items on the Consent Agenda. The motion was approved by a vote of 6-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 “Public Meeting Appearance Card” and present it to the Town Secretary prior to the meeting.) Other Comments by the Public - 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 “Public Meeting Appearance Card” 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.) PUBLIC HEARINGS: 7. Conduct a Public Hearing, and consider and act upon a request to amend the Future Land Use Plan located 500± feet north of Prosper Trail, 3,000± feet west of Dallas Parkway, from Low Density Residential to Medium Density Residential. (CA15-0003). [Companion to case Z14-0016] (JW) 8. Conduct a Public Hearing, and consider and act upon a request to rezone 9.4± acres, located 500± feet north of Prosper Trail, 3,000± feet west of Dallas Parkway, from Agricultural (A) to Planned Development-Single Family-12.5 (PD- SF-12.5). (Z14-0016). [Companion to case C15-0003] (JW) Development Services Director John Webb presented Items 7 and 8 before the Town Council concurrently. The applicant has requested that Items 7 and 8 be tabled to the May 12, 2015, Town Council meeting to continue work on the final floodplain delineation and to determine final lot boundaries. Item 5a Page 4 of 8 Mayor Pro-Tem Miller made a motion and Deputy Mayor Pro-Tem Dugger seconded the motion to table Items 7 and 8 to the May 12, 2015, Town Council meeting. The motion was approved by a vote of 6-0. 9. Presentation of a service plan and second Public Hearing to consider the annexation of an 18.6± acre tract of land, located on the south side of Prosper Trail, 2,500± feet west of Custer Road. (A15-0001). (AG) Development Services Director John Webb presented this item before the Town Council. This is the second of two required Public Hearings prior to annexation of the property. Mayor Smith opened the Public Hearing. Jack Dixon, 810 Long Valley Court, Prosper, requested that the Council consider preserving as many trees as possible on the property once it is developed. With no one else speaking, Mayor Smith closed the Public Hearing. No further action was taken. DEPARTMENT ITEMS: 10. Discussion on the Earth-Kind Dwarf Shrub Research Garden and Earth-Kind Demonstration Garden. (FJ) Public Works Director Frank Jaromin introduced Dr. Greg Church with the Texas A&M AgriLife Extension Service, who presented information on a proposed Earth- Kind Research and Demonstration project for Prosper. The project is a landscape management system that minimizes the need for fertilizers, pesticides, and irrigation by choosing plants and landscaping that are resistant to disease and drought. Dr. Church focused on several species of dwarf shrubs that will be tested at experimental design gardens at the First Street Water Tower and Rucker Elementary School. The Town Council expressed support for the projects. 11. Consider and act upon authorizing the Town Manager to execute a Facilities Construction, Use and Maintenance Agreement between Preston Lakes Homeowners’ Association, Inc., and the Town of Prosper, Texas, related to maintenance obligations of the right-of-way for Prosper Trail adjacent to the Preston Lakes subdivision and Preston Lakes Park. (HW) Hulon Webb, Executive Director of Development and Community Services, presented this item before the Town Council. The Town currently owns the right-of-way along Prosper Trail adjacent to the Preston Lakes subdivision as well as the Preston Lakes Park property within the development. These properties are both maintained by the Preston Lakes Homeowners’ Association (HOA). The Preston Lakes HOA currently pays the monthly irrigation bill for the park, but not for the right-of-way property. The proposed agreement clarifies the maintenance obligations of the Preston Lakes HOA and the Town related to the right-of-way property and Preston Lakes Park. The right-of-way property and Preston Lakes will continue to be maintained by the Preston Lakes HOA. At Preston Lakes Park, the Town will be responsible for the monthly water bill, and the Town will be allowed to construct and maintain a playground in the future, and maintain the existing perimeter hike and bike trail. Item 5a Page 5 of 8 Councilmember Vogelsang made a motion and Councilmember Davis seconded the motion to authorize the Town Manager to execute a Facilities Construction, Use and Maintenance Agreement between Preston Lakes Homeowners’ Association, Inc., and the Town of Prosper, Texas, related to maintenance obligations of the right-of-way for Prosper Trail adjacent to the Preston Lakes subdivision and Preston Lakes Park. The motion was approved by a vote of 6-0. 12. Consider and act upon a request for a variance to the Subdivision Ordinance regarding Thoroughfare Screening along Windsong Parkway and Gee Road, for Windsong Ranch, Phases 1A, 1B, 1C, 3A-1, and 3B. (V15-0001). (JW) Development Services Director John Webb presented this item before the Town Council. The applicant is requesting a variance to allow for the encroachment of existing utility easements into the required 25-foot landscape buffer in Windsong Ranch, Phases 1A, 1B, 1C, 3A-1, and 3B. The variance request is a result of CoServe Electric finalizing their design for electric infrastructure and requesting various easements be added to the plats. Although there are utility easement encroachments into the required 25-foot landscape buffer, all required landscaping has been provided in accordance with Town standards. The Planning & Zoning Commission recommended approval of the request at their March 17, 2015 meeting, and Town staff recommends approval as well. Deputy Mayor Pro-Tem Dugger made a motion and Councilmember Korbuly seconded the motion to approve a request for a variance to the Subdivision Ordinance regarding Thoroughfare Screening along Windsong Parkway and Gee Road, for Windsong Ranch, Phases 1A, 1B, 1C, 3A-1, and 3B. The motion was approved by a vote of 6-0. 13. Discussion on the Frontier Park North Conceptual Master Plan. (PN) Landscape Architect Paul Naughton presented this item before the Town Council. At the February 10, 2015, Town Council meeting, Dunaway Associates presented conceptual plans for Frontier Park North and Sexton Park. At that meeting, Town staff and Dunaway were directed to focus only on Frontier Park North. Mr. Naughton introduced Elizabeth McIlrath of Dunaway Associates. Councilmember Dugger questioned whether Town staff had included the property at Doe Creek as part of the Parks, Recreation, and Open Space Master Plan. Philip Neely of Dunaway responded the firm was aware of the property, and although it was not part of the scope of this particular part of the project, the property would be incorporated into the Town’s Parks, Recreation, and Open Space Master Plan. Ms. McIlrath continued her presentation on Frontier Park North. Council questioned the reasoning for the 300’ baseball field when the other two fields were 225’. Ms. McIlrath responded that Town staff had requested to include one 300’ field in the concept plan for flexibility for future programming. Ms. McIlrath then reviewed budget projections for natural turf and artificial turf options for the athletic field surfaces. Council’s feedback was to keep all fields at a 225’ foul line, to keep youth sports as an emphasis, to return with a more detailed cost comparison between natural turf and artificial turf, as well as a total cost of ownership between the two options. Mayor Smith recognized the following individual who requested to speak: Item 5a Page 6 of 8 Irwin “Cap” Parry, 850 Kingview Drive, Prosper, provided an estimate of the number of game and practice fields currently available in Prosper, and encouraged the Council to focus funding on other options such as a community center. No further action was taken. Mayor Smith opened Items 14, 15, and 16 concurrently. 14. Consider and act upon authorizing the Town Manager to execute a Professional Engineering Services Agreement between Graham Associates, Inc., and the Town of Prosper, Texas, related to the Prosper Trail (Kroger – Coit) Project and the First Street (Dallas North Tollway – Coleman) project. (MR) Senior Engineer Matt Richardson presented this item before the Town Council. On January 13, 2015, Town staff discussed a priority list of shovel-ready projects with the Town Council, and was directed to begin negotiating an engineering services agreement for the design for two roadway segments: Prosper Trail from the Kroger property to Coit Road, and First Street from the Dallas North Tollway to Coleman Street. Mr. Richardson reviewed the terms of the proposed agreement with Graham Associates. Councilmember Korbuly made a motion and Deputy Mayor Pro-Tem Dugger seconded the motion to authorize the Town Manager to execute a Professional Services Agreement between Graham Associates, Inc., and the Town of Prosper, Texas related to the Prosper Trail (Kroger – Coit) Project and the First Street (Dallas North Tollway – Coleman) project). The motion was approved by a vote of 6-0. 15. Consider and act upon an amendment to the FY 2014-2015 Capital Improvement Plan. (MR) Mr. Richardson continued the presentation on the CIP amendment, which is proposed to provide the funding for the Prosper Trail (Kroger – Coit) Project and the First Street (Dallas North Tollway – Coleman) project. Because these projects are not currently in the CIP, Mr. Richardson explained the amendment to the CIP that would be required to make these projects shovel-ready, and thus, attractive projects for regional funding. Mayor Smith reiterated that regional funding is typically prioritized for shovel-ready projects, so it is to the Town’s advantage to keep the Town’s road projects moving forward in order to receive outside funding. Deputy Mayor Pro-Tem Dugger made a motion and Councilmember Korbuly seconded the motion to approve an amendment to the FY 2014-2015 Capital Improvement Plan. The motion was approved by a vote of 6-0. 16. Consider and act upon an ordinance amending the FY 2014-2015 budget. (KG) Senior Engineer Matt Richardson continued the presentation on the budget amendment. The approved FY 2014-2015 budget and FY 2014-2015 CIP do not include funding for the Prosper Trail (Kroger – Coit) Project and the First Street (Dallas North Tollway – Coleman) projects. Town staff proposed to increase expenditures in the Impact Fee Fund to provide adequate funding for these projects. Item 5a Page 7 of 8 Councilmember Vogelsang made a motion and Deputy Mayor Pro-Tem Dugger seconded the motion to adopt Ordinance No 15-22 amending the FY 2014-2015- budget. The motion was approved by a vote of 6-0. 17. 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: 17a. Section 551.087 – To discuss and consider economic development incentives. 17b. 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. 17c. Section 551.071 – Consultation with Town Attorney regarding legal issues associated with proposed extraterritorial jurisdiction release, bond validation litigation in Travis County regarding Little Elm boundaries and annexations, and all matters incident and related thereto. 17d. Section 551.074 – To discuss appointments to the Planning & Zoning Commission, Parks & Recreation Board, Prosper Economic Development Corporation Board, Board of Adjustment/Construction Board of Appeals, Library Board, and Upper Trinity Regional Water District Board of Directors. The Town Council recessed into Executive Session at 7:37 p.m. 18. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. The Town Council reconvened the Regular Session at 8:32 p.m. No action was taken as a result of Executive Session. 19. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. Councilmember Davis requested that the Council reevaluate the ranking of the Preston Lakes Park playground on the CIP list. Town Manager Harlan Jefferson suggested that this topic be added as a discussion item at the June 30 mid-year budget work session. 20. Adjourn. The meeting was adjourned at 8:34 p.m. These minutes approved on the 28th day of April, 2015. Item 5a Page 8 of 8 APPROVED: Ray Smith, Mayor ATTEST: Robyn Battle, Town Secretary Item 5a Prosper is a place where everyone matters. MONTHLY FINANCIAL REPORT MARCH 2015 Prepared by Finance Department April 24, 2015 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 Contents Dashboard Charts 1 General Fund 3 TIRZ #1 ‐ Blue Star Fund 4 TIRZ #2 ‐ Matthews Southwest 5 Water‐Sewer Fund 6 Interest and Sinking Fund 7 Internal Service Fund 8 Vehicle and Equipment Replacement Fund 9 Storm Drainage Utility Fund 10 Park Dedication and Improvement Fund 11 Water Impact Fees Fund 12 Wastewater Impact Fees Fund 13 Thoroughfare Impact Fees Fund 14 Special Revenue Fund 15 Capital Projects Fund‐General 16 Capital Projects Fund‐Water/Sewer 17 Detail‐All Funds 18 Legend "Compare to" refers to percentage of fiscal year completed‐e.g., 50% = 6/12, or March. Parentheses around a number indicate credit amount or gain‐e.g., Sales Taxes (1,506,401) Red, yellow, and green traffic lights indicate status of number compared to percentage of fiscal year completed‐e.g., Sales Taxes 51.52 Item 5b $‐ $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept Town of Prosper, Texas Sales Tax Revenue by Month FY 12/13 FY 13/14 FY 14/15 $1,950,000 $975,000 $1,084,188 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,00 Total Budget YTD Budget YTD Actual Building Permit Revenues 1 Item 5b $14,726,379 $7,363,190 $6,027,102 $14,506,034 $7,253,017 $10,813,309 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 Total Budget YTD Budget YTD Actual General Fund Revenues and Expenditures Revenues Expenditures Water ‐Sewer Fund Revenues and Expenditures $10,424,679 $5,212,340 $4,363,055 $10,295,293 $5,147,647 $4,363,846 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 Total Budget YTD Budget YTD Actual Revenues Expenditures 2 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:7,587,994$ Percent YTD Amended Budget YTD Actual Month Actual % GENERAL FUND [1] Property Taxes ‐Current (6,865,290) (6,531,934) (72,727) 95.14 Sales Taxes (2,923,823) (1,506,401) (205,338) 51.52 [2] Franchise Fees (562,000) (226,790) (38) 40.35 Building Permits (1,950,000) (1,084,188) (208,725) 55.60 Fines (245,000) (136,240) (22,039) 55.61 [3] Other (1,959,921) (1,327,756) (209,724) 67.75 Total Revenues (14,506,034) (10,813,309) (718,590) 74.54 [4] 01 Town Manager 671,741 365,583 67,852 54.42 02 Town Secretary 213,632 90,362 21,728 42.30 [4]03 Finance 781,143 411,583 60,365 52.69 04 Human Resources 230,814 102,403 17,070 44.37 70 Municipal Court 204,122 98,467 15,198 48.24 Subtotal Administration 2,101,452 1,068,397 182,214 50.84 20 Police 2,018,872 739,122 124,228 36.61 25 Dispatch 664,620 289,510 33,300 43.56 Subtotal Police 2,683,492 1,028,632 157,528 38.33 30 Fire/EMS 3,451,061 1,165,624 197,138 33.78 35 Fire Marshal 144,158 54,556 9,071 37.84 Subtotal Fire 3,595,219 1,220,180 206,209 33.94 40 Streets 448,935 214,720 33,959 47.83 45 Public Library 176,392 64,971 10,979 36.83 60 Parks and Recreation 1,642,315 627,757 115,022 38.22 80 Inspections 964,717 375,871 59,428 38.96 85 Code Enforcement 164,583 67,483 5,668 41.00 90 Planning 540,217 207,209 52,883 38.36 Subtotal Development Services 1,669,517 650,562 117,979 38.97 98 Engineering 703,938 308,723 50,553 43.86 99 Non‐departmental 1,705,119 843,159 126,409 49.45 Total Expenses 14,726,379 6,027,102 1,000,852 40.93 (Gain)/Loss 220,345 (4,786,208) 282,262 Ending Fund Balance, Current Month:12,374,202$ * [1] [2] [3] [4] Property taxes are billed in October, and the majority of collections occur December through February. In February, $96,175 was received for the annual gas franchise fee payments from Atmos and CoServ. Other year to date amounts include $78,117 for telephone franchise fees and $38,634 for electric franchise fees. The electric franchise fee from Oncor is received annually in June. Other Revenue includes an estimate of $237,170 for ambulance charges for service. The Town Manager and Finance divisions include one‐time salary payouts. In addition, in Finance the cost of IT and other contracted services are greater than expected. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 3 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:‐$ Percent YTD Amended Budget YTD Actual Month Actual % [1]TIRZ #1 ‐ BLUE STAR Property Taxes ‐ ‐ ‐ ‐ Other Revenue ‐ ‐ ‐ ‐ Transfer In ‐ ‐ ‐ ‐ Total Revenue ‐ ‐ ‐ ‐ Professional Services ‐ 7,500 ‐ ‐ Transfers Out ‐ ‐ ‐ ‐ Total Expenses ‐ 7,500 ‐ ‐ (Gain)/Loss ‐ 7,500 ‐ Ending Fund Balance, Current Month:(7,500)$ * [1] The TIRZ #1 Fund is new and has not received any tax revenue from the zone's tax increment. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 4 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:‐$ Percent YTD Amended Budget YTD Actual Month Actual % [1]TIRZ #2 ‐ MATTHEWS SOUTHWEST Property Taxes ‐ ‐ ‐ ‐ Other Revenue ‐ ‐ ‐ ‐ Transfer In ‐ ‐ ‐ ‐ Total Revenue ‐ ‐ ‐ ‐ Professional Services ‐ ‐ ‐ ‐ Transfers Out ‐ ‐ ‐ ‐ Total Expenses ‐ ‐ ‐ ‐ (Gain)/Loss ‐ ‐ ‐ Ending Fund Balance, Current Month:‐$ * [1] The TIRZ #2 Fund is new and has not received any tax revenue from the zone's tax increment. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 5 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Working Capital, 10/1/2014:6,281,701$ Percent YTD Amended Budget YTD Actual Month Actual % WATER‐SEWER FUND [1] Water revenues (6,281,250) (2,406,109) (304,205) 38.31 Sewer revenues (2,997,000) (1,404,415) (238,793) 46.86 Sanitation revenues (1,017,043) (553,323) (92,245) 54.41 Total Revenues (10,295,293) (4,363,846) (635,243) 42.39 [2] 50 Water 3,752,848 1,514,775 (629,994) 40.36 55 Sewer 1,725,500 848,032 119,149 49.15 57 Utility Billing 1,033,566 451,101 88,978 43.65 99 Non‐departmental 3,912,765 1,549,147 968,030 39.59 Total Expenses 10,424,679 4,363,055 546,163 41.85 (Gain)/Loss 129,386 (791) (89,080) Ending Working Capital, Current Month:6,282,492$ * [1]Water revenues are cyclical and vary by month, as shown in the table below: Percent of Sales by Month Year to Date October 8.65%8.65% November 7.51%16.16% December 4.96%21.12% January 4.04%25.16% February 4.02%29.18% March 4.30%33.48% April 5.88%39.36% May 7.17%46.53% June 9.59%56.12% July 13.57% 69.69% August 16.41% 86.10% September 13.91% 100.00% [2] In February, the semi‐annual debt payments were recorded in the Water division, as done in prior years. However, beginning in FY2015 these payments are budgeted in Non‐departmental. March transactions reflect the correction. * Working Capital does not reflect encumbrances, commitments, or budgeted expenditures. 6 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:1,158,927$ Percent YTD Amended Budget YTD Actual Month Actual % INTEREST and SINKING FUND Property Taxes ‐Delinquent (50,000) (47,286) (11,616) 94.57 [1] Property Taxes ‐Current (2,870,065) (3,001,034) (33,414) 104.56 [2] Taxes ‐Penalties (20,000) (9,687) (3,442) 48.43 Interest Income (15,000) (12,039) (2,748) 80.26 Total Revenues (2,955,065) (3,070,045) (51,221) 103.89 [3] 2013 GO Ref Bond 287,200 68,600 ‐ 23.89 2010 Tax Note Payment 370,175 363,919 ‐ 98.31 2011 Ref Bond Payment 176,616 172,892 ‐ 97.89 2012 GO Bond Payment 112,413 56,206 ‐ 50.00 2006 Bond Payment 453,413 89,906 ‐ 19.83 2008 CO Bond Payment 1,079,049 785,993 ‐ 72.84 Bond Administrative Fees 21,000 1,600 400 7.62 2014 GO Bond Payment 370,199 102,593 ‐ 27.71 Total Expenses 2,870,065 1,641,709 400 57.20 (Gain)/Loss (85,000) (1,428,336) (50,821) Ending Fund Balance, Current Month:2,587,263$ * [1] [2] Revenue is net of refunds related to penalties. During the first several months of the fiscal year, refunds were greater than penalties collected. [3] Year to date actuals reflect semi‐annual debt payments made on February 15. Property taxes are billed in October and the majority of collections occur December through February. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 7 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:100,303$ Percent YTD Amended Budget YTD Actual Month Actual % INTERNAL SERVICE FUND‐MEDICAL EXPENSE REIMBURSEMENT PROGRAM [1] Charges for Services (25,000) (8,550) (1,395) 34.20 Interest Income (250) (322) (54) 128.74 [1] Transfer In (19,400) (1,200) (200) 6.19 Total Revenue (44,650) (10,072) (1,649) 22.56 [2] MERP H & D Expense 30,000 2,800 ‐ 9.33 Total Expenses 30,000 2,800 ‐ 9.33 (Gain)/Loss (14,650) (7,272) (1,649) Ending Fund Balance, Current Month:107,575$ * [1]Beginning in FY 2014, contributions from the General Fund were discontinued. Based on recent trends, the ISF is currently able to absorb costs by using existing fund balance. This fund continues to receive small monthly contributions from the Water‐Sewer and Drainage funds. [2] Expenses vary throughout the year based on actual claims activity. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 8 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:800,000$ Percent YTD Amended Budget YTD Actual Month Actual % VEHICLE AND EQUIPMENT REPLACEMENT FUND Charges for Services (486,195) (267,011) (44,502) 54.92 [1] Other Reimbursements (50,000) (9,976) ‐ 19.95 [2] Transfers In (800,000) ‐ ‐ ‐ Total Revenue (1,336,195) (276,987) (44,502) 20.73 Vehicle Replacement 552,000 ‐ ‐ ‐ Equipment Replacement 95,000 ‐ ‐ ‐ I/T Equipment Replacement 150,010 7,305 1,945 4.87 Total Expenses 797,010 7,305 1,945 0.92 (Gain)/Loss (539,185) (269,682) (42,557) Ending Fund Balance, Current Month:1,069,682$ * [1]Auction revenues and insurance reimbursements are placed in the Other Reimbursements account as they occur. [2]The Vehicle and Equipment Replacement Fund (VERF) was established in FY 2014 with an $800,000 transfer from fund balance in the General Fund; a second transfer is scheduled in FY 2015 for the same amount. These transfers provide start‐up funding for vehicle, field equipment, and computer equipment replacements scheduled for FY 2015. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 9 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Working Capital, 10/1/2014:226,167$ Percent YTD Amended Budget YTD Actual Month Actual % STORM DRAINAGE UTILITY FUND 0‐00 Storm Drainage Utility Fee (270,400) (133,683) (22,485) 49.44 0‐00 Interest Storm Utility (1,600) (247) (51) 15.45 Total Revenue (272,000) (133,930) (22,537) 49.24 Personnel Expenses 107,898 24,273 6,948 22.50 [1] Program Expenses 198,297 99,377 3,923 50.12 Total Expenses 306,195 123,650 10,871 40.38 (Gain)/Loss 34,195 (10,280) (11,666) Ending Working Capital, Current Month:236,447$ * [1] Program Expenses budget includes a $96,680 debt service payment for a share of the 2012 Certificates of Obligation. Year to date transactions include $63,490. The remainder is due August 15. * Working Capital does not reflect encumbrances, commitments, or budgeted expenditures.g p ,, g p 10 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:2,371,058$ Percent YTD Amended Budget YTD Actual Month Actual % PARK DEDICATION AND IMPROVEMENT FUND 0‐00 Park Dedication‐Fees (200,000) (18,280) ‐ 9.14 0‐00 Park Improvement (300,000) (18,000) ‐ 6.00 0‐00 Interest‐Park Dedication (1,500) (2,600) (482) 173.33 0‐00 Interest‐Park Improvements (500) (2,062) (376) 412.45 Total Revenue (502,000) (40,942) (858) 8.16 0‐00Miscellaneous Expense ‐ 60 10 ‐ 0‐00Professional Services‐Pk Improvements 831 ‐ ‐ ‐ 0‐00Capital Exp‐Pk Improvements 125,000 ‐ ‐ ‐ 0‐00Capital Exp‐Pk Dedication 89,000 900 ‐ 1.01 Total Expenses 214,831 960 10 0.45 (Gain)/Loss (287,169) (39,982) (848) Ending Fund Balance, Current Month:2,411,040$ * * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 11 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:4,003,571$ Percent YTD Amended Budget YTD Actual Month Actual % WATER IMPACT FEES FUND 9‐00 Impact Fees ‐Water (2,145,000) (1,118,453) (284,527) 52.14 9‐00 Interest‐Water Impact Fee (3,500) (8,270) (1,732) 236.29 Total Revenue (2,148,500) (1,126,723) (286,259) 52.44 Capital Expenditure‐Water 926,887 71,013 10,590 7.66 Total Expenses 926,887 71,013 10,590 7.66 (Gain)/Loss (1,221,613) (1,055,710) (275,669) Ending Fund Balance, Current Month:5,059,281$ * * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 12 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:2,329,812$ Percent YTD Amended Budget YTD Actual Month Actual % WASTEWATER IMPACT FEES FUND 9‐00 Impact Fees ‐Wastewater (375,650) (203,358) (37,565) 54.13 9‐00 Interest‐Wastewater Impact Fee (1,500) (4,617) (810) 307.82 Total Revenue (377,150) (207,975) (38,375) 55.14 Capital Expenditure ‐ Wastewater 137,612 ‐ ‐ ‐ Total Expenses 137,612 ‐ ‐ ‐ (Gain)/Loss (239,538) (207,975) (38,375) Ending Fund Balance, Current Month:2,537,787$ * * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 13 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:3,682,746$ Percent YTD Amended Budget YTD Actual Month Actual % THOROUGHFARE IMPACT FEES FUND 9‐00 Thoroughfare Impact Fees (1,444,000) (676,011) (181,519) 46.82 9‐00 West Thoroughfare Impact Fees ‐ (436,232) (119,264) ‐ 9‐00 Interest‐Thoroughfare Impact Fee (3,500) (3,388) (604) 96.79 9‐00 Interest‐West Thoroughfare Impact Fee (1,000) (1,197) (208) 119.70 Total Revenue (1,448,500) (1,116,828) (301,595) 77.10 9‐00 Professional Svcs.‐Thoroughfare 4,750 5,042 ‐ 106.14 [1] Professional Svcs.‐West Thoroughfare ‐ 7,778 ‐ ‐ 9‐00 Capital Exp.‐Thoroughfare 1,973,000 95,440 ‐ 4.84 [1] Capital Exp.‐West Thoroughfare ‐ 281,200 ‐ ‐ 9‐00 Total Expenses 1,977,750 389,459 ‐ 19.69 (Gain)/Loss 529,250 (727,369) (301,595) Ending Fund Balance, Current Month:4,410,115$ * [1] Year to date expenditures include $286,478 to DCFWSD #10 from West Thoroughfare Impact Fees for the Town's participation in the Teel Parkway Paving and Drainage Improvements project. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 14 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:2,283,679$ Percent YTD Amended Budget YTD Actual Month Actual % SPECIAL REVENUE FUND Police Donation Inc (8,000) (8,014) (740) 100.18 Fire Dept‐Donation Inc (9,360) (9,497) (5,755) 101.46 Child Safety Inc (7,000) (6,358) ‐ 90.83 Court Security Revenue (5,280) (2,556) (432) 48.40 Court Technology Revenue (7,020) (3,392) (576) 48.31 LEOSE Revenue ‐ (1,543) (1,543) ‐ Interest Income (3,720) (1,950) (342) 52.41 Country Xmas Donations (10,000) (11,265) ‐ 112.65 Escrow Income ‐ (547,461) (356,503) ‐ Cash Seizure/Forfeiture ‐ (13,421) ‐ ‐ [1] Transfer In ‐ (20,000) ‐ ‐ Total Revenue (50,380) (625,455) (365,891) 1,241.47 [1] Country Xmas Expense 30,000 28,920 103 96.40 [2] Court Technology Expense 13,133 12,931 ‐ 98.46 Court Security Expense 4,000 357 71 8.93 [3] Police Donation Expense 6,000 4,150 ‐ 69.17 Fire Donation Expense ‐ 3,897 3,425 ‐ Child Safety Expense 25,000 5,789 5,789 23.15 Tree Mitigation Expense 14,000 ‐ ‐ ‐ LEOSE (Law Enforcement Education)‐ ‐ (590) ‐ PD Seizure Expense 3,000 ‐ ‐ ‐ Total Expenses 95,133 56,043 8,797 58.91 (Gain)/Loss 44,753 (569,412) (357,093) Ending Fund Balance, Current Month:2,853,091$ * [1] The total cost of the Christmas Festival is now shown in one place. In prior years expenses were also reflected in the General Fund. [2] Court Technology expense includes $9,274 for two ticket writers, licensing, and software, for Code Enforcement and the Fire Department. [3] Police Donation expenses include $3,850 for Cops with a Clause and $300 for Safe Driver Recognition. * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 15 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Fund Balance, 10/1/2014:5,398,836$ Percent YTD Amended Budget YTD Actual Month Actual % CAPITAL PROJECTS FUND‐GENERAL [1] Contributions (19,696,900) (450,000) ‐ 2.28 Interest‐2004 Bond (1,500) (1,016) (175) 67.73 Interest‐2006 Bond (100) (207) (43) 206.63 Interest‐2008 Bond (5,000) (6,785) (1,157) 135.70 Interest‐2012 GO Bond (5,000) (5,289) (965) 105.79 [2] Transfers In (1,140,000) (523,500) (87,250) 45.92 Total Revenues (20,848,500) (986,797) (89,590) 4.73 [1] Capital Expenditures 28,482,055 2,828,406 262,433 9.93 Total Expenditures 28,482,055 2,828,406 262,433 9.93 (Gain)/Loss 7,633,555 1,841,609 172,844 Ending Fund Balance, Current Month:3,557,227$ * [1] In February the Town received Collin County's $450,000 contribution toward the Cockrell Park land acquisition. Year to date expenses include the total purchase cost of $1.037 million. [2]TfI ild GlFd thl tibti td$972 000 d b CilfPt Rd[2]Transfers In includes General Fund monthly contributions toward $972,000 approved by Council for Preston Road Illumination ($415,000), Downtown Enhancements ($75,000), Central Irrigation Control for Parks ($57,000), and Southwest Corner Field Lighting at Frontier Park ($425,000). * Fund balance does not reflect encumbrances, commitments, or budgeted expenditures. 16 Item 5b TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT MARCH 2015 COMPARE TO:50.00% Working Capital, 10/1/2014:2,387,634$ Percent YTD Amended Budget YTD Actual Month Actual % CAPITAL PROJECTS FUND‐WATER/SEWER Interest Income (25,500) (17,318) (2,894) 67.91 [1] Other Revenue ‐ (28,740) (8,622) ‐ [2] Transfers In (379,081) (67,041) (11,173) 17.69 Total Revenue (404,581) (113,098) (22,689) 27.95 [3] Construction 2,382,500 404,487 ‐ 16.98 Total Expenses 2,382,500 404,487 ‐ 16.98 (Gain)/Loss 1,977,919 291,389 (22,689) Ending Working Capital, Current Month:2,096,245$ * [1]This amount is for a developer reimbursement related to the West Side Utilities project. [2]The budget of $379,081 includes $245,000 from the Water and Sewer Fund for LaCima Lift Station #1, $127,081 from Water Impact Fees for Lower Pressure Plane Pump Station and Water Line, and $7,000 from the Storm Drainage Utility Fund for Crooked Stick drainage improvements. Because the La Cima Lift Station project is no [3] Year to date expenses include $230,928 for Custer Road Pump Station Improvements and $170,288 for 30" Upper Plane Water Line. longer expected to become active during FY 2015, transfers will not be made for this project. * Working Capital does not reflect encumbrances, commitments, or budgeted expenditures. 17 Item 5b TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐4035‐10‐00 3% Construction Fee (100,000.00) (100,000.00) (328,233.18) (26,553.86) 328.23 228,233.18 10‐4061‐10‐00 Notary Fees (200.00) (200.00) (125.00) (3.00) 62.50 (75.00) 10‐4105‐10‐00 Property Taxes ‐Delinquent (75,000.00) (75,000.00) (76,773.21) (18,849.86) 102.36 1,773.21 10‐4110‐10‐00 Property Taxes ‐Current (6,865,290.00) (6,865,290.00) (6,531,934.28) (72,727.27) 95.14 (333,355.72) 10‐4115‐10‐00 Taxes ‐Penalties (30,000.00) (30,000.00) (21,003.59) (6,408.51) 70.01 (8,996.41) 10‐4120‐10‐00 Sales Taxes (2,923,823.00) (2,923,823.00) (1,506,401.31) (205,337.56) 51.52 (1,417,421.69) 10‐4130‐10‐00 Sales Tax‐Mixed Beverage (10,000.00) (10,000.00) (3,034.94) 30.35 (6,965.06) 10‐4140‐10‐00 Franchise Taxes ‐ Electric (345,000.00) (345,000.00) (38,634.36) 11.20 (306,365.64) 10‐4150‐10‐00 Franchise Taxes ‐ Telephone (125,000.00) (125,000.00) (78,117.06) (37.54) 62.49 (46,882.94) 10‐4160‐10‐00 Franchise Taxes ‐ Gas (68,500.00) (68,500.00) (96,174.80) 140.40 27,674.80 10‐4170‐10‐00 Franchise Taxes ‐ Road Usage (3,500.00) (3,500.00) (2,809.36) 80.27 (690.64) 10‐4190‐10‐00 Franchise Fee‐Cable (20,000.00) (20,000.00) (11,054.84) 55.27 (8,945.16) 10‐4200‐10‐00 T‐Mobile Fees (23,808.00) (23,808.00) (11,902.50) (1,983.75) 49.99 (11,905.50) 10‐4201‐10‐00 Tierone Converged Network (18,000.00) (18,000.00) (9,000.00) (1,500.00) 50.00 (9,000.00) 10‐4202‐10‐00 NTTA Tag Sales (150.00) (150.00) (60.00) 40.00 (90.00) 10‐4205‐10‐00 Internet America (18,000.00) (18,000.00) (9,000.00) (1,500.00) 50.00 (9,000.00) 10‐4218‐10‐00 Administrative Fees‐EDC (7,500.00) (7,500.00) (3,750.00) (625.00) 50.00 (3,750.00) 10‐4230‐10‐00 Other Permits (60.00) ‐ 60.00 10‐4610‐10‐00 Interest Income (50,000.00) (50,000.00) (17,581.34) (4,208.36) 35.16 (32,418.66) 10‐4910‐10‐00 Other Revenue (40,000.00) (40,000.00) (18,053.76) (669.32) 45.13 (21,946.24) 10‐4995‐10‐00 Transfer In (877,403.00) (877,403.00) (435,236.46) (72,539.41) 49.61 (442,166.54) Subtotal object ‐ 0 (11,601,174.00) (11,601,174.00) (9,198,939.99) (412,943.44) 79.29 (2,402,234.01) Program number: (11,601,174.00) (11,601,174.00) (9,198,939.99) (412,943.44) 79.29 (2,402,234.01) Department number: 10 Administration (11,601,174.00) (11,601,174.00) (9,198,939.99) (412,943.44) 79.29 (2,402,234.01) 10‐4230‐20‐00 Other Permits (600.00) (600.00) (225.00) (75.00) 37.50 (375.00) 10‐4440‐20‐00 Accident Reports (600.00) (600.00) (431.00) 71.83 (169.00) 10‐4450‐20‐00 Alarm Fee (35,200.00) (35,200.00) (18,386.00) (2,532.00) 52.23 (16,814.00) 10‐4910‐20‐00 Other Revenue (1,000.00) (1,000.00) (362.00) (60.00) 36.20 (638.00) Subtotal object ‐ 0 (37,400.00) (37,400.00) (19,404.00) (2,667.00) 51.88 (17,996.00) Program number: (37,400.00) (37,400.00) (19,404.00) (2,667.00) 51.88 (17,996.00) Department number: 20 Police (37,400.00) (37,400.00) (19,404.00) (2,667.00) 51.88 (17,996.00) 10‐4310‐30‐00 Charges for Services (237,170.00) (237,170.00) (19,025.68) (1,693.10) 8.02 (218,144.32) 10‐4411‐30‐00 CC FIRE ASSOC (315.85) ‐ 315.85 10‐4510‐30‐00 Grants (3,000.00) (3,000.00) (610.00) 20.33 (2,390.00) 10‐4910‐30‐00 Other Revenue (500.00) (500.00) (95.40) 19.08 (404.60) Subtotal object ‐ 0 (240,670.00) (240,670.00) (20,046.93) (1,693.10) 8.33 (220,623.07) Program number: (240,670.00) (240,670.00) (20,046.93) (1,693.10) 8.33 (220,623.07) Department number: 30 Fire/EMS (240,670.00) (240,670.00) (20,046.93) (1,693.10) 8.33 (220,623.07) 10‐4315‐35‐00 Fire Review/Inspect Fees (11,000.00) (11,000.00) (12,025.00) (1,775.00) 109.32 1,025.00 Subtotal object ‐ 0 (11,000.00) (11,000.00) (12,025.00) (1,775.00) 109.32 1,025.00 Program number: (11,000.00) (11,000.00) (12,025.00) (1,775.00) 109.32 1,025.00 Department number: 35 Fire Marshal (11,000.00) (11,000.00) (12,025.00) (1,775.00) 109.32 1,025.00 10‐4910‐40‐00 Other Revenue (14,040.00) (1,260.00) ‐ 14,040.00 Subtotal object ‐ 0 (14,040.00) (1,260.00) ‐ 14,040.00 Program number: (14,040.00) (1,260.00) ‐ 14,040.00 Department number: 40 Streets (14,040.00) (1,260.00) ‐ 14,040.00 10‐4062‐45‐00 Over Due Fees (75.00) (75.00) ‐ (75.00) 10‐4063‐45‐00 Lost Fees (60.00) (60.00) (41.69) 69.48 (18.31) 18 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐4064‐45‐00 Printing/Coping Fees (96.05) (0.40) ‐ 96.05 10‐4065‐45‐00 Book Fines (20.00) (20.00) (357.20) (47.80) 1,786.00 337.20 10‐4510‐45‐00 Grants (19,335.00) (19,335.00) (4,833.98) (4,833.98) 25.00 (14,501.02) 10‐4910‐45‐00 Other Revenue (150.00) (150.00) (250.60) (0.05) 167.07 100.60 Subtotal object ‐ 0 (19,640.00) (19,640.00) (5,579.52) (4,882.23) 28.41 (14,060.48) Program number: (19,640.00) (19,640.00) (5,579.52) (4,882.23) 28.41 (14,060.48) Department number: 45 Public Library (19,640.00) (19,640.00) (5,579.52) (4,882.23) 28.41 (14,060.48) 10‐4056‐60‐00 Field Rental Fees (17,000.00) (17,000.00) (13,582.50) (13,447.50) 79.90 (3,417.50) 10‐4057‐60‐00 Pavilion User Fees (3,500.00) (3,500.00) (730.00) (330.00) 20.86 (2,770.00) 10‐4058‐60‐00 Park Program Fees (23,500.00) (23,500.00) (11,303.34) (3,911.63) 48.10 (12,196.66) 10‐4910‐60‐00 Other Revenue (250.00) (250.00) (1,560.00) (1,010.00) 624.00 1,310.00 Subtotal object ‐ 0 (44,250.00) (44,250.00) (27,175.84) (18,699.13) 61.41 (17,074.16) Program number: (44,250.00) (44,250.00) (27,175.84) (18,699.13) 61.41 (17,074.16) Department number: 60 Parks and Recreation (44,250.00) (44,250.00) (27,175.84) (18,699.13) 61.41 (17,074.16) 10‐4410‐70‐00 Fines (245,000.00) (245,000.00) (136,240.03) (22,038.72) 55.61 (108,759.97) 10‐4610‐70‐00 Interest Income (700.00) (700.00) (1,023.26) (199.53) 146.18 323.26 Subtotal object ‐ 0 (245,700.00) (245,700.00) (137,263.29) (22,238.25) 55.87 (108,436.71) Program number: (245,700.00) (245,700.00) (137,263.29) (22,238.25) 55.87 (108,436.71) Department number: 70 Municipal Court (245,700.00) (245,700.00) (137,263.29) (22,238.25) 55.87 (108,436.71) 10‐4017‐80‐00 Registration Fee (44,000.00) (44,000.00) (33,300.00) (4,500.00) 75.68 (10,700.00) 10‐4060‐80‐00 NSF Fees (30.00) (30.00) ‐ 30.00 10‐4210‐80‐00 Building Permits (1,950,000.00) (1,950,000.00) (1,084,187.86) (208,724.75) 55.60 (865,812.14) 10‐4230‐80‐00 Other Permits (159,200.00) (159,200.00) (81,323.80) (13,065.00) 51.08 (77,876.20) 10‐4240‐80‐00 Plumb/Elect/Mech Permits (24,075.00) (24,075.00) (15,430.00) (3,420.00) 64.09 (8,645.00) 10‐4242‐80‐00 Re‐inspection Fees (24,600.00) (24,600.00) (18,330.00) (4,455.00) 74.51 (6,270.00) 10‐4910‐80‐00 Other Revenue (3,800.00) (3,800.00) (2,134.04) (480.20) 56.16 (1,665.96) Subtotal object ‐ 0 (2,205,675.00) (2,205,675.00) (1,234,735.70) (234,674.95) 55.98 (970,939.30) Program number: (2,205,675.00) (2,205,675.00) (1,234,735.70) (234,674.95) 55.98 (970,939.30) Department number: 80 Inspections (2,205,675.00) (2,205,675.00) (1,234,735.70) (234,674.95) 55.98 (970,939.30) 10‐4245‐85‐00 Health Inspections (9,525.00) (9,525.00) (8,000.00) (2,625.00) 83.99 (1,525.00) 10‐4910‐85‐00 Other Revenue (5,000.00) (5,000.00) (615.00) 12.30 (4,385.00) Subtotal object ‐ 0 (14,525.00) (14,525.00) (8,615.00) (2,625.00) 59.31 (5,910.00) Program number: (14,525.00) (14,525.00) (8,615.00) (2,625.00) 59.31 (5,910.00) Department number: 85 Code Enforcement (14,525.00) (14,525.00) (8,615.00) (2,625.00) 59.31 (5,910.00) 10‐4220‐90‐00 Zoning Permits (35,000.00) (35,000.00) (6,244.58) (721.47) 17.84 (28,755.42) 10‐4225‐90‐00 Plat Fees (50,000.00) (50,000.00) (49,400.60) (14,310.00) 98.80 (599.40) 10‐4910‐90‐00 Other Revenue (1,000.00) (1,000.00) (79,839.00) (100.00) 7,983.90 78,839.00 Subtotal object ‐ 0 (86,000.00) (86,000.00) (135,484.18) (15,131.47) 157.54 49,484.18 Program number: (86,000.00) (86,000.00) (135,484.18) (15,131.47) 157.54 49,484.18 Department number: 90 Planning (86,000.00) (86,000.00) (135,484.18) (15,131.47) 157.54 49,484.18 Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (14,506,034.00) (14,506,034.00) (10,813,309.45) (718,589.57) 74.54 (3,692,724.55) 10‐5110‐10‐01 Salaries & Wages 267,788.00 (115,000.00) 152,788.00 121,926.87 4,532.81 79.80 30,861.13 10‐5115‐10‐01 Salaries ‐ Overtime 4,852.00 4,852.00 1,808.14 106.41 37.27 3,043.86 10‐5126‐10‐01 Salaries‐Vacation Buy‐Out 7,028.00 (3,800.00) 3,228.00 3,200.00 99.13 28.00 10‐5140‐10‐01 Salaries ‐ Longevity Pay 200.00 200.00 195.00 97.50 5.00 10‐5141‐10‐01 Salaries ‐ Incentive 10,000.00 ‐ (10,000.00) 10‐5142‐10‐01 Car Allowance 6,000.00 (3,969.00) 2,031.00 2,261.55 111.35 (230.55) 10‐5143‐10‐01 Cell Phone Allowance 1,080.00 (720.00) 360.00 360.00 100.00 19 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5145‐10‐01 Social Security Expense 12,141.00 (6,000.00) 6,141.00 5,658.61 285.41 92.15 482.39 10‐5150‐10‐01 Medicare Expense 4,018.00 4,018.00 1,962.71 66.75 48.85 2,055.29 10‐5155‐10‐01 SUTA Expense 414.00 414.00 234.00 (180.00) 56.52 180.00 10‐5160‐10‐01 Health Insurance 11,785.00 (6,000.00) 5,785.00 2,647.99 45.77 3,137.01 10‐5165‐10‐01 Dental Insurance 626.00 626.00 250.49 25.56 40.01 375.51 10‐5170‐10‐01 Life Insurance/AD&D 302.00 302.00 181.15 7.88 59.98 120.85 10‐5175‐10‐01 Liability (TML) Workers' Comp 555.00 555.00 485.87 87.54 69.13 10‐5180‐10‐01 TMRS Expense 32,116.00 (15,000.00) 17,116.00 15,912.94 550.68 92.97 1,203.06 10‐5185‐10‐01 Long Term/Short Term Disabilit 456.00 456.00 ‐ 456.00 10‐5190‐10‐01 Contract Labor 17,500.00 (10,000.00) 7,500.00 4,610.00 680.00 61.47 2,890.00 10‐5210‐10‐01 Office Supplies 1,500.00 1,500.00 573.97 38.27 926.03 10‐5212‐10‐01 Building Supplies 500.00 500.00 205.21 41.04 294.79 10‐5230‐10‐01 Dues,Fees,& Subscriptions 5,130.00 (2,000.00) 3,130.00 2,689.01 (4.99) 85.91 440.99 10‐5240‐10‐01 Postage and Delivery 750.00 750.00 11.32 0.96 1.51 738.68 10‐5250‐10‐01 Publications 450.00 450.00 ‐ 450.00 10‐5280‐10‐01 Printing and Reproduction 1,000.00 1,000.00 134.91 54.40 13.49 865.09 10‐5330‐10‐01 Copier Expense 10,000.00 10,000.00 7,625.53 4,205.53 2,374.47 76.26 10‐5340‐10‐01 Building Repairs 1,000.00 1,000.00 24.97 2.50 975.03 10‐5410‐10‐01 Professional Services 25,000.00 186,689.00 211,689.00 55,353.48 27,186.98 152,810.52 26.15 3,525.00 10‐5418‐10‐01 IT Fees 135,000.00 135,000.00 69,202.25 11,837.15 65,797.75 51.26 10‐5430‐10‐01 Legal Fees 46,250.00 46,250.00 34,397.85 11,666.00 74.37 11,852.15 10‐5480‐10‐01 Contracted Services 950.00 950.00 434.35 62.56 45.72 515.65 10‐5520‐10‐01 Telephones 24,000.00 24,000.00 8,215.28 4,202.77 4,016.60 34.23 11,768.12 10‐5524‐10‐01 Gas‐Building 500.00 500.00 340.89 66.15 68.18 159.11 10‐5525‐10‐01 Electricity 10,000.00 10,000.00 2,997.42 665.75 29.97 7,002.58 10‐5526‐10‐01 Data Network 15,000.00 15,000.00 9,989.11 1,658.52 66.59 5,010.89 10‐5530‐10‐01 Travel/Lodging/Meals Expense 5,000.00 (3,200.00) 1,800.00 1,093.53 175.20 60.75 706.47 10‐5533‐10‐01 Mileage Expense 1,250.00 (500.00) 750.00 303.13 40.42 446.87 10‐5536‐10‐01 Training/Seminars 1,600.00 (500.00) 1,100.00 295.00 26.82 805.00 Subtotal object ‐ 0 651,741.00 20,000.00 671,741.00 365,582.53 67,852.48 224,999.34 54.42 81,159.13 Program number: 1 Town Manager 651,741.00 20,000.00 671,741.00 365,582.53 67,852.48 224,999.34 54.42 81,159.13 10‐5110‐10‐02 Salaries & Wages 68,205.00 68,205.00 33,642.40 5,834.96 49.33 34,562.60 10‐5126‐10‐02 Salaries‐Vacation Buy‐Out 644.00 644.00 ‐ 644.00 10‐5140‐10‐02 Salaries ‐ Longevity Pay 90.00 90.00 90.00 100.00 10‐5143‐10‐02 Cell Phone Allowance 540.00 90.00 ‐ (540.00) 10‐5145‐10‐02 Social Security Expense 4,274.00 4,274.00 2,125.63 367.50 49.73 2,148.37 10‐5150‐10‐02 Medicare Expense 1,000.00 1,000.00 497.12 85.95 49.71 502.88 10‐5155‐10‐02 SUTA Expense 207.00 207.00 27.00 (180.00) 13.04 180.00 10‐5170‐10‐02 Life Insurance/AD&D 95.00 95.00 85.10 15.76 89.58 9.90 10‐5175‐10‐02 Liability (TML) Workers' Comp 171.00 171.00 149.70 87.54 21.30 10‐5180‐10‐02 TMRS Expense 7,988.00 7,988.00 3,880.75 703.29 48.58 4,107.25 10‐5185‐10‐02 Long Term/Short Term Disabilit 156.00 156.00 ‐ 156.00 10‐5193‐10‐02 Records Retention 1,000.00 1,000.00 332.20 33.22 667.80 10‐5210‐10‐02 Office Supplies 1,000.00 1,000.00 309.06 39.98 30.91 690.94 10‐5230‐10‐02 Dues,Fees,& Subscriptions 1,000.00 1,000.00 390.00 210.00 39.00 610.00 10‐5240‐10‐02 Postage and Delivery 750.00 750.00 18.17 10.31 2.42 731.83 10‐5310‐10‐02 Rental Expense 5,000.00 5,000.00 2,284.79 854.21 45.70 2,715.21 10‐5340‐10‐02 Building Repairs 231.47 206.50 ‐ (231.47) 20 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5430‐10‐02 Legal Fees 10,000.00 10,000.00 7,217.43 1,629.32 72.17 2,782.57 10‐5435‐10‐02 Legal Notices/Filings 5,000.00 5,000.00 1,929.15 471.30 38.58 3,070.85 10‐5460‐10‐02 Election Expense 15,000.00 15,000.00 3,603.62 3,541.34 24.02 11,396.38 10‐5480‐10‐02 Contracted Services 39,702.00 39,702.00 22,237.10 4,914.40 17,440.00 56.01 24.90 10‐5526‐10‐02 Data Network 113.97 37.99 ‐ (113.97) 10‐5530‐10‐02 Travel/Lodging/Meals Expense 5,000.00 5,000.00 801.16 16.02 4,198.84 10‐5533‐10‐02 Mileage Expense 1,000.00 1,000.00 67.36 6.74 932.64 10‐5536‐10‐02 Training/Seminars 1,600.00 1,600.00 565.00 245.00 35.31 1,035.00 10‐5538‐10‐02 Council/Public Official Expens 22,750.00 22,750.00 7,395.82 2,151.46 32.51 15,354.18 10‐5600‐10‐02 Special Events 22,000.00 22,000.00 1,827.93 499.00 8.31 20,172.07 Subtotal object ‐ 0 213,632.00 213,632.00 90,361.93 21,728.27 17,440.00 42.30 105,830.07 Program number: 2 Town Secretary 213,632.00 213,632.00 90,361.93 21,728.27 17,440.00 42.30 105,830.07 10‐5110‐10‐03 Salaries & Wages 372,679.00 372,679.00 186,539.86 29,355.54 50.05 186,139.14 10‐5115‐10‐03 Salaries ‐ Overtime 1,808.00 1,808.00 603.42 33.38 1,204.58 10‐5126‐10‐03 Salaries‐Vacation Buy‐Out 3,350.00 3,350.00 1,683.64 50.26 1,666.36 10‐5140‐10‐03 Salaries ‐ Longevity Pay 745.00 745.00 195.00 26.17 550.00 10‐5143‐10‐03 Cell Phone Allowance 1,080.00 1,080.00 270.00 25.00 810.00 10‐5145‐10‐03 Social Security Expense 22,593.00 22,593.00 11,259.06 1,767.34 49.83 11,333.94 10‐5150‐10‐03 Medicare Expense 5,505.00 5,505.00 2,638.29 413.33 47.93 2,866.71 10‐5155‐10‐03 SUTA Expense 1,125.00 1,125.00 341.49 (601.06) 30.36 783.51 10‐5160‐10‐03 Health Insurance 33,102.00 33,102.00 10,705.28 1,345.40 32.34 22,396.72 10‐5165‐10‐03 Dental Insurance 1,564.00 1,564.00 649.22 102.24 41.51 914.78 10‐5170‐10‐03 Life Insurance/AD&D 558.00 558.00 264.75 31.52 47.45 293.25 10‐5175‐10‐03 Liability (TML) Workers' Comp 932.00 932.00 815.92 87.55 116.08 10‐5180‐10‐03 TMRS Expense 43,992.00 43,992.00 20,406.98 2,330.39 46.39 23,585.02 10‐5185‐10‐03 Long Term/Short Term Disabilit 855.00 855.00 ‐ 855.00 10‐5186‐10‐03 WELLE‐Wellness Prog Reimb Empl 1,800.00 1,800.00 629.00 85.00 34.94 1,171.00 10‐5190‐10‐03 Contract Labor 15,440.00 (1,800.00) 13,640.00 2,595.00 500.00 19.03 11,045.00 10‐5210‐10‐03 Office Supplies 1,500.00 1,500.00 2,194.01 216.41 146.27 (694.01) 10‐5212‐10‐03 Building Supplies 1,000.00 1,000.00 109.59 10.96 890.41 10‐5220‐10‐03 Office Equipment 855.00 855.00 804.86 25.87 94.14 50.14 10‐5230‐10‐03 Dues,Fees,& Subscriptions 4,960.00 4,960.00 2,843.00 990.00 57.32 2,117.00 10‐5240‐10‐03 Postage and Delivery 750.00 750.00 826.51 128.27 110.20 (76.51) 10‐5265‐10‐03 Promotional Expense (306.00) ‐ 306.00 10‐5280‐10‐03 Printing and Reproduction 1,000.00 1,000.00 ‐ 1,000.00 10‐5310‐10‐03 Rental Expense 18,500.00 18,500.00 8,100.50 1,567.60 10,973.20 43.79 (573.70) 10‐5330‐10‐03 Copier Expense 20,520.00 20,520.00 10,439.02 1,105.47 9,907.76 50.87 173.22 10‐5340‐10‐03 Building Repairs 1,500.00 1,500.00 899.49 59.97 600.51 10‐5410‐10‐03 Professional Services 64,000.00 64,000.00 36,300.00 23,200.00 56.72 4,500.00 10‐5412‐10‐03 Audit Fees 40,000.00 40,000.00 16,750.00 15,250.00 41.88 8,000.00 10‐5414‐10‐03 Appraisal / Tax Fees 65,180.00 65,180.00 37,639.76 15,500.88 57.75 27,540.24 10‐5418‐10‐03 IT Fees 9,480.00 7,000.00 16,480.00 24,165.44 3,397.00 146.64 (7,685.44) 10‐5419‐10‐03 IT Licenses 19,500.00 (5,000.00) 14,500.00 12,500.00 262.80 86.21 1,737.20 10‐5430‐10‐03 Legal Fees 5,000.00 5,000.00 3,078.00 570.00 61.56 1,922.00 10‐5435‐10‐03 Legal Notices/Filings (26.30) ‐ 26.30 10‐5480‐10‐03 Contracted Services 9,550.00 1,800.00 11,350.00 10,662.25 129.00 93.94 687.75 10‐5520‐10‐03 Telephones (245.27) (245.27) ‐ 245.27 10‐5525‐10‐03 Electricity 2,143.50 719.73 ‐ (2,143.50) 21 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5526‐10‐03 Data Network 165.44 (592.00) ‐ (165.44) 10‐5530‐10‐03 Travel/Lodging/Meals Expense 7,500.00 (2,000.00) 5,500.00 991.79 1,522.25 18.03 4,508.21 10‐5536‐10‐03 Training/Seminars 3,220.00 3,220.00 1,950.00 60.56 1,270.00 Subtotal object ‐ 0 781,143.00 781,143.00 411,582.50 60,364.91 59,593.76 52.69 309,966.74 Program number: 3 Finance 781,143.00 781,143.00 411,582.50 60,364.91 59,593.76 52.69 309,966.74 10‐5110‐10‐04 Salaries & Wages 101,783.00 101,783.00 45,535.89 7,762.24 44.74 56,247.11 10‐5126‐10‐04 Salaries‐Vacation Buy‐Out 961.00 961.00 1,921.36 199.93 (960.36) 10‐5140‐10‐04 Salaries ‐ Longevity Pay 85.00 85.00 80.00 94.12 5.00 10‐5145‐10‐04 Social Security Expense 6,413.00 6,413.00 2,652.96 426.79 41.37 3,760.04 10‐5150‐10‐04 Medicare Expense 1,500.00 1,500.00 620.45 99.81 41.36 879.55 10‐5155‐10‐04 SUTA Expense 207.00 207.00 27.00 (180.00) 13.04 180.00 10‐5160‐10‐04 Health Insurance 11,781.00 11,781.00 4,826.72 856.80 40.97 6,954.28 10‐5165‐10‐04 Dental Insurance 313.00 313.00 138.02 25.56 44.10 174.98 10‐5170‐10‐04 Life Insurance/AD&D 95.00 95.00 113.40 21.00 119.37 (18.40) 10‐5175‐10‐04 Liability (TML) Workers' Comp 254.00 254.00 222.36 87.54 31.64 10‐5180‐10‐04 TMRS Expense 11,985.00 11,985.00 5,398.90 927.32 45.05 6,586.10 10‐5185‐10‐04 Long Term/Short Term Disabilit 233.00 233.00 ‐ 233.00 10‐5186‐10‐04 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 270.00 50.00 45.00 330.00 10‐5191‐10‐04 Hiring Cost 25,050.00 25,050.00 2,133.95 521.86 8.52 22,916.05 10‐5210‐10‐04 Office Supplies 1,824.00 1,824.00 430.97 199.87 23.63 1,393.03 10‐5220‐10‐04 Office Equipment 5,500.00 5,500.00 3,758.14 2,863.14 68.33 1,741.86 10‐5230‐10‐04 Dues,Fees,& Subscriptions 5,530.00 5,530.00 3,457.81 2,840.00 62.53 2,072.19 10‐5240‐10‐04 Postage and Delivery 750.00 750.00 49.28 7.65 6.57 700.72 10‐5250‐10‐04 Publications 350.00 350.00 ‐ 350.00 10‐5280‐10‐04 Printing and Reproduction 2,000.00 2,000.00 ‐ 2,000.00 10‐5290‐10‐04 Miscellaneous Expense 5,000.00 5,000.00 772.56 15.45 4,227.44 10‐5410‐10‐04 Professional Services 32,000.00 (11,000.00) 21,000.00 12,819.53 268.00 10,000.00 61.05 (1,819.53) 10‐5419‐10‐04 IT Licenses 3,000.00 3,000.00 2,720.00 90.67 280.00 10‐5430‐10‐04 Legal Fees 10,000.00 10,000.00 7,277.00 380.00 72.77 2,723.00 10‐5530‐10‐04 Travel/Lodging/Meals Expense 4,600.00 4,600.00 1,081.68 23.52 3,518.32 10‐5536‐10‐04 Training/Seminars 5,000.00 5,000.00 752.50 15.05 4,247.50 10‐5600‐10‐04 Special Events 5,000.00 5,000.00 5,342.40 106.85 (342.40) Subtotal object ‐ 0 241,814.00 (11,000.00) 230,814.00 102,402.88 17,070.04 10,000.00 44.37 118,411.12 Program number: 4 Human Resources 241,814.00 (11,000.00) 230,814.00 102,402.88 17,070.04 10,000.00 44.37 118,411.12 Department number: 10 Administration 1,888,330.00 9,000.00 1,897,330.00 969,929.84 167,015.70 312,033.10 51.12 615,367.06 10‐5110‐20‐00 Salaries & Wages 1,187,364.00 (6,200.00) 1,181,164.00 427,195.26 77,135.50 36.17 753,968.74 10‐5115‐20‐00 Salaries ‐ Overtime 55,586.00 55,586.00 27,942.71 3,055.56 50.27 27,643.29 10‐5126‐20‐00 Salaries‐Vacation Buy‐Out 8,689.00 8,689.00 3,179.04 36.59 5,509.96 10‐5127‐20‐00 Salaries‐Certification Pay 14,580.00 14,580.00 7,007.01 1,116.92 48.06 7,572.99 10‐5140‐20‐00 Salaries ‐ Longevity Pay 4,215.00 4,215.00 4,215.00 100.00 10‐5143‐20‐00 Cell Phone Allowance 1,080.00 1,080.00 550.00 115.00 50.93 530.00 10‐5145‐20‐00 Social Security Expense 74,673.00 74,673.00 28,249.65 4,757.62 37.83 46,423.35 10‐5150‐20‐00 Medicare Expense 17,665.00 17,665.00 6,606.73 1,112.66 37.40 11,058.27 10‐5155‐20‐00 SUTA Expense 3,882.00 3,882.00 609.66 (2,457.89) 15.71 3,272.34 10‐5160‐20‐00 Health Insurance 111,759.00 111,759.00 35,543.24 6,852.76 31.80 76,215.76 10‐5165‐20‐00 Dental Insurance 6,043.00 6,043.00 1,896.21 383.40 31.38 4,146.79 10‐5170‐20‐00 Life Insurance/AD&D 4,992.00 4,992.00 2,057.92 403.53 41.22 2,934.08 10‐5175‐20‐00 Liability (TML) Workers' Comp 27,440.00 27,440.00 24,784.34 762.00 90.32 2,655.66 22 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5180‐20‐00 TMRS Expense 139,390.00 139,390.00 53,746.54 9,499.34 38.56 85,643.46 10‐5185‐20‐00 Long Term/Short Term Disabilit 3,933.00 3,933.00 ‐ 3,933.00 10‐5186‐20‐00 WELLE‐Wellness Prog Reimb Empl 2,400.00 2,400.00 1,107.00 205.00 46.13 1,293.00 10‐5190‐20‐00 Contract Labor 6,000.00 6,000.00 3,500.00 560.00 58.33 2,500.00 10‐5191‐20‐00 Hiring Cost 375.00 50.00 ‐ (375.00) 10‐5192‐20‐00 Physical & Psychological 1,200.00 1,200.00 300.00 25.00 900.00 10‐5210‐20‐00 Office Supplies 9,375.00 9,375.00 3,213.93 989.74 34.28 6,161.07 10‐5212‐20‐00 Building Supplies 900.00 900.00 109.00 12.11 791.00 10‐5214‐20‐00 Tactical Supplies 24,669.00 24,669.00 11,029.19 459.02 8,213.41 44.71 5,426.40 10‐5215‐20‐00 Ammunition 7,000.00 7,000.00 5,449.98 1,000.00 1,188.45 77.86 361.57 10‐5220‐20‐00 Office Equipment 13,612.00 13,612.00 212.35 1.56 13,399.65 10‐5230‐20‐00 Dues,Fees,& Subscriptions 8,500.00 8,500.00 1,390.38 709.43 16.36 7,109.62 10‐5240‐20‐00 Postage and Delivery 750.00 750.00 459.10 77.78 61.21 290.90 10‐5250‐20‐00 Publications 400.00 400.00 ‐ 400.00 10‐5260‐20‐00 Advertising 1,000.00 1,000.00 ‐ 1,000.00 10‐5265‐20‐00 Promotional Expense 1,500.00 1,500.00 ‐ 1,500.00 10‐5280‐20‐00 Printing and Reproduction 500.00 500.00 143.69 50.00 28.74 356.31 10‐5310‐20‐00 Rental Expense 4,200.00 4,200.00 2,274.30 324.90 54.15 1,925.70 10‐5335‐20‐00 Radio/Video Repairs 2,000.00 2,000.00 ‐ 2,000.00 10‐5340‐20‐00 Building Repairs 2,000.00 4,700.00 6,700.00 190.00 4,650.00 2.84 1,860.00 10‐5350‐20‐00 Vehicle Expense 50,000.00 50,000.00 14,324.95 736.82 28.65 35,675.05 10‐5352‐20‐00 Fuel 60,000.00 60,000.00 16,039.42 108.79 26.73 43,960.58 10‐5353‐20‐00 Oil/Grease/Inspections 2,500.00 2,500.00 79.50 3.18 2,420.50 10‐5400‐20‐00 Uniform Expense 17,000.00 17,000.00 5,767.82 1,574.42 33.93 11,232.18 10‐5410‐20‐00 Professional Services 1,600.00 1,600.00 450.00 450.00 28.13 1,150.00 10‐5415‐20‐00 Tuition Reimbursement 5,050.00 ‐ (5,050.00) 10‐5418‐20‐00 IT Fees 3,950.00 3,950.00 ‐ 3,950.00 10‐5419‐20‐00 IT Licenses 3,000.00 3,000.00 ‐ 3,000.00 10‐5430‐20‐00 Legal Fees 7,550.00 7,550.00 2,838.82 95.00 37.60 4,711.18 10‐5480‐20‐00 Contracted Services 22,290.00 22,290.00 13,103.72 52.55 6,000.00 58.79 3,186.28 10‐5520‐20‐00 Telephones 16,200.00 16,200.00 4,465.28 1,098.54 27.56 11,734.72 10‐5524‐20‐00 Gas‐Building 400.00 400.00 413.32 166.90 103.33 (13.32) 10‐5525‐20‐00 Electricity 10,000.00 10,000.00 4,408.62 811.07 44.09 5,591.38 10‐5526‐20‐00 Data Network 13,760.00 13,760.00 2,098.65 419.73 15.25 11,661.35 10‐5530‐20‐00 Travel/Lodging/Meals Expense 8,225.00 8,225.00 1,082.47 1,082.47 13.16 7,142.53 10‐5533‐20‐00 Mileage Expense 2,500.00 2,500.00 ‐ 2,500.00 10‐5536‐20‐00 Training/Seminars 20,600.00 20,600.00 4,056.56 148.00 19.69 16,543.44 10‐5600‐20‐00 Special Events 4,000.00 4,000.00 310.06 310.06 7.75 3,689.94 10‐5630‐20‐00 Safety Equipment 28,500.00 28,500.00 11,295.98 10,011.13 39.64 17,204.02 10‐5640‐20‐00 Signs & Hardware 1,000.00 1,000.00 ‐ 1,000.00 Subtotal object ‐ 0 2,020,372.00 (1,500.00) 2,018,872.00 739,122.40 124,227.75 20,051.86 36.61 1,259,697.74 Program number: 2,020,372.00 (1,500.00) 2,018,872.00 739,122.40 124,227.75 20,051.86 36.61 1,259,697.74 Department number: 20 Police 2,020,372.00 (1,500.00) 2,018,872.00 739,122.40 124,227.75 20,051.86 36.61 1,259,697.74 10‐5110‐25‐00 Salaries & Wages 332,302.00 332,302.00 139,992.74 23,912.00 42.13 192,309.26 10‐5115‐25‐00 Salaries ‐ Overtime 13,952.00 13,952.00 5,031.45 1,818.61 36.06 8,920.55 10‐5126‐25‐00 Salaries‐Vacation Buy‐Out 3,040.00 3,040.00 751.20 24.71 2,288.80 10‐5127‐25‐00 Salaries‐Certification Pay 8,820.00 8,820.00 4,002.80 678.44 45.38 4,817.20 10‐5140‐25‐00 Salaries ‐ Longevity Pay 990.00 990.00 970.00 97.98 20.00 23 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5145‐25‐00 Social Security Expense 21,548.00 21,548.00 8,900.64 1,554.58 41.31 12,647.36 10‐5150‐25‐00 Medicare Expense 5,039.00 5,039.00 2,081.60 363.57 41.31 2,957.40 10‐5155‐25‐00 SUTA Expense 1,656.00 1,656.00 191.39 (961.46) 11.56 1,464.61 10‐5160‐25‐00 Health Insurance 33,904.00 33,904.00 12,449.43 2,215.82 36.72 21,454.57 10‐5165‐25‐00 Dental Insurance 1,877.00 1,877.00 966.17 178.92 51.47 910.83 10‐5170‐25‐00 Life Insurance 662.00 662.00 297.86 55.16 44.99 364.14 10‐5175‐25‐00 Liability (TML) Workers' Comp 831.00 831.00 727.50 87.55 103.50 10‐5180‐25‐00 TMRS Expense 40,273.00 40,273.00 17,021.05 3,144.85 42.26 23,251.95 10‐5185‐25‐00 Long Term/Short Term Disabilit 711.00 711.00 ‐ 711.00 10‐5186‐25‐00 WELLE‐Wellness Prog Reimb Empl 2,400.00 2,400.00 459.00 85.00 19.13 1,941.00 10‐5192‐25‐00 Physical & Psychological 1,300.00 1,300.00 ‐ 1,300.00 10‐5210‐25‐00 Supplies 2,500.00 2,500.00 356.19 14.25 2,143.81 10‐5212‐25‐00 Building Supplies 1,500.00 1,500.00 149.65 9.98 1,350.35 10‐5220‐25‐00 Office Equipment 2,440.00 1,500.00 3,940.00 414.21 17.99 10.51 3,525.79 10‐5230‐25‐00 Dues,Fees,& Subscriptions 2,000.00 2,000.00 589.77 156.35 29.49 1,410.23 10‐5240‐25‐00 Postage and Delivery 100.00 100.00 8.03 8.03 8.03 91.97 10‐5250‐25‐00 Publications 100.00 100.00 ‐ 100.00 10‐5280‐25‐00 Printing and Reproduction 100.00 100.00 ‐ 100.00 10‐5340‐25‐00 Building Repairs 1,800.00 1,800.00 569.55 31.64 1,230.45 10‐5400‐25‐00 Uniform Expense 2,500.00 2,500.00 35.99 1.44 2,464.01 10‐5418‐25‐00 IT Fees 4,500.00 4,500.00 ‐ 4,500.00 10‐5419‐25‐00 IT Licenses 5,000.00 5,000.00 ‐ 5,000.00 10‐5430‐25‐00 Legal Fees 2,450.00 2,450.00 ‐ 2,450.00 10‐5480‐25‐00 Contracted Services 152,825.00 152,825.00 92,121.57 57,708.75 60.28 2,994.68 10‐5520‐25‐00 Telephones 30.78 ‐ (30.78) 10‐5524‐25‐00 Gas‐Building 41.02 ‐ (41.02) 10‐5530‐25‐00 Travel/Lodging/Meals Expense 2,000.00 2,000.00 4.00 0.20 1,996.00 10‐5533‐25‐00 Mileage Expense 1,000.00 1,000.00 4.00 0.40 996.00 10‐5536‐25‐00 Training/Seminars 12,000.00 12,000.00 1,342.08 72.08 11.18 10,657.92 10‐5600‐25‐00 Special Events 1,000.00 1,000.00 ‐ 1,000.00 Subtotal object ‐ 0 663,120.00 1,500.00 664,620.00 289,509.67 33,299.94 57,708.75 43.56 317,401.58 Program number: 663,120.00 1,500.00 664,620.00 289,509.67 33,299.94 57,708.75 43.56 317,401.58 Department number: 25 Dispatch Department 663,120.00 1,500.00 664,620.00 289,509.67 33,299.94 57,708.75 43.56 317,401.58 10‐5110‐30‐00 Salaries & Wages 2,105,209.00 2,105,209.00 638,050.77 120,870.58 30.31 1,467,158.23 10‐5115‐30‐00 Salaries ‐ Overtime 237,097.00 237,097.00 93,223.89 14,985.66 39.32 143,873.11 10‐5126‐30‐00 Salaries‐Vacation Buy‐Out 18,757.00 18,757.00 ‐ 18,757.00 10‐5127‐30‐00 Salaries‐Certification Pay 20,341.00 20,341.00 9,441.98 1,684.74 46.42 10,899.02 10‐5140‐30‐00 Salaries ‐ Longevity Pay 9,340.00 9,340.00 8,780.00 94.00 560.00 10‐5141‐30‐00 Salaries ‐ Incentive 1,650.00 ‐ (1,650.00) 10‐5143‐30‐00 Cell Phone Allowance 4,680.00 4,680.00 1,950.00 390.00 41.67 2,730.00 10‐5145‐30‐00 Social Security Expense 110,585.00 110,585.00 44,090.05 8,009.26 39.87 66,494.95 10‐5150‐30‐00 Medicare Expense 25,862.00 25,862.00 10,311.42 1,873.12 39.87 15,550.58 10‐5155‐30‐00 SUTA Expense 7,038.00 7,038.00 694.36 (3,919.41) 9.87 6,343.64 10‐5160‐30‐00 Health Insurance 107,116.00 107,116.00 62,768.26 13,263.96 58.60 44,347.74 10‐5165‐30‐00 Dental Insurance 6,257.00 6,257.00 2,699.48 562.32 43.14 3,557.52 10‐5170‐30‐00 Life Insurance/AD&D 6,302.00 6,302.00 2,915.21 603.98 46.26 3,386.79 10‐5171‐30‐00 Life Insurance‐Supplemental 8,000.00 8,000.00 7,920.00 99.00 80.00 10‐5175‐30‐00 Liability (TML) Workers Comp 35,184.00 35,184.00 31,945.84 1,144.00 90.80 3,238.16 24 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5180‐30‐00 TMRS Expense 206,677.00 206,677.00 82,295.89 15,828.97 39.82 124,381.11 10‐5185‐30‐00 Long Term/Short Term Disabilit 2,945.00 2,945.00 ‐ 2,945.00 10‐5186‐30‐00 WELLE‐Wellness Prog Reimb Empl 9,000.00 9,000.00 2,787.00 355.00 30.97 6,213.00 10‐5190‐30‐00 Contract Labor 720.00 720.00 ‐ 720.00 10‐5194‐30‐00 FD Annual Phy & Screening 20,000.00 20,000.00 3,065.50 1,363.00 15.33 16,934.50 10‐5210‐30‐00 Office Supplies 4,598.00 4,598.00 1,818.05 406.55 39.54 2,779.95 10‐5212‐30‐00 Building Supplies 4,000.00 4,000.00 2,321.66 807.74 58.04 1,678.34 10‐5230‐30‐00 Dues,Fees,& Subscriptions 4,800.00 4,800.00 4,149.68 86.45 650.32 10‐5240‐30‐00 Postage and Delivery 250.00 250.00 64.55 42.75 25.82 185.45 10‐5250‐30‐00 Publications 350.00 350.00 ‐ 350.00 10‐5280‐30‐00 Printing and Reproduction 1,200.00 1,200.00 403.95 33.66 796.05 10‐5320‐30‐00 Repairs & Maintenance 6,500.00 6,500.00 4,043.44 187.75 62.21 2,456.56 10‐5335‐30‐00 Radio/Video Repairs 14,700.00 14,700.00 1,100.03 64.16 7.48 13,599.97 10‐5340‐30‐00 Building Repairs 14,700.00 66,707.00 81,407.00 10,400.43 983.67 61,429.80 12.78 9,576.77 10‐5350‐30‐00 Vehicle Expense 35,000.00 35,000.00 17,622.21 6,394.49 50.35 17,377.79 10‐5352‐30‐00 Fuel 35,000.00 35,000.00 6,041.25 17.26 28,958.75 10‐5400‐30‐00 Uniform Expense 43,824.00 43,824.00 1,727.59 661.50 3.94 42,096.41 10‐5410‐30‐00 Professional Services 7,500.00 7,500.00 ‐ 7,500.00 10‐5415‐30‐00 Tuition Reimbursement 200.00 ‐ (200.00) 10‐5418‐30‐00 IT Fees 7,500.00 7,500.00 ‐ 7,500.00 10‐5430‐30‐00 Legal Fees 2,000.00 2,000.00 247.00 12.35 1,753.00 10‐5440‐30‐00 EMS 96,000.00 4,250.00 100,250.00 58,836.02 991.65 30,594.79 58.69 10,819.19 10‐5445‐30‐00 Emergency Management Expense 27,100.00 27,100.00 12,791.48 1,491.48 47.20 14,308.52 10‐5480‐30‐00 Contracted Services 6,530.00 6,530.00 300.00 60.00 4.59 6,230.00 10‐5520‐30‐00 Telephones 20,500.00 20,500.00 3,660.82 946.98 3,047.87 17.86 13,791.31 10‐5524‐30‐00 Gas ‐ Building 7,000.00 7,000.00 2,339.95 325.35 33.43 4,660.05 10‐5525‐30‐00 Electricity 22,000.00 22,000.00 6,811.38 1,172.39 30.96 15,188.62 10‐5526‐30‐00 Data Network 12,442.00 12,442.00 11,955.44 1,709.40 96.09 486.56 10‐5530‐30‐00 Travel/Lodging/Meals Expense 3,000.00 3,000.00 1,810.16 993.60 60.34 1,189.84 10‐5533‐30‐00 Mileage Expense 1,500.00 1,500.00 424.98 28.33 1,075.02 10‐5536‐30‐00 Training/Seminars 18,000.00 18,000.00 6,344.94 2,165.00 35.25 11,655.06 10‐5610‐30‐00 Fire Fighting Equipment 18,000.00 18,000.00 4,284.36 415.90 23.80 13,715.64 10‐5630‐30‐00 Safety Equipment 25,000.00 25,000.00 1,335.05 302.32 5.34 23,664.95 Subtotal object ‐ 0 3,380,104.00 70,957.00 3,451,061.00 1,165,624.07 197,137.86 95,072.46 33.78 2,190,364.47 Program number: 3,380,104.00 70,957.00 3,451,061.00 1,165,624.07 197,137.86 95,072.46 33.78 2,190,364.47 Department number: 30 Fire/EMS 3,380,104.00 70,957.00 3,451,061.00 1,165,624.07 197,137.86 95,072.46 33.78 2,190,364.47 10‐5110‐35‐00 Salaries & Wages 86,828.00 86,828.00 39,258.24 6,816.00 45.21 47,569.76 10‐5115‐35‐00 Salaries ‐ Overtime 1,200.00 1,200.00 696.79 195.40 58.07 503.21 10‐5126‐35‐00 Salaries‐Vacation Buy‐Out 1,199.00 1,199.00 ‐ 1,199.00 10‐5140‐35‐00 Salaries ‐ Longevity Pay 635.00 635.00 630.00 99.21 5.00 10‐5143‐35‐00 Cell Phone Allowance 1,080.00 1,080.00 450.00 90.00 41.67 630.00 10‐5145‐35‐00 Social Security Expense 5,602.00 5,602.00 2,225.58 372.93 39.73 3,376.42 10‐5150‐35‐00 Medicare Expense 1,310.00 1,310.00 520.47 87.22 39.73 789.53 10‐5155‐35‐00 SUTA Expense 207.00 207.00 (10.02) (172.88) (4.84) 217.02 10‐5160‐35‐00 Health Insurance 6,608.00 6,608.00 2,600.68 535.78 39.36 4,007.32 10‐5165‐35‐00 Dental Insurance 313.00 313.00 118.98 25.05 38.01 194.02 10‐5170‐35‐00 Life Insurance/AD&D 315.00 315.00 122.22 25.74 38.80 192.78 10‐5175‐35‐00 Liability (TML) Workers' Comp 1,787.00 1,787.00 1,564.43 87.55 222.57 25 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5180‐35‐00 TMRS Expense 10,469.00 10,469.00 4,642.01 842.94 44.34 5,826.99 10‐5185‐35‐00 Long Term/Short Term Disabilit 194.00 194.00 ‐ 194.00 10‐5186‐35‐00 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 ‐ 600.00 10‐5193‐35‐00 Records Retention 250.00 250.00 ‐ 250.00 10‐5194‐35‐00 FD Annual Phy & Screening 651.00 651.00 ‐ 651.00 10‐5210‐35‐00 Supplies 300.00 300.00 ‐ 300.00 10‐5215‐35‐00 Ammunition 1,000.00 1,000.00 ‐ 1,000.00 10‐5220‐35‐00 Office Equipment 200.00 200.00 58.15 29.08 141.85 10‐5230‐35‐00 Dues,Fees,& Subscriptions 600.00 600.00 55.00 9.17 545.00 10‐5240‐35‐00 Postage and Delivery 60.00 60.00 5.75 9.58 54.25 10‐5250‐35‐00 Publications 550.00 550.00 ‐ 550.00 10‐5260‐35‐00 Advertising 2,000.00 2,000.00 ‐ 2,000.00 10‐5280‐35‐00 Printing and Reproduction 500.00 500.00 140.80 28.16 359.20 10‐5350‐35‐00 Vehicle Expense 800.00 800.00 ‐ 800.00 10‐5352‐35‐00 Fuel 2,000.00 2,000.00 673.41 33.67 1,326.59 10‐5353‐35‐00 Oil/Grease/Inspections 500.00 500.00 ‐ 500.00 10‐5400‐35‐00 Uniform Expense 1,050.00 1,050.00 188.00 188.00 17.91 862.00 10‐5418‐35‐00 IT Fees 200.00 200.00 ‐ 200.00 10‐5430‐35‐00 Legal Fees 5,000.00 5,000.00 114.00 2.28 4,886.00 10‐5480‐35‐00 Contracted Services 2,000.00 2,000.00 ‐ 2,000.00 10‐5520‐35‐00 Telephones 1,200.00 1,200.00 ‐ 1,200.00 10‐5526‐35‐00 Data Network 800.00 800.00 189.95 37.99 23.74 610.05 10‐5530‐35‐00 Travel/Lodging/Meals Expense 500.00 500.00 ‐ 500.00 10‐5536‐35‐00 Training/Seminars 3,200.00 3,200.00 284.86 8.90 2,915.14 10‐5620‐35‐00 Tools & Equipment 200.00 200.00 ‐ 200.00 10‐5630‐35‐00 Safety Equipment 1,000.00 1,000.00 26.93 26.93 2.69 973.07 10‐5640‐35‐00 Signs & Hardware 1,250.00 1,250.00 ‐ 1,250.00 Subtotal object ‐ 0 144,158.00 144,158.00 54,556.23 9,071.10 37.85 89,601.77 Program number: 144,158.00 144,158.00 54,556.23 9,071.10 37.85 89,601.77 Department number: 35 Fire Marshal 144,158.00 144,158.00 54,556.23 9,071.10 37.85 89,601.77 10‐5110‐40‐00 Salaries & Wages 96,351.00 96,351.00 48,158.93 8,761.58 49.98 48,192.07 10‐5115‐40‐00 Salaries ‐ Overtime 7,629.00 7,629.00 3,292.84 901.81 43.16 4,336.16 10‐5126‐40‐00 Salaries‐Vacation Buy‐Out 909.00 909.00 ‐ 909.00 10‐5140‐40‐00 Salaries ‐ Longevity Pay 1,120.00 1,120.00 1,120.00 100.00 10‐5145‐40‐00 Social Security Expense 6,174.00 6,174.00 3,126.10 573.49 50.63 3,047.90 10‐5150‐40‐00 Medicare Expense 1,444.00 1,444.00 731.09 134.12 50.63 712.91 10‐5155‐40‐00 SUTA Expense 414.00 414.00 54.00 (307.02) 13.04 360.00 10‐5160‐40‐00 Health Insurance 8,724.00 8,724.00 5,017.76 873.66 57.52 3,706.24 10‐5165‐40‐00 Dental Insurance 626.00 626.00 276.05 51.12 44.10 349.95 10‐5170‐40‐00 Life Insurance/AD&D 189.00 189.00 85.10 15.76 45.03 103.90 10‐5175‐40‐00 Liability (TML) Workers Comp 646.00 646.00 565.54 87.55 80.46 10‐5180‐40‐00 TMRS Expense 11,539.00 11,539.00 5,960.91 1,147.04 51.66 5,578.09 10‐5185‐40‐00 Long Term/Short Term Disabilit 220.00 220.00 ‐ 220.00 10‐5186‐40‐00 WELLE‐Wellness Prog Reimb Empl 1,200.00 1,200.00 84.00 7.00 1,116.00 10‐5210‐40‐00 Office Supplies 600.00 600.00 ‐ 600.00 10‐5230‐40‐00 Dues,Fees,& Subscriptions 200.00 200.00 ‐ 200.00 10‐5250‐40‐00 Publications 50.00 50.00 ‐ 50.00 10‐5310‐40‐00 Rental Expense 14,000.00 14,000.00 6,480.07 46.29 7,519.93 26 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5320‐40‐00 Repairs & Maintenance 4,000.00 4,000.00 3,236.98 2,905.20 80.93 763.02 10‐5321‐40‐00 Signal Light Repairs 6,400.00 6,400.00 ‐ 6,400.00 10‐5340‐40‐00 Building Repairs 2,500.00 2,500.00 805.39 32.22 1,694.61 10‐5350‐40‐00 Vehicle Expense 6,500.00 6,500.00 1,636.79 1,052.28 25.18 4,863.21 10‐5352‐40‐00 Fuel 10,100.00 10,100.00 826.62 8.18 9,273.38 10‐5353‐40‐00 Oil/Grease/Inspections 800.00 800.00 62.00 7.75 738.00 10‐5400‐40‐00 Uniform Expense 3,500.00 3,500.00 239.92 6.86 3,260.08 10‐5430‐40‐00 Legal Fees 57.00 ‐ (57.00) 10‐5480‐40‐00 Contracted Services 23,200.00 23,200.00 49,500.00 213.36 (26,300.00) 10‐5520‐40‐00 Telephones 1,300.00 1,300.00 310.51 (41.09) 23.89 989.49 10‐5521‐40‐00 Cell Phone Expense 1,000.00 1,000.00 ‐ 1,000.00 10‐5525‐40‐00 Electricity 100,000.00 100,000.00 60,571.27 11,805.98 60.57 39,428.73 10‐5526‐40‐00 Data Network 36.16 7.28 ‐ (36.16) 10‐5530‐40‐00 Travel/Lodging/Meals Expense 800.00 800.00 ‐ 800.00 10‐5536‐40‐00 Training/Seminars 800.00 800.00 539.90 500.00 67.49 260.10 10‐5620‐40‐00 Tools & Equipment 3,000.00 3,000.00 1,252.08 41.74 1,747.92 10‐5630‐40‐00 Safety Equipment 2,000.00 2,000.00 ‐ 2,000.00 10‐5640‐40‐00 Signs & Hardware 25,000.00 25,000.00 4,829.39 19.32 20,170.61 10‐5650‐40‐00 Maintenance Materials 106,000.00 106,000.00 15,863.83 5,577.82 33,667.32 14.97 56,468.85 Subtotal object ‐ 0 448,935.00 448,935.00 214,720.23 33,959.03 33,667.32 47.83 200,547.45 Program number: 448,935.00 448,935.00 214,720.23 33,959.03 33,667.32 47.83 200,547.45 Department number: 40 Streets 448,935.00 448,935.00 214,720.23 33,959.03 33,667.32 47.83 200,547.45 10‐5110‐45‐00 Salaries & Wages 103,324.00 103,324.00 36,846.90 5,838.59 35.66 66,477.10 10‐5126‐45‐00 Salaries‐Vacation Buy‐Out 216.00 216.00 ‐ 216.00 10‐5145‐45‐00 Social Security Expense 6,419.00 6,419.00 2,285.67 362.22 35.61 4,133.33 10‐5150‐45‐00 Medicare Expense 1,501.00 1,501.00 534.52 84.71 35.61 966.48 10‐5155‐45‐00 SUTA Expense 828.00 828.00 148.27 (222.37) 17.91 679.73 10‐5165‐45‐00 Dental Insurance 313.00 313.00 138.02 25.56 44.10 174.98 10‐5170‐45‐00 Life Insurance 95.00 95.00 42.55 7.88 44.79 52.45 10‐5175‐45‐00 Liability (TML)/Workers' Comp 265.00 265.00 231.99 87.54 33.01 10‐5180‐45‐00 TMRS Expense 11,998.00 11,998.00 2,768.37 465.40 23.07 9,229.63 10‐5185‐45‐00 Long Term/Short Term Disabilit 106.00 106.00 ‐ 106.00 10‐5210‐45‐00 Supplies 4,800.00 1,200.00 6,000.00 3,151.01 1,152.77 52.52 2,848.99 10‐5212‐45‐00 Building Supplies 500.00 500.00 618.51 218.07 123.70 (118.51) 10‐5220‐45‐00 Office Equipment 3,000.00 3,000.00 2,531.36 759.00 84.38 468.64 10‐5230‐45‐00 Dues,Fees,& Subscriptions 7,600.00 7,600.00 4,075.18 150.00 53.62 3,524.82 10‐5240‐45‐00 Postage and Delivery 400.00 400.00 28.67 12.35 7.17 371.33 10‐5250‐45‐00 Publications 500.00 500.00 ‐ 500.00 10‐5281‐45‐00 Book Purchases 15,000.00 15,000.00 9,789.78 1,436.03 65.27 5,210.22 10‐5400‐45‐00 Uniform Expense 121.00 ‐ (121.00) 10‐5418‐45‐00 IT Fees 1,875.00 1,875.00 250.00 250.00 13.33 1,625.00 10‐5480‐45‐00 Contracted Services 5,652.00 5,652.00 ‐ 5,652.00 10‐5520‐45‐00 Telephones 500.00 500.00 324.93 26.88 64.99 175.07 10‐5525‐45‐00 Electricity 5,500.00 5,500.00 ‐ 5,500.00 10‐5530‐45‐00 Travel 1,700.00 1,700.00 33.29 33.29 1.96 1,666.71 10‐5533‐45‐00 Mileage Expense 1,000.00 1,000.00 334.66 223.99 33.47 665.34 10‐5536‐45‐00 Training/Seminars 1,500.00 1,500.00 99.95 80.00 6.66 1,400.05 10‐5600‐45‐00 Special Events 600.00 600.00 541.39 75.00 90.23 58.61 27 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5640‐45‐00 Signs & Hardware 75.00 ‐ (75.00) Subtotal object ‐ 0 175,192.00 1,200.00 176,392.00 64,971.02 10,979.37 36.83 111,420.98 Program number: 175,192.00 1,200.00 176,392.00 64,971.02 10,979.37 36.83 111,420.98 Department number: 45 Public Library 175,192.00 1,200.00 176,392.00 64,971.02 10,979.37 36.83 111,420.98 10‐5110‐60‐01 Salaries & Wages 171,802.00 171,802.00 65,075.39 11,243.52 37.88 106,726.61 10‐5126‐60‐01 Salaries‐Vacation Buy‐Out 1,077.00 1,077.00 ‐ 1,077.00 10‐5140‐60‐01 Salaries ‐ Longevity Pay 185.00 185.00 175.00 94.60 10.00 10‐5145‐60‐01 Social Security Expense 10,767.00 10,767.00 3,903.23 670.77 36.25 6,863.77 10‐5150‐60‐01 Medicare Expense 2,518.00 2,518.00 912.85 156.87 36.25 1,605.15 10‐5155‐60‐01 SUTA Expense 569.00 569.00 54.00 (360.00) 9.49 515.00 10‐5160‐60‐01 Health Insurance 18,085.00 18,085.00 6,999.78 1,240.70 38.71 11,085.22 10‐5165‐60‐01 Dental Insurance 896.00 896.00 276.05 51.12 30.81 619.95 10‐5170‐60‐01 Life Insurance/AD&D 196.00 196.00 85.10 15.76 43.42 110.90 10‐5175‐60‐01 Liability (TML) Workers Comp 906.00 906.00 793.16 87.55 112.84 10‐5180‐60‐01 TMRS Expense 19,858.00 19,858.00 7,439.39 1,344.69 37.46 12,418.61 10‐5185‐60‐01 Long Term/Short Term Disabilit 1,217.00 1,217.00 ‐ 1,217.00 10‐5186‐60‐01 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 459.00 85.00 76.50 141.00 10‐5190‐60‐01 Contract Labor 210.00 60.00 ‐ (210.00) 10‐5210‐60‐01 Office Supplies 2,375.00 2,375.00 1,114.18 206.64 46.91 1,260.82 10‐5220‐60‐01 Office Equipment 8,162.00 8,162.00 1,372.65 1,372.65 16.82 6,789.35 10‐5230‐60‐01 Dues,Fees,& Subscriptions 3,150.00 3,150.00 1,008.12 482.12 32.00 2,141.88 10‐5240‐60‐01 Postage and Delivery 7.82 7.82 ‐ (7.82) 10‐5310‐60‐01 Rental Expense 1,812.00 ‐ (1,812.00) 10‐5320‐60‐01 Repairs & Maintenance 25,180.00 25,180.00 22,680.00 90.07 2,500.00 10‐5400‐60‐01 Uniform Expense 300.00 300.00 ‐ 300.00 10‐5410‐60‐01 Professional Services 77,182.00 77,182.00 43,300.52 15,251.06 33,881.64 56.10 (0.16) 10‐5418‐60‐01 IT Fees 3,100.00 500.00 3,600.00 713.48 19.82 2,886.52 10‐5430‐60‐01 Legal Fees 5,000.00 5,000.00 2,375.00 570.00 47.50 2,625.00 10‐5520‐60‐01 Telephones 5,900.00 5,900.00 3,655.94 877.24 61.97 2,244.06 10‐5526‐60‐01 Data Network 1,700.00 1,700.00 337.92 19.88 1,362.08 10‐5530‐60‐01 Travel/Lodging/Meals Expense 3,800.00 3,800.00 293.10 219.45 7.71 3,506.90 10‐5533‐60‐01 Mileage Expense 2,225.00 2,225.00 692.93 101.60 31.14 1,532.07 10‐5536‐60‐01 Training/Seminars 7,350.00 7,350.00 677.40 9.22 6,672.60 10‐5600‐60‐01 Special Events 1,986.00 1,986.00 1,985.40 99.97 0.60 Subtotal object ‐ 0 271,738.00 104,848.00 376,586.00 168,409.41 33,597.01 33,881.64 44.72 174,294.95 Program number: 1 Parks Administration 271,738.00 104,848.00 376,586.00 168,409.41 33,597.01 33,881.64 44.72 174,294.95 10‐5110‐60‐02 Salaries & Wages 419,808.00 419,808.00 206,096.91 33,455.71 49.09 213,711.09 10‐5115‐60‐02 Salaries ‐ Overtime 13,477.00 13,477.00 4,635.61 408.46 34.40 8,841.39 10‐5126‐60‐02 Salaries‐Vacation Buy‐Out 3,757.00 3,757.00 1,257.60 33.47 2,499.40 10‐5140‐60‐02 Salaries ‐ Longevity Pay 2,215.00 2,215.00 2,230.00 100.68 (15.00) 10‐5143‐60‐02 Cell Phone Allowance 30.00 30.00 ‐ (30.00) 10‐5145‐60‐02 Social Security Expense 26,621.00 26,621.00 12,381.64 1,897.40 46.51 14,239.36 10‐5150‐60‐02 Medicare Expense 6,226.00 6,226.00 2,895.72 443.75 46.51 3,330.28 10‐5155‐60‐02 SUTA Expense 2,277.00 2,277.00 404.09 (1,272.66) 17.75 1,872.91 10‐5160‐60‐02 Health Insurance 64,707.00 64,707.00 35,246.50 6,194.68 54.47 29,460.50 10‐5165‐60‐02 Dental Insurance 3,441.00 3,441.00 1,492.37 255.60 43.37 1,948.63 10‐5170‐60‐02 Life Insurance/AD&D 1,040.00 1,040.00 502.00 86.04 48.27 538.00 10‐5175‐60‐02 Liability (TML) Workers Comp 8,136.00 8,136.00 7,122.66 87.55 1,013.34 28 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5180‐60‐02 TMRS Expense 49,755.00 49,755.00 24,610.20 4,046.97 49.46 25,144.80 10‐5185‐60‐02 Long Term/Short Term Disabilit 834.00 834.00 ‐ 834.00 10‐5186‐60‐02 WELLE‐Wellness Prog Reimb Empl 3,600.00 3,600.00 1,217.00 200.00 33.81 2,383.00 10‐5212‐60‐02 Building Supplies 1,500.00 1,500.00 189.14 12.61 1,310.86 10‐5230‐60‐02 Dues,Fees,& Subscriptions 100.00 100.00 ‐ (100.00) 10‐5310‐60‐02 Rental Expense 23,500.00 23,500.00 11,853.05 1,827.00 11,207.00 50.44 439.95 10‐5320‐60‐02 Repairs & Maintenance 210,275.00 210,275.00 26,806.42 12,370.31 45,336.00 12.75 138,132.58 10‐5350‐60‐02 Vehicle Expense 6,000.00 6,000.00 1,378.00 35.00 22.97 4,622.00 10‐5352‐60‐02 Fuel 17,000.00 17,000.00 5,082.21 29.90 11,917.79 10‐5353‐60‐02 Oil/Grease/Inspections 3,300.00 3,300.00 594.62 200.17 18.02 2,705.38 10‐5400‐60‐02 Uniform Expense 5,400.00 5,400.00 3,766.59 1,687.18 69.75 1,633.41 10‐5480‐60‐02 Contracted Services 178,300.00 178,300.00 41,639.32 8,775.00 46,173.00 23.35 90,487.68 10‐5525‐60‐02 Electricity 96,000.00 96,000.00 55,042.71 5,701.73 57.34 40,957.29 10‐5620‐60‐02 Tools & Equipment 4,725.00 4,725.00 700.24 14.82 4,024.76 10‐5630‐60‐02 Safety Equipment 1,600.00 1,600.00 183.47 63.48 11.47 1,416.53 10‐5640‐60‐02 Signs & Hardware 2,800.00 2,800.00 ‐ 2,800.00 Subtotal object ‐ 0 1,156,294.00 1,156,294.00 447,458.07 76,505.82 102,716.00 38.70 606,119.93 Program number: 2 Parks Maintenance 1,156,294.00 1,156,294.00 447,458.07 76,505.82 102,716.00 38.70 606,119.93 10‐5110‐60‐03 Salaries & Wages 42,787.00 42,787.00 270.37 270.37 0.63 42,516.63 10‐5126‐60‐03 Salaries‐Vacation Buy‐Out 404.00 404.00 ‐ 404.00 10‐5145‐60‐03 Social Security Expense 2,678.00 2,678.00 14.11 14.11 0.53 2,663.89 10‐5150‐60‐03 Medicare Expense 626.00 626.00 3.30 3.30 0.53 622.70 10‐5155‐60‐03 SUTA Expense 207.00 207.00 6.22 6.22 3.01 200.78 10‐5170‐60‐03 Life Insurance/AD&D 95.00 95.00 0.64 0.64 0.67 94.36 10‐5175‐60‐03 Liability (TML) Workers Comp 107.00 107.00 93.67 87.54 13.33 10‐5180‐60‐03 TMRS Expense 5,005.00 5,005.00 32.09 32.09 0.64 4,972.91 10‐5185‐60‐03 Long Term/Short Term Disabilit 101.00 101.00 ‐ 101.00 10‐5240‐60‐03 Postage and Delivery 6,875.00 6,875.00 228.32 207.30 3.32 6,646.68 10‐5260‐60‐03 Advertising 2,000.00 2,000.00 524.50 524.50 26.23 1,475.50 10‐5280‐60‐03 Printing and Reproduction 5,850.00 5,850.00 603.17 550.21 10.31 5,246.83 10‐5475‐60‐03 Credit Card Fees 467.89 74.02 ‐ (467.89) 10‐5600‐60‐03 Special Events 19,200.00 19,200.00 6,657.47 3,102.50 34.67 12,542.53 10‐5995‐60‐03 Recreation Activities 23,500.00 23,500.00 2,987.81 133.75 12.71 20,512.19 Subtotal object ‐ 0 109,435.00 109,435.00 11,889.56 4,919.01 10.86 97,545.44 Program number: 3 Recreation 109,435.00 109,435.00 11,889.56 4,919.01 10.86 97,545.44 Department number: 60 Parks and Recreation 1,537,467.00 104,848.00 1,642,315.00 627,757.04 115,021.84 136,597.64 38.22 877,960.32 10‐5110‐70‐00 Salaries & Wages 97,779.00 97,779.00 41,985.51 7,659.32 42.94 55,793.49 10‐5115‐70‐00 Salaries ‐ Overtime 251.00 251.00 ‐ 251.00 10‐5126‐70‐00 Salaries‐Vacation Buy‐Out 898.00 898.00 ‐ 898.00 10‐5127‐70‐00 Salaries‐Certification Pay 9,000.00 (9,000.00) ‐ 10‐5128‐70‐00 Language Pay 900.00 900.00 450.00 100.00 50.00 450.00 10‐5140‐70‐00 Salaries ‐ Longevity Pay 70.00 70.00 70.00 100.00 10‐5145‐70‐00 Social Security Expense 6,122.00 6,122.00 2,500.21 456.11 40.84 3,621.79 10‐5150‐70‐00 Medicare Expense 1,431.00 1,431.00 584.72 106.67 40.86 846.28 10‐5155‐70‐00 SUTA Expense 414.00 414.00 83.52 (240.54) 20.17 330.48 10‐5160‐70‐00 Health Insurance 8,157.00 8,157.00 3,195.70 554.76 39.18 4,961.30 10‐5165‐70‐00 Dental Insurance 313.00 313.00 138.02 25.56 44.10 174.98 10‐5170‐70‐00 Life Insurance/AD&D 95.00 95.00 42.55 7.88 44.79 52.45 29 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5175‐70‐00 Liability (TML) Workers Comp 238.00 238.00 208.36 87.55 29.64 10‐5180‐70‐00 TMRS Expense 11,443.00 11,443.00 4,806.08 915.09 42.00 6,636.92 10‐5185‐70‐00 Long Term/Short Term Disabilit 181.00 181.00 ‐ 181.00 10‐5186‐70‐00 WELLE‐Wellness Prog Reimb Empl 270.00 50.00 ‐ (270.00) 10‐5190‐70‐00 Contract Labor 4,800.00 4,800.00 2,170.00 345.00 45.21 2,630.00 10‐5210‐70‐00 Office Supplies 1,500.00 1,500.00 1,042.34 235.74 69.49 457.66 10‐5212‐70‐00 Building Supplies 1,500.00 1,500.00 662.37 107.50 44.16 837.63 10‐5220‐70‐00 Office Equipment 4,970.00 4,970.00 3,149.97 63.38 1,820.03 10‐5230‐70‐00 Dues,Fees,& Subscriptions 100.00 100.00 40.00 40.00 60.00 10‐5240‐70‐00 Postage and Delivery 1,200.00 1,200.00 500.00 300.00 41.67 700.00 10‐5250‐70‐00 Publications 100.00 100.00 ‐ 100.00 10‐5280‐70‐00 Printing and Reproduction 700.00 700.00 ‐ 700.00 10‐5310‐70‐00 Rental Expense 25,400.00 25,400.00 14,104.57 1,995.51 55.53 11,295.43 10‐5320‐70‐00 Repairs & Maintenance 60.00 ‐ (60.00) 10‐5418‐70‐00 IT Fees 500.00 500.00 95.00 95.00 19.00 405.00 10‐5420‐70‐00 Municipal Court/Judge Fees 10,000.00 10,000.00 6,866.00 1,200.00 68.66 3,134.00 10‐5430‐70‐00 Legal Fees 20,000.00 20,000.00 13,646.27 833.86 68.23 6,353.73 10‐5480‐70‐00 Contracted Services 360.00 360.00 90.00 25.00 270.00 10‐5481‐70‐00 Cash Over/Short 5.00 ‐ (5.00) 10‐5520‐70‐00 Telephones 300.00 300.00 820.10 194.60 273.37 (520.10) 10‐5524‐70‐00 Gas‐Building 900.00 900.00 432.31 167.94 48.03 467.69 10‐5525‐70‐00 Electricity 2,000.00 2,000.00 408.57 88.32 20.43 1,591.43 10‐5530‐70‐00 Travel/Lodging/Meals Expense 500.00 500.00 ‐ 500.00 10‐5533‐70‐00 Mileage Expense 500.00 500.00 ‐ 500.00 10‐5536‐70‐00 Training/Seminars 500.00 500.00 100.00 20.00 400.00 Subtotal object ‐ 0 213,122.00 (9,000.00) 204,122.00 98,467.17 15,198.32 60.00 48.24 105,594.83 Program number: 213,122.00 (9,000.00) 204,122.00 98,467.17 15,198.32 60.00 48.24 105,594.83 Department number: 70 Municipal Court 213,122.00 (9,000.00) 204,122.00 98,467.17 15,198.32 60.00 48.24 105,594.83 10‐5110‐80‐00 Salaries & Wages 545,258.00 (52,876.00) 492,382.00 167,177.76 36,912.94 33.95 325,204.24 10‐5115‐80‐00 Salaries ‐ Overtime 13,354.00 30,000.00 43,354.00 24,732.21 1,964.48 57.05 18,621.79 10‐5126‐80‐00 Salaries‐Vacation Buy‐Out 3,938.00 3,938.00 ‐ 3,938.00 10‐5140‐80‐00 Salaries ‐ Longevity Pay 1,280.00 1,280.00 755.00 58.98 525.00 10‐5143‐80‐00 Cell Phone Allowance 140.00 140.00 ‐ (140.00) 10‐5145‐80‐00 Social Security Expense 34,241.00 34,241.00 10,859.36 2,211.70 31.71 23,381.64 10‐5150‐80‐00 Medicare Expense 8,009.00 8,009.00 2,539.73 517.25 31.71 5,469.27 10‐5155‐80‐00 SUTA Expense 2,173.00 2,173.00 495.78 (1,001.80) 22.82 1,677.22 10‐5160‐80‐00 Health Insurance 62,016.00 62,016.00 16,473.79 3,282.70 26.56 45,542.21 10‐5165‐80‐00 Dental Insurance 3,043.00 3,043.00 883.30 179.43 29.03 2,159.70 10‐5170‐80‐00 Life Insurance/AD&D 890.00 890.00 348.88 75.38 39.20 541.12 10‐5175‐80‐00 Liability (TML) Workers Comp 3,669.00 3,669.00 3,212.03 87.55 456.97 10‐5180‐80‐00 TMRS Expense 63,498.00 63,498.00 21,853.38 4,631.35 34.42 41,644.62 10‐5185‐80‐00 Long Term/Short Term Disabilit 2,664.00 2,664.00 ‐ 2,664.00 10‐5186‐80‐00 WELLE‐Wellness Prog Reimb Empl 1,800.00 1,800.00 104.00 5.78 1,696.00 10‐5190‐80‐00 Contract Labor 3,120.00 3,120.00 580.00 80.00 18.59 2,540.00 10‐5210‐80‐00 Office Supplies 7,150.00 7,150.00 3,271.85 688.51 45.76 3,878.15 10‐5212‐80‐00 Building Supplies 500.00 500.00 170.08 34.02 329.92 10‐5220‐80‐00 Office Equipment 8,204.00 8,204.00 1,912.61 1,820.04 23.31 6,291.39 10‐5230‐80‐00 Dues,Fees,& Subscriptions 96,450.00 96,450.00 80,523.41 221.94 2,500.00 83.49 13,426.59 30 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5240‐80‐00 Postage and Delivery 50.00 50.00 2.63 1.67 5.26 47.37 10‐5250‐80‐00 Publications 6,237.00 6,237.00 4,290.52 4,290.52 68.79 1,946.48 10‐5280‐80‐00 Printing and Reproduction 2,000.00 2,000.00 9.50 0.48 1,990.50 10‐5340‐80‐00 Building Repairs 2,000.00 2,000.00 1,353.79 1,258.79 67.69 646.21 10‐5350‐80‐00 Vehicle Expense 3,000.00 3,000.00 1,144.90 367.43 38.16 1,855.10 10‐5352‐80‐00 Fuel 9,600.00 (1,000.00) 8,600.00 1,631.01 18.97 6,968.99 10‐5353‐80‐00 Oil/Grease/Inspections 1,000.00 1,000.00 511.28 134.75 51.13 488.72 10‐5400‐80‐00 Uniform Expense 3,020.00 3,020.00 ‐ 3,020.00 10‐5410‐80‐00 Professional Services 25,000.00 25,000.00 17,743.66 7,256.34 70.98 10‐5418‐80‐00 IT Fees 4,000.00 5,000.00 9,000.00 5,000.00 ‐ 4,000.00 10‐5430‐80‐00 Legal Fees 3,250.00 3,250.00 304.00 9.35 2,946.00 10‐5465‐80‐00 Public Relations 500.00 500.00 ‐ 500.00 10‐5480‐80‐00 Contracted Services 780.00 7,300.00 8,080.00 7,692.00 60.00 95.20 388.00 10‐5520‐80‐00 Telephones 4,380.00 4,380.00 893.45 289.58 20.40 3,486.55 10‐5521‐80‐00 Cell Phone Expense 1,200.00 1,200.00 ‐ 1,200.00 10‐5525‐80‐00 Electricity 6,500.00 6,500.00 2,265.39 578.44 34.85 4,234.61 10‐5526‐80‐00 Data Network 4,000.00 4,000.00 1,383.20 335.55 34.58 2,616.80 10‐5530‐80‐00 Travel/Lodging/Meals Expense 7,850.00 (2,000.00) 5,850.00 ‐ 5,850.00 10‐5533‐80‐00 Mileage Expense 3,000.00 (1,500.00) 1,500.00 ‐ 1,500.00 10‐5536‐80‐00 Training/Seminars 13,453.00 (1,300.00) 12,153.00 477.65 253.00 3.93 11,675.35 10‐5620‐80‐00 Tools & Equipment 660.00 660.00 110.36 110.36 16.72 549.64 10‐5630‐80‐00 Safety Equipment 920.00 920.00 24.00 24.00 2.61 896.00 10‐6160‐80‐00 Capital Expenditure ‐ Vehicles 14,560.00 2,876.00 17,436.00 17,435.75 ‐ 0.25 Subtotal object ‐ 0 953,217.00 11,500.00 964,717.00 375,870.51 59,428.01 32,192.09 38.96 556,654.40 Program number: 953,217.00 11,500.00 964,717.00 375,870.51 59,428.01 32,192.09 38.96 556,654.40 Department number: 80 Inspections 953,217.00 11,500.00 964,717.00 375,870.51 59,428.01 32,192.09 38.96 556,654.40 10‐5110‐85‐00 Salaries & Wages 49,433.00 49,433.00 22,165.62 3,806.41 44.84 27,267.38 10‐5115‐85‐00 Salaries ‐ Overtime 828.00 828.00 369.64 44.64 458.36 10‐5126‐85‐00 Salaries‐Vacation Buy‐Out 455.00 455.00 ‐ 455.00 10‐5140‐85‐00 Salaries ‐ Longevity Pay 270.00 270.00 265.00 98.15 5.00 10‐5145‐85‐00 Social Security Expense 3,147.00 3,147.00 1,356.42 225.42 43.10 1,790.58 10‐5150‐85‐00 Medicare Expense 736.00 736.00 317.23 52.72 43.10 418.77 10‐5155‐85‐00 SUTA Expense 207.00 207.00 27.00 (147.81) 13.04 180.00 10‐5160‐85‐00 Health Insurance 3,547.00 3,547.00 1,596.02 290.56 45.00 1,950.98 10‐5165‐85‐00 Dental Insurance 313.00 313.00 138.02 25.56 44.10 174.98 10‐5170‐85‐00 Life Insurance/AD&D 95.00 95.00 42.55 7.88 44.79 52.45 10‐5175‐85‐00 Liability (TML) Workers' Comp 309.00 309.00 270.51 87.54 38.49 10‐5180‐85‐00 TMRS Expense 5,882.00 5,882.00 2,577.57 451.82 43.82 3,304.43 10‐5185‐85‐00 Long Term/Short Term Disabilit 111.00 111.00 ‐ 111.00 10‐5186‐85‐00 WELLE‐Wellness Prog Reimb Empl 600.00 (263.00) 337.00 ‐ 337.00 10‐5210‐85‐00 Office Supplies 500.00 500.00 38.29 7.66 461.71 10‐5230‐85‐00 Dues,Fees,& Subscriptions 300.00 300.00 212.27 212.27 70.76 87.73 10‐5240‐85‐00 Postage and Delivery 400.00 400.00 146.00 36.92 36.50 254.00 10‐5350‐85‐00 Vehicle Expense 500.00 93.00 593.00 593.11 100.02 (0.11) 10‐5352‐85‐00 Fuel 1,800.00 1,800.00 194.98 10.83 1,605.02 10‐5353‐85‐00 Oil/Grease/Inspections 100.00 100.00 ‐ 100.00 10‐5400‐85‐00 Uniform Expense 200.00 200.00 ‐ 200.00 10‐5430‐85‐00 Legal Fees 3,000.00 3,000.00 209.00 6.97 2,791.00 31 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐5435‐85‐00 Legal Notices/Filings 300.00 300.00 ‐ 300.00 10‐5480‐85‐00 Contracted Services 88,000.00 (480.00) 87,520.00 35,176.50 525.00 63,733.00 40.19 (11,389.50) 10‐5520‐85‐00 Telephones 800.00 800.00 194.41 143.14 24.30 605.59 10‐5526‐85‐00 Data Network 480.00 480.00 189.95 37.99 39.57 290.05 10‐5536‐85‐00 Training/Seminars 800.00 800.00 34.95 4.37 765.05 10‐5600‐85‐00 Special Events 500.00 500.00 ‐ 500.00 10‐5620‐85‐00 Tools & Equipment 250.00 250.00 ‐ 250.00 10‐5640‐85‐00 Signs & Hardware 1,200.00 170.00 1,370.00 1,368.08 99.86 1.92 Subtotal object ‐ 0 164,583.00 164,583.00 67,483.12 5,667.88 63,733.00 41.00 33,366.88 Program number: 164,583.00 164,583.00 67,483.12 5,667.88 63,733.00 41.00 33,366.88 Department number: 85 Code Enforcement 164,583.00 164,583.00 67,483.12 5,667.88 63,733.00 41.00 33,366.88 10‐5110‐90‐00 Salaries & Wages 253,085.00 (6,100.00) 246,985.00 97,076.38 16,598.91 39.31 149,908.62 10‐5115‐90‐00 Salaries ‐ Overtime 169.00 1,050.00 1,219.00 509.51 162.07 41.80 709.49 10‐5126‐90‐00 Salaries‐Vacation Buy‐Out 4,057.00 4,057.00 1,650.29 40.68 2,406.71 10‐5140‐90‐00 Salaries ‐ Longevity Pay 945.00 945.00 560.00 59.26 385.00 10‐5141‐90‐00 Salaries ‐ Incentive 750.00 750.00 750.00 100.00 10‐5143‐90‐00 Cell Phone Allowance 3,000.00 3,000.00 900.00 180.00 30.00 2,100.00 10‐5145‐90‐00 Social Security Expense 15,952.00 15,952.00 5,809.68 968.59 36.42 10,142.32 10‐5150‐90‐00 Medicare Expense 3,730.00 3,730.00 1,358.71 226.52 36.43 2,371.29 10‐5155‐90‐00 SUTA Expense 776.00 776.00 133.58 (490.98) 17.21 642.42 10‐5160‐90‐00 Health Insurance 24,690.00 24,690.00 12,015.46 1,993.30 48.67 12,674.54 10‐5165‐90‐00 Dental Insurance 896.00 896.00 424.30 76.68 47.36 471.70 10‐5170‐90‐00 Life Insurance/AD&D 325.00 325.00 201.96 37.40 62.14 123.04 10‐5175‐90‐00 Liability (TML) Workers Comp 1,062.00 1,062.00 929.73 87.55 132.27 10‐5180‐90‐00 TMRS Expense 29,532.00 29,532.00 11,553.50 2,022.77 39.12 17,978.50 10‐5185‐90‐00 Long Term/Short Term Disabilit 1,435.00 1,435.00 ‐ 1,435.00 10‐5186‐90‐00 WELLE‐Wellness Prog Reimb Empl 1,200.00 1,200.00 540.00 100.00 45.00 660.00 10‐5190‐90‐00 Contract Labor 1,560.00 1,560.00 580.00 80.00 37.18 980.00 10‐5210‐90‐00 Office Supplies 3,800.00 3,800.00 2,408.15 445.63 525.60 63.37 866.25 10‐5220‐90‐00 Office Equipment 5,400.00 5,400.00 1,584.67 1,545.24 29.35 3,815.33 10‐5230‐90‐00 Dues,Fees,& Subscriptions 5,040.00 (2,500.00) 2,540.00 585.00 570.00 23.03 1,955.00 10‐5240‐90‐00 Postage and Delivery 200.00 200.00 134.40 12.12 67.20 65.60 10‐5250‐90‐00 Publications 500.00 500.00 ‐ 500.00 10‐5280‐90‐00 Printing and Reproduction 200.00 200.00 43.97 21.99 156.03 10‐5330‐90‐00 Copier Expense 1,100.00 1,100.00 1,078.72 ‐ 21.28 10‐5400‐90‐00 Uniform Expense 400.00 400.00 65.00 16.25 335.00 10‐5410‐90‐00 Professional Services 81,730.00 33,633.00 115,363.00 47,780.00 26,520.00 56,004.25 41.42 11,578.75 10‐5418‐90‐00 IT Fees 300.00 300.00 169.00 56.33 131.00 10‐5430‐90‐00 Legal Fees 28,000.00 20,000.00 48,000.00 13,728.60 1,045.00 20,000.00 28.60 14,271.40 10‐5435‐90‐00 Legal Notices/Filings 2,000.00 1,000.00 3,000.00 2,309.46 496.00 76.98 690.54 10‐5520‐90‐00 Telephones 5,700.00 (1,000.00) 4,700.00 381.75 79.99 8.12 4,318.25 10‐5521‐90‐00 Cell Phone Expense 1,500.00 (1,500.00) ‐ 10‐5526‐90‐00 Data Network 8,250.00 8,250.00 551.62 135.89 6.69 7,698.38 10‐5530‐90‐00 Travel/Lodging/Meals Expense 2,300.00 2,300.00 821.07 35.70 1,478.93 10‐5533‐90‐00 Mileage Expense 1,750.00 (500.00) 1,250.00 382.96 53.02 30.64 867.04 10‐5536‐90‐00 Training/Seminars 4,800.00 4,800.00 1,269.85 25.00 26.46 3,530.15 10‐5640‐90‐00 Signs & Hardware 2,000.00 (2,000.00) ‐ Subtotal object ‐ 0 493,084.00 47,133.00 540,217.00 207,208.60 52,883.15 77,608.57 38.36 255,399.83 32 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%BudgetProgram number: 493,084.00 47,133.00 540,217.00 207,208.60 52,883.15 77,608.57 38.36 255,399.83 Department number: 90 Planning 493,084.00 47,133.00 540,217.00 207,208.60 52,883.15 77,608.57 38.36 255,399.83 10‐5110‐98‐00 Salaries & Wages 462,199.00 462,199.00 211,082.30 36,290.93 45.67 251,116.70 10‐5115‐98‐00 Salaries ‐ Overtime 930.97 ‐ (930.97) 10‐5126‐98‐00 Salaries‐Vacation Buy‐Out 5,280.00 5,280.00 3,957.72 74.96 1,322.28 10‐5140‐98‐00 Salaries ‐ Longevity Pay 790.00 790.00 780.00 98.73 10.00 10‐5143‐98‐00 Cell Phone Allowance 666.49 90.00 ‐ (666.49) 10‐5145‐98‐00 Social Security Expense 27,650.00 27,650.00 11,448.64 2,025.35 41.41 16,201.36 10‐5150‐98‐00 Medicare Expense 6,793.00 6,793.00 2,861.80 473.68 42.13 3,931.20 10‐5155‐98‐00 SUTA Expense 1,035.00 1,035.00 133.18 (824.63) 12.87 901.82 10‐5160‐98‐00 Health Insurance 36,701.00 36,701.00 20,050.03 3,559.82 54.63 16,650.97 10‐5165‐98‐00 Dental Insurance 1,251.00 1,251.00 690.12 127.80 55.17 560.88 10‐5170‐98‐00 Life Insurance/AD&D 566.00 566.00 326.45 60.50 57.68 239.55 10‐5175‐98‐00 Liability (TML) Workers Comp 1,896.00 1,896.00 1,659.85 87.55 236.15 10‐5180‐98‐00 TMRS Expense 54,286.00 54,286.00 24,684.09 4,336.22 45.47 29,601.91 10‐5185‐98‐00 Long Term/Short Term Disabilit 1,071.00 1,071.00 ‐ 1,071.00 10‐5186‐98‐00 WELLE‐Wellness Prog Reimb Empl 1,200.00 1,200.00 810.00 150.00 67.50 390.00 10‐5190‐98‐00 Contract Labor 210.00 60.00 ‐ (210.00) 10‐5210‐98‐00 Office Supplies 1,800.00 1,800.00 1,036.43 235.41 57.58 763.57 10‐5212‐98‐00 Building Supplies 350.00 350.00 32.64 9.33 317.36 10‐5230‐98‐00 Dues,Fees,& Subscriptions 1,700.00 1,700.00 ‐ 1,700.00 10‐5240‐98‐00 Postage and Delivery 100.00 100.00 100.78 51.41 100.78 (0.78) 10‐5250‐98‐00 Publications 300.00 300.00 ‐ 300.00 10‐5350‐98‐00 Vehicle Expense 450.00 450.00 1,163.00 258.44 (713.00) 10‐5352‐98‐00 Fuel 1,800.00 1,800.00 ‐ 1,800.00 10‐5400‐98‐00 Uniform Expense 100.00 100.00 151.95 151.95 (51.95) 10‐5410‐98‐00 Professional Services 35,000.00 35,000.00 ‐ 35,000.00 10‐5418‐98‐00 IT Fees 250.00 250.00 ‐ 250.00 10‐5419‐98‐00 IT Licenses 35,320.00 35,320.00 354.00 ‐ 34,966.00 10‐5430‐98‐00 Legal Fees 6,000.00 6,000.00 22,137.34 3,173.00 368.96 (16,137.34) 10‐5435‐98‐00 Legal Notices/Filings 2,000.00 2,000.00 667.80 297.80 33.39 1,332.20 10‐5520‐98‐00 Telephones 5,000.00 5,000.00 1,050.26 254.87 21.01 3,949.74 10‐5524‐98‐00 Gas‐Building 1,600.00 1,600.00 715.54 141.55 44.72 884.46 10‐5525‐98‐00 Electricity 700.00 700.00 ‐ 700.00 10‐5530‐98‐00 Travel/Lodging/Meals Expense 3,250.00 3,250.00 531.79 16.36 2,718.21 10‐5533‐98‐00 Mileage Expense 1,500.00 1,500.00 415.17 49.26 27.68 1,084.83 10‐5536‐98‐00 Training/Seminars 6,000.00 6,000.00 428.75 7.15 5,571.25 Subtotal object ‐ 0 703,938.00 703,938.00 308,723.09 50,552.97 354.00 43.86 394,860.91 Program number: 703,938.00 703,938.00 308,723.09 50,552.97 354.00 43.86 394,860.91 Department number: 98 Engineering 703,938.00 703,938.00 308,723.09 50,552.97 354.00 43.86 394,860.91 10‐5176‐99‐00 TML Prop. & Liab. Insurance 100,000.00 100,000.00 83,659.38 83.66 16,340.62 10‐5305‐99‐00 Chapt 380 Program Grant Exp 14,000.00 14,000.00 3,559.00 25.42 10,441.00 10‐5418‐99‐00 IT Fees 71,821.00 71,821.00 9,491.20 5,934.00 6,985.00 13.22 55,344.80 10‐5480‐99‐00 Contracted Services 3,600.00 3,600.00 3,600.00 100.00 10‐6140‐99‐00 Capital Expenditure ‐ Equipmen 136,438.00 136,438.00 68,218.98 11,369.83 50.00 68,219.02 10‐6160‐99‐00 Capital Expenditure ‐ Vehicles 262,260.00 262,260.00 131,130.00 21,855.00 50.00 131,130.00 10‐7000‐99‐00 Contingency 50,000.00 50,000.00 30,000.00 ‐ 20,000.00 10‐7100‐99‐00 Operating Transfer Out 20,000.00 20,000.00 20,000.00 100.00 33 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 10‐7144‐99‐00 Transfer to Bond Fund 972,000.00 75,000.00 1,047,000.00 523,500.00 87,250.00 50.00 523,500.00 Subtotal object ‐ 0 1,630,119.00 75,000.00 1,705,119.00 843,158.56 126,408.83 36,985.00 49.45 824,975.44 Program number: 1,630,119.00 75,000.00 1,705,119.00 843,158.56 126,408.83 36,985.00 49.45 824,975.44 Department number: 99 Non‐departmental 1,630,119.00 75,000.00 1,705,119.00 843,158.56 126,408.83 36,985.00 49.45 824,975.44 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 14,415,741.00 310,638.00 14,726,379.00 6,027,101.55 1,000,851.75 866,063.79 40.93 7,833,213.66 Fund number: 10 General (90,293.00) 310,638.00 220,345.00 (4,786,207.90) 282,262.18 866,063.79 (2,172.14) 4,140,489.11 15‐5410‐10‐00 Professional Services 7,500.00 ‐ (7,500.00) Subtotal object ‐ 0 7,500.00 ‐ (7,500.00) Program number: 7,500.00 ‐ (7,500.00) Department number: 10 Administration 7,500.00 ‐ (7,500.00) Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 7,500.00 ‐ (7,500.00) Fund number: 15 TIRZ #1 ‐ Blue Star 7,500.00 ‐ (7,500.00) 20‐4005‐50‐00 Water Revenue (5,605,000.00) (5,605,000.00) (2,011,968.95) (220,517.50) 35.90 (3,593,031.05) 20‐4010‐50‐00 Water Tap & Construction (508,750.00) (508,750.00) (319,538.00) (69,225.00) 62.81 (189,212.00) 20‐4012‐50‐00 Saturday Inspection Fee (4,000.00) (4,000.00) (3,300.00) (1,200.00) 82.50 (700.00) 20‐4018‐50‐00 Internet Cr. Card Fees(Global) (18,000.00) (18,000.00) (10,647.90) (1,769.27) 59.16 (7,352.10) 20‐4019‐50‐00 Cr. Card Pmt Fees(auth.net) (3,000.00) (3,000.00) (2,375.35) (365.49) 79.18 (624.65) 20‐4060‐50‐00 NSF Fees (1,000.00) (1,000.00) (600.00) (150.00) 60.00 (400.00) 20‐4242‐50‐00 Re‐Inspection Fees (1,500.00) (1,500.00) (1,225.00) (425.00) 81.67 (275.00) 20‐4610‐50‐00 Interest Income (70,000.00) (70,000.00) (18,853.25) (6,845.80) 26.93 (51,146.75) 20‐4910‐50‐00 Other Revenue (70,000.00) (70,000.00) (37,600.06) (3,707.12) 53.71 (32,399.94) Subtotal object ‐ 0 (6,281,250.00) (6,281,250.00) (2,406,108.51) (304,205.18) 38.31 (3,875,141.49) Program number: (6,281,250.00) (6,281,250.00) (2,406,108.51) (304,205.18) 38.31 (3,875,141.49) Department number: 50 Water (6,281,250.00) (6,281,250.00) (2,406,108.51) (304,205.18) 38.31 (3,875,141.49) 20‐4006‐55‐00 Sewer Revenue (2,777,000.00) (2,777,000.00) (1,294,614.65) (215,392.88) 46.62 (1,482,385.35) 20‐4010‐55‐00 Sewer Tap & Construction (220,000.00) (220,000.00) (109,800.00) (23,400.00) 49.91 (110,200.00) Subtotal object ‐ 0 (2,997,000.00) (2,997,000.00) (1,404,414.65) (238,792.88) 46.86 (1,592,585.35) Program number: (2,997,000.00) (2,997,000.00) (1,404,414.65) (238,792.88) 46.86 (1,592,585.35) Department number: 55 Sewer (2,997,000.00) (2,997,000.00) (1,404,414.65) (238,792.88) 46.86 (1,592,585.35) 20‐4000‐57‐00 W/S Service Initiation (57,043.00) (57,043.00) (24,885.00) (4,960.00) 43.63 (32,158.00) 20‐4007‐57‐00 Sanitation (900,000.00) (900,000.00) (482,489.18) (81,700.74) 53.61 (417,510.82) 20‐4009‐57‐00 Late Fee‐W/S (60,000.00) (60,000.00) (45,948.85) (5,584.09) 76.58 (14,051.15) Subtotal object ‐ 0 (1,017,043.00) (1,017,043.00) (553,323.03) (92,244.83) 54.41 (463,719.97) Program number: (1,017,043.00) (1,017,043.00) (553,323.03) (92,244.83) 54.41 (463,719.97) Department number: 57 Utility Billing Department (1,017,043.00) (1,017,043.00) (553,323.03) (92,244.83) 54.41 (463,719.97) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (10,295,293.00) (10,295,293.00) (4,363,846.19) (635,242.89) 42.39 (5,931,446.81) 20‐5176‐00‐00 TML‐Prop & Liab Insurance 35,000.00 35,000.00 29,280.78 83.66 5,719.22 20‐6140‐00‐00 Capital Expenditure ‐ Equipmen 15,771.00 15,771.00 7,885.50 1,314.25 50.00 7,885.50 20‐6160‐00‐00 Capital Expenditure ‐ Vehicles 119,553.00 119,553.00 59,776.50 9,962.75 50.00 59,776.50 20‐6186‐00‐00 2013 Bond Payment 387,600.00 387,600.00 93,800.00 93,800.00 24.20 293,800.00 20‐6192‐00‐00 2011 Refd Bond Pmt 276,246.00 276,246.00 270,420.63 270,420.63 97.89 5,825.37 20‐6193‐00‐00 2012 CO Bond Payment 145,020.00 145,020.00 95,235.00 95,235.00 65.67 49,785.00 20‐6198‐00‐00 06 CO Bond Payment 491,197.00 491,197.00 97,398.61 97,398.61 19.83 393,798.39 20‐6199‐00‐00 08 CO Bond Payment 119,894.00 119,894.00 87,332.50 87,332.50 72.84 32,561.50 20‐6201‐00‐00 2014 GO Bond Payment 483,439.00 483,439.00 135,995.35 28.13 347,443.65 20‐6202‐00‐00 2014 CO Bond Payment 926,350.00 926,350.00 240,675.00 240,675.00 25.98 685,675.00 20‐7000‐00‐00 Contingency 50,000.00 50,000.00 ‐ 50,000.00 20‐7147‐00‐00 Transfer to GF 862,695.00 862,695.00 431,347.50 71,891.25 50.00 431,347.50 34 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget Subtotal object ‐ 0 3,912,765.00 3,912,765.00 1,549,147.37 968,029.99 39.59 2,363,617.63 Program number: 3,912,765.00 3,912,765.00 1,549,147.37 968,029.99 39.59 2,363,617.63 Department number: Non departmental 3,912,765.00 3,912,765.00 1,549,147.37 968,029.99 39.59 2,363,617.63 20‐5110‐50‐00 Salaries & Wages 630,968.00 630,968.00 250,919.55 46,148.92 39.77 380,048.45 20‐5115‐50‐00 Salaries ‐ Overtime 45,055.00 45,055.00 14,748.71 1,972.49 32.74 30,306.29 20‐5126‐50‐00 Salaries‐Vacation Buy‐Out 4,459.00 4,459.00 972.40 21.81 3,486.60 20‐5140‐50‐00 Salaries ‐ Longevity Pay 2,165.00 2,165.00 2,050.00 94.69 115.00 20‐5145‐50‐00 Social Security Expense 39,753.00 39,753.00 15,713.00 2,807.46 39.53 24,040.00 20‐5150‐50‐00 Medicare Expense 9,300.00 9,300.00 3,674.81 656.57 39.51 5,625.19 20‐5155‐50‐00 SUTA Expense 2,794.00 2,794.00 506.23 (1,338.00) 18.12 2,287.77 20‐5160‐50‐00 Health Insurance 77,164.00 77,164.00 24,673.38 4,400.18 31.98 52,490.62 20‐5165‐50‐00 Dental Insurance 3,981.00 3,981.00 1,518.26 281.16 38.14 2,462.74 20‐5170‐50‐00 Life Insurance/AD&D 1,240.00 1,240.00 486.98 98.50 39.27 753.02 20‐5175‐50‐00 Liability (TML) Workers' Comp 11,255.00 11,255.00 9,853.19 87.55 1,401.81 20‐5180‐50‐00 TMRS Expense 74,858.00 74,858.00 30,211.00 5,738.72 40.36 44,647.00 20‐5185‐50‐00 Long Term/Short Term Disabilit 3,429.00 3,429.00 ‐ 3,429.00 20‐5186‐50‐00 WELLE‐Wellness Prog Reimb‐Empl 3,600.00 3,600.00 1,053.00 225.00 29.25 2,547.00 20‐5190‐50‐00 Contract Labor 2,250.00 600.00 ‐ (2,250.00) 20‐5210‐50‐00 Office Supplies 3,100.00 3,100.00 1,221.30 182.54 39.40 1,878.70 20‐5212‐50‐00 Building Supplies 1,550.00 1,550.00 198.80 12.83 1,351.20 20‐5220‐50‐00 Office Equipment 11,004.00 11,004.00 4,733.44 2,994.56 43.02 6,270.56 20‐5230‐50‐00 Dues,Fees,& Subscriptions 3,400.00 3,400.00 1,577.64 839.00 46.40 1,822.36 20‐5240‐50‐00 Postage and Delivery 1,800.00 1,800.00 27.71 15.75 1.54 1,772.29 20‐5250‐50‐00 Publications 50.00 50.00 ‐ 50.00 20‐5280‐50‐00 Printing and Reproduction 3,450.00 3,450.00 ‐ 3,450.00 20‐5310‐50‐00 Rental Expense 600.00 600.00 ‐ 600.00 20‐5320‐50‐00 Repairs & Maintenance 3,600.00 3,600.00 12.25 0.34 3,587.75 20‐5340‐50‐00 Building Repairs 4,000.00 4,000.00 4,521.75 113.04 (521.75) 20‐5350‐50‐00 Vehicle Expense 25,700.00 25,700.00 8,214.76 2,177.36 31.96 17,485.24 20‐5352‐50‐00 Fuel 40,200.00 40,200.00 8,506.92 74.09 21.16 31,693.08 20‐5353‐50‐00 Oil/Grease/Inspections 2,470.00 2,470.00 119.25 4.83 2,350.75 20‐5400‐50‐00 Uniform Expense 14,600.00 14,600.00 1,494.69 92.54 10.24 13,105.31 20‐5418‐50‐00 IT Fees 18,700.00 19,000.00 37,700.00 24,392.18 7,000.00 64.70 6,307.82 20‐5419‐50‐00 IT Licenses 1,200.00 1,200.00 2,363.00 196.92 (1,163.00) 20‐5430‐50‐00 Legal Fees 1,000.00 1,000.00 57.00 5.70 943.00 20‐5435‐50‐00 Legal Notices/Filings 500.00 500.00 ‐ 500.00 20‐5475‐50‐00 Credit Card Fees 25,000.00 25,000.00 16,612.68 2,655.65 66.45 8,387.32 20‐5480‐50‐00 Contracted Services 16,000.00 26,223.00 42,223.00 38,851.15 417.96 672.75 92.01 2,699.10 20‐5520‐50‐00 Telephones 17,820.00 17,820.00 3,462.69 407.62 19.43 14,357.31 20‐5521‐50‐00 Cell Phone Expense 2,160.00 2,160.00 ‐ 2,160.00 20‐5524‐50‐00 Gas‐Building 2,570.00 2,570.00 512.02 19.92 2,057.98 20‐5525‐50‐00 Electricity 150,000.00 150,000.00 90,591.59 13,560.17 60.39 59,408.41 20‐5526‐50‐00 Data Network 4,000.00 4,000.00 2,754.10 699.80 68.85 1,245.90 20‐5530‐50‐00 Travel/Lodging/Meals Expense 1,000.00 1,000.00 ‐ 1,000.00 20‐5533‐50‐00 Mileage Expense 1,000.00 1,000.00 155.40 15.54 844.60 20‐5536‐50‐00 Training/Seminars 5,600.00 3,500.00 9,100.00 6,755.83 1,169.99 74.24 2,344.17 20‐5540‐50‐00 Water Testing 1,500.00 1,500.00 1,180.05 390.52 78.67 319.95 20‐5545‐50‐00 Meter Purchases 203,500.00 12,220.00 215,720.00 86,636.60 900.00 14,000.00 40.16 115,083.40 35 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 20‐5550‐50‐00 Water Purchases 2,037,900.00 2,037,900.00 804,682.38 162,330.21 39.49 1,233,217.62 20‐5620‐50‐00 Tools & Equipment 10,900.00 10,900.00 3,478.77 31.92 7,421.23 20‐5630‐50‐00 Safety Equipment 7,700.00 7,700.00 1,047.82 13.61 6,652.18 20‐5640‐50‐00 Signs & Hardware 800.00 800.00 178.12 22.27 621.88 20‐5650‐50‐00 Maintenance Materials 12,400.00 12,400.00 3,100.54 1,341.00 25.00 9,299.46 20‐5660‐50‐00 Chemical Supplies 1,000.00 1,000.00 550.94 474.89 55.09 449.06 20‐5670‐50‐00 System Improvements/Repairs 78,950.00 78,950.00 37,072.81 2,373.49 46.96 41,877.19 20‐6160‐50‐00 Capital Expenditure ‐ Vehicles 60,000.00 60,000.00 56,126.50 ‐ 3,873.50 20‐6186‐50‐00 2013 Bond Payment (93,800.00) ‐ 20‐6187‐50‐00 2014 CO Bond Payment (240,675.00) ‐ 20‐6192‐50‐00 2011 Refd Bond Pmt (270,420.63) ‐ 20‐6193‐50‐00 2012 CO Bond Payment (95,235.00) ‐ 20‐6198‐50‐00 2006 CO Bond Payment (97,398.61) ‐ 20‐6199‐50‐00 2008 CO Bond Payment (87,332.50) ‐ 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,080.00 180.00 50.00 1,080.00 Subtotal object ‐ 0 3,691,905.00 60,943.00 3,752,848.00 1,514,774.69 (629,993.60) 77,799.25 40.36 2,160,274.06 Program number: 3,691,905.00 60,943.00 3,752,848.00 1,514,774.69 (629,993.60) 77,799.25 40.36 2,160,274.06 Department number: 50 Water 3,691,905.00 60,943.00 3,752,848.00 1,514,774.69 (629,993.60) 77,799.25 40.36 2,160,274.06 20‐5110‐55‐00 Salaries & Wages 144,885.00 144,885.00 54,722.83 10,084.13 37.77 90,162.17 20‐5115‐55‐00 Salaries ‐ Overtime 7,279.00 7,279.00 3,049.73 384.78 41.90 4,229.27 20‐5126‐55‐00 Salaries‐Vacation Buy‐Out 1,074.00 1,074.00 ‐ 1,074.00 20‐5140‐55‐00 Salaries ‐ Longevity Pay 840.00 840.00 830.00 98.81 10.00 20‐5145‐55‐00 Social Security Expense 9,175.00 9,175.00 3,360.02 599.77 36.62 5,814.98 20‐5150‐55‐00 Medicare Expense 2,146.00 2,146.00 785.81 140.27 36.62 1,360.19 20‐5155‐55‐00 SUTA Expense 776.00 776.00 83.29 (360.99) 10.73 692.71 20‐5160‐55‐00 Health Insurance 19,699.00 19,699.00 6,143.25 1,109.12 31.19 13,555.75 20‐5165‐55‐00 Dental Insurance 1,209.00 1,209.00 414.07 76.68 34.25 794.93 20‐5170‐55‐00 Life Insurance/AD&D 320.00 320.00 131.60 27.58 41.13 188.40 20‐5175‐55‐00 Liability (TML) Workers' Comp 3,311.00 3,311.00 2,898.61 87.55 412.39 20‐5180‐55‐00 TMRS Expense 16,910.00 16,910.00 6,668.60 1,252.73 39.44 10,241.40 20‐5185‐55‐00 Long Term/Short Term Disabilit 1,075.00 1,075.00 ‐ 1,075.00 20‐5186‐55‐00 WELLE‐Wellness Prog Reimb‐Empl 1,200.00 1,200.00 348.00 85.00 29.00 852.00 20‐5210‐55‐00 Office Supplies 800.00 800.00 ‐ 800.00 20‐5212‐55‐00 Building Supplies 600.00 600.00 ‐ 600.00 20‐5220‐55‐00 Office Equipment 750.00 750.00 ‐ 750.00 20‐5230‐55‐00 Dues,Fees,& Subscriptions 1,550.00 1,550.00 ‐ 1,550.00 20‐5240‐55‐00 Postage and Delivery 200.00 200.00 ‐ 200.00 20‐5250‐55‐00 Publications 100.00 100.00 ‐ 100.00 20‐5310‐55‐00 Rental Expense 500.00 500.00 ‐ 500.00 20‐5320‐55‐00 Repairs & Maintenance 400.00 400.00 ‐ 400.00 20‐5335‐55‐00 Radio/Video Repairs 700.00 700.00 ‐ 700.00 20‐5340‐55‐00 Building Repairs 1,000.00 1,000.00 243.33 24.33 756.67 20‐5350‐55‐00 Vehicle Expense 6,200.00 6,200.00 4,765.12 967.12 76.86 1,434.88 20‐5352‐55‐00 Fuel 6,500.00 6,500.00 1,081.84 16.64 5,418.16 20‐5353‐55‐00 Oil/Grease/Inspections 1,500.00 1,500.00 ‐ 1,500.00 20‐5400‐55‐00 Uniform Expense 8,600.00 8,600.00 353.95 4.12 8,246.05 20‐5430‐55‐00 Legal Fees 500.00 500.00 ‐ 500.00 36 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 20‐5480‐55‐00 Contracted Services 21,000.00 21,000.00 1,415.20 6.74 19,584.80 20‐5520‐55‐00 Telephones 3,560.00 3,560.00 288.24 54.13 8.10 3,271.76 20‐5521‐55‐00 Cell Phone Expense 1,080.00 1,080.00 ‐ 1,080.00 20‐5524‐55‐00 Gas ‐ Building 1,000.00 1,000.00 ‐ 1,000.00 20‐5525‐55‐00 Electricity 50,800.00 50,800.00 18,687.06 3,516.65 36.79 32,112.94 20‐5530‐55‐00 Travel/Lodging/Meals Expense 600.00 600.00 ‐ 600.00 20‐5533‐55‐00 Mileage Expense 500.00 500.00 ‐ 500.00 20‐5536‐55‐00 Training/Seminars 1,700.00 1,700.00 1,505.85 1,446.00 88.58 194.15 20‐5540‐55‐00 Water Testing 500.00 500.00 ‐ 500.00 20‐5560‐55‐00 Sewer Management Fees 1,268,700.00 1,268,700.00 702,661.27 94,721.35 55.38 566,038.73 20‐5620‐55‐00 Tools & Equipment 4,500.00 4,500.00 1,251.22 1,225.77 27.81 3,248.78 20‐5630‐55‐00 Safety Equipment 4,600.00 6,261.00 10,861.00 6,593.67 60.71 4,267.33 20‐5640‐55‐00 Signs & Hardware 1,000.00 1,000.00 ‐ 1,000.00 20‐5650‐55‐00 Maintenance Materials 1,000.00 1,000.00 ‐ 1,000.00 20‐5660‐55‐00 Chemical Supplies 1,000.00 1,000.00 ‐ 1,000.00 20‐5670‐55‐00 System Improvements/Repairs 12,000.00 12,000.00 1,585.75 13.22 10,414.25 20‐5680‐55‐00 Lift Station Expense 30,900.00 30,900.00 28,163.80 3,818.50 91.15 2,736.20 20‐6140‐55‐00 Capital Expenditure ‐ Equipmt 75,000.00 75,000.00 76,796.00 ‐ (1,796.00) Subtotal object ‐ 0 1,719,239.00 6,261.00 1,725,500.00 848,032.11 119,148.59 76,796.00 49.15 800,671.89 Program number: 1,719,239.00 6,261.00 1,725,500.00 848,032.11 119,148.59 76,796.00 49.15 800,671.89 Department number: 55 Sewer 1,719,239.00 6,261.00 1,725,500.00 848,032.11 119,148.59 76,796.00 49.15 800,671.89 20‐5110‐57‐00 Salaries & Wages 106,969.00 106,969.00 47,486.35 8,148.30 44.39 59,482.65 20‐5115‐57‐00 Salaries ‐ Overtime 5,000.00 5,000.00 796.08 86.28 15.92 4,203.92 20‐5140‐57‐00 Salaries ‐ Longevity Pay 550.00 550.00 545.00 99.09 5.00 20‐5145‐57‐00 Social Security Expense 6,788.00 6,788.00 2,870.41 482.07 42.29 3,917.59 20‐5150‐57‐00 Medicare Expense 1,588.00 1,588.00 671.29 112.74 42.27 916.71 20‐5155‐57‐00 SUTA Expense 621.00 621.00 131.36 (322.76) 21.15 489.64 20‐5160‐57‐00 Health Insurance 8,223.00 8,223.00 4,240.19 775.22 51.57 3,982.81 20‐5165‐57‐00 Dental Insurance 626.00 626.00 276.05 51.12 44.10 349.95 20‐5170‐57‐00 AD&D/Life Insurance 189.00 189.00 85.10 15.76 45.03 103.90 20‐5175‐57‐00 Liability (TML) Workers' Comp 241.00 241.00 210.98 87.54 30.02 20‐5180‐57‐00 TMRS Expense 12,686.00 12,686.00 4,841.89 865.93 38.17 7,844.11 20‐5185‐57‐00 Long Term/Short Term Disabilit 185.00 185.00 ‐ 185.00 20‐5186‐57‐00 WELLE‐Wellness Prog Reimb‐Empl 1,200.00 1,200.00 540.00 100.00 45.00 660.00 20‐5210‐57‐00 Office Supplies 1,600.00 1,600.00 1,259.74 24.97 78.73 340.26 20‐5212‐57‐00 Building Supplies 800.00 800.00 373.87 46.73 426.13 20‐5220‐57‐00 Office Equipment 2,000.00 2,000.00 699.29 34.97 1,300.71 20‐5230‐57‐00 Dues,Fees,& Subscriptions 150.00 150.00 ‐ 150.00 20‐5240‐57‐00 Postage and Delivery 21,000.00 21,000.00 11,755.03 2,288.85 55.98 9,244.97 20‐5280‐57‐00 Printing and Reproduction 1,000.00 1,000.00 ‐ 1,000.00 20‐5400‐57‐00 Uniform Expense 150.00 150.00 ‐ 150.00 20‐5418‐57‐00 IT Fees 8,000.00 8,000.00 5,500.00 ‐ 2,500.00 20‐5419‐57‐00 IT Licenses 10,000.00 10,000.00 10,000.00 ‐ 20‐5470‐57‐00 Trash Collection 820,000.00 820,000.00 369,241.48 74,918.01 45.03 450,758.52 20‐5479‐57‐00 Household Haz. Waste Disposal 6,000.00 6,000.00 1,350.00 22.50 4,650.00 20‐5480‐57‐00 Contracted Services 15,000.00 15,000.00 3,600.83 1,305.31 24.01 11,399.17 20‐5520‐57‐00 Telephones 800.00 800.00 126.00 126.00 15.75 674.00 20‐5530‐57‐00 Travel/Lodging/Meals Expense 300.00 300.00 ‐ 300.00 37 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 20‐5533‐57‐00 Mileage Expense 1,000.00 1,000.00 ‐ 1,000.00 20‐5536‐57‐00 Training/Seminars 900.00 900.00 ‐ 900.00 Subtotal object ‐ 0 1,033,566.00 1,033,566.00 451,100.94 88,977.80 15,500.00 43.65 566,965.06 Program number: 1,033,566.00 1,033,566.00 451,100.94 88,977.80 15,500.00 43.65 566,965.06 Department number: 57 Utility Billing Department 1,033,566.00 1,033,566.00 451,100.94 88,977.80 15,500.00 43.65 566,965.06 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 10,357,475.00 67,204.00 10,424,679.00 4,363,055.11 546,162.78 170,095.25 41.85 5,891,528.64 Fund number: 20 Water/Sewer 62,182.00 67,204.00 129,386.00 (791.08) (89,080.11) 170,095.25 (0.61) (39,918.17) 30‐4105‐10‐00 Property Taxes ‐Delinquent (50,000.00) (50,000.00) (47,286.03) (11,616.12) 94.57 (2,713.97) 30‐4110‐10‐00 Property Taxes ‐Current (2,870,065.00) (2,870,065.00) (3,001,033.77) (33,413.81) 104.56 130,968.77 30‐4115‐10‐00 Taxes ‐Penalties (20,000.00) (20,000.00) (9,686.60) (3,442.44) 48.43 (10,313.40) 30‐4610‐10‐00 Interest Income (15,000.00) (15,000.00) (12,038.74) (2,748.34) 80.26 (2,961.26) Subtotal object ‐ 0 (2,955,065.00) (2,955,065.00) (3,070,045.14) (51,220.71) 103.89 114,980.14 Program number: (2,955,065.00) (2,955,065.00) (3,070,045.14) (51,220.71) 103.89 114,980.14 Department number: 10 Administrative (2,955,065.00) (2,955,065.00) (3,070,045.14) (51,220.71) 103.89 114,980.14 Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (2,955,065.00) (2,955,065.00) (3,070,045.14) (51,220.71) 103.89 114,980.14 30‐6186‐10‐00 2013 GO Ref Bond 287,200.00 287,200.00 68,600.00 23.89 218,600.00 30‐6191‐10‐00 2010 Tax Note Payment 370,175.00 370,175.00 363,918.75 98.31 6,256.25 30‐6192‐10‐00 2011 Ref Bond Pmt 176,616.00 176,616.00 172,891.87 97.89 3,724.13 30‐6193‐10‐00 2012 GO Bond Payment 112,413.00 112,413.00 56,206.25 50.00 56,206.75 30‐6198‐10‐00 2006 Bond Payment 453,413.00 453,413.00 89,906.40 19.83 363,506.60 30‐6199‐10‐00 2008 CO Bond Payment 1,079,049.00 1,079,049.00 785,992.50 72.84 293,056.50 30‐6200‐10‐00 Bond Administrative Fees 21,000.00 21,000.00 1,600.00 400.00 7.62 19,400.00 30‐6201‐10‐00 2014 G.O. Bond Payment 370,199.00 370,199.00 102,592.98 27.71 267,606.02 Subtotal object ‐ 0 2,870,065.00 2,870,065.00 1,641,708.75 400.00 57.20 1,228,356.25 Program number: 2,870,065.00 2,870,065.00 1,641,708.75 400.00 57.20 1,228,356.25 Department number: 10 Administrative 2,870,065.00 2,870,065.00 1,641,708.75 400.00 57.20 1,228,356.25 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 2,870,065.00 2,870,065.00 1,641,708.75 400.00 57.20 1,228,356.25 Fund number: 30 Interest and Sinking (85,000.00) (85,000.00) (1,428,336.39) (50,820.71) 1,680.40 1,343,336.39 40‐4100‐10‐00 Charges for Services (25,000.00) (25,000.00) (8,550.00) (1,395.00) 34.20 (16,450.00) 40‐4610‐10‐00 Interest Income (250.00) (250.00) (321.86) (54.36) 128.74 71.86 40‐4995‐10‐00 Transfer In (19,400.00) (19,400.00) (1,200.00) (200.00) 6.19 (18,200.00) Subtotal object ‐ 0 (44,650.00) (44,650.00) (10,071.86) (1,649.36) 22.56 (34,578.14) Program number: (44,650.00) (44,650.00) (10,071.86) (1,649.36) 22.56 (34,578.14) Department number: 10 General Fund (44,650.00) (44,650.00) (10,071.86) (1,649.36) 22.56 (34,578.14) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (44,650.00) (44,650.00) (10,071.86) (1,649.36) 22.56 (34,578.14) 40‐5160‐10‐00 MERP H & D Expense ‐ GF 30,000.00 30,000.00 2,800.00 9.33 27,200.00 Subtotal object ‐ 0 30,000.00 30,000.00 2,800.00 9.33 27,200.00 Program number: 30,000.00 30,000.00 2,800.00 9.33 27,200.00 Department number: 10 General Fund 30,000.00 30,000.00 2,800.00 9.33 27,200.00 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 30,000.00 30,000.00 2,800.00 9.33 27,200.00 Fund number: 40 Internal Service Fund (14,650.00) (14,650.00) (7,271.86) (1,649.36) 49.64 (7,378.14) 41‐4100‐99‐00 Charges for Services (486,195.00) (486,195.00) (267,010.98) (44,501.83) 54.92 (219,184.02) 41‐4910‐99‐00 Other Reimbursements (50,000.00) (50,000.00) (9,976.12) 19.95 (40,023.88) 41‐4995‐99‐00 Transfer In (800,000.00) (800,000.00) ‐ (800,000.00) Subtotal object ‐ 0 (1,336,195.00) (1,336,195.00) (276,987.10) (44,501.83) 20.73 (1,059,207.90) Program number: (1,336,195.00) (1,336,195.00) (276,987.10) (44,501.83) 20.73 (1,059,207.90) Department number: 99 Non‐Departmental (1,336,195.00) (1,336,195.00) (276,987.10) (44,501.83) 20.73 (1,059,207.90) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (1,336,195.00) (1,336,195.00) (276,987.10) (44,501.83) 20.73 (1,059,207.90) 38 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 41‐6125‐10‐01 Capital‐Equipment (Technology) 10,470.00 10,470.00 1,434.85 804.86 13.70 9,035.15 Subtotal object ‐ 0 10,470.00 10,470.00 1,434.85 804.86 13.70 9,035.15 Program number: 1 Administration‐Town Manager 10,470.00 10,470.00 1,434.85 804.86 13.70 9,035.15 41‐6125‐10‐02 Capital‐Equipment (Technology) 2,200.00 2,200.00 4,822.94 1,043.00 219.23 (2,622.94) Subtotal object ‐ 0 2,200.00 2,200.00 4,822.94 1,043.00 219.23 (2,622.94) Program number: 2 Administration‐Town Secretary 2,200.00 2,200.00 4,822.94 1,043.00 219.23 (2,622.94) 41‐6125‐10‐03 Capital‐Equipment (Technology) 8,300.00 8,300.00 16,482.58 ‐ (8,182.58) Subtotal object ‐ 0 8,300.00 8,300.00 16,482.58 ‐ (8,182.58) Program number: 3 Administration‐Finance 8,300.00 8,300.00 16,482.58 ‐ (8,182.58) 41‐6125‐10‐04 Capital‐Equipment (Technology) 2,200.00 2,200.00 ‐ 2,200.00 Subtotal object ‐ 0 2,200.00 2,200.00 ‐ 2,200.00 Program number: 4 Administration‐Human Resources 2,200.00 2,200.00 ‐ 2,200.00 Department number: 10 Administration‐Town Manager 23,170.00 23,170.00 6,257.79 1,847.86 16,482.58 27.01 429.63 41‐6125‐20‐00 Capital‐Equipment (Technology) 53,040.00 53,040.00 26,981.86 ‐ 26,058.14 41‐6160‐20‐00 Capital‐Vehicles 76,000.00 76,000.00 76,124.94 ‐ (124.94) Subtotal object ‐ 0 129,040.00 129,040.00 103,106.80 ‐ 25,933.20 Program number: 129,040.00 129,040.00 103,106.80 ‐ 25,933.20 Department number: 20 Police 129,040.00 129,040.00 103,106.80 ‐ 25,933.20 41‐6125‐25‐00 Capital‐Equipment (Technology) 1,700.00 1,700.00 1,305.17 ‐ 394.83 Subtotal object ‐ 0 1,700.00 1,700.00 1,305.17 ‐ 394.83 Program number: 1,700.00 1,700.00 1,305.17 ‐ 394.83 Department number: 25 Dispatch 1,700.00 1,700.00 1,305.17 ‐ 394.83 41‐6125‐30‐00 Capital‐Equipment (Technology) 31,670.00 31,670.00 279.29 77.96 12,279.48 0.88 19,111.23 41‐6160‐30‐00 Capital‐Vehicles 250,000.00 250,000.00 ‐ 250,000.00 Subtotal object ‐ 0 281,670.00 281,670.00 279.29 77.96 12,279.48 0.10 269,111.23 Program number: 281,670.00 281,670.00 279.29 77.96 12,279.48 0.10 269,111.23 Department number: 30 Fire 281,670.00 281,670.00 279.29 77.96 12,279.48 0.10 269,111.23 41‐6125‐35‐00 Capital‐Equipment (Technology) 2,430.00 2,430.00 768.21 19.49 31.61 1,661.79 Subtotal object ‐ 0 2,430.00 2,430.00 768.21 19.49 31.61 1,661.79 Program number: 2,430.00 2,430.00 768.21 19.49 31.61 1,661.79 Department number: 35 Fire Marshal 2,430.00 2,430.00 768.21 19.49 31.61 1,661.79 41‐6125‐40‐00 Capital‐Equipment (Technology) 961.58 ‐ (961.58) Subtotal object ‐ 0 961.58 ‐ (961.58) Program number: 961.58 ‐ (961.58) Department number: 40 Streets 961.58 ‐ (961.58) 41‐6125‐50‐00 Capital‐Equipment (Technology) 6,100.00 6,100.00 961.58 ‐ 5,138.42 41‐6140‐50‐00 Machinery & Equipment 95,000.00 95,000.00 85,425.00 ‐ 9,575.00 41‐6160‐50‐00 Capital‐Vehicles 44,000.00 44,000.00 48,999.79 ‐ (4,999.79) Subtotal object ‐ 0 145,100.00 145,100.00 135,386.37 ‐ 9,713.63 Program number: 145,100.00 145,100.00 135,386.37 ‐ 9,713.63 Department number: 50 Water 145,100.00 145,100.00 135,386.37 ‐ 9,713.63 41‐6125‐55‐00 Capital‐Equipment (Technology) 2,200.00 2,200.00 ‐ 2,200.00 41‐6140‐55‐00 Machinery & Equipment 68,790.42 ‐ (68,790.42) 41‐6160‐55‐00 Capital‐Vehicles 142,000.00 142,000.00 35,471.50 ‐ 106,528.50 Subtotal object ‐ 0 144,200.00 144,200.00 104,261.92 ‐ 39,938.08 Program number: 144,200.00 144,200.00 104,261.92 ‐ 39,938.08 Department number: 55 Sewer 144,200.00 144,200.00 104,261.92 ‐ 39,938.08 41‐6125‐57‐00 Capital‐Equipment (Technology) 3,400.00 3,400.00 3,492.24 ‐ (92.24) 39 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget Subtotal object ‐ 0 3,400.00 3,400.00 3,492.24 ‐ (92.24) Program number: 3,400.00 3,400.00 3,492.24 ‐ (92.24) Department number: 57 Utility Billing 3,400.00 3,400.00 3,492.24 ‐ (92.24) 41‐6125‐60‐00 Capital‐Equipment (Technology) 2,200.00 2,200.00 ‐ 2,200.00 Subtotal object ‐ 0 2,200.00 2,200.00 ‐ 2,200.00 Program number: 2,200.00 2,200.00 ‐ 2,200.00 Department number: 60 Parks 2,200.00 2,200.00 ‐ 2,200.00 41‐6125‐70‐00 Capital‐Equipment (Technology) 2,200.00 2,200.00 1,732.92 ‐ 467.08 Subtotal object ‐ 0 2,200.00 2,200.00 1,732.92 ‐ 467.08 Program number: 2,200.00 2,200.00 1,732.92 ‐ 467.08 Department number: 70 Municipal Court 2,200.00 2,200.00 1,732.92 ‐ 467.08 41‐6125‐80‐00 Capital‐Equipment (Technology) 8,500.00 8,500.00 6,092.82 ‐ 2,407.18 41‐6160‐80‐00 Capital‐Vehicles 40,000.00 40,000.00 ‐ 40,000.00 Subtotal object ‐ 0 48,500.00 48,500.00 6,092.82 ‐ 42,407.18 Program number: 48,500.00 48,500.00 6,092.82 ‐ 42,407.18 Department number: 80 Inspections 48,500.00 48,500.00 6,092.82 ‐ 42,407.18 41‐6125‐85‐00 Capital‐Equipment (Technology) 1,700.00 1,700.00 1,096.57 ‐ 603.43 Subtotal object ‐ 0 1,700.00 1,700.00 1,096.57 ‐ 603.43 Program number: 1,700.00 1,700.00 1,096.57 ‐ 603.43 Department number: 85 Code Enforcement 1,700.00 1,700.00 1,096.57 ‐ 603.43 41‐6125‐90‐00 Capital‐Equipment (Technology) 6,100.00 6,100.00 1,436.50 ‐ 4,663.50 Subtotal object ‐ 0 6,100.00 6,100.00 1,436.50 ‐ 4,663.50 Program number: 6,100.00 6,100.00 1,436.50 ‐ 4,663.50 Department number: 90 Planning 6,100.00 6,100.00 1,436.50 ‐ 4,663.50 41‐6125‐98‐00 Capital‐Equipment (Technology) 2,200.00 2,200.00 1,571.49 ‐ 628.51 Subtotal object ‐ 0 2,200.00 2,200.00 1,571.49 ‐ 628.51 Program number: 2,200.00 2,200.00 1,571.49 ‐ 628.51 Department number: 98 Engineering 2,200.00 2,200.00 1,571.49 ‐ 628.51 41‐6125‐99‐00 Capital‐Equipment (Technology) 3,400.00 3,400.00 ‐ 3,400.00 Subtotal object ‐ 0 3,400.00 3,400.00 ‐ 3,400.00 Program number: 3,400.00 3,400.00 ‐ 3,400.00 Department number: 99 Non‐Departmental 3,400.00 3,400.00 ‐ 3,400.00 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 797,010.00 797,010.00 7,305.29 1,945.31 389,206.44 0.92 400,498.27 Fund number: 41 Vehicle/Equipment Replacement (539,185.00) (539,185.00) (269,681.81) (42,556.52) 389,206.44 50.02 (658,709.63) 45‐4001‐10‐00 Storm Drainage Utility Fee (270,400.00) (270,400.00) (133,683.18) (22,485.37) 49.44 (136,716.82) 45‐4610‐10‐00 Interest Storm Utility (1,600.00) (1,600.00) (247.25) (51.28) 15.45 (1,352.75) Subtotal object ‐ 0 (272,000.00) (272,000.00) (133,930.43) (22,536.65) 49.24 (138,069.57) Program number: (272,000.00) (272,000.00) (133,930.43) (22,536.65) 49.24 (138,069.57) Department number: 10 Administration (272,000.00) (272,000.00) (133,930.43) (22,536.65) 49.24 (138,069.57) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (272,000.00) (272,000.00) (133,930.43) (22,536.65) 49.24 (138,069.57) 45‐5110‐10‐00 Salaries 80,056.00 (5,664.00) 74,392.00 16,861.01 5,214.76 22.67 57,530.99 45‐5115‐10‐00 Salaries‐Overtime 3,004.00 3,004.00 1,154.29 363.03 38.43 1,849.71 45‐5126‐10‐00 Salaries0Vacation Buy‐Out 171.00 171.00 ‐ 171.00 45‐5140‐10‐00 Salaries‐Longevity Pay 75.00 75.00 75.00 100.00 45‐5145‐10‐00 Social Security Expense 5,016.00 5,016.00 1,066.14 334.61 21.26 3,949.86 45‐5150‐10‐00 Medicare Expense 1,174.00 1,174.00 249.35 78.26 21.24 924.65 45‐5155‐10‐00 SUTA Expense 362.00 362.00 31.61 (82.37) 8.73 330.39 45‐5160‐10‐00 Health Insurance 11,477.00 11,477.00 1,866.02 340.56 16.26 9,610.98 40 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 45‐5165‐10‐00 Dental Expense 270.00 270.00 138.02 25.56 51.12 131.98 45‐5170‐10‐00 Life Ins/AD&D 159.00 159.00 46.49 11.82 29.24 112.51 45‐5175‐10‐00 Liability (TML) Workers Comp 720.00 720.00 630.32 87.54 89.68 45‐5180‐10‐00 TMRS Expense 8,942.00 8,942.00 2,070.86 662.08 23.16 6,871.14 45‐5185‐10‐00 Long Term/Short Term Disabilit 1,536.00 1,536.00 ‐ 1,536.00 45‐5186‐10‐00 WELLE‐Wellness Prog Reimb Empl 600.00 600.00 84.00 14.00 516.00 45‐5210‐10‐00 Office Supplies 400.00 400.00 ‐ 400.00 45‐5220‐10‐00 Office Equipment 2,602.00 2,602.00 2,067.99 2,067.99 79.48 534.01 45‐5230‐10‐00 Dues, Fees, & Subscriptions 300.00 300.00 ‐ 300.00 45‐5250‐10‐00 Publications 37.00 37.00 ‐ 37.00 45‐5310‐10‐00 Rental Expense 7,800.00 7,800.00 ‐ 7,800.00 45‐5320‐10‐00 Repairs & Maiantenance 800.00 800.00 ‐ 800.00 45‐5340‐10‐00 Building Repairs 500.00 500.00 232.42 46.48 267.58 45‐5350‐10‐00 Vehicle Expense 1,500.00 1,500.00 177.40 11.83 1,322.60 45‐5352‐10‐00 Fuel 3,300.00 3,300.00 566.23 17.16 2,733.77 45‐5353‐10‐00 Oil/Grease/Inspections 400.00 400.00 ‐ 400.00 45‐5400‐10‐00 Uniforms 3,300.00 3,300.00 114.95 3.48 3,185.05 45‐5410‐10‐00 Professional Services‐Storm Dr 5,000.00 5,000.00 ‐ 5,000.00 45‐5435‐10‐00 Legal Notices/Filings 1,365.00 ‐ (1,365.00) 45‐5480‐10‐00 Contract Services 23,009.00 23,009.00 23,009.00 100.00 45‐5520‐10‐00 Telephones 300.00 300.00 221.97 103.15 73.99 78.03 45‐5521‐10‐00 Cell Phone Expense 687.00 687.00 ‐ 687.00 45‐5530‐10‐00 Travel/Lodging/Meals Expense 200.00 200.00 ‐ 200.00 45‐5536‐10‐00 Training/Seminars 1,400.00 1,400.00 519.95 500.00 37.14 880.05 45‐5620‐10‐00 Tools & Equipment 3,200.00 3,200.00 ‐ 3,200.00 45‐5630‐10‐00 Safety Equipment 2,600.00 2,600.00 103.16 3.97 2,496.84 45‐5640‐10‐00 Signs & Hardware 600.00 600.00 ‐ 600.00 45‐5650‐10‐00 Maintenance Materials 4,000.00 4,000.00 ‐ 4,000.00 45‐6160‐10‐00 Capital Expense‐Vehicles 19,000.00 5,664.00 24,664.00 24,663.75 ‐ 0.25 45‐6193‐10‐00 2012 CO Bond Payment 96,680.00 96,680.00 63,490.00 65.67 33,190.00 45‐7143‐10‐00 Transfer to Internal Serv. Fd 240.00 240.00 120.00 20.00 50.00 120.00 45‐7147‐10‐00 Transfer to GF 14,778.00 14,778.00 7,389.00 1,231.50 50.00 7,389.00 Subtotal object ‐ 0 283,186.00 23,009.00 306,195.00 123,650.18 10,870.95 24,663.75 40.38 157,881.07 Program number: 283,186.00 23,009.00 306,195.00 123,650.18 10,870.95 24,663.75 40.38 157,881.07 Department number: 10 Administration 283,186.00 23,009.00 306,195.00 123,650.18 10,870.95 24,663.75 40.38 157,881.07 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 283,186.00 23,009.00 306,195.00 123,650.18 10,870.95 24,663.75 40.38 157,881.07 Fund number: 45 Storm Drainage Utility Fund 11,186.00 23,009.00 34,195.00 (10,280.25) (11,665.70) 24,663.75 (30.06) 19,811.50 60‐4045‐60‐00 Park Dedication‐Fees (200,000.00) (200,000.00) (18,280.00) 9.14 (181,720.00) 60‐4055‐60‐00 Park Improvement (300,000.00) (300,000.00) (18,000.00) 6.00 (282,000.00) 60‐4615‐60‐00 Interest‐Park Dedication (1,500.00) (1,500.00) (2,599.90) (481.62) 173.33 1,099.90 60‐4620‐60‐00 Interest‐Park Improvements (500.00) (500.00) (2,062.25) (376.05) 412.45 1,562.25 Subtotal object ‐ 0 (502,000.00) (502,000.00) (40,942.15) (857.67) 8.16 (461,057.85) Program number: (502,000.00) (502,000.00) (40,942.15) (857.67) 8.16 (461,057.85) Department number: 60 Parks and Recreation (502,000.00) (502,000.00) (40,942.15) (857.67) 8.16 (461,057.85) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (502,000.00) (502,000.00) (40,942.15) (857.67) 8.16 (461,057.85) 60‐5290‐60‐00 Miscellaneous Expense 60.00 10.00 ‐ (60.00) 60‐5411‐60‐00 Professional Services‐Pk Imp 831.00 831.00 ‐ 831.00 60‐6001‐60‐00 Pk Ded Fee Expense 125,000.00 125,000.00 ‐ 125,000.00 41 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 60‐6002‐60‐00 Pk Imp'ment fee‐Expense 89,000.00 89,000.00 89,000.00 ‐ 60‐6140‐60‐00 Capital Exp‐Pk Dedication 900.00 ‐ (900.00) Subtotal object ‐ 0 214,000.00 831.00 214,831.00 960.00 10.00 89,000.00 0.45 124,871.00 Program number: 214,000.00 831.00 214,831.00 960.00 10.00 89,000.00 0.45 124,871.00 Department number: 60 Parks and Recreation 214,000.00 831.00 214,831.00 960.00 10.00 89,000.00 0.45 124,871.00 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 214,000.00 831.00 214,831.00 960.00 10.00 89,000.00 0.45 124,871.00 Fund number: 60 Parks & Recreation Fund (288,000.00) 831.00 (287,169.00) (39,982.15) (847.67) 89,000.00 13.92 (336,186.85) 65‐4015‐99‐00 Impact Fees ‐Water (2,145,000.00) (2,145,000.00) (1,118,453.00) (284,527.00) 52.14 (1,026,547.00) 65‐4020‐99‐00 Impact Fees ‐Sewer (375,650.00) (375,650.00) (203,358.00) (37,565.00) 54.14 (172,292.00) 65‐4040‐99‐00 Thoroughfare Impact Fees (1,444,000.00) (1,444,000.00) (676,011.10) (181,518.66) 46.82 (767,988.90) 65‐4041‐99‐00 West Thorfare Imp. Fees Rev (436,232.00) (119,264.00) ‐ 436,232.00 65‐4615‐99‐00 Interest‐Water Impact Fee (3,500.00) (3,500.00) (8,269.98) (1,732.23) 236.29 4,769.98 65‐4620‐99‐00 Interest‐Sewer Impact Fee (1,500.00) (1,500.00) (4,617.34) (809.80) 307.82 3,117.34 65‐4640‐99‐00 Interest‐Thorfare Imp Fee (3,500.00) (3,500.00) (3,387.77) (603.70) 96.79 (112.23) 65‐4641‐99‐00 Interest‐West Thorfare imp fee (1,000.00) (1,000.00) (1,197.04) (208.24) 119.70 197.04 Subtotal object ‐ 0 (3,974,150.00) (3,974,150.00) (2,451,526.23) (626,228.63) 61.69 (1,522,623.77) Program number: (3,974,150.00) (3,974,150.00) (2,451,526.23) (626,228.63) 61.69 (1,522,623.77) Department number: 99 Impact Fees (3,974,150.00) (3,974,150.00) (2,451,526.23) (626,228.63) 61.69 (1,522,623.77) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (3,974,150.00) (3,974,150.00) (2,451,526.23) (626,228.63) 61.69 (1,522,623.77) 65‐5415‐99‐00 Professional Serv‐Water Imp Fe 7,472.74 ‐ (7,472.74) 65‐5420‐99‐00 Professional Serv‐Sewer Imp Fe 1,012.00 1,012.00 1,012.35 ‐ (0.35) 65‐5440‐99‐00 Professional Serv‐Thorfare Imp 4,750.00 4,750.00 5,041.50 106.14 (291.50) 65‐5441‐99‐00 Prof Serv‐West Thorfare Impact 7,777.50 ‐ (7,777.50) 65‐6115‐99‐00 Capital Expenditure‐Water 926,887.00 926,887.00 ‐ 926,887.00 65‐6120‐99‐00 Capital Expenditure‐Sewer 136,600.00 136,600.00 ‐ 136,600.00 65‐6140‐99‐00 Capital Expenditure‐Thorofare 1,905,000.00 68,000.00 1,973,000.00 95,440.00 4.84 1,877,560.00 65‐6141‐99‐00 Cap. Exp‐West Thorfare Impact 278,700.00 ‐ (278,700.00) 65‐6413‐99‐00‐1505‐ST W Thor‐Land Acq/ROW 2,500.00 ‐ (2,500.00) 65‐7144‐99‐00 Transfer to Capital Proj Fund 63,540.54 10,590.09 ‐ (63,540.54) Subtotal object ‐ 0 2,968,487.00 73,762.00 3,042,249.00 460,472.28 10,590.09 1,012.35 15.14 2,580,764.37 Program number: 2,968,487.00 73,762.00 3,042,249.00 460,472.28 10,590.09 1,012.35 15.14 2,580,764.37 Department number: 99 Impact Fees 2,968,487.00 73,762.00 3,042,249.00 460,472.28 10,590.09 1,012.35 15.14 2,580,764.37 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 2,968,487.00 73,762.00 3,042,249.00 460,472.28 10,590.09 1,012.35 15.14 2,580,764.37 Fund number: 65 Impact Fees (1,005,663.00) 73,762.00 (931,901.00) (1,991,053.95) (615,638.54) 1,012.35 213.66 1,058,140.60 67‐4530‐10‐00 Police Donation Inc (8,000.00) (8,000.00) (8,014.15) (740.00) 100.18 14.15 67‐4531‐10‐00 Fire Dept‐Donation Inc (9,360.00) (9,360.00) (9,497.00) (5,755.00) 101.46 137.00 67‐4535‐10‐00 Child Safety Inc (7,000.00) (7,000.00) (6,357.93) 90.83 (642.07) 67‐4536‐10‐00 Court Security Revenue (5,280.00) (5,280.00) (2,555.70) (431.94) 48.40 (2,724.30) 67‐4537‐10‐00 Technology Fd Revenue (7,020.00) (7,020.00) (3,391.56) (575.91) 48.31 (3,628.44) 67‐4550‐10‐00 LEOSE Revenue (1,542.83) (1,542.83) ‐ 1,542.83 67‐4610‐10‐00 Interest Income (3,720.00) (3,720.00) (1,949.52) (341.67) 52.41 (1,770.48) 67‐4721‐10‐00 Country Xmas Donations (10,000.00) (10,000.00) (11,265.00) 112.65 1,265.00 67‐4915‐10‐00 Escrow Income (547,460.50) (356,503.30) ‐ 547,460.50 67‐4916‐10‐00 Cash Seizure Forfeit‐PD (13,420.80) ‐ 13,420.80 67‐4995‐10‐00 Transfer In (20,000.00) ‐ 20,000.00 Subtotal object ‐ 0 (50,380.00) (50,380.00) (625,454.99) (365,890.65) 1,241.47 575,074.99 Program number: (50,380.00) (50,380.00) (625,454.99) (365,890.65) 1,241.47 575,074.99 Department number: 10 Administrative (50,380.00) (50,380.00) (625,454.99) (365,890.65) 1,241.47 575,074.99 42 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (50,380.00) (50,380.00) (625,454.99) (365,890.65) 1,241.47 575,074.99 67‐5201‐10‐00 LEOSE Expense (590.00) ‐ 67‐5202‐10‐00 Country Xmas Expense 10,000.00 20,000.00 30,000.00 28,920.22 102.53 96.40 1,079.78 67‐5203‐10‐00 Court Technology Expense 13,133.00 13,133.00 12,930.50 (2,500.00) 98.46 2,702.50 67‐5204‐10‐00 Court Security Expense 4,000.00 4,000.00 357.00 71.40 8.93 3,643.00 67‐5205‐10‐00 Police Donation Exp 6,000.00 6,000.00 4,150.00 69.17 1,850.00 67‐5206‐10‐00 Fire Dept Donation Exp 3,822.02 3,424.74 ‐ (3,822.02) 67‐5208‐10‐00 Child Safety Expense 25,000.00 25,000.00 5,788.50 5,788.50 (720.50) 23.15 19,932.00 67‐5212‐10‐00 Tree Mitigation Expense 14,000.00 14,000.00 ‐ 14,000.00 67‐5216‐10‐00 Volunteer Per Diem Expense 75.00 ‐ (75.00) 67‐5292‐10‐00 PD Seizure Expense 3,000.00 3,000.00 ‐ 3,000.00 Subtotal object ‐ 0 75,133.00 20,000.00 95,133.00 56,043.24 8,797.17 (3,220.50) 58.91 42,310.26 Program number: 75,133.00 20,000.00 95,133.00 56,043.24 8,797.17 (3,220.50) 58.91 42,310.26 Department number: 10 Administrative 75,133.00 20,000.00 95,133.00 56,043.24 8,797.17 (3,220.50) 58.91 42,310.26 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 75,133.00 20,000.00 95,133.00 56,043.24 8,797.17 (3,220.50) 58.91 42,310.26 Fund number: 67 Special Revenue‐Donations 24,753.00 20,000.00 44,753.00 (569,411.75) (357,093.48) (3,220.50) (1,272.34) 617,385.25 75‐4530‐10‐00 Contributions (19,696,900.00) (19,696,900.00) ‐ (19,696,900.00) 75‐4530‐10‐00‐1504‐PK Contributions (450,000.00) ‐ 450,000.00 75‐4611‐10‐00 Interest‐2004 Bond (1,500.00) (1,500.00) (1,015.99) (174.55) 67.73 (484.01) 75‐4612‐10‐00 Interest‐2006 Bond (100.00) (100.00) (206.63) (43.04) 206.63 106.63 75‐4613‐10‐00 Interest 2008 Bond (5,000.00) (5,000.00) (6,784.81) (1,157.44) 135.70 1,784.81 75‐4616‐10‐00 Interest 2012 GO Bond (5,000.00) (5,000.00) (5,289.29) (964.62) 105.79 289.29 75‐4995‐10‐00 Transfer In (1,140,000.00) (1,140,000.00) (523,500.00) (87,250.00) 45.92 (616,500.00) Subtotal object ‐ 0 (20,848,500.00) (20,848,500.00) (986,796.72) (89,589.65) 4.73 (19,861,703.28) Program number: (20,848,500.00) (20,848,500.00) (986,796.72) (89,589.65) 4.73 (19,861,703.28) Department number: 10 Capital Projects (20,848,500.00) (20,848,500.00) (986,796.72) (89,589.65) 4.73 (19,861,703.28) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (20,848,500.00) (20,848,500.00) (986,796.72) (89,589.65) 4.73 (19,861,703.28) 75‐5419‐10‐00‐1401‐FC Professional Services 198,110.75 87,921.25 105,228.75 ‐ (303,339.50) 75‐5419‐10‐00‐1402‐FC Professional Services 22,839.84 7,600.00 21,296.25 ‐ (44,136.09) 75‐5419‐10‐00‐1405‐ST Professional Services 121,747.50 44,198.75 111,852.50 ‐ (233,600.00) 75‐5419‐10‐00‐1406‐TR Professional Services 4,400.00 ‐ (4,400.00) 75‐5419‐10‐00‐1408‐TR Professional Services 9,304.00 268.00 10,492.00 ‐ (19,796.00) 75‐5419‐10‐00‐1412‐ST Professional Services 21,500.00 ‐ (21,500.00) 75‐5419‐10‐00‐1416‐ST Professional Services 200.00 ‐ (200.00) 75‐6110‐10‐00 Capital Expenditure 28,407,055.00 75,000.00 28,482,055.00 ‐ 28,482,055.00 75‐6113‐10‐00 Capital Expenditure 2008 Bond 90,877.42 4,998.96 ‐ (90,877.42) 75‐6120‐10‐00 Non‐Bond Capital Expenditures 6,171.23 1,760.75 ‐ (6,171.23) 75‐6410‐10‐00‐1416‐ST Land Acquisition/ROW 3,855.00 ‐ (3,855.00) 75‐6410‐10‐00‐1504‐PK Land AcquisitionROW 1,037,374.15 ‐ (1,037,374.15) 75‐6610‐10‐00‐1205‐ST Construction 81,816.75 ‐ (81,816.75) 75‐6610‐10‐00‐1207‐ST Construction 474,236.51 2,378.15 ‐ (476,614.66) 75‐6610‐10‐00‐1304‐PK Construction 85,843.45 75,657.50 ‐ (161,500.95) 75‐6610‐10‐00‐1405‐ST Construction 11,465.00 2,462,175.65 ‐ (2,473,640.65) 75‐6610‐10‐00‐1406‐TR Construction 93,448.00 ‐ (93,448.00) 75‐6610‐10‐00‐1408‐TR Construction 2,007.53 896,429.00 ‐ (898,436.53) 75‐6610‐10‐00‐1411‐TR Construction 7,052.80 7,052.80 28,773.58 ‐ (35,826.38) 75‐6610‐10‐00‐1413‐ST Construction 15,590.20 ‐ (15,590.20) 75‐6610‐10‐00‐1416‐ST Construction 451,255.80 88,382.80 499,080.80 ‐ (950,336.60) 43 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 75‐6610‐10‐00‐1418‐ST Construction 22,929.35 ‐ (22,929.35) 75‐6610‐10‐00‐1502‐PK Construction 261,588.00 146,159.00 ‐ (407,747.00) 75‐6610‐10‐00‐1506‐PK Construction 1,497.59 125,544.13 ‐ (127,041.72) 75‐6610‐10‐00‐1510‐FC Construction 20,250.00 20,250.00 1,058,585.06 ‐ (1,078,835.06) Subtotal object ‐ 0 28,407,055.00 75,000.00 28,482,055.00 2,828,405.92 262,433.31 5,760,607.32 9.93 19,893,041.76 Program number: 28,407,055.00 75,000.00 28,482,055.00 2,828,405.92 262,433.31 5,760,607.32 9.93 19,893,041.76 Department number: 10 Capital Projects 28,407,055.00 75,000.00 28,482,055.00 2,828,405.92 262,433.31 5,760,607.32 9.93 19,893,041.76 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 28,407,055.00 75,000.00 28,482,055.00 2,828,405.92 262,433.31 5,760,607.32 9.93 19,893,041.76 Fund number: 75 Capital Projects 7,558,555.00 75,000.00 7,633,555.00 1,841,609.20 172,843.66 5,760,607.32 24.13 31,338.48 76‐4610‐10‐00 Interest Income (25,500.00) (25,500.00) (17,318.14) (2,893.86) 67.91 (8,181.86) 76‐4910‐10‐00 Other Revenue (28,739.56) (8,621.87) ‐ 28,739.56 76‐4996‐10‐00 Transfers In (379,081.00) (379,081.00) (67,040.58) (11,173.43) 17.69 (312,040.42) Subtotal object ‐ 0 (404,581.00) (404,581.00) (113,098.28) (22,689.16) 27.95 (291,482.72) Program number: (404,581.00) (404,581.00) (113,098.28) (22,689.16) 27.95 (291,482.72) Department number: 10 Capital Projects‐W/S (404,581.00) (404,581.00) (113,098.28) (22,689.16) 27.95 (291,482.72) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (404,581.00) (404,581.00) (113,098.28) (22,689.16) 27.95 (291,482.72) 76‐5419‐10‐00‐1501‐WA Professional Services 185,100.00 ‐ (185,100.00) 76‐6410‐10‐00‐0407‐WA Land Acquisition / ROW 2,200.00 ‐ (2,200.00) 76‐6610‐10‐00 Construction 2,382,500.00 2,382,500.00 ‐ 2,382,500.00 76‐6610‐10‐00‐1202‐WA Construction 230,927.50 ‐ (230,927.50) 76‐6610‐10‐00‐1204‐WA Construction 170,288.00 (18,426.00) ‐ (151,862.00) 76‐6610‐10‐00‐1503‐WW Construction 1,071.65 6,500.00 ‐ (7,571.65) Subtotal object ‐ 0 2,382,500.00 2,382,500.00 404,487.15 173,174.00 16.98 1,804,838.85 Program number: 2,382,500.00 2,382,500.00 404,487.15 173,174.00 16.98 1,804,838.85 Department number: 10 Capital Projects‐W/S 2,382,500.00 2,382,500.00 404,487.15 173,174.00 16.98 1,804,838.85 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 2,382,500.00 2,382,500.00 404,487.15 173,174.00 16.98 1,804,838.85 Fund number: 76 Capital Projects ‐ Water/Sewer 1,977,919.00 1,977,919.00 291,388.87 (22,689.16) 173,174.00 14.73 1,513,356.13 80‐4120‐65‐00 Sales Taxes ‐ EDC (870,000.00) (870,000.00) (502,133.77) (68,445.85) 57.72 (367,866.23) 80‐4610‐65‐00 Interest Income (16,000.00) (16,000.00) (9,207.78) (1,631.93) 57.55 (6,792.22) 80‐4910‐65‐00 Other Revenue (46.96) ‐ 46.96 Subtotal object ‐ 0 (886,000.00) (886,000.00) (511,388.51) (70,077.78) 57.72 (374,611.49) Program number: (886,000.00) (886,000.00) (511,388.51) (70,077.78) 57.72 (374,611.49) Department number: 65 Economic Development (886,000.00) (886,000.00) (511,388.51) (70,077.78) 57.72 (374,611.49) Revenue Subtotal ‐ ‐ ‐ ‐ ‐ ‐ (886,000.00) (886,000.00) (511,388.51) (70,077.78) 57.72 (374,611.49) 80‐5110‐65‐00 Salaries & Wages 231,000.00 231,000.00 104,745.65 17,753.50 45.34 126,254.35 80‐5115‐65‐00 Salaries ‐ Overtime 500.00 500.00 303.07 60.61 196.93 80‐5140‐65‐00 Salaries ‐ Longevity Pay 300.00 300.00 270.00 90.00 30.00 80‐5142‐65‐00 Car Allowance 6,000.00 6,000.00 2,723.09 461.54 45.39 3,276.91 80‐5143‐65‐00 Cell Phone Allowance 2,160.00 2,160.00 1,672.00 270.00 77.41 488.00 80‐5145‐65‐00 Social Security Expense 14,350.00 14,350.00 5,419.43 1,094.17 37.77 8,930.57 80‐5150‐65‐00 Medicare Expense 3,350.00 3,350.00 1,525.17 255.89 45.53 1,824.83 80‐5155‐65‐00 SUTA Expense 650.00 650.00 81.00 (476.60) 12.46 569.00 80‐5160‐65‐00 Health Insurance 17,864.00 17,864.00 9,272.84 1,624.60 51.91 8,591.16 80‐5165‐65‐00 Dental Insurance 1,100.00 1,100.00 414.07 76.68 37.64 685.93 80‐5170‐65‐00 Life Insurance/AD&D 300.00 300.00 247.43 45.82 82.48 52.57 80‐5175‐65‐00 Liability (TML) Workers' Comp 550.00 550.00 481.50 87.55 68.50 80‐5176‐65‐00 TML Prop. & Liab Insurance 800.00 800.00 669.28 83.66 130.72 80‐5180‐65‐00 TMRS Expense 24,800.00 24,800.00 12,452.88 2,202.49 50.21 12,347.12 44 TOWN OF PROSPER, TEXASMONTHLY FINANCIAL REPORT‐ALL FUNDSMARCH 2015COMPARE TO 50.00%Current CurrentCurrrentCurrent CurrentCurrent YearYearYearYTDMonth Percent YTD Remaining Account Number DescriptionAdopted BudgetAmendmentsAmended BudgetActualActualEncumbrances%Budget 80‐5185‐65‐00 Long Term/Short Term Disabilit 560.00 560.00 ‐ 560.00 80‐5186‐65‐00 WELLE‐Wellness Prog Reimb‐Empl 1,800.00 1,800.00 378.00 70.00 21.00 1,422.00 80‐5189‐65‐00 Administrative Fees 7,500.00 7,500.00 3,750.00 625.00 50.00 3,750.00 80‐5191‐65‐00 Hiring Cost 100.00 100.00 ‐ 100.00 80‐5210‐65‐00 Office Supplies 2,000.00 2,000.00 1,632.74 836.79 81.64 367.26 80‐5212‐65‐00 Building Supplies 500.00 500.00 22.52 4.50 477.48 80‐5220‐65‐00 Office Equipment 1,800.00 1,800.00 1,059.89 134.99 58.88 740.11 80‐5230‐65‐00 Dues,Fees,& Subscriptions 6,000.00 6,000.00 5,444.26 2,489.12 90.74 555.74 80‐5240‐65‐00 Postage and Delivery 1,000.00 1,000.00 299.91 1.19 29.99 700.09 80‐5265‐65‐00 Promotional Expense 40,000.00 40,000.00 27,467.34 6,868.11 68.67 12,532.66 80‐5280‐65‐00 Printing and Reproduction 2,000.00 2,000.00 892.08 266.43 44.60 1,107.92 80‐5310‐65‐00 Rental Expense 41,000.00 41,000.00 20,131.80 3,355.30 49.10 20,868.20 80‐5330‐65‐00 Copier Expense 5,500.00 5,500.00 2,545.36 428.51 46.28 2,954.64 80‐5340‐65‐00 Building Repairs 200.00 200.00 ‐ 200.00 80‐5410‐65‐00 Professional Services 15,000.00 15,000.00 10,724.25 1,030.00 71.50 4,275.75 80‐5412‐65‐00 Audit Fees 1,500.00 1,500.00 1,500.00 ‐ 80‐5418‐65‐00 IT Fees 5,000.00 5,000.00 1,856.50 2,599.10 37.13 544.40 80‐5430‐65‐00 Legal Fees 15,000.00 15,000.00 779.00 57.00 5.19 14,221.00 80‐5520‐65‐00 Telephones 3,200.00 3,200.00 1,851.00 553.64 57.84 1,349.00 80‐5524‐65‐00 Gas‐Building 400.00 400.00 167.58 29.22 41.90 232.42 80‐5525‐65‐00 Electricity 2,100.00 2,100.00 712.12 133.29 33.91 1,387.88 80‐5526‐65‐00 Water 500.00 500.00 132.07 50.04 26.41 367.93 80‐5530‐65‐00 Travel/Lodging/Meals Expense 10,000.00 10,000.00 3,099.43 884.07 30.99 6,900.57 80‐5531‐65‐00 Prospect Mtgs/Business Meals 5,500.00 5,500.00 2,204.60 1,135.09 40.08 3,295.40 80‐5533‐65‐00 Mileage Expense 2,300.00 2,300.00 682.66 549.13 29.68 1,617.34 80‐5536‐65‐00 Training/Seminars 5,500.00 5,500.00 1,880.00 190.00 34.18 3,620.00 80‐6015‐65‐00 Project Incentives 100,000.00 100,000.00 ‐ 100,000.00 Subtotal object ‐ 0 579,684.00 579,684.00 227,990.52 42,995.01 4,099.10 39.33 347,594.38 Program number: 579,684.00 579,684.00 227,990.52 42,995.01 4,099.10 39.33 347,594.38 Department number: 65 Economic Development 579,684.00 579,684.00 227,990.52 42,995.01 4,099.10 39.33 347,594.38 Expense Subtotal ‐ ‐ ‐ ‐ ‐ ‐ 579,684.00 579,684.00 227,990.52 42,995.01 4,099.10 39.33 347,594.38 Fund number: 80 Economic Development Corporati (306,316.00) (306,316.00) (283,397.99) (27,082.77) 4,099.10 92.52 (27,017.11) 45 Item 5c Item 5c Item 5c Item 5c Item 5c Item 5c Page 1 of 1 To: Mayor and Town Council From: Kim Galvin, Interim Finance Director Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – April 28, 2015 Agenda Item: Consider and act upon approving a renewal to the Bank Depository Services Agreement between Independent Bank and the Town of Prosper; and authorizing the Town Manager to execute same. Description of Agenda Item: On June 25, 2013, the Town Council approved the Bank Depository Services Agreement between Independent Bank and the Town of Prosper. The initial term of the agreement was two years, and will expire on June 30, 2015. The agreement allows for three one-year renewal periods, subject to the approval of the Town Council and Independent Bank. This item is to request approval of the first renewal period from July 1, 2015 to June 30, 2016. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., approved the renewal letter as to form and legality. Attached Documents: 1. Renewal letter Town Staff Recommendation: Town staff recommends approving the renewal to the Bank Depository Services Agreement; and authorizing the Town Manager to execute same. Proposed Motion: I move to approve the renewal of the Bank Depository Services Agreement between Independent Bank and the Town of Prosper; and authorize the Town Manager to execute same. Prosper is a place where everyone matters. FINANCE Item 5d Attachment 1 Item 5d Page 1 of 2 To: Mayor and Town Council From: Kim Galvin, Interim Finance Director Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – April 28, 2015 Agenda Item: Consider and act upon a resolution reviewing, updating, and adopting the Town of Prosper and Prosper EDC Investment Policy and Investment Strategy. Description of Agenda Item: The Public Funds Investment Act (PFIA) (Texas Government Code, Chapter 2256) requires the governing body of the investing entity to “review its investment policy and investment strategies and [shall] adopt by rule, order, ordinance, or resolution stating that it has reviewed the investment policy and investment strategies and that the written instrument so adopted shall record any changes made to either the investment policy or investment strategies.” Major features of the Investment Policy include: Establishment of investment objectives—safety (of principal), liquidity, and yield; Identification of investment officers—Finance Director and Accounting Manager; Enumeration of authorized investments—U.S. Treasury and agency obligations, State of Texas and other political subdivision obligations rated “A” or higher, certificates of deposit, local government investment pools, money market mutual funds, commercial paper, and repurchase agreements; Safekeeping and collateralization requirements; and Reporting requirements—comprehensive quarterly reports with book and market values for each asset. The Prosper Town Council last reviewed, updated, and adopted the Town’s investment policy and strategies on April 8, 2014. The State Legislature made no changes to the PFIA during the 2013 legislative session. Consequently, no changes are proposed to the Town’s existing policy and strategy, other than reviewing and renewing them. Budget Impact: There is no significant budget impact associated with this item. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., prepared the attached Resolution. Prosper is a place where everyone matters. FINANCE Item 5e Page 2 of 2 Attached Documents: 1. Resolution adopting Investment Policy 2. Exhibit A - Investment Policy Town Staff Recommendation: Staff recommends approval of the resolution reviewing, updating, and adopting the Town of Prosper and Prosper EDC Investment Policy and Investment Strategy. Proposed Motion: I move to approve the resolution reviewing, updating, and adopting the Town of Prosper and Prosper EDC Investment Policy and Investment Strategy. Item 5e TOWN OF PROSPER, TEXAS RESOLUTION NO. _____ A RESOLUTION OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, REVIEWING, UPDATING AND ADOPTING THE TOWN OF PROSPER AND PROSPER ECONOMIC DEVELOPMENT CORPORATION INVESTMENT POLICY AND INVESTMENT STRATEGY; MAKING FINDINGS; AND PROVIDING AN EFFECTIVE DATE. WHEREAS, the Texas Public Funds Investment Act (“the Act”), contained in Chapter 2256 of the Texas Government Code, as amended, provides in Section 2256.005(e) thereof that the governing body of an investing entity shall review its investment policy and investment strategies not less than annually; and WHEREAS, said section of the Act further provides that the governing body shall adopt a written instrument by rule, order, ordinance, or resolution stating that it has reviewed the investment policy and investment strategies; and WHEREAS, the Act requires the written instrument so adopted shall record any changes made to either the investment policy or investment strategies. NOW, THEREFORE, BE IT RESOLVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The Prosper Town Council hereby confirms that it has reviewed the Town of Prosper and Prosper Economic Development Corporation Investment Policy and Investment Strategy and adopts the Investment Policy dated April 28, 2015, with changes incorporated and recorded for compliance, attached hereto as Exhibit A. SECTION 2 This Resolution shall take effect from and after the date of its passage. DULY PASSED, APPROVED, AND ADOPTED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 28TH DAY OF APRIL, 2015. APPROVED: ___________________________________ Ray Smith, Mayor ATTEST: _________________________________ Robyn Battle, Town Secretary Item 5e Resolution No. 14-24, Page 2 APPROVED AS TO FORM AND LEGALITY: _________________________________ Terrence S. Welch, Town Attorney Item 5e EXHIBIT A PROSPER IS A PLACE WHERE EVERYONE MATTERS TOWN OF PROSPER, TEXAS and PROSPER ECONOMIC DEVELOPMENT CORPORATION INVESTMENT POLICY APRIL 28, 2015 Item 5e Revised 04/2014 Investment Policy Page 2 of 25 INVESTMENT POLICY Table of Contents PREFACE 3 I. PURPOSE 4 A. FORMAL ADOPTION 4 B. SCOPE 4 C. REVIEW AND AMENDMENT 5 D. INVESTMENT STRATEGY 5 II. INVESTMENT OBJECTIVES 5 A. SAFETY OF PRINCIPAL 5 B. MAINTENANCE OF ADEQUATE LIQUIDITY 5 C. YIELD 6 III. INVESTMENT POLICIES 6 A. AUTHORIZED INVESTMENTS 6 B. PROTECTION OF PRINCIPAL 10 C. INVESTMENT ADVISERS AND SECURITIES DEALERS 12 D. RESPONSIBILITY AND CONTROL 14 IV. INVESTMENT STRATEGY 18 A. OPERATING FUNDS 18 B. CONSTRUCTION AND CAPITAL IMPROVEMENT FUNDS 18 C. DEBT SERVICE FUNDS 19 D. ENTERPRISE FUNDS 20 APPENDIX “A” – GLOSSARY OF TERMS 21 Item 5e Revised 04/2015 Investment Policy Page 3 of 25 PREFACE The Town of Prosper and the Prosper Economic Development Corporation are separately chartered, governed, and operated entities. Each ENTITY adheres to its own governing documents and the Public Funds Investment Act. Each ENTITY additionally seeks to safely and effectively manage the funds under its control. To achieve those requirements, the governing body of each ENTITY has legally adopted this Investment Policy. Throughout this Investment Policy, the two entities shall be singularly referred to as “ENTITY” and collectively referred to as “PROSPER.” It is the policy of PROSPER that, giving due regard to the safety and risk of investment, all available funds shall be invested in conformance with State and Federal Regulations, applicable Bond Resolution requirements, adopted Investment Policy and adopted Investment Strategy. Effective cash management is recognized as essential to good fiscal management. Aggressive cash management and effective investment strategy development will be pursued to take advantage of interest earnings as viable and material revenue to all PROSPER funds. PROSPER’s portfolio shall be designed and managed in a manner responsive to the public trust and consistent with this policy. Investments shall be made with the primary objectives of: Preservation of capital, Safety of PROSPER funds, Maintenance of sufficient liquidity, Maximization of return within acceptable risk constraints, and Diversification of investments. Item 5e Revised 04/2015 Investment Policy Page 4 of 25 I. PURPOSE A. Formal Adoption This Investment Policy is authorized by PROSPER in accordance with Chapter 2256, Texas Government Code, the Public Funds Investment Act, herein referred to as “PFIA”. B. Scope This Investment Policy applies to all of the investment activities of PROSPER. These funds are accounted for in the Town’s Comprehensive Annual Financial Report (CAFR) and include: General Fund Debt Service Funds Special Revenue Funds Capital Project Funds Enterprise Funds Internal Service Funds Economic Development Corporation Funds Any new fund created by the Town The Town of Prosper may consolidate cash balances from multiple funds to maximize investment earnings. Investment income will be allocated to the various funds based on their respective participation and in accordance with generally accepted accounting principles. This Policy establishes guidelines for: 1. Who can invest PROSPER funds, 2. How PROSPER funds will be invested, and 3. When and how a periodic review of investments will be made. In addition to this Policy, bond funds (as defined by the Internal Revenue Service) shall be managed in accordance with their issuing documentation and all applicable State and Federal Law. All investments made with PROSPER funds prior to the adoption of this Investment Policy shall be held or liquidated as determined to be in the best interest of the financial well being of PROSPER. PROSPER will also monitor changes in the credit ratings of its investments quarterly using a number of resources including rating agencies, broker/dealers or financial publications. PROSPER shall take all prudent measures that are consistent with its investment policy to liquidate an investment that does not have the minimum rating. Item 5e Revised 04/2015 Investment Policy Page 5 of 25 C. Review and Amendment This Policy shall be reviewed annually by the ENTITY’s governing body. The ENTITY’s governing body shall adopt a written document stating that it has reviewed the Investment Policy. D. Investment Strategy In conjunction with the annual Policy review, the ENTITY’s governing body shall review the separate written Investment Strategy for each of PROSPER’s funds. The Investment Strategy must describe the investment objectives for each particular fund according to the following priorities: 1. Investment suitability, 2. Preservation and safety of principal, 3. Liquidity, 4. Marketability prior to maturity of each investment, 5. Diversification, and 6. Yield. II. INVESTMENT OBJECTIVES A. Safety of Principal The primary objective of all investment activity is the preservation of capital and the safety of principal in the overall portfolio. Each investment transaction shall seek to ensure first that capital losses are avoided, whether they are from securities defaults or erosion of the market value. B. Maintenance of Adequate Liquidity The investment portfolio will remain sufficiently liquid to meet the cash flow requirements that might be reasonably anticipated. Liquidity shall be achieved by matching investment maturities with forecasted cash flow requirements; investing in securities with active secondary markets; and maintaining appropriate portfolio diversification. Item 5e Revised 04/2015 Investment Policy Page 6 of 25 C. Yield The investment portfolio shall be designed with the objective of attaining a market rate of return throughout budgetary and economic cycles, taking into account the investment risk constraints and liquidity needs. Return on investment is of secondary importance compared to the safety and liquidity objectives described above. Core investments are limited to relatively low risk securities in anticipation of earning a fair return relative to the risk being assumed. III. INVESTMENT POLICIES A. Authorized Investments Investments described below are authorized by PFIA as eligible securities for PROSPER. In the event an authorized investment loses its required minimum credit rating, all prudent measures will be taken to liquidate said investment. Additionally, PROSPER is not required to liquidate investments that were authorized at the time of purchase in the event that subsequent legislation renders certain securities as no longer authorized for purchase by the Town. PROSPER’s funds governed by this Policy may be invested in: 1. Obligations of Governmental Entities. Except for the items listed in 1.e. below, the following are authorized investments for obligations of governmental agencies: a. Obligations of the United States or its agencies and instrumentalities; b. Direct obligations of the State of Texas or its agencies and instrumentalities; c. Other obligations, the principal and interest on which are unconditionally guaranteed or insured by, or backed by the full faith and credit of, the State of Texas or the United States or their respective agencies and instrumentalities, including obligations that are fully guaranteed or insured by the Federal Deposit Insurance Corporation or by the explicit full faith and credit of the United States; d. Obligations of states, agencies, counties, cities, and other political subdivisions of any State having been rated as to investment quality by a nationally recognized investment rating firm and having received a rating of not less than “A” or its equivalent; Item 5e Revised 04/2015 Investment Policy Page 7 of 25 e. The following are not authorized investments for PROSPER: 1. Obligations whose payments represent the coupon payments on the outstanding principal balance of the underlying mortgage-backed security collateral and pays no principal (Interest Only); 2. Obligations whose payments represent the principal stream of cash flow from the underlying mortgage-backed security collateral and bear no interest (Principal Only); 3. Collateralized mortgage obligations that have a stated final maturity date of greater than 10 years; and 4. Collateralized mortgage obligations the interest rate of which is determined by an index that adjusts opposite to the changes in the market index (Inverse Floater). PROSPER expressly prohibits the acceptance for collateralized deposits interest-only and principal-only mortgage backed securities and collateralized mortgage obligations with stated final maturities in excess of ten years or with coupon rates that float inversely to market index movements. 2. Financial Institution Deposits. Certificates of deposit or share certificates provided the certificate is a. Issued by a depository institution that has its main office or a branch office in Texas that is: 1. Guaranteed or insured by the Federal Deposit Insurance Corporation or its successor or the National Credit Union Share Insurance Fund or its successor; or 2. Secured by obligations that are described by 1. (Obligations of Governmental Entities) above, which are intended to include all direct Federal agency or instrumentality issued mortgage backed securities, but excluding those mortgage-backed securities of the nature described in 1.e. above, that have a market value of not less than the uninsured amount of the deposit; or 3. Secured in any other manner and amount provided by the law for deposits of PROSPER. Item 5e Revised 04/2015 Investment Policy Page 8 of 25 b. In addition to the authority to invest funds in certificates of deposit under Subsection “a”, an investment in certificates of deposit made in accordance with the following conditions is an authorized investment: 1. The funds are invested through: (a) a broker that has its main office or a branch office in this state and is selected from a list adopted by the investing entity as required by Section 2256.025; or (b) a depository institution that has its main office or a branch office in this state and that is selected by the investing entity; 2. The broker or the depository institution selected by the investing entity under Subdivision (1) arranges for the deposit of the funds in certificates of deposit in one or more federally insured depository institutions, wherever located, for the account of the investing entity; 3. The full amount of the principal and accrued interest of each of the certificates of deposit is insured by the United States or an instrumentality of the United States; and 4. The investing entity appoints the depository institution selected by the investing entity under Subdivision (1), an entity described by Section 2257.041(d), or a clearing broker-dealer registered with the Securities and Exchange Commission and operating pursuant to Securities and Exchange Commission Rule 15c3-3 (17 C.F.R. Section 240.15c3-3) as custodian for the investing entity with respect to the certificates of deposit issued for the account of the investing entity. 3. Mutual Funds. Money market mutual funds regulated by the Securities & Exchange Commission, with a dollar weighted average portfolio maturity of 60 days or less that fully invest dollar-for-dollar all PROSPER funds without sales commission or loads and, whose investment objectives include seeking to maintain a stable net asset value of $1 per share. PROSPER may not invest funds under its control in an amount that exceeds 10% of the total assets of any individual money market mutual fund, excluding bond proceeds and reserves and other funds held for debt service in money market mutual funds; 4. Local Government Investment Pools. Eligible investment pools organized and operating in compliance with PFIA that have been authorized by the ENTITY’s governing body; and whose investment philosophy and strategy include seeking to maintain a stable net asset value of $1 per share, and are consistent with this Policy and PROSPER’s ongoing investment strategy. Item 5e Revised 04/2015 Investment Policy Page 9 of 25 PROSPER expressly allows money market mutual funds and eligible investment pools, authorized by the ENTITY’s governing body, to invest to the full extent permissible within the Public Funds Investment Act. 5. Commercial Paper. Commercial paper is an authorized investment under this policy if the commercial paper: a. Has a stated maturity of 270 days or fewer from the date of its issuance; and b. Is rated not less than A-1 or P-1 or an equivalent rating by at least: 1. two nationally recognized credit rating agencies; or 2. one nationally recognized credit rating agency and is fully secured by an irrevocable letter of credit issued by a bank organized and existing under the laws of the United States or any state. 6. Repurchase Agreements. a. A fully collateralized repurchase agreement is an authorized investment under PFIA, Subchapter A, if the repurchase agreement: 1. has a defined termination date; 2. is secured by a combination of cash and obligations described by PFIA, section 2256.009(a)(1); and 3. requires the securities being purchased by the Town or cash held by the Town to be pledged to the Town, held in the Town’s name, and deposited at the time the investment is made with the Town or with the third-party selected and approved by the Town; and 4. is placed through a primary government securities dealer, as defined by the Federal Reserve, or a financial institution doing business in this state. b. In this section, “repurchase agreement” means a simultaneous agreement to buy, hold for a specific time, and sell back at a future date obligations described by Section 2256.009(a)(1), at market value at the time the funds are disbursed of not less than the principal amount of the funds disbursed. The term includes a direct security repurchase agreement and a reverse Security repurchase agreement. c. Notwithstanding any other law, the term of any reverse security repurchase a agreement may not exceed 90 days after the date the reverse security repurchase agreement is delivered. Item 5e Revised 04/2015 Investment Policy Page 10 of 25 d. Money received by an entity under the terms of a reverse security repurchase agreement shall be used to acquire additional authorized investments, but the term of the authorized investments acquired must mature not later than the expiration date stated in the reverse security repurchase agreement. B. Protection of Principal PROSPER shall seek to control the risk of loss due to failure of a security issuer or grantor. Such risk shall be controlled by investing only in the safest types of securities as defined in the Policy; by collateralization as required by law; and through portfolio diversification by maturity and type. The purchase of individual securities shall be executed “Delivery versus Payment” (DVP) through PROSPER’s Safekeeping Agent. By so doing, PROSPER’s funds are not released until PROSPER has received, through the Safekeeping Agent, the securities purchased. 1. Diversification by Investment Type Diversification by investment type shall be maintained by ensuring an active and efficient secondary market in portfolio investments and by controlling the market and opportunity risks associated with specific investment types. Bond proceeds may be invested in a single security or investment if PROSPER determines that such an investment is necessary to comply with Federal arbitrage restrictions or to facilitate arbitrage record keeping and calculation. 2. Diversification by Investment Maturity In order to minimize risk of loss due to interest rate fluctuations, investment maturities will not exceed the anticipated cash flow requirements of the funds. Generally, PROSPER will not directly invest in securities maturing more than five years from the date of purchase. Maturity guidelines by fund type are discussed in Section IV, Investment Strategy. 3. Ensuring Liquidity Liquidity shall be achieved by anticipating cash flow requirements, by investing in securities with active secondary markets and by investing in eligible money market mutual funds and local government investment pools. Item 5e Revised 04/2015 Investment Policy Page 11 of 25 A security may be liquidated to meet unanticipated cash requirements, to redeploy cash into other investments expected to outperform current holdings, or otherwise to adjust the portfolio. 4. Depository Agreements Consistent with the requirements of State Law, PROSPER requires all bank deposits to be federally insured or collateralized with eligible securities. Financial institutions serving as PROSPER’s Depositories will be required to sign a Depository Agreement with PROSPER and PROSPER’s safekeeping agent. The safekeeping portion of the Agreement shall define PROSPER’s rights to the collateral in case of default, bankruptcy, or closing and shall establish a perfected security interest in compliance with Federal and State regulations, including: The Agreement must be in writing; The Agreement has to be executed by the Depository and PROSPER contemporaneously with the acquisition of the asset; The Agreement must be approved by the Board of Directors or the designated committee of the Depository and a copy of the meeting minutes must be delivered to PROSPER; The Agreement must be part of the Depository’s “official record” continuously since its execution. a. Allowable Collateral Eligible securities for collateralization of PROSPER deposits are defined by Chapter 2257, Texas Government Code, the Public Funds Collateral Act, as amended and meet the constraints of this Section III. A. 2. b. Collateral Levels The market value of pledged collateral must at all times be equal to or greater than 102% of the principal and accrued interest for PROSPER balances, less the applicable level of FDIC insurance. c. Monitoring Collateral Adequacy PROSPER shall require monthly reports of pledged securities marked to market using quotes by a recognized market pricing service quoted on the valuation date from all financial institutions with which PROSPER has collateralized deposits. The Investment Officers will monitor adequacy of collateralization levels to verify market values and total collateral positions. Item 5e Revised 04/2015 Investment Policy Page 12 of 25 d. Additional Collateral If the collateral pledged for a deposit falls below adequate levels, as defined above in Section 4.b. , the institution holding the deposit will be notified by the Investment Officers and will be required to pledge additional securities no later than the end of the next succeeding business day. e. Security Substitution Collateralized deposits often require substitution of securities. Any financial institution requesting substitution must contact an Investment Officer for approval and settlement. The substituted security’s value will be calculated and substitution approved if the substitution maintains a pledged value equal to or greater than the required security level. An Investment Officer must provide written notification of the decision to the bank or the safekeeping agent holding the security prior to any security release. Substitution is allowable for all transactions, but should be limited, if possible, to minimize potential administrative problems and transfer expense. The Investment Officers may limit substitution and assess appropriate fees if substitution becomes excessive or abusive. 5. Safekeeping a. Safekeeping Agreement PROSPER shall contract with a bank or banks for the safekeeping of securities either owned by PROSPER as a part of its investment portfolio or as a part of its depository agreements. b. Safekeeping of Deposit Collateral All collateral securing bank deposits must be held by a third-party custodian bank eligible under the Public Funds Collateral Act, and acceptable to and under contract with PROSPER, or by a Federal Reserve Bank. C. Investment Advisers and Securities Dealers Investment Advisers shall adhere to the spirit, philosophy and specific terms of this Policy and shall invest within the same “Standard of Care” as defined in Section E. 3. below. Securities Dealers shall avoid recommending or suggesting transactions outside that “Standard of Care.” Item 5e Revised 04/2015 Investment Policy Page 13 of 25 1. Selection of Investment Advisers The selection of Investment Advisers will be performed by the Investment Officers. The Investment Officers will establish criteria to evaluate Investment Advisers including: a. Adherence to PROSPER’s policies and strategies, b. Investment performance and transaction pricing within accepted risk constraints, c. Responsiveness to PROSPER’s request for services, information and open communication, d. Understanding of the inherent fiduciary responsibility of investing public funds, and e. Similarity in philosophy and strategy with PROSPER’s objectives. Selected Investment Advisers must be registered under the Investment Advisers Act of 1940 or with the State Securities Board. A contract with an Investment Adviser may not be for a term longer than two years and any contract, renewal or extension must be approved by Town Council. 2. Selection of Authorized Securities Dealers The ENTITY’s governing body or its Investment Officers acting as the ENTITY’s Investment Committee shall, at least annually, review, revise, and adopt a list of qualified broker/dealers and financial institutions that are authorized to engage in investment transactions with the ENTITY. a. Eligibility Authorized firms may include primary dealers or regional dealers that qualify under Securities & Exchange Commission Rule 15C3-1 (Uniform Net Capital Rule), and qualified depositories. b. Documentation Requirements Brokers/dealers and financial institutions requesting to become qualified to transact investment business with PROSPER shall be required to provide: 1. a completed Broker/Dealer Questionnaire that provides information regarding creditworthiness, experience and reputation; and Item 5e Revised 04/2015 Investment Policy Page 14 of 25 2. a Certification stating the firm has received, reviewed, understood and agrees to comply with PROSPER’s investment policy. This Certification also acknowledges that the business organization has implemented reasonable procedures and controls in an effort to preclude investment transactions conducted between PROSPER and the organization that are not authorized by PROSPER’s investment policy, except to the extent that this authorization is dependent on an analysis of the makeup of PROSPER’s entire portfolio or requires an interpretation of subjective investment standards. PROSPER shall not enter into an investment transaction with a business organization prior to receiving the written instruments described above. c. Competitive Bids It is the policy of PROSPER to require competitive bidding for all individual security purchases and sales except for: 1. transactions with money market mutual funds and local government investment pools; and 2. treasury and agency securities purchased at issue through an approved broker/dealer or financial institution. D. Responsibility and Control 1. Authority to Invest The Finance Director and the Accounting Manager are the “Investment Officers” of the Town of Prosper. The PEDC Treasurer and the Accounting Manager are the “Investment Officers” of the PEDC. The Investment Officers are authorized to deposit, withdraw, invest, transfer, execute documentation, and otherwise manage PROSPER’s funds according to this Policy. The Investment Officers may authorize one or more Investment Officers to deposit, withdraw or transfer funds out of or into an investment pool or money market mutual fund in order to meet daily operating needs of PROSPER. 2. Prudent Investment Management The designated Investment Officers shall perform their duties in accordance with the adopted Investment Policy and internal procedures. In determining whether an Investment Officer has exercised prudence with respect to an investment decision, the investment of all funds over which the Investment Officer had responsibility, rather than the prudence of a single investment shall be considered. Item 5e Revised 04/2015 Investment Policy Page 15 of 25 Investment Officers acting in good faith and in accordance with these policies and procedures shall be relieved of personal liability. 3. Standard of Care The standard of care used by PROSPER shall be that as defined in PFIA, Section 2256.006. It states: “Investments shall be made with judgment and care, under circumstances then prevailing, that a person of prudence, discretion and intelligence would exercise in the management of the person’s own affairs, not for speculation, but for investment, considering the probable safety of capital and the probable income to be derived.” 4. Standards of Ethics The designated Investment Officers shall act as custodians of the public trust avoiding any transactions which might involve a conflict of interest, the appearance of a conflict of interest, or any activity which might otherwise discourage public confidence. Investment Officers shall refrain from personal business activity that could conflict with proper execution of the investment program, or which could impair their ability to make impartial investment decisions. Additionally, all Investment Officers shall file with the Texas Ethics Commission and the ENTITY’s governing body a statement disclosing any personal business relationship with a business organization seeking to sell investments to PROSPER or any relationship within the second degree by affinity or consanguinity to an individual seeking to sell investments to PROSPER. For purposes of this subsection, an Investment Officer has a personal business relationship with business organization if: a. The Investment Officer owns 10 percent or more of the voting stock or shares of the business organization or owns $5,000 or more of the fair market value of the business organization; b. Funds received by the Investment Officer from the business organization exceed 10 percent of the Investment Officer’s gross income for the previous year; or c. The Investment Officer has acquired from the business organization during the previous year investments with a book value of $2,500 or more for the personal account of the Investment Officer. Item 5e Revised 04/2015 Investment Policy Page 16 of 25 5. Establishment of Internal Controls PROSPER’s Investment Officers will maintain a system of internal controls over the investment activities of PROSPER. 6. Reporting Investment performance will be monitored and evaluated by the Investment Officers. The Investment Officers will provide a quarterly comprehensive report signed by all Investment Officers to the ENTITY’s governing body. This investment report shall: a. Describe in detail the investment position of PROSPER, b. Contain a summary statement, prepared in compliance with generally accepted accounting principles, of each pooled fund group that states the: 1. beginning market value of the reporting period; 2. ending market value for the period; 3. fully accrued interest for the reporting period c. State the book value and market value of each separately invested asset at the end of the reporting period by the type of asset and fund type invested; d. State the maturity date of each separately invested asset that has a maturity date; e. State the account or fund or pooled group fund in the state agency or local government for which each individual investment was acquired; and f. State the compliance of the investment portfolio with PROSPER’s Investment Policy, strategy, and PFIA. In defining market value, sources independent of the investment provider will determine valuations and consideration will be given to GASB Statement No. 31. PROSPER, in conjunction with its annual financial audit, shall perform a compliance audit of the management controls on investments and adherence to PROSPER’s Investment Policy. If PROSPER invests in other than money market mutual funds, investment pools or accounts offered by its depository bank in the form of certificates of deposits, or money market accounts or similar accounts, the reports prepared by the Investment Officers shall be formally reviewed at least annually by an independent auditor, and the result of the review shall be reported to the ENTITY’s governing body by that auditor. Item 5e Revised 04/2015 Investment Policy Page 17 of 25 7. Training In order to insure the quality and capability of PROSPER’s investment personnel making investment decisions, PROSPER shall provide periodic training in investments for the investment personnel through courses and seminars offered by GFOA, GFOAT, GTOT, TML, NCTCOG, ICMA, TSCPA, AICPA, or any independent source or institute of higher learning approved by the Finance Director. a. The Investment Officers shall: 1. attend at least 10 hours of training relating to the Investment Officers’ responsibilities within 12 months after taking office or assuming duties; and 2. attend an investment training session not less than once in a two-year period that begins on the first day of the Town’s fiscal year and consists of the two consecutive fiscal years after that date and receive not less than 10 hours of instruction relating to investment responsibilities under this subchapter from an independent source approved by the governing body of the local government or a designated investment committee advising the investment officer as provided for in the investment policy of the local government. b. Training under this section must include education in investment controls, security risks, strategy risks, market risks, diversification of investment portfolio and compliance with PFIA. Item 5e Revised 04/2015 Investment Policy Page 18 of 25 IV. INVESTMENT STRATEGY In order to minimize risk of loss due to interest rate fluctuations, investment maturities will not exceed the anticipated cash flow requirements of the fund. Investment guidelines by fund-type are as follows: A. Operating Funds 1. Suitability – Any investment eligible in the Investment Policy is suitable for the Operating Funds. 2. Safety of Principal – All investments shall be of high quality securities with no perceived default risk. 3. Liquidity – The Operating Fund requires the greatest short-term liquidity of any of the fund types. Short term investment pools and money market mutual funds provide daily liquidity and may be utilized as a competitive yield alternative to fixed maturity investments. The weighted average days to maturity for the operating fund portfolio shall be less than 365 days, and the maximum allowable maturity shall be five years. 4. Marketability – Securities with active and efficient secondary markets are necessary in the event of an unanticipated cash requirement. Historical market “spreads” between the bid and offer prices of a particular security-type of less than a quarter of a percentage point shall define an efficient secondary market. 5. Diversification – Investment maturities shall be staggered throughout the budget cycle to provide cash flow based on the anticipated operating needs of PROSPER. Market cycle risks will be reduced by diversifying the appropriate maturity structure out no longer than five years. 6. Yield – Attaining a competitive market yield for comparable security-types and portfolio restrictions is the desired objective. The yield of an equally weighted, rolling portfolio of Treasury securities with an average maturity roughly equivalent to that of the portfolio shall be the minimum yield objective. B. Construction and Capital Improvement Funds 1. Suitability – Any investment eligible in the Investment Policy is suitable for the Construction and Capital Improvement Funds. 2. Safety of Principal – All investments shall be of high quality securities with no perceived default risk. By managing Construction and Capital Improvement Fund’s portfolio to exceed the anticipated expenditure schedule, the market risk of the overall portfolio will be minimized. Item 5e Revised 04/2015 Investment Policy Page 19 of 25 3. Liquidity – PROSPER funds used for construction and capital improvement programs have reasonably predictable draw down schedules. The investment maturity of construction and capital improvement funds shall generally be limited to the anticipated cash flow requirement or the “temporary period,” as defined by Federal Tax Law. During the temporary period, which is generally three years for capital projects, bond proceeds may be invested at an unrestricted yield. After the expiration of the temporary period, bond proceeds subject to yield restriction shall be invested considering the anticipated cash flow requirements of the funds and market conditions to achieve compliance with the applicable regulations. The stated final maturity dates of investments held should not exceed the estimated project completion date; the maximum maturity for all construction or capital improvement funds shall be five years. 4. Marketability – Securities with active and efficient secondary markets are necessary in the event of an unanticipated cash requirement. Historical market “spreads” between the bid and offer prices of a particular security-type of less than a quarter of a percentage point shall define an efficient secondary market. 5. Diversification – Investment maturities shall be staggered throughout the budget cycle to provide cash flow based on the anticipated needs of the construction and capital improvement funds of PROSPER. 6. Yield – Attaining a competitive market yield for comparable security-types and portfolio restrictions is the desired objective. The yield of an equally weighted, rolling three-month Treasury bill portfolio shall be the minimum yield objective. C. Debt Service Funds 1. Suitability – Any investment eligible in the Investment Policy is suitable for the Debt Service Funds. 2. Safety of Principal – All investments shall be of high quality securities with no perceived default risk. By managing Debt Service Fund’s portfolio to not exceed the debt service payment schedule the market risk of the overall portfolio will be minimized. 3. Liquidity – Debt Service have predictable payment schedules. Debt Service Funds shall be invested to ensure adequate funding for each consecutive debt service payment. The Investment Officers shall invest in such a manner as not to exceed an “unfunded” debt service date with the maturity of any investment. An unfunded debt service date is defined as a coupon or principal payment date that does not have cash or investment securities available to satisfy said payment. The weighted average days to maturity for the debt service fund portfolio shall be less than 365 days and the maximum allowable maturity shall be two years. Item 5e Revised 04/2015 Investment Policy Page 20 of 25 4. Marketability – Securities with active and efficient secondary markets are not necessary as the event of an unanticipated cash requirement is not probable. 5. Diversification – Investment maturities shall be staggered throughout the budget cycle to provide cash flow based on the anticipated needs of the debt service funds of PROSPER. At no time shall the debt service schedule be exceeded in an attempt to bolster yield. 6. Yield – Attaining a competitive market yield for comparable security-types and portfolio restrictions is the desired objective. The yield of an equally weighted, rolling portfolio Treasury securities with an average maturity roughly equivalent to that of the portfolio shall be the minimum yield objective. D. Enterprise Funds 1. Suitability – Any investment eligible in the Investment Policy is suitable for the Enterprise Funds. 2. Safety of Principal – All investments shall be of high quality securities with no perceived default risk. 3. Liquidity – The Enterprise Fund requires short-term liquidity for some operations. Short-term investment pools and money market mutual funds provide daily liquidity where needed. The weighted average days to maturity for the enterprise fund portfolio shall be less than 365 days and the maximum allowable maturity shall be five years. 4. Marketability – Securities with active and efficient secondary markets are necessary in the event of an unanticipated cash requirement. Historical market “spreads” between the bid and offer prices of a particular security-type of less than a quarter of a percentage point shall define an efficient secondary market. 5. Diversification – Investment maturities shall be staggered throughout the budget cycle to provide cash flow based on the anticipated operating needs of PROSPER. Market cycle risk will be reduced by diversifying the appropriate maturity structure out no longer than five years 6. Yield – Attaining a competitive market yield for comparable security-types and portfolio restrictions is the desired objective. Portions of Enterprise Fund reserves are available to earn higher yield on longer maturities. The yield of an equally weighted, rolling portfolio Treasury securities with an average maturity roughly equivalent to that of the portfolio shall be the minimum yield objective. Item 5e Revised 04/2015 Investment Policy Page 21 of 25 Appendix “A” Glossary of Cash Management Terms Accretion – Common investment accounting entry in which the book value of securities purchased at a discount are gradually written up to the par value. The process has the effect of recording the discount as income over time. Accrued Interest – Interest earned, but not yet paid, on a bond. Agency – See Federal Agency. Amortization – Common investment accounting entry in which the book value of securities purchased at a premium are gradually written down to the par value. The process has the effect of recording the premium as a reduction to income over time. Arbitrage – Dealing simultaneously in the same product in two markets to take advantage of temporary price distortions at minimal risk Basis Point – A unit of measurement used in the valuation of fixed-income securities equal to 1/100 of 1 percent of yield; e.g., “1/4” of 1 percent is equal to 25 basis points. Benchmark – Index used to compare risk and performance to a managed portfolio. Bid – The indicated price at which a buyer is willing to purchase a security or commodity. Book Value – The original acquisition cost of an investment plus or minus the accrued amortization or accretion. Broker – A financial firm that brings securities buyers and sellers together in return for a fee. The term “broker” is often used interchangeably with “dealer” to refer to a seller of investment securities. Callable Bond – A bond issue in which all or part of its outstanding principal amount may be redeemed before maturity by the issuer under specified conditions. Cash Settlement – A transaction which calls for delivery and payment of securities on the same day that the transaction is initiated. Collateralization – Process by which a borrower pledges securities, property, or other deposits for the purpose of securing the repayment of a loan and/or security. Collateralized Mortgage Obligation (CMO) – A derivative mortgage-backed security (MBS) created from pools of home mortgage loans. A single MBS is divided into multiple classes, each Item 5e Revised 04/2015 Investment Policy Page 22 of 25 class containing unique risk profile and security characteristics. A number of CMO classes are expressly prohibited by Texas State law. Commercial Paper – An unsecured short-term promissory note issued by corporations, with maturities ranging from 1 to 270 days. Commercial paper must carry a minimum rating of A1/P1 in order to be eligible under the Texas Public Funds Investment Act. Constant Maturity Treasury (CMT) – A calculated average released by the Federal Reserve of all Treasury yields along a specific maturity point. This calculation is frequently used as a benchmark for conservative government portfolios. Coupon Rate – The annual rate of interest received by an investor from the issuer of certain types of fixed-income securities. Also known as the “interest rate.” Credit Risk – The risk to an investor that an issuer will default in the payment of interest and/or principal on a security. Derivative – Financial instruments whose value is derived from the movement of an underlying index or security. Dealer – A dealer, as opposed to a broker, sets as a principal in all securities transactions, buying and selling for their own account. Often times, the terms “broker” and “dealer” are used interchangeably to refer to a seller of investments securities. Delivery Versus Payment (DVP) – A type of securities transaction in which the purchaser pays for securities at the time of delivery either to the purchaser or his/her custodian. Derivative Security – Financial instrument created from, or whose value depends upon, one or more underlying assets or indices of asset values. Discount – The amount by which the par value of a security exceeds the price paid for the security. Diversification – A process of investing assets among a range of security types by sector, maturity, and quality rating. Dollar Weighted Average Maturity (WAM) – The average maturity of all the securities that comprise a portfolio weighted by the dollar value of each security. Fair Market Rate – A documented and verifiable rate of interest which approximates the average rate which could have been earned on similar investments at the time of the transaction. Federal Agency – A debt instrument that carries a rating of AAA because it is government sponsored. Item 5e Revised 04/2015 Investment Policy Page 23 of 25 Federal Deposit Insurance Corporation (FDIC) – A federal agency that insures bank deposits, currently up to $250,000 per account. Public deposits that exceed this amount must be properly collateralized with investment securities or insured through a surety bond. Financial Industry Regulatory Authority (FINRA) - the successor to the National Association of Securities Dealers, Inc. (NASD). FINRA is a private corporation that focuses on regulatory oversight of all securities firms that do business with the public; professional training, testing and licensing of registered persons; arbitration and mediation; market regulation by contract for the New York Stock Exchange, the NASDAQ Stock Market, Inc., the American Stock Exchange LLC, and the International Securities Exchange. Interest Rate – See “Coupon Rate.” Internal Controls – An internal control structure designed to ensure that the assets of the entity are protected from loss, theft, or misuse. The internal control structure is designed to provide reasonable assurance that these objectives are met. Interlocal Cooperation Act – Law permitting joint participation by local governments providing one or more government functions within the State. This law [Section 891.001 et seq. of the Texas Government Code (the “Act”)] has allowed for the creation of investment pools in Texas. Investment Advisers Act of 1940 – Law which requires all Investment Advisers to be registered with the SEC in order to protect the public from fraud. Investment Policy – A concise and clear statement of the objectives and parameters formulated by an investor or investment manager for a portfolio of investment securities. The Texas Public Funds Investment Act requires that public entities have a written and approved investment policy. Investment Pool – An entity created under the Interlocal Cooperation Act to invest public funds jointly on behalf of the entities that participate in the pool. Liquidity – A liquid investment is one that can be easily and quickly converted to cash without substantial loss of value. Investment pools and money market funds, which allow for same day withdrawal of cash, are considered extremely liquid. Local Government Investment Pool (LGIP) – An investment by local governments in which their money is pooled as a method for managing local funds. Market Risk - The risk that the value of a security will rise or decline as a result of changes in market conditions. Market Value – A security’s par amount multiplied by its market price. Item 5e Revised 04/2015 Investment Policy Page 24 of 25 Master Repurchase Agreement – A written contract covering all future transactions between the two parties to a repurchase agreement. Maturity – The date on which payment of a financial obligation is due. The final stated maturity is the date on which the issuer must retire a bond and pay the face value to the bondholder. See “Weighted Average Maturity.” Money Market Mutual Fund – Mutual funds that invest solely in money market instruments (short term debt instruments, such as Treasury bills, commercial paper, bankers’ acceptance, repos and federal funds). Mortgage-Backed Security (MBS) – Security backed by pools of home loan mortgages. Net Asset Value (NAV) – The value of a mutual fund or investment pool at the end of the business day. NAV is calculated by adding the market value of all securities in a fund or pool, deducting expenses, and dividing by the number of shares in the fund or pool. Offer – An indicated price at which market participants are willing to sell a security. Also referred to as the “Ask Price.” Par – Face value or principal value of a bond, typically $1,000 per bond. A security’s par value is multiplied by its coupon rate to determine coupon payment amount. Premium – The amount by which the price paid for a security exceeds the security’s par value. Primary Government Securities Dealer (Primary Dealer) – One of 20 (as of 02/2011 ) large government securities dealers who are required to submit daily reports of market activity and monthly financial statements to the New York Federal Reserve Bank. Primary Dealers are required to continually “make a market” in Treasury securities, buying or selling when asked, thereby creating a liquid secondary market for US debt obligations. Principal – The face value or par value of a debt instrument. Also may refer to the amount of capital invested in a given security. Prudent Investor Rule – Refers to an investment principle in the Public Funds Investment Act outlining the fiduciary responsibilities of Investment Officers. Regular Way Delivery – Securities settlement that calls for delivery and payment on the third business day following the trade date (T + 3); payment on a T + 1 basis is currently under consideration. Mutual funds are settled on a same day basis; government securities are settled on the next business day. Repurchase Agreement (repo or RP) – An agreement of one party to sell securities at a specified price to a second party and a simultaneous agreement of the first party to repurchase the securities at a specified price or at a specified later date. Item 5e Revised 04/2015 Investment Policy Page 25 of 25 Reverse Repurchase Agreement (Reverse Repo) – An agreement of one party to purchase securities at a specified price from a second party and a simultaneous agreement by the first party to resell the securities at a specified price to the second party on demand or at a specified date. Safekeeping – Holding of assets (e.g., securities) by a financial institution. Total Return – The sum of all investment income plus changes in the capital value of the portfolio. For mutual funds, return on an investment is composed of share price appreciation plus any realized dividends or capital gains. This is calculated by taking the following components during a certain time period: (Price Appreciation) + (Dividends Paid) + (Capital Gains) = (Total Return). Treasury Bills – Short term U.S. government non-interest bearing debt securities with maturities of no longer than one year and issued with a minimum purchase of $100. Bills pay interest only at maturity. The interest is equal to the face value minus the purchase price. Auctions of four week, 13 week and 26 week bills are every week, while auctions of 52 week bills are done every four weeks. The yields on these bills are monitored closely in the money markets for signs of interest rate trends. Treasury Notes – Intermediate U.S. government debt securities with maturities of one to 10 years and issued with a minimum purchase of $100. Treasury notes, or T-notes, are issued in terms of 2, 3, 5, 7, and 10 years, and pay interest every six months until they mature. Uniform Net Capital Rule – SEC Rule 15C3-1 outlining capital requirements for brokers/dealers. Volatility – A degree of fluctuation in the price and valuation of securities. Yield – The current rate of return on an investment security generally expressed as a percentage of the security’s face value. Yield-to-Call (YTC) – The rate of return an investor earns from a bond assuming the bond is redeemed (called) prior to its nominal maturity date. Yield Curve – A graphic representation that depicts the relationship at a given point in time between yields and maturity for bonds that are identical in every way except maturity. A normal yield curve may be alternatively referred to as a positive yield curve. Yield-to-Maturity – The rate of return yielded by a debt security held to maturity when both interest payments and the investor’s potential capital gain or loss are included in the calculation of return. Zero-coupon Securities – Security that is issued at a discount and makes no periodic interest payments. The rate of return consist of a gradual accretion of the principal of the security and is payable at par upon maturity. Item 5e To: Mayor and Town Council From: Alex Glushko, AICP, Senior Planner Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – April 28, 2015 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 preliminary site plans and site plans acted on by the Planning & Zoning Commission at their April 21, 2015, 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 preliminary site plan or site plan acted on by the Planning & Zoning Commission. Attached Documents: 1. Preliminary Site Plan for Walmart at the Gates of Prosper 2. Site Plan for Adara Windsong Ranch Multifamily 3. Site Plan for Fire Station #2 Town Staff Recommendation: Town staff recommends that the Town Council take no action on these items. Prosper is a place where everyone matters. PLANNING Item 5f Item 5f FL FL FL FLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFL FL FLFLFLFLFLFLFLFLFLFL FL FL FLFLFLFLFLFLFLFLFLFLFL F L FLFLFLFLFLFLFLFLFLFLFLFLFLFL F L FL FL FL FL FLFLFLFL FL FL F L FLFLFL FL FL FL FL FLFLFL FLFLF L FL FLFLFLFLFLFLFLFLFLFLF L F L F L FLF L 6 3 5 6 5 10 5 9 6 7 T5 7 2 6 3 2 6 6 6 11 5 5 5 5 3 10 5 11 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 FLFLFL FLTTTTTT TTTTTTTTTTTTTTTTTTTTTTTT16TTTTTTTTTTTTT TTTTTTTTTTTTTTTTTTT T T T TT TTT TT TTTTTTTT TTTTTTT TTT TTTTTTTTTTT T T T T T T T T T TTTTT TTTTTTTTTT9 T1 2 3 4 5 6 24 7 8 9 10 27 26 25 28 23 22 20 21 18 19 17 15 29 12 13 14 11 30 TTTTTTTTTT 1 7 TTT T T TTT T T T T T TTTTTTTTTTTTTTT 10 FFE=567.0 FFE=569.0 FFE=568.0 FFE=568.0 FFE=569.0 FFE=569.0 FFE=572.0 FFE=570.0 FFE=571.0 FFE=572.0 FFE=570.0 FFE=573.0 FFE=570.0 FFE=573.0 FFE=573.0 FFE=574.0 FFE=574.0 FFE=569.0 FFE=569.0 FFE=569.0 FFE=568.0 FFE=574.0 FFE=574.0 FFE=572.0 FFE=572.0 FFE=575.0 FFE=576.0 FFE=576.0 FFE=572.0 FFE=577.0 FFE=576.0FFE=568.0FL1 FFE=573.0F F E =5 7 1 .0 1 1 E X .12"W A T E R EX. 12" WTREX.24"WTROHEOHEOHEOHEOHEOHEOHEOHEOHEOHEOHEOHEOHEOHETELTELTELTELTELTELTELTELTELTELTELTELTELTELTELTEL111.1'TRANSITION12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 3435 3637 38 18 15 14 13 12 11 10 9 8 7 6 5 Lot 3 Blk X A AN12°36'51"E236.58'S77°23'09"E 178.47' ∆=36°25'44" R=190.00' L=120.80' CB=S82°06'52"E C=118.78' ∆=22°33'42" R=600.00' L=236.27' CB=S89°02'53"E C=234.74' ∆=7°26'53" R=4105.00' L=533.61' CB=S73°47'17"E C=533.24' ∆=8°28'08" R=2655.00' L=392.43' CB=S74°02'47"E C=392.08' ∆=23°41'16" R=700.00' L=289.40' CB=S66°26'24"E C=287.35'∆=6°34'34" R=190.00' L=21.81' CB=S57°53'13"E C=21.79' S 3 7 ° 1 7' 4 4 " E 1 7 3 . 4 4 ' ∆=12°43'19" R=1600.00' L=355.26' CB=N6°15'12"E C=354.53'N0°06'28"W231.32'S89 °5 3'32 "W 2 69.79' N73°11'00"W 312.58' ∆=49°46'22" R=78.00' L=67.76' CB=S81°55'49"W C=65.65' ∆=49°46'22" R=50.00' L=43.43' CB=S81°55'49"W C=42.08' N73°11'00"W 314.34' ∆=16°44'50" R=100.00' L=29.23' CB=N81°33'25"W C=29.13' ∆=37°21'06" R=1059.50' L=690.70' CB=S71°23'36"W C=678.53' ∆=122°38'20" R=65.50' L=140.20' CB=S61°31'39"W C=114.93' ∆=47°49'06" R=18.50' L=15.44' CB=S24°07'01"W C=15.00'S48°01'34"W 123.81' 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" (CM) 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" 1/2" IRSF "SPIARSENG" CROSSVINEDRIVE(50ROW)PONDEROSADRIVE(50ROW)GEEDRIVE(120ROW)∆=3°56'10" R=600.00' L=41.22' CB=S49°59'39"W C=41.21' N76°13'08"W 135.88' N83°04'28"W 197.45'N6°55'32"E84.90'S84°18'54"E 163.21'S5°41'06"W48.21'S15°23'43"W137.62'OHUOHUOHU697.9'BLUESTEM DRIVE(60RO W )CROSSVINEDRIVE(50ROW)PONDEROSADRIVE(50ROW)GEE DRIVE(120 ROW)OHUOHUOHUR 5 4 'R 3 0 'R54'R3 0 'R54'R30'R 30'R 3 0' R88' R112' R 3 0 'R 3 0' R 3 0 ' R 3 0 'R30'R20'R 3 0' R 2 0 'R20' R 2 0' R 2 0' R 3 0 'R 3 0'R30'R30 ' R88' R112' R 88' R 1 1 2 'R30'R30' R54' R30' R 5 4 ' R 3 0 'R25' R 25'R 2 0 'R 1 0 'R212'R188'R 3 0 'R 3 0' R 3 0'R30' R 30'R52' R 22'R50'R20'R20'1 8'8' 1 8' 3 0' 3 0'24'18'6'18'12'R 50'R 1 1 2 'R 2 5' 2 4 '24'12'18'18'12'40'44'30'18'24' R100' R100' R 1 0 0' R 3 0 'R3 0 ' R137' 30'R30'R30'24'10'24'24'18'5.5'24'9' TYP 18'24'18'5.5'24'18'24'18'5.5'9'TYP18'30'R 30'R30' 3 7' R 3 0 'R30'18'24'9 ' T Y P R 2 0 '24'20'R87'24'10'24'123.9'68.8'123.9'68.8'68.8'123.9'68.8'123.9'68.8' 123.9'68.8'123.9'6 8.8' 123.9' 123.9'68.8'123.9'68.8'123.9'68.8'123.9'6 8.8'123.9' 68.8'131.4'131.4'68.8'131.4'68.8'131.4'68.8' 131.4'68.8'131.4'68.8' 130.9'68.8'123.9'68.8' 131.4'68.8'123.9'68.8'131.4'68.8'131.4'68.8' 131.4'68.8'131.4'68.8'123.9'68.8' 6 8 .8 '131.4'68.8'131.4'6 8.8' 25'LANDSCAPESETBACK50'BUILDINGSETBACK15'LANDSCAPESETBACK20'BUILDINGSETBACKR30'24'R25'R25'R25'R25'R25'49.8'23.8'15'LANDSCAPESETBACK25'BUILDINGSETBACK3 0 '1 8' 27.6'18'24'26.8'9' TYP 91.2'67.3' CLUBHOUSE LEASING VISITOR PARKING 24'18' 9'TYP 18'9'TYP3 9 .1 '17' 15' LANDSCAPE SETBACK 20' BUILDING SETBACK25'LANDSCAPESETBACK50'BUILDINGSETBACKPROPOSED DETENTION POND PROPOSED SECURITY GATE 4' RETAINING WALL PROP. WROUGHT IRON FENCE EXISTING ZONING: MIXED USE PD-40 EXISTING LAND USE: OPEN SPACE TVG Texas I, LLC Doc. No. 2012-59927 O.P.R.D.C.T. WINDSONG RANCH PHASE 1A Doc. No. 2014-248 O.P.R.D.C.T. H.P. SALING SURVEY ABSTRACT NO. 1628 EXISTING ZONING: SINGLE FAMILY EXISTING LAND USE: SINGLE FAMILY WINDSONG RANCH PHASE 1A Doc. No. 2014-248 O.P.R.D.C.T. H.P. SALING SURVEY ABSTRACT NO. 1628 EXISTING ZONING: MIXED USE PD-40 EXISTING LAND USE: OPEN SPACE TVG Texas I, LLC Doc. No. 2012-59927 O.P.R.D.C.T. R57' R27'24'60' 60'ROWDEDICATION 6' RETAINING WALL 6' RETAINING WALL 24'18' 18'24'18'24'18' 24'18'24'9'TYP18' 18'9'TYP9'TYP18'24'R30'R30' 100 YEAR FULLY DEVELOPED FLOOD PLAIN LINE PER FLOOD STUDY ATEC, DATED 10/7/13 100 YEAR FEMA FLOODPLAIN FEMA PANEL 48121C0410G & 48121C0430G, DATED 4/18/11 R5 6 ' R65.5'32'15' 100 YEAR FEMA FLOODPLAIN FEMA PANEL 48121C0410G & 48121C0430G, DATED 4/18/1168.8'15'LANDSCAPESETBACK 20'BUILDING SETBACK 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 PROPOSED SECURITY GATE (EMERGENCY & EGRESS ONLY) PROP. LIVING SCREEN 1 LARGE EVERGREEN TREE (LIVE OAK), PLANTED ON 25' CENTERS, 3-INCH CALIPER MIN. AT THE TIME OF PLANTING, AND EVERGREEN SHRUBS (EASTERN RED CEDARS) PLANTED ON 15' CENTERS, 3”/45 GALLON AND 8'-10' IN HEIGHT AT THE TIME OF PLANTING 30.2'30.7'31' 3 5 .9 '48.3'45.8'30'31' 30' 30.1' 30.9' 47.6'32'4 7 .8 '30.3'36.7'32.9'37.4'31.5'37'30' TRASH DUMPSTER 8-FT MASONRY SCREEN WALL TO MATCH BUILDING MATERIAL 1 1 30' MAINTENANCE BUILDING 6' RETAINING WALL POOL/ AMENITY AREA POCKET PARK POCKET PARK POCKET PARKR54'R30'R112' R88' MAILBOXES FDC FDC FDC FDC FDC FDCFDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC FDC HIKE AND BIKE TRAIL TO CONNECT TO WINDSONG PKWY TRAIL SYSTEM 2 R150' 10' HIKE AND BIKE TRAIL 10' HIKE AND BIKE TRAIL 10' HIKE AND BIKE TRAIL 10' HIKE AND BIKE TRAIL PROP. PILOT CHANNEL TEXTURED COLORED CONCRETE PAVEMENT AS TRAFFIC CALMING DEVICE TEXTURED COLORED CONCRETE PAVEMENT AS TRAFFIC CALMING DEVICE30'DO NOT ENTER SIGNS (R5-1)100'STORAGEPROP. DECEL LANE 11' POOL CABANA PROPOSED CROSS ACCESS EASEMENT 30' SANITARY SEWER ESMT. DOC. NO. 2012-108224 O.PRDCT LOT 2, BLOCK A 2.5781 ACRES PICINIC TABLES & GRILLS PICINIC TABLES & GRILLS PICINIC TABLES & GRILLS 100 YEAR FULLY DEVELOPED FLOOD PLAIN LINE PER FLOOD STUDY ATEC, DATED 10/7/13 8' HIKE AND BIKE TRAIL 8' HIKE AND BIKE TRAIL PLOTTED BY DEANDA, GABRIELLE 4/15/2015 5:07 PMDWG NAME K:\FTW_CIVIL\061279403-DAVIS-PROSPER\DWG\10C-SITE-PLAN-PROSPER.DWGLAST SAVED 4/15/2015 5:07 PMIMAGESXREFS XREF x2436-Prosper - XREF xHatch-Prosper - XREF xfuturesite-Prosper - XREF xexsite-Prosper - XREF xex-util-Prosper - XREF xbndy-Prosper - XREF xsite-Prosper - XREF xEasements-Prosper - XREF xutil-Prosper - XREF xstrm-Prosper - XREF xhardscapeTHIS DOCUMENT, TOGETHER WITH THE CONCEPTS AND DESIGNS PRESENTED HEREIN, AS AN INSTRUMENT OF SERVICE, IS INTENDED ONLY FOR THE SPECIFIC PURPOSE AND CLIENT FOR WHICH IT WAS PREPARED. REUSE OF AND IMPROPER RELIANCE ON THIS DOCUMENT WITHOUT WRITTEN AUTHORIZATION AND ADAPTATION BY KIMLEY-HORN AND ASSOCIATES, INC. SHALL BE WITHOUT LIABILITY TO KIMLEY-HORN AND ASSOCIATES, INC.PROJECT No. 061279403DATE: APRIL 2015SCALE: AS SHOWNDESIGNED BY: HMDRAWN BY: GDCHECKED BY: HM SHEET NUMBER801 CHERRY STREET, SUITE 950FORT WORTH TEXAS 76102PHONE:817- 335-6511FAX: 817-335-5070TEXAS REGISTERED ENGINEERING FIRM F-928©2014 KIMLEY-HORN AND ASSOCIATES, INC.No.REVISIONSDATE BYADARA WINDSONGRANCHTOWN OF PROSPER, TEXAS 04/15/15 SITE PLAN D14-0069 WINDSONG RANCH (29.314 AC.) L. SALING SURVEY, ABSTRACT 1675 TOWN OF PROSPER DENTON COUNTY, TEXAS DATE PREPARED: APRIL 15, 2015 Kimley-Horn and Associates, Inc. 801 Cherry St., Unit 11, Suite 950 Fort Worth, Texas 76102 Contact: Hugo Morales, P.E. Tel. No. (817) 339-2294 TVG Texas I, LLC 1001 Windsong Parkway South Prosper, Texas 75078 Contact: David Blom Tel. No. (469) 532-0681 OWNER CIVIL ENGINEER/SURVEYOR APPLICANT/REPRESENTATIVE SITE PLAN C-02 SITE PLAN NOTES ANY REVISION TO THIS PLAN WILL REQUIRE TOWN APPROVAL AND WILL REQUIRE REVISIONS TO ANY CORRESPONDING PLANS TO AVOID CONFLICTS BETWEEN PLANS. 1.DUMPSTER AND TRASH COMPACTORS SHALL BE SCREENED IN ACCORDANCE WITH THE ZONING ORDINANCE. 2.OPEN STORAGE, WHERE PERMITTED, SHALL BE SCREENED IN ACCORDANCE WITH THE ZONING ORDINANCE. 3.OUTDOOR LIGHTING SHALL COMPLY WITH THE LIGHTING AND GLARE STANDARDS CONTAINED WITHIN THE ZONING ORDINANCE AND SUBDIVISION ORDINANCE. 4.LANDSCAPING SHALL CONFORM TO LANDSCAPE PLANS APPROVED BY THE TOWN. 5.ALL ELEVATIONS SHALL COMPLY WITH THE STANDARDS CONTAINED WITHIN THE ZONING ORDINANCE. 6.BUILDINGS OF 5,000 SQUARE FEET OR GREATER SHALL BE 100% FIRE SPRINKLED. ALTERNATIVE FIRE PROTECTION MEASURES MAY BE APPROVED BY THE FIRE DEPARTMENT. 7.FIRE LANES SHALL BE DESIGNED AND CONSTRUCTED PER TOWN STANDARDS OR AS DIRECTED BY THE FIRE DEPARTMENT. 8.TWO POINTS OF ACCESS SHALL BE MAINTAINED FOR THE PROPERTY AT ALL TIMES. 9.SPEED BUMBS/HUMPS ARE NOT PERMITTED WITHIN A FIRE LANE. 10. HANDICAPPED PARKING AREA AND BUILDING ACCESSIBILITY SHALL CONFORM TO THE AMERICANS WITH DISABILITY ACT (ADA) 11. ALL SIGNAGE IS SUBJECT TO BUILDING OFFICIAL APPROVAL. 12. ALL FENCES AND RETAINING WALLS SHALL BE SHOWN ON THE SITE PLAN AND ARE SUBJECT TO BUILDING OFFICIAL APPROVAL. 13. ALL EXTERIOR BUILDING MATERIALS ARE SUBJECT TO BUILDING OFFICIAL APPROVAL AND SHALL CONFORM TO THE APPROVED FACADE PLAN. 14. SIDEWALKS OF NOT LESS THAN SIX (6') FEET IN WIDTH ALONG THOROUGHFARES AND COLLECTORS AND FIVE (5') IN WIDTH ALONG RESIDENTIAL STREETS, AN BARRIER FREE RAMPS AT ALL CURB CROSSINGS SHALL BE PROVIDED PER TOWN STANDARDS. 15. APPROVAL OF THE SITE PLAN IS NOT FINAL UNTIL ALL ENGINEERING PLANS ARE APPROVED BY THE ENGINEERING DEPARTMENT. 16. SITE PLAN APPROVAL IS REQUIRED PRIOR TO GRADING RELEASE. 17. ALL NEW ELECTRICAL LINES SHALL BE INSTALLED AND/OR RELOCATED UNDERGROUND. 18. ALL MECHANICAL EQUIPMENT SHALL BE SCREENED FROM PUBLIC VIEW IN ACCORDANCE WITH THE ZONING ORDINANCE. NORTH 0 GRAPHIC SCALE IN FEET 30 60 120 LEGEND SETBACK LINE PROPERTY BOUNDARY EXISTING FIRE HYDRANT 24' FIRE LANE AND UTILITY FL FL EASEMENT ZONING PROPOSED USE BUILDING HEIGHT BUILDING AREA TOTAL PARKING REQUIRED TOTAL PARKING PROVIDED FLOOR AREA RATIO LOT COVERAGE PD-40 MULTIFAMILY 25.0485 ACRES (1,091,112 SF) 266,766 SF MF- 29'-3" CLUBHOUSE-15'-1" 21% 42% 120 x 2 = 240 SITE DATA SUMMARY TABLE PROJECT LOCATION U.S. HWY 380 (University Dr.)WINDSONG PKWY. FISHTRAP RD.HOPERD.N.T.S. VICINITY MAP GOODGEE RD. LOT AREA HANDICAP PARKING REQUIRED HANDICAP PARKING PROVIDED INTERIOR LANDSCAPING REQUIRED INTERIOR LANDSCAPE PROVIDED SQUARE FOOT OF IMPERVIOUS SURFACE OPEN SPACE REQUIRED OPEN SPACE PROVIDED NUMBER OF DWELLING UNITS NUMBER OF BEDROOMS Davis Development 17300 Preston Road, Suite 240 Dallas, Texas 75252 Contact: Gene Babb Tel. No. (214) 466-6220 DEVELOPER 1 BEDROOM 2 BEDROOM 3 BEDROOM 120 x 2 = 240 60 x 2.5 = 150 TOTAL = 630 300 UNITS 540 BEDROOMS 8.02 ACRES (32%) 7.51 ACRES (30%) 219STANDARD 316GARAGE 165TANDEM TOTAL = 700 13 13 441,312 SF 835,626 SF 172,387 SF TOTAL NUMBER OF BUILDINGS 34 NOTES 1.ALL DIMENSIONS ARE TO FACE OF CUB UNLESS OTHERWISE NOTED. PERIMETER WALL DIMENSIONS ARE TO OUTSIDE WALL FACE. REFERENCE ARCHITECTURAL PLANS FOR EXACT WALL WIDTH AND SPECIFICATIONS. 2.IT IS THE RESPONSIBILITY OF THE CONTRACTOR TO OBTAIN NECESSARY PERMITS PRIOR TO CONSTRUCTION. 3.FIRE WALL INSPECTED BY APPROVED PARTY 4. 100% FIRE SUPPRESSION 5.HIKE AND BIKE TRAIL TO BE IN 20' HIKE AND BIKE EASEMENT 6.TRAIL ALIGNMENT TO BE COORDINATED AND APPROVED BY THE TOWN AT THE TIME OF FINAL PLAT. 7.ALL BUILDINGS SHALL MEET BUILDING SPACING REQUIREMENTS. 8.NO EXISTING TREES TO BE REMOVED. BUILDING TYPE A BLDG AREA B C NUMBER OF BLDGS CLUB HOUSE # OF GARAGE PARKING # OF TANDEM PARKING BUILDING SUMMARY TABLE 8590 SF 8646 SF 8696 SF 6585 SF1 8 14 8 MAINTENANCE 1187 SF1 HEIGHT 29'-3" 29'-3" 29'-3" 15'-1" 8 84 10 8 42 39 T TANDEM PARKING SPACE PLOTTED BY DEANDA, GABRIELLE 4/15/2015 5:07 PMDWG NAME K:\FTW_CIVIL\061279403-DAVIS-PROSPER\DWG\10C-SITE-PLAN-PROSPER.DWGLAST SAVED 4/15/2015 5:07 PMIMAGESXREFS XREF x2436-Prosper - XREF xHatch-Prosper - XREF xfuturesite-Prosper - XREF xexsite-Prosper - XREF xex-util-Prosper - XREF xbndy-Prosper - XREF xsite-Prosper - XREF xEasements-Prosper - XREF xutil-Prosper - XREF xstrm-Prosper - XREF xhardscapeTHIS DOCUMENT, TOGETHER WITH THE CONCEPTS AND DESIGNS PRESENTED HEREIN, AS AN INSTRUMENT OF SERVICE, IS INTENDED ONLY FOR THE SPECIFIC PURPOSE AND CLIENT FOR WHICH IT WAS PREPARED. REUSE OF AND IMPROPER RELIANCE ON THIS DOCUMENT WITHOUT WRITTEN AUTHORIZATION AND ADAPTATION BY KIMLEY-HORN AND ASSOCIATES, INC. SHALL BE WITHOUT LIABILITY TO KIMLEY-HORN AND ASSOCIATES, INC.PROJECT No. 061279403DATE: APRIL 2015SCALE: AS SHOWNDESIGNED BY: HMDRAWN BY: GDCHECKED BY: HM SHEET NUMBER801 CHERRY STREET, SUITE 950FORT WORTH TEXAS 76102PHONE:817- 335-6511FAX: 817-335-5070TEXAS REGISTERED ENGINEERING FIRM F-928©2014 KIMLEY-HORN AND ASSOCIATES, INC.No.REVISIONSDATE BYADARA WINDSONGRANCHTOWN OF PROSPER, TEXAS 04/15/15 SIZETYPE DOMESTIC 2" IRRIGATION 2" ID REMARKS 2 PROPOSED METERS 32 PROPOSED METERS WATER METER SCHEDULE 1 2 FDC TEXTURED COLORED Davis Development 17300 Preston Road, Suite 240 Dallas, Texas 75252 Contact: Gene Babb Tel. No. (214) 466-6220 CONCRETE FOR TRAFFICCALMING Item 5f Item 5f Page 1 of 1 To: Mayor and Town Council From: John Webb, AICP, Director of Development Services Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – April 28, 2015 Agenda Item: Conduct a Public Hearing, and consider and act upon a request to amend the Future Land Use Plan, located on the northwest corner of Prosper Trail and the future Shawnee Trail, from Medium Density Residential to Dallas North Tollway District. The property is zoned Single Family-15 (SF-15) and Commercial Corridor (CC). (CA15-0002). [Companion Case Z14-0005] Description of Agenda Item: The applicant has requested this item be tabled and the Public Hearing be continued to the May 12, 2015, Town Council meeting, as outlined in the attached letter. Attached Documents: 1. Tabling request letter Town Staff Recommendation: Town staff recommends the Town Council continue the Public Hearing and table the item to the May 12, 2015, Town Council meeting. Proposed Motion: I move to continue the Public Hearing and table the item to the May 12, 2015, Town Council meeting. Prosper is a place where everyone matters. PLANNING Item 7 Item 7 Page 1 of 1 To: Mayor and Town Council From: John Webb, AICP, Director of Development Services Through: Harlan Jefferson, Town Manager Re: Town Council Meeting – April 28, 2015 Agenda Item: Conduct a Public Hearing and consider and act upon a request to rezone 67.7± acres, located on the northwest corner of Prosper Trail and Dallas Parkway, from Single Family-15 (SF-15) and Commercial Corridor (CC) to Planned Development-Single Family/Office/Retail (PD- SF/O/R). (Z14-0005). [Companion Case CA15-0002] Description of Agenda Item: The applicant has requested this item be tabled and the Public Hearing be continued to the May 12, 2015, Town Council meeting, as outlined in the attached letter. Attached Documents: 1. Tabling request letter Town Staff Recommendation: Town staff recommends the Town Council continue the Public Hearing and table the item to the May 12, 2015, Town Council meeting. Proposed Motion: I move to continue the Public Hearing and table the item to the May 12, 2015, Town Council meeting. Prosper is a place where everyone matters. PLANNING Item 8 Item 8