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.

For each of the situations listed below, assume that you would create a pivot table to answer the question. Indicate which field you would use for the Rows box, which field (if any) you would use for the Columns box, and which field you would use for the Values box. Also indicate what type of calculation you would use to summarize the value field.

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?

Transcribed Image Text:

7 1 2 34567 A Date 12 13 B Plant 2/2/2019 Ohio 2/4/2019 Maine 2/5/2019 Ohio 2/9/2019 Texas 2/11/2019 Texas 2/12/2019 Ohio 8 2/14/2019 Maine 9 2/16/2019 Texas 10 2/17/2019 Texas 2/20/2019 Ohio 11 2/21/2019 Maine 2/23/2019 Ohio C Job # 5180 5185 5215 5231 5267 5318 5348 5353 5488 5490 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 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 630.00 80.00 1,380.00 2,197.50 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