Madison 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:

C Job # 5180 5185 5215 5 2/9/2019 Texas 5231 6 2/11/2019 Texas 5267 7 2/12/2019 Ohio 5318 8 2/14/2019 Maine 5348 9 2/16/2019 Texas 5353 10 2/17/2019 Texas 5488 11 2/20/2019 Ohio 5490 12 2/21/2019 Maine 13 2/23/2019 Ohio 1 A 1 Date 2 2/2/2019 Ohio 3 2/4/2019 Maine 4 2/5/2019 Ohio B Plant 5501 5508 D Lamp model Desk Floor Table Floor Floor Table Desk Desk Table Table Floor Desk E Units 20 30 25 40 60 15 10 25 35 75 75 20 F DM 110.00 453.00 227.50 612.00 870.00 141.00 62.00 145.00 308.00 652.50 1,117.50 122.00 G DL 62.00 183.00 112.50 248.00 354.00 70.50 33.00 77.50 150.50 315.00 450.00 68.00 H MOH I Job cost 76.00 248.00 255.00 891.00 147.50 487.50 348.00 1,208.00 498.00 1,722.00 91.50 303.00 40.00 135.00 92.50 315.00 196.00 654.50 412.50 1,380.00 630.00 2,197.50 80.00 270.00 Cost per unit 12.40 29.70 19.50 30.20 28.70 20.20 13.50 12.60 18.70 18.40 29.30 13.50