ABC Club offers tennis courts and other sporting facilities to its members. The club has 2,000 members. Revenue is derived from annual membership fees and hourly court fees. The annual membership fees are:

• Individual $90

• Student 60

• Family 200

Approximately half the members are “family,” and the remaining memberships are split equally between individuals and students. For the next two financial years, the hourly court fees are $20 and $30 depending on the season and time of days (prime versus non-prime time). The club has ten courts, and these courts are available for 12 hours per day, from 9 am to 9 pm. The peak tennis season runs from January to July (181 days). During this period, court usage averages from 90% to 100% of capacity during prime time 5 pm to 9 pm) and from 50% to 60%powercity during the remaining hours (9 am to 4 pm). Daily court usage during the off-peak season averages from 20%to 40% of power and is charged at $12 per hour. All ABC Club memberships expire at the end of December. A substantial amount of the cash receipts was collected during the early part of the tennis season due to the renewal of annual membership fees and heavy court usage. However, cash receipts are not as large in the off-peak months. For the start of the new financial year on 1 January 2023, ABC Club is considering introducing a new membership and fee structure in an attempt to improve its cash flow planning. Under the new membership plan, only an annual membership fee would be charged, rather than a membership fee plus hourly court fees. There would be two classes of membership, with annual fees as follows:

• Individual $ 630

• Family 1,050

The yearly cost would be collected in advance at the time the membership application was completed. Members would be allowed to use the tennis courts as often as they wished during the year under the new plan. All future membership would be sold under these new terms. A special promotional campaign would be instituted to attract new members and encourage current members to remain with the club. The annual fees for individual and family members would be reduced to $500 and $900 respectively if members pay for their yearly memberships in advance during the two-month promotional campaign. ABC Club’s management estimates that 70% of the current members will continue with the club, and student members would convert to individual membership. The most active members (45% of the current members would pay the annual fee in advance and receive a special fee reduction. In contrast, the remaining members who continued would renew their membership in January. Those members who would not re-join are not considered active (that is, they playfive5 times or less during the year). Management estimates that the loss of members would be fully replaced by new members sixth in 6 instituting the new plan. These new members would pay a proportional annual fee on joining. Furthermore, many of the new members would be individuals who would play during non-prime time. Management estimates that adequate court time will be available for all members under the new plan. If the new membership plan is adopted, it would be instituted at the start of the new financial year (1 January 2023), which is the start of the tennis season. The special promotional campaign would be conducted during November and December, prior to the start of the new financial year.

Required: 

You have been engaged to help ABC Club to evaluate its new fee structure. Write a report to the President of ABC Club dealing with the following issues: (a) Prepare the revenue budget under the existing scheme. 

(b) Prepare the revenue budget under the new scheme. 

(c) Compare and contrast the two sets of budgets you have prepared in answer to requirements (a) and (b). Advise ABC Club’s management on the relative merits of the two alternative plans/strategies including how the cash management practices may differ. 

Advise which plan/strategy should be adopted and why.