Question: Create a new tab labeled Pivot & Pie . Use the data in the SUMIF tab to create a pivot table and a pie chart.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...

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: Show the employee status. Show the employees name. Show the...

Create a new tab labeled MMM and set up an empty table like the one in the Data tab. Populate the table by linking the cells to the data in the Data tab. Then, complete the following: Figure out the...

I made the graph from the table, but I do not understand how to read it in order to answer questions 2 and 3 60000000 MW - Count of Division MW - Count of Sales Month 500 00 000 MW - Sum of Amount...

Overview In this assignment, you ll continue to use the workbook titled Labor Hours that you created for your Module One assignment. You ll be looking at data related to employees who are full - time...

Overview In this assignment, youll continue to use the workbook titled Labor Hours that you created for your Module One assignment. Youll be looking at data related to employees who are full-time...

please break this down step b y step Overview In this assignment, you ll continue to use the workbook titled Labor Hours that you created for your Module One assignment. You ll be looking at data...

Calculate invested capital and before-taxROI. BALANCE SHEET Cash Marketable securities Accounts receivable Inventory $140,000 Accounts payable 200,000 Wages payable 40,000 Short-term debt 1,000,000...

Demolition Construction Services has 12,500 shares of stock outstanding and no debt. The new CFO is considering issuing $75,000 of debt and using the proceeds to retire 2,500 shares of stock. The...

Which of the following adjusting entries would be the most likely be reversed? Select one: a.DR: Depreciation Expense $500; CR: Accumulated Depreciation $500 b.DR: Salary Expense $1,980; CR: Salary...

Refer to the clustering problem involving the file FBS described in Problem 1. The NCAA has a preference for conferences consisting of similar schools with respect to their endowment, enrollment, and...

1. A restaurant, Pizza of Gaithersburg, Inc. (PG), agreed with Virginia Coffee Service (VCS) to have vending machines installed in PGs restaurants. The contract was to run for one year and was...

Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware Co. issued $35,000,000 of five-year, 12% bonds at a market (effective) interest rate of 10%, with interest...

Wynn Company has recorded the following items in its financial records. Cash in bank ..........................................$ 42,000 Cash in plant expansion fund ............. 100,000 Cash on hand...

Oxford Computer Security uses the perpetual inventory system and makes all credit Trial balance, total debits $51,000sales on terms of 2/10, n/30. Oxford completed the following transactions during...

eBook a . an addition to the cash balance according to the bank statement b . a deduction from the cash balance according to the bank statement c . an addition to the cash balance according to the...

What is the purpose of the Inventory Exceptions report?

What information is automatically provided by the computer to aid in the bank reconciliation process?

What is the purpose of the Tax Tables tab in the Setup Accounting System window?

Aqua Corporation purchases nonresidential real property on May 9, 2013, for $1 million. Straight-line cost recovery is taken in the amount of $89,765 before the property is sold on November 30, 2016,...

Prance, Inc., earns pretax book net income of $800,000 in 2016. Prance acquires a depreciable asset that year, and first-year tax depreciation exceeds book depreciation by $80,000. Prance reported no...

Swallow Company is a large real estate construction company that has made a Subchapter S election. The company reports its income using the percentage of completion method. In 2017, the company...