Question: The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The companys cost analyst has concluded that utilities cost is

The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The companys cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formula. The production superintendent disagrees; she thinks that direct labor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information:

Quarter Tons Mined Direct Labor-Hours Utilities Cost
Year 1:
First 28,000 6,300 $ 63,000
Second 18,000 4,300 $ 58,000
Third 33,000 5,300 $ 73,000
Fourth 25,000 7,300 $ 88,000
Year 2:
First 31,000 12,600 $ 133,000
Second 38,000 12,900 $ 138,000
Third 43,000 10,600 $ 98,000
Fourth 41,000 13,600 $ 138,000

1-a. Using tons mined as the independent variable, prepare a scattergraph that plots tons mined on the horizontal axis and utilities cost on the vertical axis.

1-b. Using the least-squares regression method, estimate the variable utilities cost per ton mined and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bX. (Round the Variable cost per unit to 2 decimal places and Fixed Cost to the nearest whole dollar amount.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!