Data Table - A D E F G H 1 Lamp model J Cost per unit 1 Date Plant Job # Units DM DL MOH Job cost 2 2/2/2019 Ohio 5180 Desk 20 110.00 62.00 76.00 248.00 12.40 3 2/4/2019 Maine 5185 Floor 30 453.00 183.00 255.00 891.00 29.70 4 2/5/2019 Ohio 5215 Table 25 227.50 112.50 147.50 487.50 19.50 5 2/9/2019 Texas 5231 Floor 40 612.00 248.00 348.00 1,208.00 30.20 6 2/11/2019 Texas 5267 Floor 60 870.00 354.00 498.00 1,722.00 28.70 7 2/12/2019 Ohio 5318 Table 15 141.00 70.50 91.50 303.00 20.20 8 2/14/2019 Maine 5348 Desk 10 62.00 33.00 40.00 135.00 13.50 9 2/16/2019 Texas 5353 Desk 25 145.00 77.50 92.50 315.00 12.60 10 2/17/2019 Texas 5488 Table 35 308.00 150.50 196.00 654.50 18.70 11 2/20/2019 Ohio 5490 Table 75 652.50 315.00 412.50 1,380.00 18.40 12 2/21/2019 Maine 5501 Floor 75 1,117.50 450.00 630.00 2,197.50 29.30 13 2/23/2019 Ohio 5508 Desk 20 122.00 68.00 80.00 270.00 13.50 Print Done Requirements 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. (Note: You do not need to create the pivot table in Excel in this exercise.) 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? What was the average cost for each lamp model in each plant? Print Done 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. (Click the icon to view the Excel worksheet.) Read the requirements. 1. What was the total job cost for each lamp model? Choose the fields, if any, that you would add to the Pivot table report by using the dropdown list in each report area. (If you select a field for the Values section, select what type of calculation you would use to summarize the value field using the dropdown list. If an area of the report does not need any Pivot table fields, leave the input fields empty.) Filters Columns What type of calculation you would use to summarize the value field Rows Values