budget expenses:

Lease payments $300,000

Depreciation $25,000

Salaries $160,000

Other fixed operating expenses $50,000

Variable operating expenses 1% of revenue

Variable marketng expenses 1% of revenue

calculate sales revenue and operatng profit and budget for Oct 2023 to Sep 2024?

note

1- (For Optimistic scenario Pessimistic scenario .

Number of new member enrolments each month from October 2023 to March 2024 that mean people who enrol in October for example family will pay full amount (2400) because thay enroll for full year and people who enrol in November will pay less because he is not bay full amount he pay for what they pay is (2400/12montha)=200 what they pay is 2400-200=2200 , for December it will be 2200-200=2000 and so on

And so one for all student , individual , family Optimistic scenario Pessimistic scenario.

So we need to calculate for 6 months each )

2-The club had 2,000 members in 2022to 2023

only 70% of 2000 member for next year for Optimistic scenario and it separated (35% discount -35% no discount ) and 40% of 2000 member Pessimistic scenario for next year 2023 to 2024 it separated (20% discount -20%no discount ) (this note you can find it in the qustion )

3- membership fees was offered during the promotional campaign as follows: Individual membership: $1,000 , student 1000and family membership: $2,000.

4- i submit the case and my answer (excel sheet )could you please Cheick if it right .

during the year under the new plan. All future memberships would be sold under these new terms. A special promotional campaign is planned during September 2023 to attract new members and to encourage current members to remain with the club. A discounted annual membership fees was offered during the promotional campaign as follows: Individual membership: $1,000 and family membership: $2,000. The management of Brisbane Badminton Club came up with two sets of estimates (Optimistic and pessimistic scenarios) in terms of membership enrolments for the upcoming year commencing October 2023. The management estimates that even though not all current members will continue with the club under the new membership terms and pricing, the loss of members would be offset by new members joining the club within the first six months of introducing the new membership terms and pricing. The new members joining each month during October 2023 to March 2024 would pay a proportional amount of the annual membership fees on joining. Management estimates that adequate facilities would be available for all members under the new plan. Detober 2023 to March 2024 individual and student 1000 and family 2000 For the start of the new membership year commencing October 2023, Brisbane Badminton Club is considering introducing a new membership and fees structure. Under the new membership plan, only an annual membership fee would be charged, rather than a membership fee plus hourly facilities usage fees. The predicted membership composition and planned annual membership fees for the upcoming membership year is as follows: The annual membership fees would be collected in advance at the time of member enrolments. Members would be allowed to use the club facilities as often as they wished during the year under the new plan. All future memberships would be sold under these new terms. A special promotional campaign is planned during September 2023 to attract new members and to encourage current members to remain with the club. A discounted annual membership fees was offered during the promotional campaign as follows: Individual membership: $1,000 and family membership: $2,000. The management of Brisbane Badminton Club came up with two sets of estimates (Optimistic and pessimistic scenarios) in terms of membership enrolments for the upcoming year commencing October 2023. The management estimates that even though not all current members will continue with the club under the new membership terms and pricing, the loss of members would be offset by new members joining the club within the first six months of introducing the new membership terms and pricing. The new members joining each month during October 2023 to March 2024 would pay a proportional amount of the annual membership fees on joining. Management estimates that adequate facilities would be available for all members under the new plan. during the year under the new plan. All future memberships would be sold under these new terms. A special promotional campaign is planned during September 2023 to attract new members and to encourage current members to remain with the club. A discounted annual membership fees was offered during the promotional campaign as follows: Individual membership: $1,000 and family membership: $2,000. The management of Brisbane Badminton Club came up with two sets of estimates (Optimistic and pessimistic scenarios) in terms of membership enrolments for the upcoming year commencing October 2023. The management estimates that even though not all current members will continue with the club under the new membership terms and pricing, the loss of members would be offset by new members joining the club within the first six months of introducing the new membership terms and pricing. The new members joining each month during October 2023 to March 2024 would pay a proportional amount of the annual membership fees on joining. Management estimates that adequate facilities would be available for all members under the new plan. Detober 2023 to March 2024 individual and student 1000 and family 2000 For the start of the new membership year commencing October 2023, Brisbane Badminton Club is considering introducing a new membership and fees structure. Under the new membership plan, only an annual membership fee would be charged, rather than a membership fee plus hourly facilities usage fees. The predicted membership composition and planned annual membership fees for the upcoming membership year is as follows: The annual membership fees would be collected in advance at the time of member enrolments. Members would be allowed to use the club facilities as often as they wished during the year under the new plan. All future memberships would be sold under these new terms. A special promotional campaign is planned during September 2023 to attract new members and to encourage current members to remain with the club. A discounted annual membership fees was offered during the promotional campaign as follows: Individual membership: $1,000 and family membership: $2,000. The management of Brisbane Badminton Club came up with two sets of estimates (Optimistic and pessimistic scenarios) in terms of membership enrolments for the upcoming year commencing October 2023. The management estimates that even though not all current members will continue with the club under the new membership terms and pricing, the loss of members would be offset by new members joining the club within the first six months of introducing the new membership terms and pricing. The new members joining each month during October 2023 to March 2024 would pay a proportional amount of the annual membership fees on joining. Management estimates that adequate facilities would be available for all members under the new plan