[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 Costs $ 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 6,800 8,910 73,900 Total 60,300 71,250 $607,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) x (b) Direct Labor- Electrical Machine-Hours 60,300 6.5 391,950 Hours 71,250 6.5 463,125 Costs $ 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 direct labor-hour? (Round your answer to two decimal places.) The estimated electrical cost per direct labor-hour is 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 < Req 1 Req 2 >