Explore BrainMass
Share

# Using the high-low method, estimate the cost formula

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The number of X-rays taken and X-ray costs over the last nine months in Beverly Hospital are given below:

Month X-Rays Taken X-Ray Costs
January 6,600 \$21,120
February 13,800 \$35,460
March 13,100 \$34,576
April 11,100 \$29,808
May 8,500 \$27,200
June 10,500 \$26,256
July 5,100 \$16,320
August 10,800 \$26,726
September 5,800 \$18,560
________________________________________

Required:
1. Using the high-low method, estimate the cost formula for X-ray costs. (Round the "Variable cost per X-ray" to 2 decimal places and the "Fixed cost" to the nearest dollar amount. Omit the "\$" sign in your response.)

Y = \$
+ \$
X

2. Using the cost formula you derived above, what X-ray costs would you expect to be incurred during a month in which 4,650 X-rays are taken? (Omit the "\$" sign in your response.)

Variable cost \$

Fixed cost

________________________________________
Total cost \$

#### Solution Preview

Required:
1. Using the high-low method, estimate the cost formula for X-ray costs. (Round the "Variable cost per X-ray" to 2 decimal places and the "Fixed cost" to the nearest dollar amount. Omit the "\$" sign in your response.)
The highest and lowest levels of activity are ...

#### Solution Summary

Using the high-low method, estimate the cost formula for X-ray costs.

\$2.19

## Cost Formula Using the High Low Method

The controller of Chittenango Chain Company believes that the identification of the variable and fixed components of the firm's costs will enable the firm to make better planning and control decisions. Among the costs the controller is concerned about is the behavior of indirect-materials cost. She believes there is a correlation between machine hours and the amount of indirect materials used.
A member of the controller's staff has suggested that least-squares regression be used to determine the cost behavior of indirect materials. The regression equation shown below was developed from 40 pairs of observations.

S = \$200 + \$4H
Where S = Total monthly cost of indirect materials
H = Machine hours per month

2. Calculate the estimated cost of indirect materials if 900 machine hours are to be used during a month. (Omit the "\$" sign in your response.)

4. The high and low activity levels during the past four years, as measured by machine hours, occurred during April and August, respectively. Data concerning machine hours and indirect-material usage follow.

April ; August
Machine hours 1,100 ; 800
Indirect supplies:
Beginning inventory \$ 1,200 ; \$ 950
Ending inventory 1,550 ; 2,900
Purchases 6,000 ; 6,100
Determine the cost of indirect materials used during April and August.

5. Use the high-low method to estimate the behavior of the company's indirect-material cost.

View Full Posting Details