[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: Direct Labor- Week 1 Machine-Hours 7,700 Hours 8,910 Electrical Conta $ 76,200 Week 2 8,900, 8,920 83,800 Week 3 8,600 8,870 81,000 Week 4 8,100 8,840 80,800 Week 5 7,600 8.990 79,400 Week 6 7,100 8,940 70,700 Week 7 5,500 8,870 61,500 Week 8 Total 6,800 8,910 73,900 60,300 71,250 5607,300 Using the data above, the company translated these actual amounts into annual estimates as follows: Total for eight weeks (a) 52 weeks 8 weeks (b) Annual estimate (a) (b) Direct Labor- Machine-Hours 60,300 6.5 391,950 Hours 71,250 6.5 463,125 Electrical Costa $ 607,300 6.5 $3,947,450 Click here to download the Excel template, which you will use to answer Requirements 4.5 and 6 Click here for a brief tutorial on Regression Analysis in Excel. Excel Analytics 02-03 (Static) Part 1 and 2 Required: 1. Using the annualized data, what is the estimated electrical cost per direct labor-hour? 2. Using the annualized data, what is the estimated electrical cost per machine-hour? Complete this question by entering your answers in the tabs below. Req 1 Req 2 Using the annualized data, what is the estimated electrical cost per machine-hour? (Round your answer to two decimal places.) The estimated electrical cost per machine-hour is