Explore BrainMass
Share

Cost Formula Using the High Low Method

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

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.

© BrainMass Inc. brainmass.com October 25, 2018, 7:59 am ad1c9bdddf
https://brainmass.com/business/purchases-inventory-and-cogs/cost-formula-using-the-high-low-method-522153

Solution Summary

This solution illustrates how to determine the cost formula for overhead using the High-Low Method and how to apply that cost formula to find the overhead at a given production level.

$2.19
See Also This Related BrainMass Solution

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

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 $

View Full Posting Details