The URL can be used to link to this page

Doc Oneal Report on Brookshire - 2011Delivered to the Office of Mayor James Brainard this 5th day of August, 2011 On site review conducted July 19`.h'- July 21', 2011 Accompanying photos taken by ".Doc" ;Q'Neal for the City of Carmel, Indiana The intent of this review is to analyze various aspects of Brookshire Golf Club "Brookshire" "the Club ". Per our agreement/letter to Mr. Steve Engelking - Director of Administration, Office of Mayor dated June 14th, 2011; the scope of our services is to review the following: • Department I -lead Meetings • Club Objectives • Financial Overview • Labor and Expense Management • Budgeting • Personnel Training • Food and Beverage • Equipment Agreements • Website, Social Networking and Marketing • Insurance Review • Season Pass Holders • Capital Needs • Economies and Efficiencies The scope of our services are not limited to the above and may extend to an even broader scope of services by means of suggestions, recommendations, pricing samples and ideas that have proven successful at other golf facilities that we feel could prove beneficial to Brookshire. Detailed information regarding these additional items may be found in Exhibits A and B. We would encourage you to thoroughly review these as they provide General Observations and Comments as well as a comprehensive Marketing Analysis and Recommended Strategy that lend to the overall purpose of this review. Meeting with Department Heads We conducted our initial meeting with Bob Higgins - Golf Course Superintendent, who also serves as the General Manager of Brookshire. We found Bob to be engaging, accommodating, hospitable, friendly and a pleasure to work with during this review. Bob was very enlightening and informative and in many cases was helpful with his input relative to the Club, processes and facility knowledge through his years of experience at Brookshire. We also had the opportunity to meet with Bob Higgins and Brian Ballard to discuss Brookshire's approach to marketing and advertising. Both individuals were quite willing to share their experiences at Brookshire, discuss marketing approaches and offer opinions as to what strategies could allow for growth. Additionally, we were fortunate to spend quite a bit of time with Debbie Eggert - Food and Beverage Director. Debbie is a wonderful person with a graceful sense about her; someone who appears to be very level headed and would he steady and consistent. 3 Debbie also serves as the head of Food and Beverage at Forest Dale Elementary School in the Cannel Clay School System. Lastly, we spent some time visiting with Pam Lister - Administrator and "conduit" to the City of Carmel with respect to the finances of the Club. Our conversation with Pam was very enlightening and she could not have been nicer in providing information that was necessary for us to conduct our review of the Club. Objectives of the Club The main objectives of Brookshire are to provide an affordable and positive golf experience for all golfers with an emphasis on Seniors and Juniors. Financial Overview The budget, prepared annually in July and distributed to the Mayors office for approval, is focused solely on expenses. It is the desire of the City of Carmel to operate Brookshire at break -even through all operations and obligated payments. In 2010, Brookshire operated at a cash flow deficit funded by the City in excess of $250,000. (See Exhibit C) The majority of annual operating expenses include payment obligations for the golf cars, the golf course equipment and the irrigation system and pump house. The cost for 2011, 2012 and 2013 per year for the cost of all of the aforementioned equipment is $300,000, compared to $177,000 in 2010. This is shown as part of the budget and is reflected in the operations of the Club. It is our understanding that the irrigation and pump house will also have payments due in 2014 and 2015. The annual payment for the irrigation system (installed in 2010) and pump house is $192,000 per year, financed through Huntington Bank on a five year agreement. At the end of all equipment and irrigation /pump house agreements, the assets will be owned by the City of Carmel. Revenue Growth will be reviewed later in this report. Labor and Expense Management Bob Higgins is solely responsible for all labor and expense management. The chart that is utilized by Bob in his management of the labor is attached as Exhibit D. Purchase orders are generally not used unless there is an expense exceeding $5,000. Purchases exceeding this amount are subject to multiple bids, providing Bob Higgins and the City of Cannel the ability to select high quality and cost efficient vendors. Based upon our review of expenses including comparisons to similar facilities and industry benchmarks, we believe there is opportunity to reduce operating expenses and improve efficiency. Total salaries and wages plus benefits, per the 2011 budget, will 4 exceed $7 0,000. Brookshire will generate approximately $925 0 00 of revenue in 2011, therefore the labor and benefits aspect of the budget represents a percentage that is too high to operate at a break even. Salaried positions are in line and commensurate with the market in this area, but benefit costs are extremely high. We suggest that Bob review total staffing requirements for maintenance operations. 2011 expenses were budgeted at $1.4 million; however, Bob and his team have worked very efficiently to reduce operating expenses. Through July 20, 2011, expenses were under budget by approximately $120,000. At the current pace of revenues vs. expenses, it is reasonable to assume that Brookshire will still operate at a $350,000 deficit for 2011. This is in part due to difficult (cold, windy and rainy) golf conditions in April and May, the additional irrigation and pump house expense the extreme heat in July and higher expenses than other similar operations. The total Brookshire property represents approximately 113 acres, of which approximately 100 are maintained. Many of the areas that are not maintained are required to comply with Department of Natural Resources regulations. The specific DNR regulations and rulings most affecting Brookshire appear to be in response to a creek contamination in 2005. There are DNR designated environmentally sensitive areas nth ou ouLthe, olf course that ma of be currently required-. -.Some areas encroach on the core golf course and —make— the — course— appear —to— shrink in size. The ESA's (Environmentally Sensitive Areas) are extremely close to the maintained areas of the golf course and deter from the golf experience. As evident in the pictures below, these areas are unsightly and appear unnecessary in many instances. Right of #3 and #8 Right of #I ...near #2 and #8 5 Golf Course Maintenance area is as follows: • Entrance Area — 2 acres • Range tee — t acre • Range — 6 acres • Chipping Practice Area — 4 acres • Teeing areas -2 acres • Fairways and approaches to greens — 22.5 acres • Golf course rough area (non-fairway areas) — 63 acres • DNR Easement Areas — 13 acres Open Space — Practice Chipping and Bunker Area —4 acres Practice Putting Green Practice Range 6 1 The City of Cannel, Brookshire Golf Club made a substantial capital purchase in 2009 of approximately $ 330,000 of grounds maintenance equipment. This lease will expire in 2013. In addition, the City of Carmel purchased 82 Club Car golf cars and 2 maintenance vehicles at a total cost of $ 293,000. This lease will expire in 2012. Therefore at the end of 2013 all the equipment and golf cars will be owned by and will be an asset of the City of Carmel, Brookshire Golf Club. The new irrigation system and pump house were installed in 2010 and are being financed through Huntington National Bank at an annual payment of approximately $ 184,000. This agreement will expire at the end of 2015. Starting in 2014 and ultimately in 2016 the cash need for equipment lease and payments on irrigation and pump house will be substantially reduced. It is fair to say that there will be some replacement costs, perhaps some golf cars will be traded out over time, however, the cash demand will ease substantially in 2014 and 2016. (Total asset list is provided on Exhibit E). There are currently 82 Club Car oil cars and 2 maintenance vehicles leased through PNC Equipment Financing. Manage nt agrees that a maximum ofrars are needed. We recommend immediately implementing a strategy to re uce a fleet by 15- 20 golf cars to achieve available cash flow savings for the Club. Golf Car Storage Budgeting Bob Higgins, in coordination with the Mayor's office, provides a draft budget annually in early July. The focus of the budget is to identify the anticipated expenses for the upcoming year, providing a schedule (see Exhibit F) outlining the decrease or increase from the prior year's budget. It is our understanding that there is no revenue aspect of the budget that is presented, however, it is reasonable to assume that Bob would have information available regarding the anticipated revenues for the upcoming year. Revenue generation is critical to the success of the Club and it would appear that in 2011 the revenue generated will be less than anticipated due to inclement weather early in the season and the extreme heat in the middle of the season. It is imperative to the success of the Club that revenue be addressed in the annual budget and strategies developed and implemented to reach the goals and enhance overall revenue. Personnel Training Staff training is conducted by the various department heads. There is also a handbook that is presented to each staff member upon employment. We would encourage Bob Higgins to increase staff meetings from quarterly to monthly and more often during peak revenue months to review expected standards and quality of service requirements. These are essential to the perception and success of the Club. Perception is reality. Food and Beverage In 2010, food and beverage provided gross revenue of $115,000. Banquet business represents 12 -13% of total food and beverage revenue. To date 2011, food costs are averaging approximately 55% of gross revenue. Although in line based on volume, we would recommend a target of 45 -50% on an operation of this size and beverage costs at. 35 %. This would add $10,000 annually to the bottom line and is achievable through closely monitoring food waste and pricing. Per the June, 2011 month end statement, it would appear that food and beverage revenues will be negatively impacted by the reduction in golf play for the year. While weather has negatively impacted customer traffic, many opportunities exists to enhance food and beverage offerings and revenue. The kitchen is clean and well presented. We discussed with Debbie various ways to attract food and beverage business. We recommended offering more specials to the surrounding community. For example, Friday night beer /drink and appetizer specials. Currently, there is simply not enough space in the stand -up freezer to store the extra items needed to provide some "out of the box" ideas to promote the bar and food service. If a third -party company was engaged, the need for freezer space could be an added piece of equipment that they could address. It is a disappointment that the surrounding community has not embraced the Club more than they have to date. The bar is comfortable and well designed, providing two televisions to watch the games or your favorite event. Unfortunately, with the exception of a few times a week, the bar sits fairly idle. We would recommend promoting the Club in the community newsletter, through periodic flyers and use of social media. We are sure that a constant reminder of the opportunities at the Club would produce additional activity. 8 4.We believe that Brookshire would benefit from increased exposure on television Channel 16 - City of Carmel Government station by promoting banquet room opportunities and the food service in general. Thousands of cars drive by Brookshire each and every, day with no knowledge of the available food and beverage service. Improved and increased marketing will open the Club to these many potential customers. In addition, we recommend exploring outsourcing food and beverage services to enhance revenues while reducing direct overhead and mitigating operational risk. Sitting area within the bar Banquet room — Seats 115 Bar presentation — nice Kitchen serving window 9 Equipment Agreements Existing Agreements (per Bob Higgins as actual agreement documentation was not provided): • Equipment o PNC — terms through end of 2012 0 • Golf Cars o I'NC — terms through end of 2013 g • Irrigation and Pump o Huntington National Bank — terms through end of 2015 Brookshire will own all equipment upon agreement expirations. The City of Carmel will have a nice asset list going forward. (See Exhibit E) We recommend a thorough review of all agreements for compliance issues and to identity potential cost- saving opportunities. Website, Social Networking and Marketing Given the history of Brookshire and the transition to City ownership over the past few years, marketing has taken a back seat to improving the course and developing a solid relationship with the current and potential base of customers. Much has been accomplished and use of the golf course has increased. However, there has been little to no dollars or time devoted to marketing. In effect, there is great potential for growth with a much more comprehensive marketing approach that is consistent with other strategic decisions discussed elsewhere in this report. Golf Course Marketing Systems, a division of Cohoat and O'Neal Management, has performed a complete marketing evaluation that may be found in Exhibit B. This evaluation outlines Brookshire's current strategy and provides recommended approaches and opportunities. Insurance Review Health Insurance Bob Higgins informed us that the employees of Brookshire Golf Club are City of Carmel employees and are self - insured through the City of Carmel health insurance plan. Unfortunately for the Club, the current total cost of health insurance is significantly above golf industry standards and hinder the Club's ability to operate at break -even. 10 i Property and Casualty L.,_ Management is involved, in cooperation with Steve Engelking, in procuring and managing the Club property and casualty program. As such, property and casualty insurance information was not available for our review. We would suggest that Club management review all necessary coverages (umbrella coverage, business income loss, all assets covered, liquor liability, etc.) with the Club's insurance agent. The agent should ensure that coverages are up to date and adequate. It is always wise to re -visit annually and golf course insurance is a specialized program. We believe the opportunity exists to decrease insurance costs by $3,000 — $6,000. ilsIn addition, we would suggest that the City engineers perform a quality and strength /load integrity study of all bridges. Golf course bridges age quickly and are often unintentionally neglected. Bridge on # 13 Spanning telephone pole support Season Pass Holders Currently, Brookshire has 56 season pass holders, representing approximately $70,000 of revenue. The majority of this revenue is received in November and January each year as the Club attempts to off -set the reduction in cash flow during the `off season." Per Bob Higgins, only five of these season pass holders live within the 420 -home Brookshire Residential Community. The Club offers the clubhouse free of charge for the community's monthly /annual meetings; therefore we would suggest that a push be made to sell memberships to this group at the Fall and Winter meetings. Possibly provide incentives, referral awards, etc. to the community to gain support for the Club. Additionally, identify and contact former members and regular players, inquiring why they left the Club. This information is vital to Brookshire's success. Member information can be found browsing through the Club's Point of Sale system...Fore Reservations. 11 Capital Needs This is an area of great concern. It is no secret that Brookshire Golf Club is still feeling the impact of years of poor management and a loss of credibility. Historically, Brookshire Golf Club has had the reputation of a lower end facility, poorly maintained golf course, an-friendly service staff and in general a less than quality golf experience. Over the past few years, Bob Higgins and Brian Ballard have done a wonderful job of trying to re- establish the credibility and the positive experience that applied years ago. Brookshire was once upon a time a Club that people enjoyed, IvMen's Club participants were 100 and the golf course was always in nice condition. Prior to the City of Cannel purchasing the golf course, the course condition was deplorable, the experience was unfavorable and golfers found other options. This is a difficult mindset to change, especially when there are many options within one community and county. Therefore, it is vital that the golf course condition must be good, price must be right and perceived value.must he high. The experience has to be exceptional and not mediocre. The golf industry is in a state of flux at this point in time and with the economy being stressed, it is clear that if one is going to take the time to play golf that the value and experience must run parallel. In fact, expectations must not only be met, hut exceeded. Brookshire Golf Club has no doubt, made enormous strides in recent years. However, the Club is still fighting the "gremlins " - 13NR encroachment, a lack of land for 18 holes, abbreviated practice range with limited flight golf balls, bridges that need to be repaired /replaced and worn cart paths. The Master Plan prepared in 2009 addresses many issues facing Brookshire. Following, we provide updated comments regarding a number of these areas. 12 Cart Paths There are cart paths that are paved and some that are crushed stone. it is extremely labor intensive and costly to repair and dress up the areas around these paths. Yet, if general impressions are going to change, these types of enhancements must be made to the golf course. The Master Plan prepared in 2009 addresses many of these issues. Cart Paths 13 Bunkers Bunkers, in general, are not drained properly and present a challenge for playahility and conditioning if rain occurs. Some of the bunkers have developed so much sand along the perimeter /banks that they dry and brown quickly in dry conditions. This is no reflection on the Superintendent and staff. It is a losing proposition and they need to be fixed over time or accept mediocre conditions with the hunkers. Costs are estimated at $3,000 — 5,000 per bunker, dependent upon the severity and size. Tees Bunkers Bob Higgins has done a masterful job of maintaining the playing conditions of the course. The tees are in decent condition despite their position. Morning sunshine is critical and many of the tees are draped in shade until mid- morning or throughout the day. Shaded tee complexes at R:00 a.m, Tees will get thin with weak grass conditions quickly. 14 Putting Greens Putting surfaces are currently quite nice. Although, there is fear that several of the greens, because of their position within a tree canopy/shade, will also begin to deteriorate, Tree trimming is essential and, in some cases, tree removal is necessary so that these greens can breathe, get ample morning and mid -day sunshine and cooler air temperatures. The greens specifically in jeopardy are 41, *7, 410 and #17. There are other greens that are bordering on being shaded ton long. #2 Green - no sunshine at 8:00 a.m. Practice green — ideal conditions Fairways Bob Higgins and the new irrigation system have proven to be a great asset to the fairway conditions. Many of the fairways are in good shape, but many are also challenged with improper sunshine exposure. Over time, lack of sunshine will wear and tear on the grass plant and deteriorate their condition. We would suggest that priority be placed on trimming or eliminating all trees possible. Conditions of bent and blue grass excel in open air conditions 15 Economies and Efficiencies The golf course industry today is facing a crossroad. Do courses continue to "run the cupboard dry" and hope for the best or change the dynamic of how the business is conducted? For Brookshire, it is a matter of identifying the issues, as we have in this report and from the Master Plan prepared in 2009. We are certain that if the City of Carmel continues on the current path, the course will continue to operate at a deficit in excess of $250k for the next several years. At some point, the value of the Club will obviously come into question. Where does Brookshire Golf Club, City of Carmel want to he in five years? Items to consider: • Condition of golf course • Condition of clubhouse • Cart paths — asphalt or other • Privatization of ownership /management • Bunkers —re -do with drainage or not • DNR — can amends be made and ESA encroachments be lessened • Pricing - rates and season passes • Rounds of golf— 201 1 projections are somewhat over estimated (26,000 projected actual versus 30,000 budgeted) • Bridges — repair and replace given high cost • Reconfigure course - turn facility into a very nice nine hole golf course with a three hole junior course o Convert some holes to green space and park like atmosphere o Maintain nine holes, providing more room and eliminate dangerous overlapping o Convert three holes to junior golf holes for the growth of the game within the community o Currently there is a movement afoot to convert some golf courses to 12 holes to save on time, cost and other factors. Perhaps the City of Carmel could lead the way. • Grants — are Federal /State dollars available through grants to assist with some aforementioned ideas and costs • Marketing — develop formal strategy • Current chipping and bunker area (4 acres) considered for residential o Sale could be used to offset some course enhancement costs • Swimming pool -- long term goal of this privately held asset/liability • Junior Golf Program — grow and expand o Host several summer camps totaling more than 150 kids o Generate $15,000 of additional revenue o Should be important to the City of Carmel i6 Summary of Considerations and Recommendations l 1. Consider a change to the front entrance to the building. The welcome needs to he warmer and more inviting. 2. Daily reports with more of a focus on revenues. We have a sample daily report template that may be provided to assist the staff. 3. Plan to meet with the Department of Natural Resources (DNR) and attempt to develop a closer relationship to determine the potential to `scale back" on environmentally sensitive areas that are now encroaching onto the golf course. 4. Consider setting the precedence of establishing a high quality 9 — 12 hole golf course with a three hole junior golf course. This non - traditional facility would provide a unique option focused on junior, senior and developing golfers in a customized, friendly environment. Perhaps a step "outside the box" would be a great message and follow the trend of the City of Cannel being a leader. 5. Consider options for the chipping and bunker area as you enter the club, just to the south of the main entrance. This area is not a quality practice area and remains an expansive open area that is not seeing the best land use for this acreage. Either develop residential to re- capture some of the initial capital investment to or improve the quality of the area for golf usage. 6. Return 15 -20 golf cars to Club Car. There is not the need for 84 golf cars in the fleet and is simply taking space and costing money. Scott Gaede is the Club Car representative at 513.218.1988. 7. Food and Beverage should target better food and beverage costs which could save $ 10,000 towards the bottom line. 8. More effective communications with the 420 -home Brookshire residential community. More interest in the club and more support from a golf and Ihod and beverage point of view. 9. Engage one of the local catering companies to consider using the banquet facility as an independent contractor. 10. Utilize the beverage cart more effectively. Opportunities do exist in this aspect of the food and beverage. 11. The City Engineers should test all golf course bridges for safety and load integrity. 12. MORE golf outings! 17 13. Consider over the next few years making some enhancements, as money allows, to cart paths, bunkers and other areas that will improve the playability and impression of the golf course. 14. Trim and remove some trees that will allow more sunshine to the currently shaded areas. Specifically tee and green areas. 15. Marketing — work with John Cohoat to develop a plan and a strategy. it WILL make a big difference across all areas of operation and performance. 16. The Junior Golf Program needs to be more extensive and provide an opportunity to many more children. 17. More exposure on Channel 16 for banquet business, food and beverage, current events and so much more. 18. Men's Club should start earlier...or at least start weekend tee times at 6:30 a.rn. during the golf season. hosing some good golf activity at this time of the day. 19. More Senior play! 20. Remove some of the bulky white cart control stakes and replace with green stakes and rope to present a less offensive appearance to the specific area. 21. Winter projects — consider doing as described in the report. 18 Brookshire Golf Club in 2016 What will be different in 2016 compared to 2011? We believe that a committee should be formed to address Club concerns and objectives. We would he happy to serve on this committee and to assist with the thought process as you go forward. The old saying of "if nothing changes... nothing changes "... We honestly believe that Brookshire Golf Club has wonderful potential. It sits in the heart of one of the most thriving communities and counties in America, amongst thousands of roof tops and is visible to thousands of people daily along 11611' and 126th streets. We would love to be a part of the future enhancement and progress of the Club. Perhaps the City of Carmel would prefer to engage our services on a "retainer" bask with an agreed upon fee to assist in she implementation of the ideas reviewed in this report. To Mayor James Brainard, Steve Engelking, Bob Biggins, Brian Ballard, Pam Lister, Debbie Egged and the other very cooperative people of Brookshire Golf Club...we thank you for the opportunity to assist in the Evaluation and Marketing of Brookshire Golf Club. Cohoat and O'Neal Management Corp. August 5`h, 2011 Brookshire Golf Club 19 Cohoat and O'Neal Management Carp. 20 Exhibit A General Observations and Comments First Impressions Upon arriving at the Cub for the first time, we were a bit perplexed on where to enter the building. There was not a real warm welcoming to the facility. Original entry - somewhat welcoming awning Sign on old door directing to new door —now states Restrooms & Snack Bar Upon entering this door you walk into a hallway Golf Shop The Golf Shop is adequate and provides a service to the golfers of Brookshire Golf Club. Golf shop revenue currently totals 550,000 annually with a profit margin of approximately 28 %. This was not the case in 2010, however, indications from the June financial statement illustrates that the golf shop will work towards a profit margin of close to 30% for the calendar year of 20 t I. Although a good target, there is just not much revenue. Golf club sales are negligible (wedges and putters primarily) and most of the goods sold in the golf shop arc golf necessities (shirts, balls, gloves and other accessories). A physical inventory of the golf shop is taken each month by Brian and his staff. We thought the shop was nicely presented. Despite a few burned out light bulbs, the shop was dean and had a good feel to it, We would prefer an easier entrance to the shop though. Golf Shop as presented July 19th, 2011 A -2 Banquet Room The current banquet room marketing piece can be found in Exhibit H. We would suggest that the City of Carmel review the capital needs for this room. Chairs are very tired and unattractive and could be a determining factor in a bride choosing to go elsewhere for their special occasion. Debbie has elected, in most cases, to use chair covers for all - wedding receptions which has sufficed. Once again, we would suggest a conversation with a local catering company or two to see if they would have an interest in independently utilizing this room for events. i A -3 General Course Comments The Beverage Cart is not used at any time due to the golf course configuration, which can place the beverage cart driver in harm's way. In the past, the cart has been positioned in certain locations on the golf course, however, the revenues generated from the cart were minima] and therefore the decision was made to eliminate the beverage cart during normal course of play. We would encourage the Club to investigate alternatives. The beverage cart should produce a substantial amount of revenue on a regular day of play. Sandwiches, cold drinks and snacks are always welcome to any golfer. In addition, it gives the player the sense of being on vacation and places them in a buying mood. The practice chipping and bunker areas arc located in a highly visible area. they can be seen from the road, as golfers arrive and depart the Club. We recommend that this area be considered for residential, or improve the area and make it a quality feature of learning the game. Currently, due to cost controls, the grass is maintained at a higher cut than most greens and therefore, does not simulate a real golf course experience. This area will not be a large revenue source; however, it becomes part of the package that forms perceptions of the Club. At this point, this area is more of a negative. Each tee on the golf course includes a yardage sign (yard arm) that provides a visual of the golf hole (granite monument), the yardage and the par. The area around each monument is a mulch bed with a bench and a waste basket. We would suggest enhancing these areas. Once again, not critical but it offers an impression. The areas are not edged, weeds present in the mulch and the general appearance sub - standard. Many of these areas were visually unappealing. Simply de- weeding and enhancing the golfer's impression should be relatively inexpensive and should be a priority. Approaching teeing area A -4 Cart restricted areas are defined by large ugly white posts that draw too much attention. Many of these are worn out, broken and not erect. We would suggest installing green stakes that are less offensive and less visible. A -5 2010 Irrigation System Installation The course still shows scars from the 2010 irrigation installation. They are quite visible throughout the golf course, yet, they should start to disappear as fall approaches and growing conditions are enhanced. The new Rain Bird irrigation system is excellent. It provides tremendous coverage throughout the golf course and will enhance the playing conditions over time. As long as the course continues to receive ample water and some of the `tired and sore" areas receive consistent water coverage, many of the worn spots will begin to heal on their own. It is fair to say that by next May, 2012 many of these areas will sec substantial improvement. Bob Higgins has elected to aerate twice a year on tees and greens and once a year on fairways. This process can be fairly expensive and time consuming and, for a period of time, provides an unsightly experience for the golfer. However, this will pay dividends in the long run. The turfgrass conditions will strengthen as a result of the root zone. The roots will reach deeper and get bigger and stronger as a result. is e areec certain that rat for many years this practice was not implemented and 13ob Higgins o in the shaded tee areas and the shaded green complexes are holding on pretty well due to this practice. We would encourage this process to continue in the future. A -6 Pricing and Daily Rates See Exhibit G for comparisons of other area golf courses. Point of Sale The point of sale system is Fore Reservations. This system is very capable of performing a wide variety of reports and its ability to reach out to the database with regards to daily, weekly and all types of promotional specials. It truly is an all- encompassing system. We would encourage Bob and Brian to attend one of the Fore Reservations conferences on the educational opportunities that lie within this system. Sonic of the ideas or suggestions have been reviewed in the Marketing section of this report. The key is developing /growing the database and collecting as much information from all customers as possible. Pace of Play Pace of Play seems to be managed well from the Golf Shop. We have heard from general discussions with those who play Brookshire on a fairly regular basis, that pace of play can be slowed on weekend afternoons. If that is the case, we would simply encourage Brian and his team to be certain that the pace is addressed. Golfers despise slow play. Ensure that this addressed early in the process with the starter /ranger or Golf Shop staff. Outin s Outings are not as much of the Club framework as they could /should be at this point. Once again, we believe a negative stigma still looms from previous management teams. Outings are critical to the revenue and financial health of the Club. Brookshire should target 20+ golf outings with food and beverage packages annually. Identify ideal days of the week to host outings, price them accordingly and solicit business. There are companies within Carmel that would love to support their City Club. Incentivizc businesses within the City to host their outings at Brookshire. Perhaps offer special pricing for businesses within the City limits, if that is an acceptable practice. Outings should represent close to 8% of your total golf rounds. Growing the outing aspect of the Club is essential and will enhance food and beverage and golf shop sales. It is truly a "domino" impact on the Club. We would suggest an outing packet to assist in the sale of golf outings and someone to make an effort to sell them. At this juncture it is really "build it and they will come" approach to the golf outings. A -7 Men's Club Men's Club starts at 7:30 a.m. on Saturday mornings- shotgun starts with general play starting at 9:30 a.m. Our suggestion is that play should always start earlier than 7:30 a.m. especially on weekends. Golfers rise early and want to start play as soon us possible, finish their rounds and go home to do their "honey do" list. Many golf courses in the area star at 6:30 ant and are booked in every time slot. We would also encourage a much earlier start during the June, July and August part of the golf season. We will guarantee that there are golfers going elsewhere to get an earlier start on weekend mornings. Very few Men's Club golfers eat at the Club. Consider offering them a reason to stay. Incentivize them with a nice inexpensive buffet. They are currently playing golf, settling their bets and many are heading home. Make it a priority to change these habits. Provide them a Saturday Men's Club special that is tasty and less costly than normal. Seniors We would love to see the Senior golf group grow in numbers. It is always nice to have a Senior group who plays your golf course twice a week. This presents good activity on two mornings that are generally slow. We have found that Monday and Thursday mornings are great time for a Senior group to play. Also, Seniors will not spend much money before, during and after golf. We would recommend occasionally providing a complimentary lunch to thank them and to expose them to the great food choices. A -8 Late Fall and Winter Projects Late fall and winter time is truly the only time that some projects can be completed due to time constraints with staff and many other responsibilities that have to be completed throughout the golf season. For example, maintenance building clean up and organizational work within the building and surrounding areas are good winter projects. The maintenance building and surrounding area is important for a few critical reasons. It establishes the standard of quality from the Superintendent. In many cases it is difficult to have the facility spotless due to all of the work and mess that is created from the day to day operations. However, it is good to make certain that each winter there is a desired look that needs to be achieved so that heading into the next season everything is cleaned, serviced properly and presented in a very orderly and clean manner. it "sets the tone" for the entire staff. In addition, the building and surrounding area is quite visible to all golfers. Impressions are formed on Hole #1 and if the area is unsightly it creates a negative impression. Other winter projects include painting and servicing all golf course accessories. Water coolers should be re- painted and any other items that are going back onto the golf course need to be re- furbished over the winter. • A -9 Golf Professional We had the opportunity to spend some time with Class A Golf Professional Brian Ballard. Brian has a good pedigree and, in our opinion, is a quality golf professional. He was previously employed several years ago as an Assistant at Brookshire Golf Club under different Brookshire Management. Most recently, Brian worked as an Assistant Golf Professional under the direction of John Dunham, one of the best in the business, and Chris Brummett, both from Highland Golf and Country Club in Indianapolis, Indiana. We found Brian to be very relaxed and easy to visit with during our time together. We were able to do a lot of fact finding from Brian and get some insight as to the programs as well as his professionalism. This is Brian's first head golf professional position. Needless to say, he wants to excel and he has a real allegiance to Brookshire Golf Club. Instruction is a part of the services that Brian and his staff provide, yet, there is not a substantial amount of private or small group instruction in terms of revenue generation. Carmel Dads' Club does bring their Fall and Spring Golf Programs to the Club and that is a nice financial incentive for the teaching staff. We have seen Brian on the Channel 16 TV station providing instruction on various aspects of the game. Brian does a nice job and he should do this more often. Brian should also promote Club programs (Junior, Senior, Men's Club, and Ladies Leagues), cite testimonials and review current and upcoming activities. A -10 Administrator Brookshire Administrator, Pam Lister, provided us an overview of Club finances. We were able to identify a number of issues that should be addressed in the near future. Although minor, it would be more efficient and convenient if Pam could make her daily deposit at a bank in close proximity to the Club as long as it was an acceptable government practice. The current process is cumbersome and adds time and expense to travel to and from City Hall each day. u i,t c auk ,�st O, Jthtce We continue to emphasize the importance of focusing on revenue. Based on our conversations, it appears that expenses are such a concern that sometimes revenues are forgotten. Revenues should be monitored each and every day of the month. The Club would benefit from a daily report that compares aetuaLrevenue_to_target _ The team should review and react to the report daily versus monthly. At the end of the month it is too late. The_CI needs to know what is ' ttgandwhat deeds impr ved. Revenue and marketing run hand in han . Each must be a significant part of the future. Pam is responsible for the submission of all invoices and the Clerk - Treasurer's office is responsible for payment of all payablcs. Pam is also responsible for collection of receivables, although the Club has few. In the case of a golf outing receivable, the check is payable to Brookshire Golf Club and submitted to the Clerk - Treasurers office. Many golf outing receivables can take up to a week to settle with the Club. Payroll is administered through a time card system and, once again, submitted by Pam to the Clerk - Treasurer's office for payroll distribution. All payroll is distributed through direct deposit. In addition, Pam is responsible for the reconciliation each evening and all deposits are taken to the Clerk - 'treasurer's office the following day. The money is kept overnight in a safe. Lastly, Pam prepares monthly financial statements and submits them to Bob Higgins for review. Onc proved, the fnancials_are_dittributed to the Mayor_and City Council. Members. The Club is losing substantial money in 2011 at this point in time per June Financial Statement. City of Carmel Employees We recommend utilizing the various City of Carmel employees that have extra capacity _temporarily this fall. Many areas that need attention on the golf course could be enhanced. It comes down to man power and labor costs. If some of the other department employees have the time available we are sure that Bob Higgins would greatly appreciate their assistance. This may not be possible, but just a suggestion. A -I l Exhibit B Brookshire Golf Club Carmel, IN Marketing Consulting Evaluation Prepared by: John S. Cohoat, Golf Course Marketing Systems, a division of Cohoat O'Neal Management I met with Bob Higgins and Brian Ballard for approximately two hours on Thursday, July 21, 2011 to discuss the Brookshire approach to marketing and advertising. Both individuals were quite willing to share the story of their experience at Brookshire, discuss marketing approaches and offer opinions as to what strategies could allow for growth. I want to thank Bob and Brian for their frank discussion and helpful approach. Overall Observations Regarding Current Marketing Reality at Brookshire: Given the history of Brookshire and the transition to City ownership over the past few years, marketing has taken a back seat to improving the course and developing a solid relationship with the current base of customers. Much has been accomplished and use of the golf course is up. However, there has frankly been almost no dollars or time devoted to marketing. This is not to be critical but just to express the reality. In effect, there is great potential for growth with a much more comprehensive marketing approach that is consistent with other strategic decisions discussed elsewhere in this report. Here is my assessment of the current marketing strategy and messaging at Brookshire: • By improving the course and working to provide a better overall experience, course management intends to improve "word of mouth" and slowly draw golfers back to Brookshire. This has certainly worked somewhat as rounds have increased over the last few years. • To the extent that there is a marketing message used, it might be "Hamilton County's Best Value in Golf'. This positions the course as a low cost alternative for a relatively good golf experience. (This is an area of concern also, since competing on low price is not recommended as a good marketing strategy.) • By staging various events, leagues and golfing opportunities, there is an effort to draw certain niches. These include senior leagues, The City Championship, junior clinics, ladies clinics, etc. • With the limited budget available ($5,000 last year and $8,000 this year), the focus has been on having a decent web site, monthly emails, a few media ads and a few brochures. • Limited discounting has been used to attract new business. • There has been an attempt to get more outings and banquets by bidding on specific requests and doing your best to accommodate their needs with limited facilities and services. Golf Course Marketing Systems page I of R John S. Cohoat. Elements of an Effective Golf Course Marketing Program and Strategy: Most golf courses have a strategy not much different from Brookshire. They arc quite reactive to what opportunities advertisers bring them and respond on an "as needed" basis, typically trying to copy other golf courses, sometimes with heavy discounting to drive play. Very few golf professionals, general managers or superintendents are truly marketing experts, so they try to do the best they can to have a nice course, good service, clean facilities, well stocked pro shop, etc. while not being sure what to do about marketing. This part of the report answers the question of what Brookshire might aspire to if you want to really ramp up your marketing and attract new business. In effect there are only four ways to grow your golf course business: I. Attract more golfers to your course. 2. Get them to come back more often. 3. Get them to spend more money with you. 4. Enhance all your allied revenue generating services like banquet facilities (also by getting more customers, having them come back more and spending more). To implement a comprehensive marketing program that accomplishes the above goals in a cost effective manner, here are some basic concepts: Focus on Direct Response Advertising where every dollar spent can be tracked for return on investment. The other side of this coin is to eliminate or minimize brand building or "get the word out" advertising where there are no proven returns. Just having a few brochures and ads in community publications or hospitality guides won't get you the returns you want from your advertising. Next, have a priority to grow your database in a way that provides as much information as possible about your golfing and non- golfing customers. Many courses, if they have a list at all, focus on getting names and email addresses. We recommend getting full home addresses, phone numbers, place of employment, family information, etc. While this may not be possible fur the initial contact, this should always be the goal since having this information sets you up to be able to market effectively to your list. Next, implement multi media approaches to your marketing. While we highly recommend good email marketing, there are many other avenues that should be used. This includes direct mail which is still highly effective if implemented correctly. Social media including Facebook, Linked In, Twitter and other local sites are necessary. Great web sites with lead generation can be effective. Sequential mailings to a targeted neighborhood or for targeted businesses to attract outings /banquets should be designed. Golf Course Marketing Systems page 2 of 8 John S. Cohoat Once you have your base of good golfers, you need to implement a referral program. With an ongoing referral program this can be one of the easiest ways to increase your business dramatically. Loyal fans can bring more good customers to you. There is also much opportunity in going after golfers or other customers who are now "lost ". Again, by having an effective database tool and old customer lists, the golf course can identify customers who, for whatever reason, have not used your services recently. These "lost customers" can be attracted again with specific offers targeted to them and some portion will respond. Get away from boring, "me too" advertising and look for ways to stand out. I don't have space to go into all the strategies here, but there are opportunities to design fun mailings, mails, events, etc. that will really attract people to your facility. Especially since Golf Courses are in the business of recreation, we should find ways to advertise that arc memorable, fun and noticeable. Next, become real students of, and practitioners of marketing. What do I mean here? My observation is that most golf courses don't spend nearly enough time on this area or their business and it really should he the highest priority, because this is where the growth and long -term success comes from. At least one person needs to take this area of the business quite seriously and devote time and study to it. it doesn't mean they have to do all the technical web site stuff or write long sales letters, because there are vendors or assistants who can he used for this. But a true marketing leader needs to be on board, usually working very closely with a marketing coach or mastermind group. 'Be in the game of "self- promotion ". Look for every opportunity to get free publicity and toot your own horn. Do press releases on every event to local newspapers and radio stations. Have someone win an award or have a student do well in a tournament? Tell about it in your emaits, on your web site, newsletters, etc. Post the information on Facebook or do a YouTuhe video. If your golf professional wins or places in a big tournament, tell about. If you do something to help a non - profit raise money, make sure you tell the story and get pictures or videos. As you continue to grow your database of golfers, businesses, community members, non- profits, etc., don't be afraid to communicate with them very frequently. What I mean by this is up to severat times a week for your core golfers. The more you are in front of them, making offers, telling them what's happening, giving tips, telling about new golf technology, tooting your horn, etc. the better. Will some people tune you out or unsubscribe? Yes. But the point is they aren't your most loyal followers and that's who should be top of mind for you. Don'I worry about the few naysayers, just keep building your list of rabid fans and keep the dialogue going with them. That's how you build your business. Golf Course Marketing Systems page 3 of 8 John S. Cohoat Major Breakthrough in Thinking About Your Marketing We preach a different approach to thinking about marketing and advertising expenditures. Most golf course and businesses view marketing as a cost roach is doing business...discretionary expenditures that just cat up budget dollars. Our approach marketing We talk about the lifetimeivalue of g golfers your and most hat you oaretwilling too base. invest to get a new one and keep the ones you've got. Once we accomplish this mindset change, we need to think in terms of setting up Reservations sfornyourrBrookshire Point tof Sale wand Golfers few Guide elements youraweb system site and em it marketing. You arc only using very limited capabilities of these systems and l assume this is primarily due to cost and time considerations. We can provide full information on the elements of a marketing system, but here are some highlights: 1. A selected group of high priority prospects and present customers to market to on a regular bask 2. Appropriate multi -media for communicating with this list on a consistent basis 3. A compelling marketing message that set you apart from other golf courses and facilities. (We introduce the term Unique Selling Proposition "USP" here. For any golf course, this is an exercise that takes quite a hit of lime to develop their USP.) 4. "Irresistible Offers" that will attract prospects and customers to you, not just plain vanilla messages like every other golf course. 5. A means of capturing new leads and present customers. 6. Then, a multi -step, short term follow up system. So many businesses fail here by neglecting to follow up with lends generated. 7. Finally, a system of maintenance and follow up of unconverted leads. Just because someone doesn't respond immediately, don't give up. Keep them on the list and follow up with different offers, news, etc and eventually some portion will respond_ The use of such online and offline systems can put your marketing on "auto- pilot" so that there is a consistent le-vet of marketing activity rather than "random acts" of marketing in response to a downturn in revenue or because you feel a need to respond to your competition. Golf Course Marketing Systems John S. Cohoat page 4 of 8 Recommendations /Opportunities: Elsewhere in this report we have outlined major issues including the present financial losses. Major decisions are necessary as to what vision the city leaders have for Brookshire, sonic of which may involve substantial investment, course reconfiguration, change in management priorities, etc. These decisions will affect how the eventual marketing plans and messages are carried out. In the interim, starting right now, there is opportunity to implement many recommendations that could enhance revenue and the bottom line. Most would necessarily require a change in mindset, commitment to invest in marketing and implementation of marketing systems as noted above. I would also caution that I make these suggestions based upon our short meetings and without benefit of extensive data analysis. Such additional investigation may color the recommendations and uncover even more issues or opportunities for growth. Here are sonic initial items for focus: I. Make every effort to grow the database. I can't emphasize how important this is, because having a large database allows you to market on so many levels. Take every opportunity to register new individuals and businesses into your databases. Train staff to obtain the information and give people an incentive to provide the information. This will require constant emphasis from Bob Higgins and Brian Ballard to ensure that this is happening all the time. 2. Target the local neighborhood with an extensive campaign to obtain new course members and users. This group needs to start to think of Brookshire as "their club ". This may involve purchasing mailing lists. Consider mailing multiple sequences to the lists with strong offers to get the neighbor to consider Brookshire. Special neighborhood events and offers should be designed. 3. Consider implementing a Loyalty or Rewards Program. There are various vendors who can provide such a program with cards, points, award levels, certificates, mailings, etc. Part of the program should include a Birthday Program where the member gets free golf in the month of their birthday (or half- birthday for those whose birthdays fall in the winter). 4. Step tip your email marketing campaign. My understanding is that emits go out about once per month. This can be increased dramatically and the entails should change in style to inject more personality, stories, strong offers, tips, interesting news and more. 5. I suggest a meeting of course management and an outside person take place for several hours to consider a Unique Selling Proposition (USP) for Brookshire. (We have a tool to assist with this process and would be happy to facilitate if you so desire.) Golf Course Marketing Systems page 5 of 8 John S. Cohoat 6. I understand that you have just done a first email to the city of Carmel database. Since the city owns this database, it should be studied to see how it could be used to your advantage. This large list could provide a great source of individuals and businesses who should become Brookshire customers. 7. Consider what special offers and fringe benefits can be offered to City of Carmel employees. We understand there may be some restrictions but we believe there must be practical ways to provide a win -win for Brookshire and city employees. 8. We have provided a competitive analysis elsewhere in this report. Management should study this as well as do their own "mystery shopping" and site visits to understand their competition as well as possible. We suggest you target one or two primary competitors and market to their customer bases. The golf industry is fluid and only the strongest will survive, requiring that you beat your competitors to the punch. 9. A separate plan for banquets, foodservice and catering should be developed. As mentioned elsewhere, this may involve contracts or joint ventures with outside caterers who may be interested in expanding their presence at Brookshire. 10. Also, develop a separate plan for golf outings. We believe you could do much more in this area. Strategies could include getting more involved with the Carmel Chamber of' Commerce. Also, scour the Internet for outings held in the area during the past few years and contact the companies, non - profits or organizers. Develop an outing package to present to them, with possible special offers. I I. Immediately start to gather testimonials and use them throughout your marketing. Ask those who are most loyal to write comments. Buy a small video camera and record video testimonials which can be posted on your web site, inserted into emails and posted on YouTube. Get a variety of testimonials from seniors, ladies, parents, juniors, banquets, outings, etc. While you have been working to improve the reputation of Brookshire, social proof is provided by your customers talking about the good things they like about your course, staff and facility. 12. Develop a Facebook Fan Page for Brookshire and a Brookshire YouTube Channel. These are both easy to set up. Then have someone on staff responsible for posting regular content. (We suggest that the video of Brian Ballard's TV spots be posted on the Internet.) Golf Course Marketing Systems page 6 of' 8 John S. Cohoat 13. We have affiliated consultants who can provide a comprehensive Internet marketing strategy for Brookshire. Here are some general comments: a. The web site is adequate and similar to what many golf courses use. b. There should be many more places on the web site for prospects to sign up for your list. You can offer free reports, webinars, DVD's, golf tips or even gifts like a sleeve of golf balls or a golf glove. c. Add testimonials to the site as noted elsewhere. d. Add videos to the site. e. Add captions to the pictures used on the site. f When people sign up, it would be wonderful to have a series of mails that are automatically generated with messages about Brookshire, your facilities, tips, golf technology, events, welcome from the pro, etc. (These are called auto- responders in online marketing language.) Your presence on search engines is adequate and comparable to your competition. However, there are opportunities to enhance your presence by use of videos, articles, podcasts, listing on various sites, etc. Again, this is beyond the scope of this report, but can he provided if so desired. You could dominate all key words by a more aggressive Internet strategy. 14. Continue to work closely with the Carmel Dad's Club and other youth sports organizations. Sec if they are open to Brookshire developing special programs for them and send offers through them to their list. This can help to build your list and increase affinity with these critical groups. 15. We understand that the major group of rabid golfers is the senior group and that the age for senior discount is 55. Many golf courses have chosen to increase the senior age cutoff because of our aging population and longer life expectancy. We recommend considering moving to age 60 in the next few years and eventually even age 62 or 65. If you have concern about those who may object you can grandfather them in and /or raise the age each year by one, so that no one loses a discount. g. 16. Some golf courses have successfully expanded the definition of weekends to include Fridays. This can provide additional revenue by capturing Friday play at weekend rates. This should be evaluated. 17. While some limited advertising has been done, much of what has been attempted is not trackable as to returns on investment. Eliminate non - trackable advertising and either save the money or invest it on some other advertising where returns can be proven. Golf Course Marketing Systems page 7 of S John S. Cohoat Final Thoughts on Marketing Brookshire Golf Club has definitely made strides in the last few years and the City of Carmel has made a significant investment in this community asset. Perhaps the quickest way to begin to address your financial shortfall is to increase your marketing efforts. While piecemeal marketing is the norm in most businesses, including the golf industry, we recommend you consider investing in a comprehensive marketing system /plan with ongoing support and education for management. Golf Course Marketing Systems page 8 of 8 John S. Cohoat Reputation Management JACtua5210fd 4 '.a5 tut' I 5 ''8 ' Page 1 of9 Brookshire Golf Course - Reputation Management Report - 7/15/2011 Report Data: Brookshire Golf Course 12120 Oroaksldu Cannel, IM 16033 - 13111660.03/5- hantnewnrookshiregoll.coro Reputation Management Score: 44 Presence: Good The Reputation Management score for a business combines saturation and depth of directory listings witn overall prominence In combined search results. Scores ore on a scale of 0 -100. Ways to Improve Your Score Priority 1: Priority 2: Priority 3: Priority 4: Priority 5: t Add a business description on Mama 5� Add a business description on Gargle Places Add your listing to Yelp Add your websilo and a business description on Best of the Web Local • Add your listing to Goikink.com What Your Score Means 0.20 Minimal Presence 2140 Fair Presence 41-60 Good Presence 61.80 Excellent Presence 81 -100 MaxImum Presence Businesses with your score tend to have: • Presence In organic (unpaid) search results on major search engines. • basic listings in many local search and online yellow pages sites. • • Some additional information in local search and online yellow pages sites. • Some ratings and raviows• htto: //207.1 14. 187. 115/ PrintRenorts /PrintRenort.asnx ?Id= 125563 &wnid =12557 I &the... 7/19/2011 Reputation Management Brookshire Golf Course • Reputation Management Report - 7/1512011 Report OM. orookshba Gott C aura -12120 Brookshire Carmel, IN 66033 - (3111590 -0315 • trttp :llw•aw.MOOkshlree0li corn Your Presence on Search Engine Sites Chart t Appearance of Yoot Business in Soar cit Engine Results for Your Btu in ass C„deaory and City query This chart highlights key results na rr earchesnengine quer and (Google, Yahoo., Bing!, Ask) Y rory as city. We Identity top-ranking directories in the query and measure the quality of your listing in each directory. The oneysis identifies what potenbal customers ere likely to see when they've hoard of information. We also identity the ranking (if any) of your own websile. Your business information's, 0% immolate on goBink.ann 100% complete on Iocal.Y'nhoo.com 33% complete on manta com 0% complete on yelp.com 100% complete an yellowpages.com 50% complete on molopagus.com 75% complete on yollowbot corn 100% complete on facebook.com 0% complete on yellOwpages aol,com Your business website appears 2nd in search results for major search engines. Page 2ot9 Links to directory sites _ Chart 2: 1.ppnararees of Your Busioesg in Sear:ll El .01 25uui'r•' • ,ir business N nnre nit City This chart highlights key results in a search engine query (Coogle, Yahoo!, Bing!, Ask) for your business name and We identify top-ranking o irli results and measure the quality of in each droctory. The analysis identifies what potential customers are likely to see when they've hoard of your business and are seeking further Information. We also identify tho ranking (if any) of your own websile. Your business information Is: • 0% runplete on gollink.com • 100% complete at tacebuok.corn • 100% complete on yellowpages.lycos.corn • 100% complete on t•egulfcw tuns. net Your business web its openers 1st in search resells for major search engines. httn //2117.1 14. 187.1 15/Print R ennrls /PrintR ennn.asnx ?td= 125563 &.wnid = 125571 &the... 7/19/2011 Reputation Management Page 3 of 9 Brookshire Golf Course - Reputation Management - 7115/2011 Rupert Oars: Brookshire Gait Course .12170 Brookshire Carmel. IN 40053 -13171500-0375 - htrp liwww.mookshlregoa mm Search Engine Results This table shows natural search results at Boogie. Yahoo!, Bing!. and Ask for your business category I city. Your Reputation Management score Is displayed for each site. e The site domain was found using this search engine 0 = The sae domain was not found using this scorch engine seerth Terms .'Carmel. IN". 'Golf Course Site Name Site Details Depth of Information about your business on Rank Googl , Binn/Yehoo this site outgo Ir. 0011 Category Specific I reooc smrecaj eom 2 rryuevrevr cram Probable Business Name 3 Match carmel.homeslo:saie.C. 4 aiumcr00.nome corn 6 0 $L.4:01Iehoo corn Local Search 7 mania com Social Networking 8 c oo.odshcn piS 10 elracka.COnt 11 pl n u crae.cc corn 12 d2zciiy corn Internet Yellow Pages 13 0 ,winlasesclub cum 14 0 aponmenihomrprm,oy =nln Probable Business Name It Match spnngrsllsudescarmel.cocl 19 nMlake50nllrlu0 9iii 20 vgrldg? 'n 21 .•..flat, 22 0 1nai040100 bl COm Probable Business Name 23 March a1 112.cnm Social Networking 25 rle'bne. nz 26 0 0 0 0 0 0 100 33 0 here. -lY117 1 1 4 1 R7 1 1 3/ PrintRennris/ PrintRennrt.nsnx7Id =1255638r.wnid =125571 &the_ . 7/19/2011 Reputation Management Page 4 of 9 Brookshire Golf Course - Reputation Management - 7/1512011 Report Data, nmoksM• GoII Course -12120 ernoksMru Carsick IN 46033 -13171500.0115 - http;uww'u.brwbhireeottcem Search Engine Results This table shows natural search results at Google. Yahoo!, Bing!, and Ask for your business name 4 city. Your Reputation Management solo is displayed for each site. = The sac domain was found using the search engine 0 = The site domain was not found using this search engine SeamN Terms •' Brookshire Golf Course • - Carmal, IN' Site Name Site Details oo.shreadt corn Depth of Information about your business on this Rank GeoAlc DinglYahoo site rgm Category Specific 3 0 Probable Business Name 4 son wn: Match Matching Link 7 0 Probable Business Name g 0 id yYeq COm Match Matching Link Probable Business Name 10 nern, oncuuatvcoit.aom Match Matching Link Probable Business Name 11 mdyp9oltcooe com Match Mai nk _ QQQfl'&L4➢ nwlmrar..com !o y inj crq n1GSe com Probable Business Noma Match Matching Link Probable Business Name Match Malchina Link VOdtetom 19 21 17 15 0 16 17 golf :ion com allow rem uptu +e corn ouStuumelnomes.com reGiew 5011 goncoulsesatr ae com Probable Business Name Match MatchingJ.Nk Probable Business Name Match MatCninlink Probable Business Name Match M Iehl o LI k 22 23 25 29 31 32 Probable Business Name 33 Match 0 0 0 ',ter.. 111111 1 tit 127 115/ Pr inlRenorts /PrinfRennrt.asnx ?Id =125563 &wnid =125571 &the... 7/19/2011 Reputation Management Page 5 of-9 Brookshire Golf Course - Reputation Management Report - 7115/2011 Report Data: aroorshhe Golf Course -12120 Brookshire Gomel, IN 46033 - (3171560 -0375 - http llwww brockehiregon. coo Your Presence On Directory Sites Chart 1: Percent o! Dir: story Weusites Listing YOU, Business This chart shows breadth of covorogo in directory sites organized by site typo, Including Internet Yellow Pages, Local Search, Regional Sites, Social Networking, Category Specific. and Online Dueclories. Your business information appears n. 66% of Internet Yellow Pages 0% of Regional Directory 37% of Social Networking 92% of Directory Assistance 67% of Local Search 10% of Category Specific Ch_.; 2: Depth of Informatics: about You: Rosiness on Directory Sit el This chart shows depth of coverage across all directory silos. 'Basic Listings" contains name, address, and phone number. 'Additional Contact' includes web addresses, toll - free or second phone, email address, and lax number. 'Business Profiles' refers to any desciptiun of products, services, payment methods, and other offerings. 'Ratings 6 Reviews' indicates whether we found reviews or ratings foe the business. Acres all directory sites: • 53% contain Basic Listings for your business • 44% contain Additional Contact Information • 44% Business Profiles • 22% Ratings and Reviews Type of directory silo Type of business Inrormarien httrv/ /7f17 lid 1X7 115 /Printl7LnnrlcfPrintRcnnrt acnc9lA= 175S61 Rrurnitl= 175571Rthe 7 /1Q /7111I Reputation Management Brookshire Golf Course - Reputation Management - 7/15(2011 Report Data Brookshire Gdl Course -12120 nreokshlre Carmel. IN 30023 - 1311)350 -0315 - http]Iwww.Mma %hlreeoll.com Information about Your Business on Each Directory Site Surveyed This table shows how you appear in top-ranked directory sites. = The directory site contains this Information about your business 0 = The directory site does not contain this information about your business 7 = The directory site may contain this information, but results were Inconclusive NA = This type of Information IS NOT available on the directory site Site Type S11n Bnsm Additional Business Ratings Silo Rank Listings Coytad Profiles Reviews _— -- Category 1 0 t3 0 0 C2,L'■mk chin Specific Directory I NA NA ':ihlin a e ?CGnI Assistance VP con, IYP 1 "shoo' Le4al Local Search 1 Regional 2 0 iieiolaeiana, orG mm Directory Social 1 Check facetted, Networking Phone Category 2 MyTekvei ;,con' specific Directory 2 NA NA 4ddresses to_ Assistance Luprrlages skin IYP 2 yxgle Places Local Search 2 Ino �ItyOIkithaeonul secs, Regional Directory 2 Social 2 YSiP Networking Category 3 Specific Directory Assistance NA NA Page 6 of 9 Comments Content front Lncaleze; Featured Listings by YPrnm The New Yellowpages com ilellaMeto Network, Ruviows by CitySeamh © Q 0 Q Paid listings only ThnG adDorrseL LOm -Ii I corn. COL Pages 5v +p �u }i1 a5 r'myj lyseO.$lom Twiner GoldBanboe. corn IA�F ^I Lvcvs Veto" Panes L_ansv.e_I ids ua Fce411 Con) D er, rows seed. f;OLr5V4 Lo:aEdge "eneYtgonti :dernon! CTCie 3 0 0 Check Phone IVP 3 0 Local Search 3 Regional Directory Social Networking Category Specific Directory Assistance IYP Local Search Social Networking Directory Assistance IYP 3 3 4 4 4 4 4 5 5 Local Search 5 Social Networking Directory Assistance IYP 0 0 Check Phone O NA NA 0 NA © O NA 0 NA O O NA 0 NA © 0 NA NA 0 5 © NA NA 6 © NA NA Local Search 6 0 0 0 6 NA Powered by YP,com 0 NA TheClyOf.COM Network 0 NA No method to update listings Business info and reviews aggregator NA Powered by WhltePages rum Submit changes to Ink111SA: 0 featured listings by YellowPages corn Basic listings by Birg: featured listings by VellowPagas,com Midwest Regional Directory. powered by HorroPages NA NA NA NA NA NA NA NA Powered by VP.com Powered by Yellcwbcok.com Premium Listings through Text Update through your Telephone Company 0 No method to update listing NA NA 7 Listings may be claimed, Let not added, for free Reviews aggregator hrtnr //7!17 1 14 1 R7 1 I S /Print P Annri a /PritttRrnnrt acny'llti =175Sfi1&wnidi =17557 I Rn that 7/1 9 /711 1 1 Reputation Management Page 7 of 9 Brookshire Golf Course - Reputation Management • 7/1511011 Report Data'. nrookehlre Gott Course • tabs Brookshire Carmel, IN 46033 • (31 7150041 3 7 5 • hnp:llwww.brooknhlropollcom Reputation Management Score: Ratings of Your Business: A Selection Sites Containing Ratings of Your Business This chart shows sites we have found that have ratings of your business. You can dick on the site links to see the business listings and ratings . 44 Presence'. Good .Site Sim Tvoa Si a Rank Number of Ratings Average Rating Goltt nl, cam Category Specific 1 0 yahoo' Local Local Scorch 1 1 Goggle algces Local Search 2 0 Irty .ejOuSc gOnt Category Specific 2 0 +np Social Networking 2 0 AOL Yellow Ptige3 Internet Yellow Pages 3 0 Barg Busingys Portal Local Search 3 1 Ctyseaice Loch Search 5 2 Q.97Knues Internet Yellow Pages 5 0 13slyer Pants s Social Networking 6 1 merchant Gimle Local Search 6 0 Local. eon, Local Search 7 0 Ldolu Pages Social Networking 7 u na n mg Internet Yellow Pages 7 0 yellowed Internet Yellow Pages 9 0 Kudzu (Oro Internet Yellow Pages 9 0 LocaISeamn co?t Local Search 9 0 OrenL st Local Scorch 13 0 AreaGu:ces net Local Search 14 1 rd.wee2te5 Internet Yellow Pages 16 0 hUn- //7117 114 1527 11 S /Print RPnnrtc /PrintRennrt acnx'IId= I25561&wnid= 175571 &the. 7/10/7011 Reputation Management Page 8 of 9 Brookshire Golf Course - Reputation Management Report - 7115/2011 Report Bate: Brootehire Golf Course. 12120 moot shire Cermet. IN A6033 - 13111500.0315 • late illwww.rOOAShlreeoll.COm Reviews of Your Business: A Selection Shows below is a selection of reviews of your business from popular roview sites. You may browse through all of the reviews or soled a specific review site from the list below. Data Review Rating Source Reviewed — — y p ewum 2005108103 " threes new mamlzlnence by a YP.com User Brookshire Golf Club in Carmel is a mature course that offers ... are • Cnallareinn crass nor roll evrinlamer by Christy f3. PROS: Challenging holes CONS: Poorly maintained nears bewlr.malnte,nefoe by Christy B. Brookshire Golf Club in Carmel is a mature course tint odors a good uunbinatlon... httn //2117 114 1R7 1 I5/PrintRennrlc /PrintRennrl ncnx71(1= 1255fi3Rcwnid=- 125571&.1he. 7/19/2011 Reputation Management Page 9 of 9 Brookshire Golf Course - Reputation Management Report - 7115/2011 Report Oats: Broctthire Golf Course .12120 Brookshire Carmel, IN 46033 - 13171540.0375 • hop I/wwW.rooksl4myoll.com Mentions of Your Business: A Selection In the table below, we display selections from news sites, social networking sites, Wogs, and other sites with tree -form content. These selections are likely to include mentions of your business. Date Published 08 /04/2008 Source indy. blz.Com Reputation Management Score: 44 Presence: Good Mention Rainmakers to Most 41n Annual Plod Pacts Gautier v-Biz by Hosted at Brookshire Golf Course, 12120 Brookshire Parkway in Carmel, Ole day will consist of an 18-hole golf scramble, live music, food end networking opportunities. All proceeds will be donated to the Knotek family.... Tee Walkers, GNI win Dad by iS It Is still a bit surprising that Alex calls his Dad 'Jew the majority of the time! Before heading 03/17/2008 ogslwrcom out to the driving range at Brookshire Gat Course, Jeff made Alex a breakfast of champions. walkorphotos.d P_eeCcre2-Choose 'Scot::r:EL Smoking Co turnet p,/ Qepule : .,. by Brookshire Golf Course '... so many golfers opposed to the ban that Brainard deckled to 07/09/2011 aogspot con reverse the executive order.' Posted by Belinda at 12:19 - Email This BkxgThis! Share to t2csconand Twitter Share to Facebook Share to Google ... 07/28/2008 07/23/2010 indy- blz.com 1 blog.relroduck.com A nointment el New Deeded 01(j_31(011$ tot Brookshire Golf Court by Cannel, IN - David Van Bruoeno has been appointed Director of Golf Operations for Brookshire Golf Course Other full -time staff members at Brookshire Golf. RnbtDu :. cu.n 010g LoCF.nO for Sonmlbin9 w DQCns (Npeyeed7 by Sunday. July 25th, is Hie Annual Rirk's/Riv golf ailing at Brookshire Golf Course. $75 per person 4 people per team, sign up no later then July 11th. Dinner, prizes and awards happen at the RN directly after the Curn.ru Us I noibriftocn !dan4gement Lrr.. IoM 114 1 R7 1 1 S/ PrinlRennris/ PrinlRennrt.ncnv7lr1= 125563Xr.wnid= 125571 Rohe... 7/19/2011 umers^lp Rowena eon Fes rt Fees mg* Fe., Per Golf Revenue a Gait Pavenue Shop i • O a t Hr Goad/ '71 Son Goods ea el P6 Shp 551es d end Bewrepe weds BE Sales - Food 5aas- AlcahIc Beverages 5c14s - fkm./thaohoIC Sew ropes 3Mddes - Food and Baysrato alert Snack Bar Sales January Febnury Mardi Ape Sawsnta Golf Caine (raven Statements For no Month Enddp December 31, 2010 May Juno July August September October Noa rnber December VtD 170.775.00 58500.00 $550.00 51. 740.00 (91,400.00) 32,950.00 56,150.00 $35,825.00 51.725.00 $67.115.00 30.00 12,25000 53,995.33 19681.05 72.482-33 12.864.49 13.031.78 12.737.15 39,350.03 8425.65 186.92 455,597.90 186.92 161,770.11 9,350.70 6725 97 240.08 4,020.00 16,135,00 16,01000 18,16503 14,775.0) 15,050.00 12.737.15 2 .00 2.345,00 43,7500 240.00 4.676.04 7.421.11 7,53640 1,50538 d, 212.15 5,93015 0• 74.77 49.04 6,538.74 ?0m 67664 421.11 930.48 1.500.38 212.15 2.9)0.15 312.74 30.00 29.73105 78,09230 109,543.81 9123276 93,619.08 82339.45 71,504.51 51,087.50 57410.68 2.65317 67904475 11 ]8270 43025 22,828.42 14.02 1577.57 2540.65 3,207.76 3,853.11 3,57.33 4,343.89 4,333.97 2.280.90 1.50 1.002.34 28372.11 1109 577.57 2.84085 J.209]g 3.853.41 3,895.33 4,343.89 4.583.87 2, (1397) 14.02 (13981 100.34 13.08 1,970.64 5,568.69 6,367.76 6,30588 7,063,22 7,51879 7.82747 569641 1.905,68 1.441.59 51.25455 4167 58,02 88961 4,237.96 6,714.12 0,647.02 5779.63 4.153.68 11.57 12963 1292500 5,44583 0,306.00 7,970237 7,890.51 4697.69 18.29 2070 759.66 2,706.02 3,365.34 3,702.55 3951.16 3237.96 71.53 20025 3,50439 12,109.61 15400.46 14320.84 17,021.30 12 419.21 anquet Saes - Banquet Ford Sties • Banquet Almlhllc Beverages Sundaes - Banquet dal Banquet Revenh MI Food and Beverage Revenue a Reveawe ST OF GOODS SOLD o Shop last of Sees of Nara Goods lest al Sales of SofGoods ;vet a Sundries :s, of Goods Sod • Pro Stop 449410 3043.52 651.82 5,08441 5,11012 624,77 2,155.58 1,776.39 60025 (109.12) 13,02428 10,730.33 1970.53 1205,260 36.824 81 48,000,23 0,93 22554.74 (109.12) (204.35) 105,460.58 052 1,670.19 153.00 370.37 1,197.59 008.09 78044 (7.39) 1,118.52 1,870.19 153.00 370.37 1,197,59 808.89 70208 1,15005 20625 537455 1254281 15,770.63 14,51843 15,430.19 13.201,29 1308305 24933 37,08417 90203.80 131,68720 117.057.87 119,11249 103,057.53 4,263.27 209255 1, 546.05 1,522.40 (1.522,10) 14,608.97 (236) 5,705.67 1.17025 1,548,05 14,602 61 18808.93 11,909.58 3.522.58 (204.35) 120,28117 99,241.91 680 5.49 62.83912 369041 850,592,47 W925 1,839.63 2.170,00 1,95719 2.217,52 2221.03 (418. 81 5,43 2.55709 2,720,73 3040.72 981 9.10 491]0 2,059.45 2,2 �. (407.17) 9.16 6d and Beverage toad' Bar Cost or Sales - Feel Con a Salsa - Alwhalc Beverages Cost of Sale,- Non-Almnaf4 Botonmas Coe of SdeWlea • Food and Beverage ;ost of Goods Sold • Snack Bar 2,335.19 3.215,78 68.54 1,58273 1,985 .78 66421 479.70 7,59249 4,051.16 22,857.05 2],210.92 88.0 1,35365 3,898.08 4,157,43 4,41468 4241435 5,251.75 189.42 597 .75 3,750.71 4735,52 3,000.51 341,20 1,170.46 2,308.75 225060 4.625.30 1,69410 742.30 2.73160 1498.60 31.96 734.00 787.69 30oaaet Coal of Sam • Banquet Food 681.74 ' ' A of Jabs- Banquet Ncn.A a. Beverage/ 1 of Se Non-A Soles - Banquet la3wOC Beverages of Sulam - Banquet 147.92 5:0,52 340233 304.23 13.41 78.84 7.97 6,639.74 9,954.72 9,913,10 4,66221 158.49 657.90 5,637,81 3,588.41 1.343 91 11643.65 48,155.81 5,48384 293689 2,518.10 3,117,07 2,70028 2078.31 249870 690.58 1149.40 41.90 8857 2066 27,798T 19,370,52 12.00658 1,76414 5,7080 11)20.43 5,927.86 8,47995 3,015.67 59.49 1-x33.18 3000 449 999 110.15 792 48 28.86 311.65 70.50 11297 16340 59,92801 8,14025 206.81 4,49 794 44 l J as es 1 Cost of Goods Sad - Banquet tal Cost of Goods Said ass PCFS 622.19 0025 312.20 307518 1,073.17 11487 1,10431 70.50 270.37 7,145.99 53003 5,158.18 10,73182 14,412.15 17,402.94 10,42285 17,835.35 11.680.34 11,149.67 1,44407 11,920.02 113229.01 12.48088 (300,70) 31.92809 8547198 117,275.05 99,654.93 108,689.84 05,402.18 86,581.57 58,935,82 81,39505 (8,029.01) 737,352.06 'CRATING EXPENSES slay and Wages 2109235 20,97479 23.542.65 32.77552 40,946.52 47,08540 72.300.82 45,257.91 42,850.03 40.83523 35,631.35 34,152.34 459,444.75 ICA 1.500.97 1,485.05 1,652.00 2,393.64 3,025.85 3,471.85 5,395.51 315208 3,115.20 3,050.83 2,714,90 2,494.54 33,633.28 wets Insurance 4,9411,14 4,948.14 •948.14 4,948.14 4,948.14 4,948.14 7,419.21 4,946.14 4,046.14 4,946.14 4,940.14 7,419.21 64,299.82 3entelInsumna 150 02 186.02 15602 135,02 168.02 156.02 279.03 180.02 189.02 18002 188.02 279.03 2,416.20 `enebn Expense 2,032.40 2,008.70 2,020.19 2,024.90 2,02490 2.02544 3,081.29 2,087.30 2.000.43 2,081.75 2,132.80 3,122.81 26,691.97 Doak* 1,076.13 878.08 1,01195 1,158.02 1,419.63 2,211,76 2,89837 3006 .75 3,595.33 2,52043 1,440.94 1.213.82 22,445.13 Saar end Seat 95.52 90.11 190.70 108,47 50850 222.73 859.65 55152 12880 113.65 100.70 2,948.25 les 910,22 1,04434 454.45 330.99 11274 641.04 177.81 154.97 100,00 153,85 191.13 450,03 4,781.77 1O34D 155.16 155.16 155.16 455.18 155.18 155.18 31032 155,16 155.18 155.18 1,700.76 ;r, - -bne 02537 854,82 538.46 594.57 596.83 478,81 303.40 1,323.34 094.31 66580 547,60 830.57 8,077.74 Telap0orw 90.11 91.63 90.54 92.88 9D.67 99.56 282,78 359,27 129.03 10484 106.14 104.84 164149 )Pens and Maintenance 94482 1,781.78 342.17 1,404.85 774.10 321.43 77.4 1,079.09 62.97 59346 73042 (079.:3) 7.433.90 faun Removal 305.62 11709 49832 65483 423.58 206.26 365.04 754,45 596.29 38506 388,91 28243 4,978.20 Equipment Repairs and Matenenc 1,371.59 1,334.18 707.43 1,117.06 986.07 1399.22 1227.53 1,692.54 2,267.27 3.830.33 55.38 248,53 18,026.81 9mal Tants and Egapmam 1.203.25 44.131 2,327.44 3,575.30 1uel 2.39287 1.90500 1.100.15 1,325.05 1,440.04 2,41890 2,170.55 145578 597.08 14,808.40 f striper 7,655.80 7,320.70 13,488.64 7,08720 15,920.85 7,214.82 52000 05,18581 saa9dde4 3.017,00 405.00 3,422.00 38e. Grades Swples 1,808.23 3,059,03 D653 1,508.29 49.85 1,07925 154.92 7,759.90 (revel 72.00 54,50 5.00 32.50 10.50 7.00 1550 227.00 :met Per Dien 93.40 93.00 90.50 125.50 81.90 4900 31.50 7.00 578.90 316ce Suppllee and Expanse 429.55 35061 204.53 365.59 231,73 420.85 197.17 875.60 180.75 947.50 120.33 (0.10) 4,604.94 Pdmtg 1,534.92 3,140.85 Postage 991 883 19.45 1182 18.99 88'40 Leased Equipment 39000 20,12050 390.00 9,154,18 9,958.52 10,007,87 17,91983 29.863.02 11,444.87 70,755.71 390.00 1,48598 178,881.24 Insurance 9,000.00 9,00000 4dvemsb9 307.00 595.00 387.00 1,088.25 590.00 387.00 100070 387.00 329405 Software Support 42003 500.00 1,900.00 20.00 Odv ProfeadWta) Fees 7137 !673.37 Contacted Services 153.00 53.50 00.00 23300 3,194.00 80.00 153.00 213.50 23300 8080 13150 Undorms 366.65 141,52 38300 28571 900.35 69573 230.61 585.74 357,52 357.52 27689 188.79 !731.03 Llunses and Fees 1,000.00 90.00 133.00 45.00 14000 1,410,00 Dues, Suoselp80ne and Training 00.00 1,05247 1,75900 0.75 79.15 1,757.50 313.50 7900 5,13037 Mums Can] Fens 411,71 9454 533.80 1.378.77 150545 2,161.51 3,828.52 1487 1,064.78 1,030.97 135.13 14,049.05 87 Miscellaneous 175.54 94.99 1,073.00 688 1,45327 Toted Operatig Expanses 40,207.36 63,642.73 44,100.20 71,351.80 89,31320 109,34827 115,79049 120,652.33 86163.11 135.702.14 51,774 65 52,83020 908,142.42 IET INCOME (4055) _ =x((77,746050) a (;022=43) -__ (12,174 11) 14,120.38 w 27,951.77 (9.0914) .�=(B,ID0�85) (35.27045) ____xx:- 398.46 .x:xx(70.020..32) __�_e 9,62040 xs__ (80287.87) __- (2550.779.0 Full Time Jan Feb March April May June July Aug Sep Oct GM /Superintendent $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 $7,200.00 Golf Professional $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 $4,200.00 Admin $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 Asst. Superinten $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 Mechanic $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 Full Time Totals $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 $21,200.00 Part Time Managem Asst. Golf Pro $0.00 $0.00 $1,200.00 $2,000.00 $2,400.00 $2,400.00 $3,600.00 $2,400.00 $2,400.00 $2,400.00 Grounds Foreman $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,900.00 $1,900.00 $3,000.00 $1,900.00 $1,900.00 $1,900.00 Snack /Banquet $300.00 $300.00 $800.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 $1,200.00 Cart Manager $0.00 $0.00 $1,000.00 $1,000.00 $1,800.00 $1,800.00 $2,700.00 $1,800.00 $1,800.00 $1,500.00 Cart Foreman /Main $0.00 $0.00 $1,000.00 $1,000.00 $1,800.00 $1,800.00 $2,700.00 $1,800.00 $1,800.00 $1,500.00 Evening Weekend Cart $0.00 $0.00 $250.00 $600.00 $750.00 $750.00 $750.00 $750.00 $750.00 $600.00 Evening Carts $0.00 $0.00 $1,000.00 $1,000.00 $1,800.00 $1,800.00 $2,700.00 $1,800.00 $1,800.00 $1,500.00 PT Manage Totals $1,800.00 $1,800.00 $6,750.00 $8,300.00 $11,650.00 $11,650.00 $16,650.00 $11,650.00 $11,650.00 $10,600.00 Part Time Grounds Seasonal 1 Seasonal 2 Seasonal 3 Seasonal 4 Summer 1 Summer 2 Summer 3 Summer 4 Part Time Retiree Part Time Gr Totals $0.00 $0.00 $1,000.00 $1,000.00 $1,700.00 $1,700.00 $2,500.00 $1,700.00 $1,700.00 $1,700.00 $0.00 $0.00 $1,000.00 $1,000.00 $1,700.00 $1,700.00 $2,500.00 $1,700.00 $1,700.00 $1,700.00 $0.00 $0.00 $1,000.00 $1,000.00 $1,700.00 $1,700.00 $2,500.00 $1,700.00 $1,700.00 $1,700.00 $0.00 $0.00 $1,000.00 $1,000.00 $1,700.00 $1,700.00 $2,500.00 $1,700.00 $1,700.00 $1,700.00 $0.00 S0.00 $0.00 $0.00 $400.00 $1,500.00 $2,250.00 $1,500.00 $400.00 $0.00 $0.00 50.00 $0.00 $0.00 $400.00 $1,500.00 $2,250.00 $1,500.00 $400.00 $0.00 $0.00 50.00 $0.00 $0.00 $400.00 $1,500.00 $2,250.00 $1,500.00 $400.00 $0.00 $0.00 $0.00 $0.00 $0.00 $400.00 $1,500.00 $2,250.00 51,500.00 $400.00 $0.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $4,800.00 $4,800.00 $9,200.00 $13,600.00 $19,800.00 $13,600.00 $9,200.00 $7,600.00 Part Time Pro Shop Counter 1 $0.00 $0.00 $0.00 $1,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $1,500.00 Nov Dec Totals $7,200.00 $7,200.00 $86,400.00 $4,200.00 $4,200.00 $50,400.00 $3,800.00 $3,800.00 $45,600.00 $3,000.00 $3,000.00 $36,000.00 $3,000.00 $3,000.00 $36,000.00 $21,200.00 $21,200.00 $254,400.00 $1,500.00 $0.00 $20,300.00 51,700.00 $1,200.00 $21,400.00 $600.00 $600.00 $11,000.00 $1,000.00 $0.00 $14,400.00 $1,000.00 $0.00 $14,400.00 $500.00 $0.00 $5,700.00 $1,000.00 $0.00 $14,400.00 $7,300.00 $1,800.00 $0.00 $101,600.00 $1,200.00 $0.00 $14,200.00 $1,200.00 $0.00 $14,200.00 $1,200.00 $0.00 $14,200.00 $1,200.00 $0.00 $14,200.00 $0.00 $0.00 $6,050.00 $0.00 $0.00 $6,050.00 $0.00 $0.00 $6,050.00 $0.00 $0.00 $6,050.00 $800.00 $800.00 $9,600.00 $5,600.00 $800.00 $0.00 $90,600.00 $500.00 $0.00 $13,000.00 Counter 2 $0.00 $0.00 $0.00 $200.00 $200.00 5200.00 $200.00 $200.00 $200.00 $200.00 Counter 3 50.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 Counter 4 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 Counter 5 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 5200.00 Counter 6 $0.00 $0.00 $0.00 $200.00 $200.00 $200.00 5200.00 $200.00 $200.00 $200.00 Counter Totals $0.00 $0.00 $0.00 $2,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $2,500.00 Part Time Carts Cart 1 $0.00 $0.00 $0.00 $600.00 $800.00 _ $800.00 $800.00 $800.00 $800.00 $800.00 Cart 2 $0.00 $0.00 $0.00 $600.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 Cart 3 $0.00 $0.00 $0.00 $400.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 Cart 4 $0.00 $0.00 $0.00 $200.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 Cart 5 $0.00 $0.00 $0.00 $200.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 Cart Totals $0.00 $0.00 $0.00 $2,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 Snack Bar SB1 $120.00 $120.00 $400.00 $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 $600.00 SB2 $120.00 $120.00 $200.00 $500.00 $600.00 $600.00 $600.00 $600.00 $600.00 $500.00 SB3 $120.00 $0.00 $100.00 $400.00 $600.00 $600.00 $600.00 $600.00 $600.00 $500.00 SB4 $0.00 $0.00 $0.00 $200.00 $600.00 $600.00 $600.00 $600.00 $600.00 $400.00 SBS $0.00 $0.00 $0.00 $100.00 $600.00 $600.00 $600.00 $600.00 $600.00 $200.00 Snack Bar Totals $360.00 $240.00 $700.00 $1,800.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $2,200.00 $27,160.00 $24,040.00 $33,450.00 $40,100.00 $52,050.00 $56,450.00 $67,650.00 $56,450.00 $52,050.00 $48,100.00 $0.00 $0.00 $0.00 $0.00 $0.00 $500.00 $400.00 $200.00 $200.00 $200.00 $ 200.00 $1,200.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $400.00 $120.00 $200.00 $120.00 $100.00 5120.00 $0.00 $0.00 $0.00 $0.00 $700.00 $360.00 Total Part Time $36,500.00 $24,160.00 $1,400.00 $1,400.00 $1,400.00 $1,400.00 $1,400.00 $0.00 $20,000.00 $5,800.00 $5,600.00 $5,400.00 $5,200.00 $5,200.00 $27,200.00 $5,360.00 $4,760.00 $4,340.00 $3,600.00 $3,300.00 $21,360.00 $260,760.00 $515,160.00 115 hours per week 8 per hour Exhibit E Asset No. Date C005309 \4121/2004 F000038 1111/1997 C008724 1/1/1992 BGC0059 7/17/2007 BGC0060 7/17/2007 BGC0061 7/17/2007 C005276 7/17/2007 BGC0018 7/17/2007 BGC0013 7/17/2007 6800014 7/17/2007 BGC0064 7/17/2007 BGC0065 7/17/2007 C005289 7/17/2007 C009538 7/1/2003 C005299 7/17/2007 C008637 1/1/1992 C006638 1/1/1992 C008725 1/1/1992 C008726 1/1/1992 C005303 7/17/2007 C005302 7/17/2007 C00P722 10/23/2007 001 .3 10/23/2007 C009724 10/23/2007 C009725 10/23/2007 C009726 10/23/2007 C005270 7/17/2007 C005275 7/17/2007 C005295 7/17/2007 C005298 7/17/2007 C005281 7/17/2007 C009523 12/9/2002 8800015 7/17/2007 8800056 7/17/2007 8800057 7/17/2007 BGC0058 7/17/2007 C005274 7/17/2007 BGC0016 7/17/2007 BGC0000S 7/17/2007 BGC0037 7/17/2007 BGC0038 7/17/2007 BGC0039 7/17/2007 BGC0040 7/17/2007 8800041 7/17/2007 BGC0043 7/17/2007 6Gr -0044 7/17/2007 BC 145 7/17/2007 BGC0046 7/17/2007 BGC0047 7/17/2007 BGC0050 7/17/2007 8800051 7/17/2007 Brookshire Inventory Description Serial Number 0033044754 PB9642041889 FROM CT TO GOLF 251216108 NO SNO FOUND 251216072 STORAGE SHED COMPUTER DESKTOP BATTERY BACK UP TABLE ROUND WEED EATERS WEED EATERS WEED EATERS BOOKCASE 4 SHELVES TABLES 4 TOP (4) BAR STENO WARMERS /STEAM (3) 8' SERVING TABLES (2) BLOWER BLOWER 20" IV MONITOR FLAT FILE VERTICAL 4 DR CHAIR FABRIC BURGUNDY CHAIR FABRIC BURGUNDY CHAIR FABRIC BURGUNDY CHAIR FABRIC BURGUNDY BOOKCASE 7 SHELVES CABINET METAL FILE CABINET 4 DRAWER FILE CABINET 4 DRAWER FILE CABINET 4 DRAWER FILE CABINET 4 DRAWER FILE CABINET 4 DRAWER CHAIR EXECUTIVE BLACK FILE LATERAL 4 DRAWER CHAIR EXECUTIVE BLACK FILE LATERAL 4 DR COFFEE MAKER 2 BURNER PRINTER OUTDOOR GREEN GLASS TABLES (3) 8L20100850 2627510 BAR MUL5016E0075956 KEN FROM CT TO GOLF FROM CT TO GOLF FROM CT TO GOLF FROM CT TO GOLF STORAGE OFF PR STORAGE OFF PR KEN KEN DAVE KEN KITCHEN SCNDO125476 MOWER PUSH 21" CUT MOWER PUSH 21" CUT MOWER PUSH 21" CUT CREDENZA SMALL BLACK OUTDOOR WOVEN CHAIRS GREEN(18) DISHWASHER/SINK SPRAY JET FAIRWAY MOWERS CUTTING UNIT FAIRWAY MOWERS CUTING UNIT FAIRWAY MOWERS CUTTING UNIT FAIRWAY MOWERS CUTTING UNI FAIRWAY MOWERS CUTTING UNIT FAIRWAY MOWER CUTTING UNITS FAIRWAY MOWER CUTTING UNITS FAIRWAY MOWER CUTTING UNITS FAIRWAY MOWER CUTTING UNITS FAIRWAY MOWER CUTTING UNITS MOWER TRIMMER CUTTING UNIT MOWER TRIMMER CUTTING UNIT knnwco - roinnhACG rIl ITTnNr, I MIT GXJS60H122821 GXI4SZA025611 GX1S63V 147633 KEN M 0022M B 061383 M0022M8061414 M 0022M B061397 M0022MB061385 M0022MB061413 M0022MB061384 M0022MB061386 M 0022 M B 061396 M0022MB061387 M0022M B 061398 M0026AX120820 M0026AX120813 M0026AX120832 Category COMPUTER COMPUTER FURN FIX OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV COMPUTER OLDINV FURN FIX FURN FIX FURN FIX FURN FIX • OLDINV • OLDINV FURN FIX FURN FIX FURN FIX FURN FIX FURN FIX OLDINV OLDINV OLDINV OLDINV OLDINV COMPUTER OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV Cost 0.00 195.00 200.00 200.00 200.00 200.00 240.00 250.00 300.00 300.00 300.00 300.00 335.00 350.00 380.00 400.00 400.00 400.00 400.00 400.00 431.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 500.00 525.00 559.00 600.00 600.00 600.00 600.00 700.00 720.00 767.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 800.00 BGC0046 7/17/2007 BCC0047 7/17/2007 BGC0050 7/17/2007 BGC0051 7/17/2007 BGC0052 7/17/2007 C005278 7/17/2007 BC 81 7/17/2007 BGC0082 7/17/2007 BGC0083 7/17/2007 BGC0084 7/17/2007 BGC0085 7/17/2007 C005277 7/17/2007 C005268 7/17/2007 C005269 7/17/2007 C005297 7/17/2007 C008703 1/1/1994 BGC0000 7/17/2007 C005301 7/17/2007 C005287 7/17/2007 BGC0000 7/17/2007 BGC0019 7/17/2007 BGC0025 7/17/2007 BGC0026 7/17/2007 BGC0027 7/17/2007 C005292 7/17/2007 C005293 7/17/2007 C005294 7/17/2007 C005296 7/17/2007 C005085 12/1/2005 C005048 4/1/2006 CC ?2 7/17/2007 C005300 7/17/2007 C005304 7/17/2007 C009534 5/27/2003 F008027 1/1/2008 BGC054 7/17/2007 C005286 7/17/2007 BGC0062 7/17/2007 BGC0063 7/17/2007 BGC0071 7/17/2007 BGC0029 7/17/2007 BGC0030 7/17/2007 BGC0031 7/17/2007 BGC0033 7/17/2007 BGC0034 7/17/2007 BGC0035 7/17/2007 BGC0011 7/17/2007 BGC0075 7/17/2007 BGC0066 7/17/2007 BGC0073 7/17/2007 BGC0076 7/17/2007 BGC0077 7/17/2007 BGC0078 7/17/2007 BGC0079 7/17/2007 B( )80 7/17/2007 C006285 7/17/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 R(:CARTO 17/1/7007 FAIRWAY MOWER CUTTING UNITS FAIRWAY MOWER CUTTING UNITS MOWER TRIMMER CUTTING UNIT MOWER TRIMMER CUTTING UNIT MOWER TRIMMER CUTTING UNIT PRINTER ALL IN ONE TRAILER TRAILER TRAILER TRAILER TRAILER CREDENZA PUTTY DESK BLACK METAL DESK BLACK METAL DESK METAL PUTTY FILE 4 DRAWER LATERAL 4 TABLES (4TOP) SNACK BAR SAFE SENTRY KEN PREP STATION 48" W /CLEAVER KITCHEN 16 UPHOL ARM CHAIRS SNACK BAR CHAIRS (16) BAR GREEN MOWERS EXTRA CUTTING GREEN MOWERS EXTRA CUTTING GREEN MOWERS EXTRA CUTTING COMPUTER DELL CASH REGISTE COMPUTER DELL CASH REGISTE COMPUTER DELL CASH REGISTE DESK WOOD COMPUTERS LAPTOP COMPUTER- DESKTOP COMPUTER DESKTOP COMPUTER DELL 2350 COMPUTER DELL 2350 COMPUTER COMPUTER DESKTOP MOWER WALK BEHIND 36" PREP STATION W /SINK AIR SWEEPER AIR SWEEPER LARGE ROLLER GREEN MOWERS CUTTING UNITS GREEN MOWERS CUTTING UNITS GREEN MOWERS CUTTING UNITS GREEN MOWERS CUTTING UNIT GREEN MOWERS CUTTING UNIT GREEN MOWERS CUTTING UNIT 10 8 TOP TABLES MOWER GANG GRADER EZGO WORK HORSE WALKING GREENS MOWERS WALKING GREENS MOWERS WALKING GREENS MOWERS WALKING GREENS MOWERS WALKING GREENS MOWERS SLICER 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CI I IR CART M0022MB061387 M0022MB061398 M0026AX120820 M0026AX120813 M0026AX120832 KEN 042382700001375 042382700001374 042382700001376 042382700001378 042382700001379 MELISSA KEN KEN MELISSA M0022GB070419 M0022GB070423 M0022GB070568 KITCHEN /SNACK PRO SHOP PRO SHOP KEN 0035843274 0036503689 DAVE KEN KEN 30224054 37258173 343493253118 KITCHEN NO VISIBLE # 80219 # NO VISIBLE #'S M0022GB070571 M0022GB070418 M0022GB070570 M0022M 13010100 M0022MB010122 CANT READ OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV FURN FIX OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV B • OLDINV OLDINV OLDINV OLDINV COMPUTER COMPUTER OLDINV OLDINV OLDINV COMPUTER COMPUTER OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV OLDINV MACHEQ MACHEQ MACHEQ MACHEQ 06271068 W DB B 1060X200932 1312037 04021230000691 04021230000698 04021230000697 04021230000700 04021230000112 KITCHEN P00806972207 PQ0806972208 PQ0806972209 POna0RP72710 800.00 800.00 800.00 800.00 800.00 800.00 850.00 850.00 850.00 850.00 850.00 860.00 900.00 900.00 900.00 1000.00 1000.00 1000.00 1049.00 1200.00 1200.00 1500.00 1500.00 1500.00 1500.00 1500.00 1500.00 1500.00 1530.00 1575.00 1700.00 1700.00 1700.00 1757.00 1800.00 1800.00 1894.00 2000.00 2000.00 2000.00 2200.00 2200.00 2200.00 2200.00 2200.00 2200.00 2748.00 2750.00 3000.00 3000.00 3000.00 3000.00 3000.00 3000.00 3000.00 3117.00 3200.00 3200.00 3200.00 3200 00 IJVVVVIJ II IIIGVVI BGC0080. 7/17/2007 C005285 7/17/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO C 12/1/2007 BC ZTO112/1/2007 BG... ,12T0 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/112007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1 /2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BE RTO 12/1/2007 BGL..,RTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1 /2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTI 12/1/2007 BGCARTS 12/1/2007 BGCARTO 12/1/2007 BGCARTO. 12/1/2007 BGCARTO 12/1/2007 BGCARTO' 12/1/2007 BGCARTO 12/1/2007 BC RTO 12/1/2007 BG.,,,RTO ' 12/1/2007 BGCARTO' 12/1/2007 BGCARTO 12/1/2007 BGCARTO ' 12/1/2007 BGCARTO ' 12/1/2007 V V/'1LI \IIVV VI \LLIVJ IVIVVVLI•J WALKING GREENS MOWERS SLICER 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART VYVL ILJVVVVI VV 04021230000112 KITCHEN P00806972207 P00806972208 P00806972209 P00806972210 P00806972211 P00806972212 P00806972214 PQ0806972216 P00806972218 P00806972219 P00806972222 P00806972224 P00806972226 P00806972228 P00806972229 P00806972230 P00806972233 P00806972237 P00806972239 P00806972241 P00806972243 P00806972245 P00806972247 P00806972249 P00806972250 P00806972252 P00806972254 P00806972256 P00806871199 P00805871201 P00805871203 P00805871326 P00805871330 P00805871384 P00805872007 PQ0805872009 P00805872011 P00805872013 PQ0805872015 P00805872017 P00805872019 PQ0805872020 P00805872022 P00805872023 P00805872025 P00805872027 P00805872029 P00805872031 P00805872032 P00805872035 P00805872036 P00805872040 P00805872043 P00805872045 PQ0805872047 P00805872050 P00805872051 VLVIIVV •VVV.VV OLDINV 3000.00 OLDINV 3117.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 MACHEQ 3200.00 BGCARTO 12/1/2007 BGCARTO,12 /1 /2007 BGCARTO, 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO, 12/1/2007 BC 270.12/1/2007 BGCARTO! 12/1/2007 BGCARTOE 12/1/2007 BGCARTO 12/1/2007 BGCARTO E 12/1/2007 13 GCARTOE 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO E 12/1/2007 BGCARTO E 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BGCARTO' 12/1/2007 BGCARTO' 12/1/2007 BGCARTO' 12/1/2007 BGCARTO' 12/1/2007 BGCARTO 12/1/2007 BGCARTO' 12/1/2007 BGCARTO E 12/1/2007 BGCARTO 12/1/2007 BGCARTO 12/1/2007 BC )001 7/17/2007 C008701 1/1/1994 BGCARTO 12/1/2007 BGCCART 12/1/2007 BGC0022 7/17/2007 BGC0023 7/17/2007 BGC0024 7/17/2007 BGC0068 7/17/2007 PROPCRC 11/21/2006 BGC00005 7/17/2007 BGCARTO 12/1/2007 BGC0048 7/17/2007 BGC0074 7/17/2007 BGC0012 7/17/2007 BGC0067 7/17/2007 BGC0072 7/17/2007 C005283 7/17/2007 BGC0070 7/17/2007 BGC0028 7/17/2007 BGC0032 7/17/2007 BGC00008 7/17/2007 BGC0069 7/17/2007 BGC0049 7/17/2007 Brn036 7/17/2007 B'. 342 7/17/2007 BGC0086 7/17/2007 BGC0053 7/17/2007 VEHFR000 12/30/2000 BGC0054 7/17/2007 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART 2008 CLUB CART PHONE SYSTEM 6 PHONES FILE 4 DRAWER LATERAL 2008CLUB CAR TURF 2008CLUB CAR TURF WALKING GREENS MOWERS WALKING GREENS MOWERS WALKING GREEN MOWERS AERATOR BROOKSHIRE GOLF LEGAL FEES FRYER COMMERCIAL 2 COMPARTMT 2008 CLUB CAR TURF 2 SAND BUNKER RAKE WORKMAN 80 CHAIRS BANQUET VINYL TRAILER UTILITY GATOR REFRIGATED UNIT DRINKS AERATOR GREEN MOWERS GREEN MOWERS FREEZER 2 DOOR SPRAYER MOWER TRIMMER FAIRWAY MOWERS FAIRWAY MOWER TOPDRESSER TRACTOR 2000 SILVERADO LS TRUCK UT1LI TRACTOR P00805872040 MACHEQ 3200.00 PQ0805872043 MACHEQ 3200.00 P00805872045 MACHEQ 3200.00 P00805872047 MACHEQ 3200.00 P00805872050 MACHEQ 3200.00 P00805872051 MACHEQ 3200.00 P00805872053 MACHEQ 3200.00 PQ0805872055 MACHEQ 3200.00 P00805872057 MACHEQ 3200.00 P00805872059 MACHEQ 3200.00 P00805872061 MACHEQ 3200.00 PQ0805872062 MACHEQ 3200.00 PQ0805872064 MACHEQ 3200.00 P00805872067 MACHEQ 3200.00 PQ0805872069 MACHEQ 3200.00 P00805872070 MACHEQ 3200.00 PQ0805872073 MACHEQ 3200.00 P00805872074 MACHEQ 3200.00 P00805872076 MACHEQ 3200.00 PC10805872078 MACHEQ 3200.00 P00805872080 MACHEQ 3200.00 P00805872081 MACHEQ 3200.00 P00806872085 MACHEQ 3200.00 P00806872086 MACHEQ 3200.00 P00806872087 MACHEQ 3200.00 P00806872088 MACHEQ 3200.00 P00806872090 MACHEQ 3200.00 PQ0806872091 MACHEQ 3200.00 P00806872092 MACHEQ 3200.00 P00806872094 MACHEQ 3200.00 OLDINV 3351.00 FURN FIX 3500.00 HG0806871323 MACHEQ 3500.00 HG0806871322 MACHEQ 3500.00 M00220A021150 OLDINV 3500.00 M00220A030894 OLDINV 3500.00 M00220A030890 OLDINV 3500.00 NO VISIBLE #'S OLDINV 3500.00 GOLF 3640.00 OLDINV 3794.00 RG0806871321 MACHEQ 4000.00 TC1200H010187 OLDINV 5500.00 0720270160 OLDINV 5500.00 OLDINV 6020.00 OLDINV 6500.00 WOTURFD001326 OLDINV 6500.00 KITCHEN OLDINV 6974.00 521854 OLDINV 7700.00 TC250AG03003 OLDINV 9000.00 TC250AG030033 OLDINV 9000.00 OLDINV 9139.00 260000270 OLDINV 9700.00 TC2653D131268 OLDINV 11000.00 TC32250020204 OLDINV 16000.00 TC3225CO20218 OLDINV 16000.00 100214 OLDINV 23000.00 LV4400H240578 OLDINV 28000.00 1GCO29U2YE280432VEHICLE 28991.00 LV4600P362118 OLDINV 30000.00 BGG0042- BGC0086 BGC0053 VEHFR00C 8GC0054 7/17/2007 7/17/2007 7/17/2007 12/30/2000 7/17/2007 I /-01 \v VIl I PINY •I-I %V FAIRWAY MOWER TOPDRESSER TRACTOR 2000 SILVERADO LS TRUCK UTILI TRACTOR TC3225CO20218 100214 LV4400H240578 1GCG29U2YE280432 LV4600P362118 OLDINV OLDINV OLDINV VEHICLE OLDINV 16000.00 23000.00 28000.00 28991.00 30000.00 c ^.t i s /uf2olo D:po rt -13ustlfiodons Brookshire Golf Course for 2011 Budget LINE NI.114BER NAME AMOUNT DESCRIPTIO ��Salaries • nd - . 100 laRLLThne Sa W . S 257 000.00 Deceased 110 Part-TSre Sala S 253 t 0.00 23 000.00 IIIII S Increased Increased Due to decease k fun time budget $10000 due to actual previous s numbers. a 5 Total Salads and Wages 535 500.00 5200 Deferred . .. %Jen $ 4 500.00 increased due to brevity. 210 - s Shared Soda! Share of Heath Insurance NM NM S 33.22500 ahaht decease — 89 300.00 Decreased duo to tuner of full to O+mbrea. 220 Em... s 221 ... s Stare of...n Insurance 1.060.00 5 SI. t decease. 222 %Moyers Stae of life l aurance MI 450.00 5 ktv No ease 730E sShare dPEPF due Decreased due to nunbadfull tlmo �.- rt greased Inaease MI D' Total Personal Services S 700 10.00 5 — at C301 MOM Sucplies !4�` 301 SlaVawry & Printed Material $ 500.00 Office SiWiks S 4000.00 302 0311 Op Supplies Bottles Gas Bold S 300.00 51 t increase he Gas grill._ _ Gas of Diesel and Gas a� 313 Goad Fuel -319 Case 9 000.00 Deaeasei due to serelatfon Malntasance Supplies 350 Gravels Materials �-�" 10 000.00 1 500.00 5 000.00 1000.00 f 9500.00 5ImeaSel 5Increase based on past reeds, lead for Gdlolrq and pnd[L_r�alrs and malnteiurKe. for Gat path state and drat le. 360 Sandi Increased based on past reeds, real for punkas and topdre sn o sand for greet. 364 Panel based cn pest needs, tree for edebr paints. �� r370 -381 M389 III Ma ila 3rrt Paint bared anan past reeds, used interior are tsdtltO Nhdten parts. • -. Y Pans Inutesai based on .. ro.dc. � fpr a+d 380 Small Tools and Minor Eoul. - t Water Matltetarca Su .• Ike Otter Maintenance Supoles 5 $ 5 000.00 1500.00 $ 2 000.00 5 - IS and - — -• Increased used for Irrbatke repairs. maintenance shed lnaeased used fa and maintenance - .. las fa' chMlouse era . IS c ^.t hetlfkatlorn for 2011 Budget I • • -2 NUMBER/NAME AMOUNT DESCRIPTION OF CHANGE Miscellaneous Soppily; 3 Other ousreneous 0c 390 Other Mtsslhnfaus Su ld pps j 1 39012 Safety • • S 750.00 I Increased based on past needs, used for safety equipment and first aid for empkyees. I 39040 Food and Beverage S 75,000.00 f - I Ilncreased based on need and past performance. 39045 Retail Goods 39099 Other Mbsellaneous f 5 000.00 No Increase. Total Supplies $ 1350.00 I 431,2T11ER &VICES AND f N' ARCd Professional Bennett, 2 000.00 400 legal Fees AIIIIMMep No inosase. 41903 Software Support Fees $ 1.500.00 Maimed used for P05 software support 41999 Other Professional 3 000.00 I Increased, for consulting fees. ME $ I used I Corn Ion a Transportation I Postage 421 stage $ 500.00 I 1 No Increase. Used for mailings, egress mail fees. 940 THephare Lire S 12 000.00 Increase based on oast usage. 442 Cellular Pine I 2 750.00 i Deceased based on past, usage. Used Mr phorres. 442 ,erne line Charges $ 750.00 $ fees. Decreased, used for pasture: fees. 43001 Tmvel 001 Tray S 6 000.00 past usage. Used fa natal mnferenres for Pre and Superintendent once a year. In eas based e. Used for 43002 External Training and Travel 1 000.00 Decreased, Decreased, used for bml tralnkiq_CNSSes. for 43004 Trove Per Diems $ 500.0 I $ No Increase. 43005 Chamber Luncheon 50.00 0 I increase. Used for network! • at Chamber of Commerce luncheon. Printing and Aavertlsly: i 45001 internal Materials $ 9000.00 Decrease. Used for scorecards and flyers . 460 Classified Ms 5 500.00 I Increase. Used for bid notifications and OQopenlngs. I Insurance: I 970 Workers CanEensatlon $ 2 000.00 No Incease. Used for waiters canomsaton benefits. on General Insurance S 9 (1(0.00 MI No Increase. Used for insurance through Adminetrat10n. general Utilities: 980 Electric t, 5 20000.001 S 3 000.00 No Increase No Increase. 485 Water and Sewer 490 Gas 8 000.00 Decreased 495 Cable S S 1 500.00 I . Increased due to rate change. Used In ter and po strop. I Repairs and Maintenance L S 25 000.00 I 91000.00 I 500 Equipment Repays & Maintenance 504 Grounds Maetenance Decreased for repairing golf course equipment and cart flat. Increase. fertillzatkon for -. f No Golf coursA and patttants seed and supplies the • - • • 1 1 ' I 3usdDaatbns for 2011 Budget Page 3 LINE NUMBER /NAME AMOUNT I DESCRIPTION OF CHANGE Rentals and Leases: 9999 Other l ls and Leases $ 300 000.00 inoeased due to l •.tbn and pum• slatbn. Also for cart and .• ul • - t leases Other Senlaes and_Shpes 553 5 •anlmdon & Membersnp Dues $ 4, 000.00 4 1 500.00 Increased based on usage. Local and natkrlal dues for arr� mrase. 583 Other Fees and Licenses pest pro(eslonah 9of Decreased. Alcotsi horsing for snack bar personnell. Fulls for cash - • Isters and reimbursements. 595 Pe Cash 1 000.00 nil 56001 IINfOrrtls S 2 000.00 No Increase. Used for appmplate appearance by at employees. Gite�SSoft is 15 000 based m past user Golf retail item such as cbthm•. ��ff5600�6 at _ based on f retell hems such as cktn and balls. ;Thad Other Services and Charges $ 582,100.00 ITotal increased due to leases for I akin and pump station. u :moot __ ,- 630 Furniture & Fixtures S 5 000.00 Increase. Used for kitchen and snack bar egulpmen. 635 Grounds Maintenance Egubnert $ 2,500.00 In tease. Used for mince equipment for goats. ._4- 632 Computer . u¢xrant 01 Hardware - No increase. 02 Software $ 2 000.00 No increase. For compute updates and so0ware updatos mmugh PO5 povlder. Total Equipment $ 9,500.00 __ Total Budge: $ 1,426,160.00 1 Increase due to irrigation and pump station, otherwise decreased. MN III I $45 [ $55 L $45/$55 L $10 I $3,600 I $2,250 2011 Competitive Analysis $/$ = $ week /$ weekend Golf Membership Weekday Weekend Twilight Senior Cart Range Annual Rates Rates Rates Rates Rates Fees Plans Membership Rate w /cart(Indv.) Bear Slide Brookshire Fox Prairie Golf Club of Indiana Gray Eagle Ironwood Pebble Brook Plum Creek Prairie View River Glen Stony Creek The Fort Wood Wind $38 $26 $42 $35 $35 $29 $59 $90 $32 $22 $59 $34 $47 $32 $48 $45 $48 $39 $69 $90 $42 $31 $69 $42 $21/$31 $35/$40 $20 I $39 N/A $35 $29 $55 N/A $17/$19 $49 $24/$32 $2.9 Deduct $5 N/A $30 N/A $20/$35 $27 N/A $40 N/A N/A $39 $29 Information Source: Course Websites and Direct Phone Calls $17 $0 /Inc. $15 $0 /Inc. $0 /Inc. $10 $0 /Inc. $0 /Inc. $10 $8 -$14 $0 /Inc. $15/$17 N/A $400 N/A $350 L N/A N/A 1—$300 $700 N/A Inc. $410 I N/A $64/10bag $350 $2,150 $2,198 $2,000 $1295+Cart $1295 +Cart $2,095 $3,000 $3,950 $2,000 N/A $1,870 SERVICES WE CAN PROVIDE You WITH PA System Projector Table Skirting Bartenders Beverage Packages Custom Linens Dish Ware Gla ssWare Flat ware Chafing Dishes SERVICES WE CAN ASSIST YOU WITH DJ's Catering Florist Cakes Room Layout Limo Service Brookshire Golf Course 12120 Brookshire Parkway Carmel, IN 46033 Phone: 317.846.7431 Direct: 317.4173070 — Email: degger$ crrmel.in.g w BANQU. f PRICE LIST oaE ``‘44 4 cc S n r C w Brooks hire Golf Course 12120 Brookshire Parkway Carmel, IN 46033 Tel. 317.846.7431