Question

In: Accounting

As the new manager of a local fitness club, Gifted & Lifted, you have been studying...

As the new manager of a local fitness club, Gifted & Lifted, you have been studying

the club’s financial data. You would like to determine how the club’s costs behave in

order to make accurate predictions for next year. Here is the information from the

last six months:

Month

Club enrollment

(# of members)

Total operating costs

Operating Costs per member

July

450

$8,900

$19.78

August

480

$9,800

$20.42

September

500

$10,100

$20.20

October

550

$10,150

$18.45

November

560

$10,500

$18.75

December

525

$10,200

$19.43

1-By looking at the “Total Operating Costs” and the “Operating Costs per Member,” can you tell whether the club’s operating costs are variable, fixed, or mixed? Explain your answer

2- List 10 costs the club might have and be sure to label them “fixed” or “variable”

3-Use high-low method to determine the club’s monthly operating cost equation.

4-Using the answer from number 3, predict the total monthly operating costs if the club has 800 members. What if instead you have 390 members? 1,000 members?

5-Can you predict total monthly operating costs if the club has 3,000 members? Explain your answer

Solutions

Expert Solution

Solution 1:

As total operating cost is changing with the Number of members, therefore same cannot be considerd as fixed. Further operating cost per member is also not constant, therefore operating cost cannot be considered as variable. Therefore Club's operating cost are mixed.

Solution 2:

List of cost the club might have and be sure to label them "Fixed" or "Variable"

1. Rent - Fixed

2. Electricity - Variable

3. Trainer Fee - Variable

4. Food cost - Varible

5. Administrative Salary - Fixed

6. Equipment depreciation - Fixed

7. Insurance - Fixed

8. Uniform Expenses - Variable

9. Rates and taxes = Fixed

10. Fuel expenses - variable

Solution 3:

Operating cost at 450 members = $8,900

Operating cost at 560 members = $10,500

Variable cost using high low method = (Cost at high level - Cost at low level) / (high level activity - low level activity)

= ($10,500 - $8,900) / (560-450)

= $14.55 per member

Fixed cost = $8,900 - (450*14.545454) = $2.355

Operating cost equation = $2,355 + $14.55 X

Solution 4:

Total monthly operating cost at 800 member = $2,355 + (800*$14.55) = $13,995

Total monthly operating cost at 390 member = $2,355 + (390*$14.55) = $8,030

Total monthly operating cost at 1000 member = $2,355 + (1000*$14.55) = $16,905

Solution 5:

Total monthly operating cost at 3000 member = $2,355 + (3000*$14.55) = $46,005


Related Solutions

Suppose you are the manager of a small, local diner. You have been studying the sales...
Suppose you are the manager of a small, local diner. You have been studying the sales data of your restaurant over the past year. You have managed to identify two groups of            consumers who frequent your establishment and have cross-referenced their orders with historical data. You have jotted down the following notes to yourself:                         Hamburger French Fries Group 1 Maximum Valuation $3.00 $1.00 Group 2 Maximum Valuation $2.50 $2.00 Currently, you sell your products a la carte (separately...
The following is information pertaining to a local fitness club, Fitness for Life. Month Club Membership...
The following is information pertaining to a local fitness club, Fitness for Life. Month Club Membership (number of members) Total Operating Costs July 450 $                      8,900 August 480 $                      9,800 September 500 $                   10,100 October 550 $                   10,150 November 560 $                   10,500 December 525 $                   10,200 1. By looking at the Total Operating Costs and the Average Operating Costs Per Member, can you tell whether the club's operating costs are variable, fixed, or mixed? 2. Perform Regression analysis using Microsoft Excel. What is the monthly operating...
As an entry level new clubhouse manager at the Country Club you have been assigned the...
As an entry level new clubhouse manager at the Country Club you have been assigned the position of scheduling and preparing and monitoring overtime pay for the club's unionized employees. You have scheduled two employees for the last week of December where overtime pay conditions have occurred. This was a hectic period with numerous holiday functions and the New Year's celebration. Overtime pay will be paid at the rate of 1.5 times the base rate. Sami worked two different jobs...
As the representative of the local accounting club, you have been asked by the dean to...
As the representative of the local accounting club, you have been asked by the dean to help her understand the costs of the different degrees offered at the school. You decide to use an activity-based cost system. Write a report outlining the first two steps of developing an ABC system for this purpose: (1) Identify the activities, and (2) identify the activities associated with each activity.
As the manager of a factory that is producing Good X, you have been studying the...
As the manager of a factory that is producing Good X, you have been studying the macroeconomy for some time and have also been examining other markets, such as that of Good Y. You’ve jotted down the following notes:                         Consumer income: estimated to increase over the next year                         Income elasticity of demand for Good X = -0.75                         Cross-price elasticity of demand for Good X (with Good Y) = -1.9 The CEO asks you to analyze what might...
You have been asked by the board of the local hockey club to review its accounting...
You have been asked by the board of the local hockey club to review its accounting procedures. You have made the following observations in regards to cash collected for annual dues and for weekly entrance ticket sales. The club's board has given financial management and audit of the financial records responsibility to the finance committee. This team prepares the budget and approves all major cash disbursements. No audit has been considered necessary in recent years because the same trusted employee...
You have been asked to teach a fitness class at your local community center three mornings...
You have been asked to teach a fitness class at your local community center three mornings a week. The community center weight room has 4 squat/press racks, bars, bumper plates, dumbbells and kettlebells in a range of sizes, 4 TRX units, cones, jump ropes, and a large open indoor space as well as an outdoor courtyard. You may bring in any additional equipment you would like. Design a four-week cycle of classes in which you develop strength, endurance, and cardiovascular...
You are a researcher that is studying a population of dragons. You have been studying the...
You are a researcher that is studying a population of dragons. You have been studying the dragons for many years and think that this population has some individuals that have some genetic abnormalities that could be the result of 1) DNA replication and repair errors, 2) chromatic packaging issues or 3) chromosomal mutations. These abnormalities seem to run in families and do not appear to be affected by seasonal or environmental changes but do cause the individuals to get ill...
Congratulations! You have been appointed as a new product manager with Samsung and have been tasked...
Congratulations! You have been appointed as a new product manager with Samsung and have been tasked to introduce the latest smartphone in a new country. Choose and research a country other than the United States and India, and then formulate a plan to effectively integrate this product from a global and social standpoint. Speculate on the major challenges and opportunities you anticipate facing in this role. Provide a reference source.
3. You are a researcher that is studying a population of trolls. You have been studying...
3. You are a researcher that is studying a population of trolls. You have been studying the trolls for many years and think that this population has some individuals that have some genetic abnormalities that could be the result of 1) DNA replication and repair errors, 2) chromatic packaging issues or 3) chromosomal mutations. These abnormalities seem to run in families and do not appear to be effected by seasonal or environmental changes but do cause the individuals to get...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT