Madison Lighting has several plants located around the United States. The companys controller has imported its job

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: