1. Create a new tab labeled Pivot & Pie. Use the data in the SUMIF tab to create a pivot table and a pie chart. Complete the following:
   1. Show the employee status.
   2. Show the employee’s name.
   3. Show the employee cost.
   4. Write a rationale statement.

SUMIF DATA

B 1 Employee's Name Hourly Pay Rate Mon 2 Smith A 3 Rodriquez 4 Daniel 5 Eli 6 Lee 7 Kim 8 Buster 9 Green 10 $8.95 $11.00 $14.00 $16.00 $19.00 $20.00 $25.00 $40.00 Tue 8 8 8 8 8 8 8 8 Wed 8 8 8 8 8 8 8 8 E 8 8 8 8 8 8 8 8 Thu F 8 8 8 8 8 8 8 8 Fri G Y 8 8 8 8 8 8 8 8 H Total Hrs. Worked Gross Pay Status $358.00 C $440.00 C $560.00 C 40 40 $640.00 F $760.00 C $800.00 F 40 40 $1,000.00 C 40 $1,600.00 F 40 40 40 Cost Incurred by Full Time Employee Formula $3,040.00 Cost Incurred by Contract Employees $3,118.00 3040 3118