Hale Lighting has several plants located around the United States. The company’s controller has imported its job cost data from the past year into Excel. The following is a sample of the table of the records in that Excel file. Access the full data set online in the MyLab Accounting exercise.

Using the full data set online, create pivot tables to answer the following questions.1. What was the total job cost for each lamp model?2. What was the total job cost for each lamp model by plant?3. What was the average cost per unit for each lamp model?4. What was the average cost for each lamp model in each plant?5. What is the total direct material (DM) used in each plant?6. What is the total direct labor (DL) used in each plant?

Transcribed Image Text:

A Date B Plant 1 2 2/2/2019 Maine 3 2/14/2019 Ohio 4 2/16/2019 Maine 2/23/2019 Texas 2/4/2019 Ohio 2/9/2019 Texas 7 8 2/11/2019 Maine 9 2/21/2019 Ohio 2/5/2019 Texas 10 5586 11 2/12/2019 Texas 5742 12 2/17/2019 Maine 5828 13 2/20/2019 Texas 5823 195. с Job # 5843 5408 5286 5676 6 5710 5440 5657 5803 D Lamp model Floor Floor Desk Desk Desk Table Floor Floor Table Floor Table Table E Units 30 15 20 25 F DM 165.00 93.00 116.00 152.50 35 50 25 95 1,415.50 30 20 528.50 765.00 362.50 273.00 188.00 30 264.00 65 565.50 G DL 93.00 49.50 62.00 85.00 213.50 310.00 147.50 570.00 135.00 94.00 129.00 273.00 H MOH 114.00 60.00 74.00 100.00 Job cost 297.50 435.00 207.50 798.00 177.00 122.00 372.00 202.50 252.00 337.50 1,039.50 1,510.00 717.50 2,783.50 585.00 404.00 168.00 561.00 357.50 1,196.00 Cost per unit 12.40 13.50 12.60 13.50 29.70 30.20 28.70 29.30 19.50 20.20 18.70 18.40