Barry Cheney, the golf course manager at the Red Bluff Golf Course & Pro Shop
Barry Cheney, the golf course manager at the Red Bluff Golf Course & Pro Shop, has been considering expanding the clubhouse to accommodate a steady increase in business. This expansion could include more space for the pro shop and more guest accommodations. Barry will need to provide a detailed analysis of past sales along with sales forecasts to assure William Mattingly, the resort’s CEO, that the money spent on the improvements and expansion will have positive financial benefits for Red Bluff. To increase management’s understanding of the current capacities, Barry has collected data about traffic, sales, and product mix. He has asked you to analyze this data using Excel’s What-If Analysis tools.
Leave a Reply