Also type down the fomula you use to get tha answer and how you input it. please

if you can't answer it please don't do it

! 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 Utilities Cost Quarter Tons Mined Labor-Hours Year 1: 34,000 6,900 $ 69,000 21,000 4,900 $ 64,000 First Second Third Fourth Year 2: 39,000 $ 79,000 5,900 7,900 31,000 $ 94,000 37,000 13,800 $119,000 $124,000 14,700 First Second Third Fourth 44,000 49,000 47,000 $104,000 11,800 14,800 $139,000 2. Using the least-squares regression method, estimate the variable utilities cost per direct labor-hour and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bx. (Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount.) Y= ! 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 Utilities Cost Quarter Tons Mined Labor-Hours Year 1: 34,000 6,900 $ 69,000 21,000 4,900 $ 64,000 First Second Third Fourth Year 2: 39,000 $ 79,000 5,900 7,900 31,000 $ 94,000 37,000 13,800 $119,000 $124,000 14,700 First Second Third Fourth 44,000 49,000 47,000 $104,000 11,800 14,800 $139,000 2. Using the least-squares regression method, estimate the variable utilities cost per direct labor-hour and the total fixed utilities cost per quarter. Express these estimates in the form Y = a + bx. (Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount.) Y=