Naveed is the payroll manager at a local construction company. He has a table of the company's twelve employees hours worked last week and hourly wages. a. Enter the data from the table into Excel. b. Calculate the total wages for each employee under column header (Total Wages) c. Calculate total wages for all employees combined using the SUMPRODUCT function. d. Check your work by summing up your answers to part (b) using a formula as well. DATA Employee Abe Barry Carl Dave Ernie Frank George Hank Ira James Ken Lou Hours worked 49 39 48 42 33 50 36 42 30 32 40 50 Hourly wa $13.60 $13.90 $12.60 $13.70 $12.20 $12.40 $12.40 $12.70 $13.00 $13.80 $13.20 $12.70 Allison needs to order building products for the latest house her construction company is building. She has the cost per case for each product, and the number of cases for each that she wants to buy. What is the total payment Allison will have to make? DATA Product 1 2 3 4 5 6 7 8 $/Case $79.10 $85.19 $53.75 $78.91 $43.30 $15.74 $94.28 $21.75 $36.54 $10.68 $94.94 $69.85 $86.15 $43.71 $54.57 $89.08 Cases to Order 7 39 15 23 35 26 6 23 10 45 44 20 34 35 29 16 9 10 11 12 13 14 15 16