Required information Problem 5A-6 (Algo) Least-Squares Regression; Scattergraph; Comparison of Activity Bases [LO5-11] 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- Quarter Year 1: First Tons Mined Hours Utilities Cost 30,000 6,500 $ 65,000 Second 19,000 4,500 $ 60,000 Third 35,000 5,500 $ 75,000 Fourth 27,000 7,500 $ 90,000 Year 2: First 33,000 13,000 $ 115,000 Second 40,000 13,500 $ 120,000 Third 45,000 11,000 $ 100,000 Fourth 43,000 14,000 $ 135,000 Problem 5A-6 Part 1 (Algo) 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 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. 4. To remove a point from the graph, click on the point and select delete option. Utilities Cost .. ཅ་་ ས་༦ སྐྱ་-སྔ་་ པས་ཅ་་ད -བ་ ས་༦ པཅ་་་་ ་པཔ་ ་ ་ཅས་ གཡས་་་་ད པ པ་པ་ ་པ་་- ་་་་་་སྨཔ VII METS TIVLIEVINGUTUAIS UM MATRASO 100 ! Required information ✓. ་པཅ་་ཅ་ ཅའབཅ་ ་པཔ་ས་་་པ་ཅབད ཅIIཅn པ་་ ས་S པས་་་་ ས་་ས ཅ་་ཅ་ BITC པས་སཅབ པ་ འ པ་་པས་ 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 30000 50000 20000 40000 60000 Tons Mined Tools Year 1 - 1st qu Year 1 - 2nd q Year 1 - 3rd qɩ Year 1 - 4th qu Year 2 - 1st qɩ Year 2 - 2nd q Year 2-3rd qɩ Year 2 - 4th qu 1-b. 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 = +