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 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 Direct Cabor Utilities Tons Mined Hours Cost Quarter Year 1: First Second Third Fourth Year 2 First Second Third Fourth 29,000 19.000 34,00 26,000 5.400 4,400 5,400 7.400 $ 64,000 $ 59.000 $ 74,000 $ 89,000 12.000 39,000 44,000 42,000 12.800 13,200 10,00 11,800 $ 132,000 $ 135,000 $99.000 $ 140,000 nces 2. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor-hours on the horizontal avis . 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 an 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 Required information 4. To remove a point from the grapn, CIICK on the point and select aerete option. w tor $180,000 Yo 1.2 5150,000 ... 5120,000 Utilities Cost 2590,000 $50,000 $30,000 30 0 3.000 0,000 0.000 12.000 15,000 18.000 Direct Labor Hours reset Required information 500.000 Utilities 300.000 530.000 3.600 6,000 9,000 12.000 15.000 10,000 Direct Labor Hours reset 2.b. Using the least squares regression method, estimate the variable utilities cost per direct labor-hour and the total faed utilities cost per quarter. Express these estimates in the form Y2+bx (Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount.) Yo