Share
Explore BrainMass

Variable and Fixed Costs

Nation's Capital Fitness, Inc. operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y = a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows:

Month Hours of Maintenance
Service Maintenance
Costs
January 520 $ 4,470
February 490 4,260
March 300 2,820
April 500 4,350
May 310 2,960
June 480 4,200
July 320 3,000
August 400 3,600
September 470 4,050
October 350 3,300
November 340 3,160
December 320 3,030
Total 4,800 $ 43,200

Average 400 $ 3,600

Required:

1-a.
Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Inc.
Variable cost per hour $
Fixed cost per month $

1-b.
Express the cost behavior pattern in equation form

Maintenance cost = $ + $ X

Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

$2.19