# Question

The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company’s cost analyst has concluded that utilities cost is a mixed cost, and he is attempting to find a base with which the cost might be closely correlated. 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:

Required:

1. Using tons mined as the independent variable, prepare a scatter-graph that plots tons mined on the horizontal axis and utilities cost on the vertical axis. Determine a cost formula for utilities cost using least-squares regression. Express this cost formula in the form Y = a + bX.

2. Using direct labor-hours as the independent variable, prepare a scatter-graph that plots direct labor-hours on the horizontal axis and utilities cost on the vertical axis. Determine a cost formula for utilities cost using least-squares regression. Express this cost formula in the form Y = a + bX.

3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilitiescost?

Required:

1. Using tons mined as the independent variable, prepare a scatter-graph that plots tons mined on the horizontal axis and utilities cost on the vertical axis. Determine a cost formula for utilities cost using least-squares regression. Express this cost formula in the form Y = a + bX.

2. Using direct labor-hours as the independent variable, prepare a scatter-graph that plots direct labor-hours on the horizontal axis and utilities cost on the vertical axis. Determine a cost formula for utilities cost using least-squares regression. Express this cost formula in the form Y = a + bX.

3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilitiescost?

## Answer to relevant Questions

Why do companies use predetermined overhead rates rather than actual manufacturing overhead costs to apply overhead to jobs?The following data from the just completed year are taken from the accounting records of Mason Company: Required: 1. Prepare a schedule of cost of goods manufactured. Assume all raw materials used in production were direct ...Refer to the data for the Ferre Publishing Company in Exercise 4B–3. In Exercise 4B–3, The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the ...Crossfire Company segments its business into two regions—East and West. The company prepared the contribution format segmented income statement shown below:Required: 1. Compute the companywide break-even point dollar in ...Refer to the data for Minden Company in Problem 8–17. The company is considering making the following changes to the assumptions underlying its master budget: In Problem 8–17 Minden Company is a wholesale distributor of ...Post your question

0