3) What customer (ID) has made the most $$$ purchases?

4) What product (ID) has the most number of units sold?

5) What is the Average Order $$$ amount?

Now your boss is under pressure from the Auditors. They feel that Revenue has not been recorded properly from 2005-2008. Your boss wants your recommendation as to what revenue amounts should be recorded for the years 2005-2008.

6) What is your recommendation to record the Breakdown of the $$$ Amount of Revenue by Year for (and make sure to describe how and why (simple, short explanation) you came up with this breakdown/solution):

a. 2005

b. 2006

c.2007

d. 2008

And finally, your boss wants one last thing (since he doesnt know anything about PivotTables & you need to create a generic one that he can use):

7) In the PivotTable tab (worksheet), create a multi-level pivot table where you can calculate Sales $$$ or Quantities by Customer, Territory, Product and/or Salesperson.

I included a screenshot of what the excel sheet looks like. I just need help figuring out which excel formulas and procedures to use to get the results needed

E F . 1 1 NM0009 836 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 861 B D DueDate ShipDate Sales Order Number 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 SO50215 5/13/07 0:00 5/8/07 0:00 SO50215 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 SO50216 5/13/07 0:00 5/8/07 0:00 SO50216 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050218 5/13/07 0:00 5/8/07 0:00 SO50218 5/13/07 0:00 5/8/07 0:00 S050218 Download Working Pivot Table CustomerID 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 29571 29571 29571 29571 29571 29816 29816 29816 29816 29816 29816 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 29953 29953 29953 Sales PersonID 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 284 284 284 284 284 283 283 283 283 283 283 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 284 284 284 + TerritoryID Productid 819 4 820 4 765 4 762 4 791 4 763 4 729 4 726 4 738 4 792 4 4 801 4 760 4 793 4 730 4 761 4 790 4 800 1 863 1 783 1 782 1 861 1 779 1 712 1 715 1 854 1 1 782 1 862 1 809 1 787 1 781 1 743 1 802 1 863 1 782 1 784 1 860 1 831 1 785 1 747 1 825 1 814 1 808 1 832 1 779 1 748 1 804 1 742 1 739 1 815 1 806 1 857 1 715 1 712 OrderQty Unit Price 2 149.031 4 198.036 469.794 1 469.794 2 1466.01 2 469.794 3 202.332 2 202.332 2 183.9382 4 1308.9375 4 324.4527 2 600.2625 1 469.794 3 1308.9375 1 202.332 1 469.794 4 1466.01 2 600.2625 2 22.794 1 1229.4589 1 1229.4589 2 22.794 1 1242.8518 3 5.1865 2 28.8404 1 44.994 2 22.794 1 1229.4589 4 22.794 1 33.7745 3 647.994 4 1242.8518 1 736.1455 2 88.932 3 22.794 6 1229.4589 2 1229.4589 1 14.1289 3 209.256 3 647.994 3 736.1455 4 196.329 1 209.256 1 24.2945 4 209.256 3 1242.8518 3 744.2727 1 137.694 1 744.2727 1 744.2727 3 36,447 4 61.374 53.994 5 28.8404 10 5.1865 LineTotal 298.062 792.144 1879.176 469.794 2932.02 939.588 606.996 404.664 367.8764 5235.75 1297.8108 1200.525 469.794 3926.8125 202.332 469.794 5864.04 1200.525 45.588 1229.4589 1229.4589 45.588 1242.8518 15.5595 57.6808 44.994 45.588 1229.4589 91.176 33.7745 1943.982 4971.4072 736.1455 177.864 68.382 7376.7534 2458.9178 14.1289 627.768 1943.982 2208.4365 785.316 209.256 24.2945 837.024 3728.5554 2232.8181 137.694 744.2727 744.2727 109.341 245,496 215.976 144.202 51.865 45 46 47 48 49 50 51 52 53 54 55 56 Answers E F . 1 1 NM0009 836 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 861 B D DueDate ShipDate Sales Order Number 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050214 5/13/07 0:00 5/8/07 0:00 SO50214 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 SO50215 5/13/07 0:00 5/8/07 0:00 SO50215 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 S050215 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 S050216 5/13/07 0:00 5/8/07 0:00 SO50216 5/13/07 0:00 5/8/07 0:00 SO50216 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 SO50217 5/13/07 0:00 5/8/07 0:00 S050218 5/13/07 0:00 5/8/07 0:00 SO50218 5/13/07 0:00 5/8/07 0:00 S050218 Download Working Pivot Table CustomerID 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 30094 29571 29571 29571 29571 29571 29816 29816 29816 29816 29816 29816 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 30107 29953 29953 29953 Sales PersonID 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 284 284 284 284 284 283 283 283 283 283 283 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 276 284 284 284 + TerritoryID Productid 819 4 820 4 765 4 762 4 791 4 763 4 729 4 726 4 738 4 792 4 4 801 4 760 4 793 4 730 4 761 4 790 4 800 1 863 1 783 1 782 1 861 1 779 1 712 1 715 1 854 1 1 782 1 862 1 809 1 787 1 781 1 743 1 802 1 863 1 782 1 784 1 860 1 831 1 785 1 747 1 825 1 814 1 808 1 832 1 779 1 748 1 804 1 742 1 739 1 815 1 806 1 857 1 715 1 712 OrderQty Unit Price 2 149.031 4 198.036 469.794 1 469.794 2 1466.01 2 469.794 3 202.332 2 202.332 2 183.9382 4 1308.9375 4 324.4527 2 600.2625 1 469.794 3 1308.9375 1 202.332 1 469.794 4 1466.01 2 600.2625 2 22.794 1 1229.4589 1 1229.4589 2 22.794 1 1242.8518 3 5.1865 2 28.8404 1 44.994 2 22.794 1 1229.4589 4 22.794 1 33.7745 3 647.994 4 1242.8518 1 736.1455 2 88.932 3 22.794 6 1229.4589 2 1229.4589 1 14.1289 3 209.256 3 647.994 3 736.1455 4 196.329 1 209.256 1 24.2945 4 209.256 3 1242.8518 3 744.2727 1 137.694 1 744.2727 1 744.2727 3 36,447 4 61.374 53.994 5 28.8404 10 5.1865 LineTotal 298.062 792.144 1879.176 469.794 2932.02 939.588 606.996 404.664 367.8764 5235.75 1297.8108 1200.525 469.794 3926.8125 202.332 469.794 5864.04 1200.525 45.588 1229.4589 1229.4589 45.588 1242.8518 15.5595 57.6808 44.994 45.588 1229.4589 91.176 33.7745 1943.982 4971.4072 736.1455 177.864 68.382 7376.7534 2458.9178 14.1289 627.768 1943.982 2208.4365 785.316 209.256 24.2945 837.024 3728.5554 2232.8181 137.694 744.2727 744.2727 109.341 245,496 215.976 144.202 51.865 45 46 47 48 49 50 51 52 53 54 55 56 Answers