5. Io enter exact coorainates, on the point and enter tne values or x and y. 4. To remove a polnt from the graph, cllck on the polnt and select delete option. (i) 1-b. Using the least-squares regression method, estimate the varlable utilitles cost per ton mined and the total fixed utilitles cost per quarter. Express these estimates in the form Y=a+bX. Note: Round the Varlable cost per unlt to 2 declmal places and Flxed Cost to the nearest whole dollar amount. 2-b. Using the least-squares regression method, estimate the varlable utilitles cost per direct labor-hour and the total fixed utillties co per quarter. Express these estimates in the form Y=a+bX. 3. Would you recommend the company use tons mined or direct labor-hours as a base for planning utllitles cost? Complete this question by entering your answers in the tabs below. 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. Note: Round the Variable cost to 2 decimal places and Fixed Cost to the nearest whole dollar amount. Required Information The Hard Rock Mining Company wants to separate Its utillties cost Into varlable and fixed elements for planning purposes. The controller belleves tons mined might be a good base for developing a cost formula. The production superintendent disagrees; she thinks direct labor-hours would be a better base. Quarterly data for tons mined, direct labor-hours, and utilitles cost are as follows: Required: 1-a. Using tons mined as the Independent varlable, prepare a scattergraph that plots tons mIned on the horlzontal axIs and utilitles 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 horlzontal axis and utllities 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 coordlnates, cllck on the point and enter the values of x and y. 4. To remove a polnt from the graph, cllck on the point and select delete option