Question
Required information Excel Analytics 02-03 (Static) Job-Order Costing and Regression Analysis (L02-1, L02-2] [The following information applies to the questions displayed below) Landis Company
Required information Excel Analytics 02-03 (Static) Job-Order Costing and Regression Analysis (L02-1, L02-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 Machine- Hours Direct Labor-Hours Electrical Costs. Week 1 7,700 8,910 $ 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 $607,300 Using the data above, the company translated these actual amounts into annual estimates as follows: Total for eight weeks (a) Machine- Direct Labor- Electrical Hours 60,300 Hours 71,250 Costs $ 607,300 6.5 6.5 6.5 Annual estimate (a) x 391,950 463,125 $3,947,450 (b) 52 weeks +8 weeks (b) 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started