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 Hours Cost Tons Mined Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth 23,000 16,000 28,000 20,000 5,800 3,800 4,800 6,800 $ 58,000 $ 53,000 $ 68,000 $ 83,000 26,000 33,000 38,000 36,000 10,800 9,800 8,800 11,800 $108,000 $113,000 $ 93,000 $128,000 2-a. Using direct labor-hours as the independent variable, prepare a scattergraph that plots direct labor hours 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 plor direct labor-hours 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-4th quarter), 3. To enter exact coordinates, click on the point and enter the values of x and y. A TA FAm vennine from the aranh lirinn hannint and calar dolara Antinn 3 2 of 3 !!! search quares Regression Saved Required information 4. To remove a point from the graph, click on the point and select delete option. Year 1 - 1st quartier 5140,000 Year 1 - 2nd quartier $120,000 $100 000 Year 1.Sed quarter ces 580.000 Utilities Cost Year 1-4 quarter 560.000 Year 2- 1st quarter $40.000 520.000 Year 22nd quarter 30 2.000 4.000 6.000 8.000 10 000 12000 14000 Year 2-3rd Direct Labor-Hours Next > 2