Required information Excel Analytics 02-03 (Static) Job-Order Costing and Regression Analysis (L02-1, LO2-2) [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: Electrical Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week Total Machine-Bours 7,700 8.900 8,600 8.100 7,600 7,100 5,500 6,800 60,300 Direct Labor- Hours B.910 8.920 8,870 8,840 8,990 2,940 3,870 8.919 71,250 Costs 76,200 83,800 B1,000 BO,00 79,400 70,700 61,500 73.900 11607300 Using the data above, the company translated these actual amounts into annual estimates as follows: Direct Labor Hours 71.250 GS 463,125 Machine-tour 60,300 6.5 391.950 lectrical CON 360300 6.5 $ 3.947.450 Total for oight week (a) 52 weeks - veeko (b) Annual estimat. (a) (b) Airlines Power School Lear SOSU Orientation 1 San Diego State U Owl P Math 141 AFRAS MindTap- 2-3 Seved 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? 0:58 Complete this question by entering your answers in the tabs below. ok onoh Reg 1 Reg2 Using the annuaired data, what is the estimated electrical cost per direct labor-Hour (Round your answer to two decima! places) The estimated electrical cost per direct labor hour is Reg 2 > Pro 1 2 3 4 of 4 Next > MacBook Air ata UN 001 w o E T R D F S H G K B N N Z 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? 60:37 Complete this question by entering your answers in the tabs below. ok Reg 1 Red2 Reg 2 Using the annualized data, what is the estimated electrical cost per machine-hour? (Round your answer to two decima places.) ces The estimated electrical cost per machine-hour is