Landis Company uses a job-order costing system with a predetermined plantwide overhead rate..

Requlred Information [The following information applies to the questions displayed below] Landis Compary uses a job-order costing system with a predetermined plartwide overhead rate based on direct laborhours. In an effort to improve its ability to measure job profitability and make decisions, the compary is considering allocating some of its overthead 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: Using the data above, the company translated these actual amounts into annual estimates as follows: Click here to downtoad the Excel template, which you will use to answer Reguirements 4.5 and 6. Click hete for a brief tutorialon Reotession Analyabs in Excoll. Refer to the eight weeks of actual data included in the Excel template. 0. Use least-squares regression to estimate the fixed electical cost per week and the variable electrical cost per machine-hour. (You can refer to Appendix 5A of the text for a brief iliustrotion 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 R2 teil us? 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 lliustration of the method being used to perform the regression. computabions.) (Round the estimated variable cost per machine hour to two decirral placest.) 0. If the company continues to use ditect labor-hours to allocate electrical costs to jobs. What impact will it have on the perceived profitability of Job Q400? t will overcost Job Q400 thereby making it appear less profitable than it would be if the electrical costs were allocated based on machine hours. It will overcost Job Q400 thereby making it appear more profitable than it would be d the electrical costs were allocated based on machine hours. It will undercost Job Q400 thereby making it appear more profitable than it would be if the electrical costs ware allocated based on machine hours. It will undercont Job Q400 thereby making it appear less profitable than it would be if the electrical costs were allocated based on machine-hours What is the R2 for the regression line in requirement 5a ? (Round your answer to four decimal places.) 0. If the company continues to use direct labor-hours to allocate electrical costs to jobs, what impact will it have on the perceived profitability of Job Q400? It will overcost Job Q400 thereby making it appear less profitable than it would be if the electrical costs were allocated pased on machine-hours. t will overcost Job Q400 thereby making it appear more profitable than it would be if the electrical costs were allocated pased on machine-hours. It will undercost Job Q400 thereby making it appear more profitable than it would be if the elecirical costs were allocated pased on machine-hours. it will undercost Job Q400 thereby making it appear less profitable than it would be if the electrical costs were allocated