Prepare a scattergraph by plotting power costs

Assignment Help Financial Accounting

Reference no: EM13940550

SCATTERGRAPH, HIGH-LOW METHOD, METHOD OF LEAST SQUARES, USE OF JUDGMENT

The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost analysts have decided that power costs are mixed; thus, they must be broken into their fixed and variable elements so that the cost behavior of the power usage activity can be properly described. Machine hours have been selected as the activity driver for power costs. The following data for the past eight quarters have been collected:

Quarter	Machine Hours	Power Cost ($)
1	20,000	26,000
2	25,000	38,000
3	30,000	42,500
4	22,000	37,000
5	21,000	34,000
6	18,000	29,000
7	24,000	36,000
8	28,000	40,000

For the following requirements, round the fixed cost to the nearest dollar and round the variable rates to the nearest cent.

Required:

1. Prepare a scattergraph by plotting power costs against machine hours. Does the scattergraph show a linear relationship between machine hours and power cost?

2. Using the high and low points, compute a power cost formula.

3. Use the method of least squares to compute a power cost formula. Evaluate the coefficient of determination.

4. Rerun the regression, and drop the point (20,000, $26,000) as an outlier. Compare the results from this regression to those for the regression in Requirement 3. Which is better?

Reference no: EM13940550

Questions Cloud

Government inquiry into taxation minimisation : What recommendations would you make to a government inquiry into taxation minimisation by companies?

Data are available for one of the products : data are available for one of the products sold by Green Company, which uses a perpetual inventory system

The demand for dvd players is expanding rapidly : The demand for DVD players is expanding rapidly, but the industry is highly competitive. A plant to make DVD players costs $40 million, has an annual capacity of 100,000 units, and has an indefinite physical life. The variable production cost per uni..

Strategic management process : Assignment brief: Prepare a strategic report that includes an introduction, summary and list of academic references which comply with Harvard, to support the requests in the case study covering the following areas: 1. Provide a critical insight in..

Prepare a scattergraph by plotting power costs : Prepare a scattergraph by plotting power costs against machine hours. Does the scattergraph show a linear relationship between machine hours and power cost?

Does alan view of his job foster a negative or positive work : Does Alan's view of his job foster a negative or positive work atmosphere with his employees? Explain.

Java application that can hold five doubles in an array : Write a Java application that can hold five doubles in an array, and display the doubles from first to last, and then display the doubles from last to first. Use the following logic for BubbleSort to sort and display the array in sequence.

Do you think that the drinking age in the united states : Do you think that the drinking age in the United States should be lowered to eighteen? Use the discussion of autonomy to support your answer.

Briefly summarize the folole muliaga scenario : Using the Folole Muliaga case study provided in Bridgeman (2010) and Eweje and Wu (2010), evaluate alternative actions and consequences to Mercury Energy. In your paper, be certain to specifically address the following: • Briefly summarize the Fol..

User Account

All Pages