The Cascades Swim Club has 300 shareholders, each holding one share of stock in the club. A share of club stock allows the shareholder’s family to use the club’s heated outdoor pool during the summer upon payment of annual membership dues of $175.00.

The club has not issued any stock in many years, and only a few of the existing shares come up for sale each year. The board of directors administers the sale of all stock. When a shareholder wants to sell, they turn the stock into the board, which sells it to the names at the top of the waiting list. For the past few years, the length of the waiting list has remained relatively steady at approximately 20 names.

However, during the past winter two events occurred that have suddenly increased the demand for shares in the club.

• The winter was especially severe, and sub-zero weather and heavy ice storms caused both the town and regional pools to buckle and crack. The problems were not discovered until maintenance crews began to prepare the pools for summer, and repairs cannot be completed until the fall.
• Also during the winter, the manager of the local country club had an argument with her board of directors and one night burned down the clubhouse. Although the pool itself was not damaged, the dressing room facilities, showers and snack bar were destroyed.

As a result of these two events, the Cascades Swim Club was inundated with applications to purchase shares. The waiting list suddenly grew to 250 people as the summer approached.

The board of directors of the Cascades Swim Club had refrained from issuing new shares in the past because there was never a very great demand, and the demand that did exist was usually absorbed within a year by stock turnover. In addition, the board had real concern about overcrowding. It seemed like the present membership of 300 shareholders was about right, and there were very few complaints about overcrowding except on holidays like Victoria Day (May) and Canada Day (July).

However, at a recent board meeting a number of new applicants had attended and asked the board to issue new shares. In addition, a number of current shareholders suggested that this might be an opportunity to improve some of the existing facilities. This was tempting to the board. Although it had set the share price at $500.00 in the past, the board could set it at a much higher level now. In addition, an increase in attendance could create a need for more lifeguards.

Before the board of directors make a decision on whether to sell more shares and, if so, how many, the board members felt they needed more information. Specifically they would like a forecast of the average number of people (family members, guests, etc.) who might attend the pool each day during the summer with the current number of shares.

The board of directors has the following daily attendance records for June through August from the previous summer, it thinks the figures would provide accurate estimates for the upcoming summer. (See chart on next page).

Assignment:

Develop a forecasting model to forecast daily demand during the upcoming summer

Answer rating: 100% (QA)

June July August Day Monday 139 Tuesday 273 Wednesday 172 315 Thursday 275 258 Friday 337 193 Saturd... View the full answer