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: Utilities Cost Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth Direct Tonn Mined Labor-Fours 28,000 6,300 18,000 4,300 33,000 5,300 25,000 7,300 $ 63,000 $ 58,000 $ 73,000 $ 88,000 31,000 38,000 43,000 41,000 13,300 12,300 11,300 14,300 $133,000 $138,000 $ 98,000 $138,000 3. Would you recommend that the company use tons mined or direct labor-hours as a base for planning utilities cost? Tons mined Direct labor-hours 4 Upload your Excel Sareedsheet for Problem 3 which should include 1) your datar, and 22 separate Scatter Plats, one showing total costs on the basis of tons and another showing total costs on the basis of direct labor hours) Alno, answer the following question in your Excel Spreadsheet On which basis should total manufacturing costs be projected. tons or direct-labor hours? Why? Explain, being as specific as possible using the information you've obtained from your Scatter Plot graphs and Least Squares Regression Analysis. You will be graded based on 1) accuracy, and 2) presentation (does your graph contain helpful titles, a linear equation, a line that crosses the Y-axts, and the R-squared value, and is it easy to read? 60 points shipped och Print References upload a response file (15MB max) Choose to no file selected Sve