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 Labor- Utilities Quarter Tons Mined Hours Cost Year 1: First 27,808 6, 280 $ 62,080 Second 18, 209 4, 20 $ 57,980 Third 32,090 5,289 $ 72, 980 Fourth 24, 808 7, 290 $ 87,980 Year 2: First 30, 209 12, 489 $128, 080 Second 37,808 12, 680 $133, 080 Third 42,090 19,489 $ 97, 080 Fourth 13,489 $136, 080 Required: 1-a. Using tons mined as the independent variable. prepare a scattergraph that plots tons mined on the horizontal axis and utilities cost on the vertical axis. Instructions: 1. On the graph below, use the point tool (Year 1-1st quarter) to plot tons mined on the horizontal axis and utilitles 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. Utilities Cost 140000 Tools 120000 Year 1 - 1st qu 100000 80000 Year 1 - 2nd q 60000 40000 Year 1 - 3rd qu 20000 O 1009 20000 3400 60000 Tons Mined