3 Part 3 of 4 Landis Company uses a job-order costing system with a predetermined plantwide...

Transcribed Image Text:

3 Part 3 of 4 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 prottability 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 25 po Machineouts birect Labor Hours Electrical Cast week 7,700 8,910 $75,200 2 8,920 1,000 week 8,470 $1,000 Merk 4 8,100 8,140 Week S 3,000 8,990 beek 5 3,300 10,700 $3,500 ebook Week Total 73,250 Using the data above, the company translated these actual amounts into annual estimates as follows Machine-hours Direct Labors Co Total for eight 52 weeks weeks (b) (4) Annual estimate (*)(b) Click here to download the Excel template which you will use 30 Bemeta Click here for a brief tutonal on Regression Analysis in Excel 4. Refer to the eight weeks of actual data included in the Excel template e. Use Excel to prepare a scattergraph plot with direct labor-hours on the horizontal axis and electrical costs on the vertical a b. Use Excel to prepare a scattergraph plot with machine-hours on the horizontal axis and electrical costs on the vertical a c. Which of the two allocation bases (deect labor-hours or machine hours appears to be the better choice for assigning electro costs to jo? The beer che for ocating electrical c leve C 3 Part 3 of 4 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 prottability 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 25 po Machineouts birect Labor Hours Electrical Cast week 7,700 8,910 $75,200 2 8,920 1,000 week 8,470 $1,000 Merk 4 8,100 8,140 Week S 3,000 8,990 beek 5 3,300 10,700 $3,500 ebook Week Total 73,250 Using the data above, the company translated these actual amounts into annual estimates as follows Machine-hours Direct Labors Co Total for eight 52 weeks weeks (b) (4) Annual estimate (*)(b) Click here to download the Excel template which you will use 30 Bemeta Click here for a brief tutonal on Regression Analysis in Excel 4. Refer to the eight weeks of actual data included in the Excel template e. Use Excel to prepare a scattergraph plot with direct labor-hours on the horizontal axis and electrical costs on the vertical a b. Use Excel to prepare a scattergraph plot with machine-hours on the horizontal axis and electrical costs on the vertical a c. Which of the two allocation bases (deect labor-hours or machine hours appears to be the better choice for assigning electro costs to jo? The beer che for ocating electrical c leve C