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 cost equation? What is the R-square?
3. Use the high-low method to determine the club's monthly operating cost equation.
4. Can we predict total montly operating costs if the club has 3,000 members?

Solutions

Expert Solution

1.
The cost is mixed cost, since cost is increasing with increase in output but not with direct proportion

2. Cost equation = $3912.35 + $11.80 x
R Square = 0.8007

SUMMARY OUTPUT

Regression Statistics
Multiple R	0.894816
R Square	0.800696
Adjusted R Square	0.75087
Standard Error	278.0903
Observations	6

ANOVA
	df	SS	MS	F	Significance F
Regression	1	1242747	1242747	16.06982	0.016014
Residual	4	309336.8	77334.19
Total	5	1552083

	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	3912.354	1508.329	2.593834	0.060439	-275.438	8100.146	-275.438	8100.146
Number of Members	11.8029	2.944307	4.008718	0.016014	3.62819	19.9776	3.62819	19.9776

3. High low method
Variable cost per unit = ($10500-8900)/(560-450) = $14.55 per unit
Fixed Cost = 10500 - 560 x 14.55 = $2352

Cost Equation = $2352 + 14.55 x

4. Cost for 3000 members
using high low equation = $2352 + 14.55 x 3000 = $46002
using regression = $3912.35 + 11.80 x 3000 = $39312.35

If you have any query regarding this, kindly comment with your query

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Task 1: BetterHealth is a membership-based fitness club in Toronto. Customers can purchase a membership that...

Task 1: BetterHealth is a membership-based fitness club in Toronto. Customers can purchase a membership that provides a fixed number (e.g. 100) of free visits to the club upon registration. When the initial number of visits runs out, they can purchase additional visits as needed. All types of fitness equipment and all fitness classes offered in the club are open for this membership. Please write a Java program (Membership.java) for membership management. The Membership class should have the following public...

As part of a January promotion, flint life fitness ltd. sold six-month membership to its gym...

As part of a January promotion, flint life fitness ltd. sold six-month membership to its gym for $300. This also included a personal fitness assessment and training plan. Active Life normally charges $360 for a six-month membership and $90 for a personal fitness assessment and training plan. Using the five-step model, determine the amount of revenue that Flint Life would recognize in January, assuming that 320 memberships were sold as part of this promotion and that all of the personal...

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...

The Evergreen Golf Club offers life membership at an annual subscription fee of $3600 per person.The...

The Evergreen Golf Club offers life membership at an annual subscription fee of $3600 per person.The following information is available for the Evergreen Golf Club for the year ended 31 March 2018. cash balance at 1 April 2017 1750 Administered expenses 12775 For the annual social evening,800 tickets were sold at a price of $250each.However,payment has not yet been received for 30 tickets. Social evening costs 60895 Ground maintenance 39430 staff costs 46900 The club has a total of 120...

A-310 Fall 2018 Quiz 1 The following information relates to Vida Fitness Club which was started...

A-310 Fall 2018 Quiz 1 The following information relates to Vida Fitness Club which was started by Mark Cooper and includes one fitness club that sells athletic apparel and provides personal training. On July 1, 2018, Mark decided to incorporate and open his club. At the time of incorporation he had one investor who was eager to provide capital. The company uses the accrual method of accounting and made the following transactions during the months of July and August. Transactions...

Analyze Life Force Fitness, Inc. Life Force Fitness, Inc., assembles and sells treadmills. Activity-based product information...

Analyze Life Force Fitness, Inc. Life Force Fitness, Inc., assembles and sells treadmills. Activity-based product information for each treadmill is as follows: Activity Activity-Base Usage (hrs. per unit) X Activity Rate per Hour = Activity Cost Motor assembly 1.50 $20 $30.00 Final assembly 1.00 18 18.00 Testing 0.25 22 5.50 Rework 0.40 22 8.80 Moving 0.20 15 3.00 Activity cost per unit $65.30 All of the activity costs are...

Apex Fitness Club uses straight-line depreciation for a machine costing $21,000, with an estimated four-year life...

Apex Fitness Club uses straight-line depreciation for a machine costing $21,000, with an estimated four-year life and a $2,450 salvage value. At the beginning of the third year, Apex determines that the machine has three more years of remaining useful life, after which it will have an estimated $2,000 salvage value. Required: 1. Compute the machine’s book value at the end of its second year. 2. Compute the amount of depreciation for each of the final three years given the...

Apex Fitness Club uses straight-line depreciation for a machine costing $23,860, with an estimated four-year life...

Apex Fitness Club uses straight-line depreciation for a machine costing $23,860, with an estimated four-year life and a $2,400 salvage value. At the beginning of the third year, Apex determines that the machine has three more years of remaining useful life, after which it will have an estimated $2,000 salvage value. Required: 1. Compute the machine’s book value at the end of its second year. 2. Compute the amount of depreciation for each of the final three years given the...

Flex Fitness is a health and fitness club that operates gym facilities through out the United...

Flex Fitness is a health and fitness club that operates gym facilities through out the United States.Flex Fitness members pay their membership dues annually.Selected fiscal- year information from the company's balance sheets follows(thousands). Selected Balance Sheet Data 2016 Defered membership Income( liability) 500,568 2017 453,881 During fiscal 2016, Flex Fitness collected$1,119,833 cash for membership fees.Calculate the membership fee revenue that flex fitness recognizied during the year.

Cozy Catering, Inc. has provided the following information pertaining to the store's month ended October 31,...

Cozy Catering, Inc. has provided the following information pertaining to the store's month ended October 31, 2019: Sales revenue $100,000 Supplies expense $1,500 Interest expense 6,900 Rent expense 4,000 Cost of goods sold 60,000 Wages expense 9,500 Dividends paid 5,000 Utilities expense 1,100 Advertising expense 4,500 Loss on sale of coffee equipment 3,200 Dividends declared 7,100 Income tax expense 3,800 Unearned revenues 6,100 Note: these are not debits and credits, they are in 2 column just to make them fit....

Subjects