Madson Lighting has several plants locatod around the Unhed States The company's controler has imported iss job cost data from the past year into Excel The following is a sample of the table of the recoeds in that Excel file. (Click the icon to view the Excel worksheet) Fead the requirements 1. What was the total job cost for each lamp model? Choose the fields, if any, that you would add to the Prot uble repen by ushg the dropdown lst in each report area. (of you sulect a feld for the Velues section, select what type of calculsten you would use to summarite the value field ushy the dropdown lis. If an area of the report does not need any Phot tatie fields, lewve the input fislds emphy. Data table 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? 4. What was the average cost for each lamp model in each plant