I need the Excel worksheet and answers. Help me.

1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on the data sheet (including the heading lines). Drag "account #" to the row labels and "amount" to the Values. You should now see the dollar amounts for sales revenue, direct materials, direct labor, variable overhead, and Grand Total (contribution margin). If you don't see the dollar amounts click the arrow next to amounts in the Values box and choose "Sum of amount".

Next, answer the following:

How much are total sales revenues?

How much are total direct material costs?

How much are total direct labor costs?

How much are total overhead costs?

How much is total contribution margin?

2. Add a sheet and rename "Pivot table 2". On the sheet which is now called Pivot table 2 , insert a pivot table in cell A1 using the data range provided on the data sheet (including the heading lines). Drag "sales person" to the Row Labels box, drag "account #" to the Column Labels box, and drag "amount" to the Values box.

Answer the following:

Which sales person generated the highest sales revenue?

Which sales person generated the highest contribution margin?

Which sales person generated the lowest sales revenue?

Which sales person generated the lowest contribution margin?

3. Add a sheet and rename it "Pivot table 3". On the sheet which is now called Pivot table 3 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "Job #" to the Row Labels box and "amount" to the Values box. On the table select the data in the sum of amounts column and sort from highest to lowest. Answer the following:

Which job number generated the highest contribution margin?

Which job number generated the lowest contribution margin?

4. Add a sheet and rename "Pivot table 4". On the sheet which is now called Pivot table 4 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "customer" to the Row Labels box and "amount" to the Values box. On the table select the data in the sum of amounts column and sort from highest to lowest.

Which customer generated the highest contribution margin?

Which customer generated the lowest contribution margin?

5. Rename sheet 4 "Pivot table 5". On the sheet which is now called Pivot table 5 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "location" to the Row Labels box and "amount" to the Values box.

Which location generated the highest contribution margin?

Which location generated the lowest contribution margin?

I need the Excel worksheet and answers to the above.

\f4250 Lago C. Mayer 5050 Variable Overhea NJ -54 4251 Williams M. Cohen 4000 Sales Revenue NJ 900 4251 Williams M. Cohen 5020 Direct Materials NJ -72 4251 Williams M. Cohen 5040 Direct Labor NJ -45 4251 Williams M. Cohen 5050 Variable Overhea NJ .36 4252 Zameer C. Mayer 4000 Sales Revenue CO 600 4252 Zameer C. Mayer 5020 Direct Materials |CO -42 4252 Zameer C. Mayer 5040 Direct Labor CO 54 4252 Zameer C. Mayer 5050 Variable Overhea CO -72 4255 DON M. Ryan 4000 Sales Revenue KA 3300 4255 DON M. Ryan 5020 Direct Materials KA -231 4255 DON M. Ryan 5040 Direct Labor KA 132 4255 DON M. Ryan 5050 Variable Overhea KA -165 4260 Lerer F. Mc Govern 4000 Sales Revenue KA 680 4260 Lerer F. Mc Govern 5020 Direct Materials KA 27.2 4260 Lerer F. Mc Govern 5040 Direct Labor KA -34 4260 Lerer F. Mc Govern 5050 Variable Overhea KA .61.2 4265 Junior M. Ryan 4000 Sales Revenue NJ 3400 4265 Junior M. Ryan 5020 Direct Materials NJ -238 4265 Junior M. Ryan 5040 Direct Labor NJ 136 4265 Junior M. Ryan 5050 Variable Overhea NJ -170 4270 Marut K.Leeds 4000 Sales Revenue NJ 840 4270 Marut K.Leeds 5020 Direct Materials NJ -2 4270 Marut K. Leeds 5040 Direct Labor NJ 67.2 4270 Marut K. Leeds 5050 Variable Overhea NJ -420 4280 DON M. Ryan 4000 Sales Revenue KA 3600 4280 DON M. Ryan 5020 Direct Materials KA -252 4280 DON M. Ryan 5040 Direct Labor KA -144 4280 DON M. Ryan 5050 Variable Overhea KA 180 4281 Louis F. Mc Govern 4000 Sales Revenue KA 1350 4281 Louis F. Mc Govern 5020 Direct Materials KA 54 4281 Louis F. Mc Govern 5040 Direct Labor KA 67.5 4281 Louis F. Mc Govern 5050 Variable Overhea KA -121.5 4221 Mihal K.Leeds 4000 Sales Revenue AZ 1800 4221 Mihal K. Leeds 5020 Direct Materials AZ -2 4221 Mihal K. Leeds 5040 Direct Labor AZ 144 4221 Mihal K. Leeds 5050 Variable Overhea AZ -900 4299 Mihal K.Leeds 4000 Sales Revenue AZ 1100 4299 Mihal K. Leeds 5020 Direct Materials AZ -2 4299 Mihal K.Leeds 5040 Direct Labor AZ 88 4299 Mihal K. Leeds 5050 Variable Overhea AZ -550 9