Using the high-low method to estimate costs

Assignment Help Financial Management

Reference no: EM131329463

On November 15, 2009, Sandra Cook, a newly hired cost analyst at Demgren Company, was asked to predict overhead costs for the company's operations in 2010 when 530 unites are expected to be produced. She collected the following quarterly data:

Quarter Production In Units Overhead Costs

1/06 73 $715

2/06 76 709

3/06 68 640

4/06 133 1,124

1/07 122 995

2/07 125 1,105

3/07 122 1,113

4/07 130 1,036

1/08 121 982

2/08 126 1,060

3/08 112 990

4/08 81 951

1/09 81 829

2/09 119 1,044

3/09 87 982

1) Using the high-low method to estimate costs, prepare a prediction of overhead costs for 2010

2) Sandy ran a regressin analysis using the data she collected. The result was

Y = $347 + $5.76X

Using this cost function, predict overhead costs for 2010

3) Which prediction do you prefer? Why?

Reference no: EM131329463

Questions Cloud

Determine which type of storage space should be used : A manufacturing company is in need of 1000 square meters of storage space for 3 years. The company is considering the purchase of land for $8 000 and erecting a temporary metal structure on it at a cost of $70 per square meter. Using Present Worth An..

Standard deviation of return on client portfolio : You manage an equity fund with an expected risk premium of 14% and a standard deviation of 54%. The rate on Treasury bills is 6.8%. Your client chooses to invest $120,000 of her portfolio in your equity fund and $30,000 in a T-bill money market fund...

Estimate of appropriate price range for the shares of grap : Garrett Simpson Investments^is evaluating a firm (Garp, Inc.) for recommendation to its clients and trying to evaluate the firm's current stock price. The firm is about to offer its shares to the public and had earnings last year of $2.50 a share, wh..

How much did the company spend on new property : At the end of fiscal year 2014, Emerson Electric Co. (EMR) had net property, plant, and equipment equal to $3.5 billion. The ending balance for 2013 was $3, 507 billion, and the firm had depreciation expense during 2014 equal to $0.727 billion. How m..

Using the high-low method to estimate costs : On November 15, 2009, Sandra Cook, a newly hired cost analyst at Demgren Company, was asked to predict overhead costs for the company's operations in 2010 when 530 unites are expected to be produced. She collected the following quarterly data: Using ..

Find the coefficient of variation of the stock : Pick one stock listed in the UAE of your choice and gather weekly closing price and dividend information using the Dubai Financial Market or Abu Dhabi Securities Exchangefrom the period of January 2015 to December 2015. You need to obtain holding wee..

What is their covariance : Security X has expected return of 12% and standard deviation of 20%. Security Y has expected return of 15% and standard deviation of 27%. If the two securities have a correlation coefficient of 0.7, what is their covariance?

Using present worth analysis-type of storage space : A manufacturing company is in need of 1000 square meters of storage space for 3 years. The company is considering the purchase of land for $8 000 and erecting a temporary metal structure on it at a cost of $70 per square meter. Using Present Worth An..

Draw respective cash flow diagrams and carryout : The City of Boulder Colorado is considering three sites for flood control dams to prevent flooding resulting from the annual spring snow melt in the Rocky Mountains. Each dam would be built on different branches of a large river, designated as the Ea..

User Account

All Pages