Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i submit my answer (excel sheet ) could you Cheick if it right ? Brisbane Badminton Club offers airconditioned badminton court facilities to its members.

image text in transcribed

i submit my answer (excel sheet ) could you Cheick if it right ?

image text in transcribed

Brisbane Badminton Club offers airconditioned badminton court facilities to its members. The club has been operating at prime location in Brisbane since 1985. The club has 2,000 members. Revenue is generated from annual membership fees and hourly court usage fees. The current membership composition and current annual membership fees are as follows: The hourly court usage fees are $22 at the prime time of the day and $12 at other times during the peak season. There are 10 court rooms at the club. The club operates 362 days per year and the club's daily operating hours are 6am to 12 noon and 2pm to 8pm. The peak season runs from October to April (181 days). During peak season, court usage averages from 90% to 100% of capacity during prime time ( 6am to 8am in the morning and 6pm to 8pm in the evening). The court usage during remaining hours of the day during peak season ranges between 50% to 60% of capacity. Daily court usage during the off-season averages from 40 to 50% of the capacity, and is charged at a flat fee of $16 per hour. The club's memberships expire at the end of September each year. A substantial amount of revenue is collected during early part of peak season due to the renewal of annual membership fees and heavy facilities usage. However, revenue collection during off-season drops significantly due to reduced facilities usage. Membership category \% of total members Individual Student Family Annual membership fees (\$) 0.25 0.25 0.5 peak season October to April (181 days) 90% to 100% prime time 6 am to 8 am an fees at the prime time total per day peak season October to Apri remaining hours 9-10 club room 4 hours 22 50% to 60% of capacity. time fees at the prime time total per day peak season October to Apri total revenue for peak seson total revenue for the year recipt Lease payments Depreciaton Salaries fix Other fixed operatng expens Variable marketng expenses operating expenses operating profit Number of member total Annual membership fees (\$) 50 30 100 peak season October to April (181 days) 5-6 club room 8 hours 12 537.6 \begin{tabular}{|r|} \hline 97,305.60 \\ \hline 248,621.60 \\ \hline 545,005.60 \\ \hline \end{tabular} budget \begin{tabular}{|r|} \hline 545,005.60 \\ \hline 100,000.00 \\ \hline 25,000.00 \\ \hline 160,000.00 \\ \hline 50,000.00 \\ \hline 5,450.06 \\ \hline 5,450.06 \\ \hline 345,900.11 \\ \hline 199,105.49 \\ \hline \end{tabular} 500500 1000 40% to 50% time fees total per day total revenue for off seson off season may to september 181 4-5 club room 12 hours 16 864 156,384.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

12th Edition

840062338, 840062346, 9780840062338, 978-0840062345

More Books

Students also viewed these General Management questions