Landis Company uses a job-order costing system with a predetermined plantwide overhead rats based on direct labor- hours in an effort to improve its ability to measure job profitability and make decisions, the company is considering elocating some of its overhead costs, such as electrical costs, based on machine-hours instead of direct labor-hours. To further explore the potential benefits of this approach, the company has gathered the folowing eight weeks of actual not estimated) date with respect to its electrical costs 76,300 1,400 4,978 1,000 4.110 7,400 75,400 Week 3,100 NE 5,500 8,970 Using the data above, the company translated these actual amounts into annual estimates as follows Total for eight (4) Annual estimate (a) (b) 40,300 71,250 Duste 607,300 6.5 4.5 391,950 463,125 $3,947,450 Click here to download the Excel template, which you will use to answer Requirements 4.5 and S Click here for a brief toriaLon Regression Analysis in c Excel Analytics 02-03 (Static) Part 5 and 6 5. Refer to the eight weeks of actual data included in the Excel template a. Use least-squares regression to estimate the fixed electrical cost per week, and the variable electrical cost per machine-hour (You can refer to Appendix SA of the text for a brief lustration of the method being used to perform the regression computations) b. What is the R for the regression line in requirements? e. What does the tell us? Complete this question by entering your answers in the tabs below. Reg SC Use least-squares regression to estimate the fleed electrical cost per week and the variable electrical cost per machine-hour (You can refer to Appendix SA of the text for a brief lustration of the method being used to perform the regression computations) (Round the estimated variabia cost per machine hour to two decimal places) 6. If the company continues to use direct labor-hours to allocate electrical costs to jobs, what impact will it have on the perceived profitability of Job 04007 based on machine-hours besed in machine-hours based on machine based on machine hours