Please answer all 3 questions. I will rate up.

! 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 Tons Mined Labor-Hours Utilities Cost Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth 18,000 13,000 23,000 15,000 5,300 3,300 4,300 6,300 $ 53,000 $ 48,000 $ 63,000 $ 78,000 21,000 28,000 33,000 31,000 10,600 9,900 8,600 11,600 $115,000 $120,000 $ 88,000 $126,000 Required: 1. Using the least-squares regression method, estimate the variable utilities cost per ton mined and the total fixed utilities cost per quarter. Express these estimates in the form Y = a +bX. (Round the Variable cost per unit to 2 decimal places and Fixed Cost to the nearest whole dollar amount.) Y = X 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= X 3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost? O Tons mined O Direct labor-hours