Required information [The following information applies to the questions displayed below. Landis Company uses a job-order costing system with a predetermined plantwide overhead rate based on direct labor- hours. In an effort to improve its ability to measure job profitability and make decisions, the company is considering allocating 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 following eight weeks of actual (not estimated) data with respect to its electrical costs Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Machine-Hours Direct Labor-Hours 7,700 8,910 8,900 8,920 8,600 8,870 8,100 8,840 7,600 8,990 7.100 8,940 5,500 8,870 6,800 3,910 60,300 71,250 Electrical Costs $ 76,200 83,800 81,900 80,800 79,489 70,700 61,500 73,900 $ 607,300 Total Using the data above, the company translated these actual amounts into annual estimates as follows Machine Hours 60,300 Total for eight weeks (a) 52 weeks + 8 weeks (b) teta Direct Labor-Hours 71,250 6.5 663 175 Electrical Costs 5 607,300 6. 1.007 CA 6.5 101 OCA 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 5A of the text for a brief illustration of the method being used to perform the regression computations.) b. What is the R2 for the regression line in requirement 5a? c. What does the tell us? Complete this question by entering your answers in the tabs below. Red SA Reg 58 Reg 5C 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 5A of the text for a brief illustration of the method being used to perform the regression computations.) (Round the estimated variable cost per machine hour to two decimal places.) The estimated foed electrical cost per week is The estimated variable electrical cost per machine hour is Hoe Reg 58 > Complete this question by entering your answers in the tabs below. Req 5A Req 5B Reg 50 What is the R2 for the regression line in requirement 5a? (Round your answer to four decimal pla The RP is Complete this question by entering your answers in the tabs below. Reg SA Req 5B Req 5C What does the R2 tell us? Olt tells us the percentage of variation in the dependent variable (electrical cost) explained by variation in the independent variable (machine-hours) it tells us the percentage of variation in the dependent variable (machine-hours) explained by variation in the Independent variable (electrical cost) It tells us the percentage of variation in the independent variable (electrical cost) explained by variation in the dependent variable (machine-hours) It tells us the percentage of variation in the independent variable (machine-hours) explained by variation in the dependent variable (electrical cost).