Heminemansecinum Required information Problem 5A.6 (AlgO) Leest-Squares Regresslon; Scottergreph; Comporison of Actlvity Bases [LOJ-11] The Hard Rock Mining Company is develoging cont formulas for management planning and declalon-making purposes. The company's cost analyat has concluded that utilies cost is orted cost and he is attenpeng 19 find a bsee that comelater wh the cost. The cortrolor has suggested that tons mhed might be a good bare to uce in developing a cost formud. The producvon sipenntendent disygrees, she thanks that drect labor-hours would be a befter bsse. The cost anslyst has decided to try both bases and has assembled the following liflormaton: Problem 5 A.6 Part 2 (Algo) 2-a. Ubing direct laboc-hours as the independent variable, prepsre a scantergraph the piots direct labor-hours on the horizontal aris and utlites coct on the vertical sits Instructions 1. On the graph below, use the point tool (Year 1.1st quarted to plor direct laboc hours on the hoctzented axis and uthities cost on the Verticis axts 2. Aepeat the came process for the plotter tools (Year 13 Znd quarter to Year 24 th quarter) 3. To enter exact cootdinates, chick on the point and enter the values of x and y. 4. To remove a point from the graph, click on the polnt and select delete option Required information Problem 3A.G (AlgO) Least-Squares Regression; Scattergraph; Comparison of Actlvity Bases [LO S-11] 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 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: Problem 5 A. 6 Port 3 (Algo) 3. Would you recommend that the compary use tons mined or direct labor-hours as a base for planning utlites cost? Direct laborthours Tons mined Problem 5A-6 (Algo) Least-Squeres Regresslon; Scattergroph; Comperison of Activity Bases [LO5-11] The Hard Rock Mining Company is developing cost formulas for management planning and deckion-making purposes. The company's cost analyst has concluded that utimies cost is a miked cost, and he 15 atrempting to find a base that correlates whth the cost. The controller has suggested that tons mined might be a good base to use in developing a coct formula. The production superintendent disegrees; she thinks that direct iabor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information Problem 5A.6 Part 1 (Algo) Regutred: 1.3. Using tons mined as the independent variable. prepare a scattergraph that plots tonis mined on the hortzonraf anks and utilties c on the vertical axts instructuons: 1. On the gragh below, use the point tool (Year 1.1st quarter) to plot tons mined on the hortzontal axis and utivies cost on the Yervical axis. 2 Repeat the same process for the plotter tools (Year 1-2nd quarter to Year 2-4th querter) 3 Yo enter exact coordinates. click on the point and enter the values of x and y. 4. To remove a polint from the graph, click on the point and select delete ophion. 2-a. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal axis and utilites cost on the vertical axls. 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 plotter 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.b. Using the least-squares regressian method, estimate the variable utlities cost per direct labor-hour and the total fixed utilites cost per quarter. Express these estimates in the form YabX. (Round the Varlable cost to 2 decimal places and Fixed Cost to the Required Information Problem 5A.6 (Algo) Least.Squares Regression; Scattergroph; Comparison of Actlvity Bases [LO5.11] The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company's cost analyst has concluded that utilties 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: Problem 5A.6 Part 3 (Algo) 3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost? Direct taborhours Tons mined Heminemansecinum Required information Problem 5A.6 (AlgO) Leest-Squares Regresslon; Scottergreph; Comporison of Actlvity Bases [LOJ-11] The Hard Rock Mining Company is develoging cont formulas for management planning and declalon-making purposes. The company's cost analyat has concluded that utilies cost is orted cost and he is attenpeng 19 find a bsee that comelater wh the cost. The cortrolor has suggested that tons mhed might be a good bare to uce in developing a cost formud. The producvon sipenntendent disygrees, she thanks that drect labor-hours would be a befter bsse. The cost anslyst has decided to try both bases and has assembled the following liflormaton: Problem 5 A.6 Part 2 (Algo) 2-a. Ubing direct laboc-hours as the independent variable, prepsre a scantergraph the piots direct labor-hours on the horizontal aris and utlites coct on the vertical sits Instructions 1. On the graph below, use the point tool (Year 1.1st quarted to plor direct laboc hours on the hoctzented axis and uthities cost on the Verticis axts 2. Aepeat the came process for the plotter tools (Year 13 Znd quarter to Year 24 th quarter) 3. To enter exact cootdinates, chick on the point and enter the values of x and y. 4. To remove a point from the graph, click on the polnt and select delete option Required information Problem 3A.G (AlgO) Least-Squares Regression; Scattergraph; Comparison of Actlvity Bases [LO S-11] 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 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: Problem 5 A. 6 Port 3 (Algo) 3. Would you recommend that the compary use tons mined or direct labor-hours as a base for planning utlites cost? Direct laborthours Tons mined Problem 5A-6 (Algo) Least-Squeres Regresslon; Scattergroph; Comperison of Activity Bases [LO5-11] The Hard Rock Mining Company is developing cost formulas for management planning and deckion-making purposes. The company's cost analyst has concluded that utimies cost is a miked cost, and he 15 atrempting to find a base that correlates whth the cost. The controller has suggested that tons mined might be a good base to use in developing a coct formula. The production superintendent disegrees; she thinks that direct iabor-hours would be a better base. The cost analyst has decided to try both bases and has assembled the following information Problem 5A.6 Part 1 (Algo) Regutred: 1.3. Using tons mined as the independent variable. prepare a scattergraph that plots tonis mined on the hortzonraf anks and utilties c on the vertical axts instructuons: 1. On the gragh below, use the point tool (Year 1.1st quarter) to plot tons mined on the hortzontal axis and utivies cost on the Yervical axis. 2 Repeat the same process for the plotter tools (Year 1-2nd quarter to Year 2-4th querter) 3 Yo enter exact coordinates. click on the point and enter the values of x and y. 4. To remove a polint from the graph, click on the point and select delete ophion. 2-a. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal axis and utilites cost on the vertical axls. 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 plotter 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.b. Using the least-squares regressian method, estimate the variable utlities cost per direct labor-hour and the total fixed utilites cost per quarter. Express these estimates in the form YabX. (Round the Varlable cost to 2 decimal places and Fixed Cost to the Required Information Problem 5A.6 (Algo) Least.Squares Regression; Scattergroph; Comparison of Actlvity Bases [LO5.11] The Hard Rock Mining Company is developing cost formulas for management planning and decision-making purposes. The company's cost analyst has concluded that utilties 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: Problem 5A.6 Part 3 (Algo) 3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost? Direct taborhours Tons mined