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

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 $

https://brainmass.com/business/purchases-inventory-and-cogs/452760

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

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