Show work via Excel and using Excel functions

Complete the two tables below. a. In the first table, put an 'X' in the proper column (5 points). b. In the second table, complete the 'Summary' using the data from the first table [2 points). c. If the employee is paid $8.50/hr, what is the labor cost of this operation?[3 points). Distance Step No. Time (min) O O Step Description 1 1 2 0.05 3 0.25 20 4 10.5 5 0.75 6 1.5 Search for hedge trimmer in back of truck Pick up trimmer Walk to hedges Trim hedges Check to see if hedge tops are straight Trim hedges again to correct bad spots Check hedges again Pick up trimmings and put in plastic bag Walk to curb, holding plastic bag and trimmer Place plastic bag by curbside 7 0.5 8 3.5 9 0.45 20 10 0.2 11 0.35 8 Walk to truck Return hedge trimmer to back of truck 12 0.25 Summary No. of Steps Activity Time (min) Distance (ft) Operation Transport Inspect O Delay Store V