The Hard Rock Mining Company

Required information 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 that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formule. 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 Die HD QUE Tonin co Year F 33, 3,300 57.000 Second 15.900 3, # $2,000 21, 4.700 61,000 Touth 19.000 6.100 82 Ya 21 Firat 25,000 11,600 $107.000 bicom 12.000 11.10 $12.000 Third 37,000 9.40 33.000 Fourth 35,000 12,400 13,000 2-a. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal axis and utilities Cost on the verticals Instructions: 1. On the graph below. use the point tool (Year 1-1st quarter to plot direct labor hours on the horizontal axis and utilities cost on the Vertical axis. 2. Repeat the same process for the platter tools (Year 1-2nd quarter to Year 2-4th quarter 3. To enter exact coordinates, click on the point and enter the values of x and y. 4. To remove a point from the graph, click on the point and select delete option 2. Using the lases regression memod, estimate the variabletites cost per direct labor hour and the stated the cost per quarter Express these sites in the form YDX (Round the Variable cost to 2 decimal places and Feed Cost to the nearest whole dollar amount Required information 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 that correlates with the cost. The controller has suggested that tons mined might be a good base to use in developing a cost formule. 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 Die HD QUE Tonin co Year F 33, 3,300 57.000 Second 15.900 3, # $2,000 21, 4.700 61,000 Touth 19.000 6.100 82 Ya 21 Firat 25,000 11,600 $107.000 bicom 12.000 11.10 $12.000 Third 37,000 9.40 33.000 Fourth 35,000 12,400 13,000 2-a. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal axis and utilities Cost on the verticals Instructions: 1. On the graph below. use the point tool (Year 1-1st quarter to plot direct labor hours on the horizontal axis and utilities cost on the Vertical axis. 2. Repeat the same process for the platter tools (Year 1-2nd quarter to Year 2-4th quarter 3. To enter exact coordinates, click on the point and enter the values of x and y. 4. To remove a point from the graph, click on the point and select delete option 2. Using the lases regression memod, estimate the variabletites cost per direct labor hour and the stated the cost per quarter Express these sites in the form YDX (Round the Variable cost to 2 decimal places and Feed Cost to the nearest whole dollar amount