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 nd 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 infon'nation: E1 Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth Required: 22,000 15.- 000 27, 000 19, 000 25.- 000 32; 000 37; 000 35, 000 Tons MinedDirect LaborHoursUtilities Cost 5,700 $ 57,000 3,700 S 52,000 4: 700 S 67, 000 6,700 $ 82,000 11,400 S 107,000 11,100 S 112. 000 9,400 S 92,000 12,400 S 127,000 El 1-a. Using tons mined as the independent variable, prepare a m that plots tons mined on the horizontal axis and utilities cost on the vertical axis. 1. 0n the graph below, use the point tool (Year 1-1st quarter) to plot tons mined 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-4-th 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. Utilities Cost 140000 120000 100000 80000 60000 40000 20000 0 10000 20000 30000 Tons Mined 40000 50000 Tools Year11si qL Year12nd qi Year 1 - 3rd qt Year 1 - 4th qL Year 2 -1st qL Year 2 - 2nd qi (3 60000 1-b. Using the least-squares regression method, estimate the variable utilities cost per ton mined and the total xed utilities cost per quarter. Express these estimates in the form 1': a + 0431'.\" (Round the Variable cost per unit to 2 decimal places and Fixed Cost to the nearest whole