Answered step by step
Verified Expert Solution
Question
1 Approved Answer
THANKS IN ADVANCE!!! PLEASE PLACE ALL ANSWERS ABOVE WITHIN THE APPROPRIATE EXCEL CELL FOR THE PROBLEM SO I KNOW WHERE TO PLACE THEM. THANKS AGAIN
THANKS IN ADVANCE!!! PLEASE PLACE ALL ANSWERS ABOVE WITHIN THE APPROPRIATE EXCEL CELL FOR THE PROBLEM SO I KNOW WHERE TO PLACE THEM. THANKS AGAIN :)
Required information Problem 6-38 High-Low Method; Fitness Centers (LO 6-1, 6-2, 6-5) [The following information applies to the questions displayed below.) 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 the high-low method to develop 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 January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 450 270 470 320 440 360 420 460 350 360 330 4,790 Maintenance Costs $ 5,427 4,230 2,730 4,310 3,030 4,170 3,100 3,590 3,980 3,230 3,220 3,040 $44,057 $ 3,671* 399* *Rounded Problem 6-38 Part 1 Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Inc. Express the cost behavior pattern in equation form. (Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount.) Monthly maintenance cost =Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started