Create Pivot Table(s) and determine the following information while analyzing the data:

D E G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per Unit Total Sales 2 001 04-Jan East Hanks Paper 8 $ 19.00 $ 152.00 002 04-Jan East Hanks Pens 10 $ 9.00 $ 90.00 003 05-Jan East Hanks Sticky Notes 20 $ 8.50 $ 170.00 5 004 06-Jan East Allen Envelopes 8 $ 4.50 $ 36.00 6 005 06-Jan East Smith Paper 9 $ 19.00 $ 171.00 006 07-Jan East Smith Pens 10 $ 9.00 $ 90.00 007 08-Jan South Harris Sticky Notes 23 $ 8.50 $ 195.50 9 008 08-Jan East Hanks Envelopes 9 $ 4.50 $ 40.50 10 009 09-Jan West Moore Paper 10 $ 19.00 $ 190.00 11 010 10-Jan Midwest Phillips Paper 10 $ 19.00 $ 190.00 12 011 10-Jan South Wilson Sticky Notes 25 $ 8.50 $ 212.50 13 012 11-Jan West Garcia Envelopes 10 $ 4.50 $ 45.00 14 013 12-Jan South Harris Paper 11 $ 19.00 $ 209.00 15 014 12-Jan East Allen Paper 10 $ 19.00 $ 190.00 16 015 13-Jan East Smith Sticky Notes 27 $ 8.50 $ 229.50 17 016 14-Jan West Moore Envelopes 9 $ 4.50 $ 40.50 18 017 14-Jan East Allen Paper 12 $ 19.00 $ 228.00 19 018 15-Jan West Garcia Pens 10 $ 9.00 $ 90.00 20 019 16-Jan Midwest Johnson Sticky Notes 30 $ 8.50 $ 255.00 21 020 16-Jan South Brown Envelopes 7 $ 4.50 $ 31.50 22 021 17-Jan South Brown Paper 13 $ 19.00 $ 247.00 23 022 18-Jan East Hanks Pens 10 $ 9.00 $ 90.00 24 023 18-Jan Midwest Johnson Sticky Notes 29 $ 8.50 $ 246.50 25 024 19-Jan South Brown Envelopes 12 $ 4.50 $ 54.00 28 025 20-Jan South Wilson Paper 14 $ 19.00 $ 266.00 27 026 20-Jan South Brown Pens 10 $ 9.00 $ 90.00 28 027 21-Jan East Allen Sticky Notes 28 $ 8.50 $ 238.00 29 028 22-Jan South Harris Envelopes 13 $ 4.50 $ 58.50 30 029 22-Jan Midwest Johnson Paper 15 $ 19.00 $ 285.00 31 030 23-Jan South Harris Pens 11 $ 9.00 $ 99.00 32 031 24-Jan Midwest Johnson Sticky Notes 21 $ 8.50 $ 178.50 33 032 24-Jan East Allen Envelopes 9 $ 4.50 $ 40.50 34 033 25-Jan South Harris Paper 13 $ 19.00 $ 247.00 35 034 26-Jan East Smith Paper 12 $ 19.00 $ 228.00 035 26-Jan Midwest Peters Sticky Notes 23 $ 8.50 $ 195.50 036 27-Jan South Wilson Envelopes 8 $ 4.50 $ 36.00 037 28-Jan Midwest Johnson Paper 11 $ 19.00 $ 209.00 038 28-Jan South Wilson Paper 13 $ 19.00 $ 247.00 40 039 29-Jan West Garcia Sticky Notes 24 $ 8.50 $ 204.00 41 040 30-Jan Midwest Johnson Envelopes 11 $ 4.50 $ 49.50 42 041 30-Jan East Allen Paper 8 $ 19.00 $ 152.00 43 042 31-Jan Midwest Johnson Pens 10 $ 9.00 $ 90.00 043 01-Feb Midwest Peters Sticky Notes 27 $ 8.50 $ 229.50 38 37 39 39 44 Question Page 4 Products Available Paper Pens Sticky Notes Envelopes Price per Unit $19.00 per case $ 9.00 per box $ 8.50 per package $ 4.50 per box Create Pivot Table(s) and determine the following information while analyzing the data: 1. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Product Total Units Ordered Total Sales 2. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) Rep Name Total Sales Region East Midwest South West 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales Region East Midwest South West 4. Using the data from requirement 3, determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Region East Midwest South Sales Percentage % % % % West 5. Now, using the Pivot Table, determine the monthly sales earned by each region. Identify the regions that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) Region Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month D E G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per Unit Total Sales 2 001 04-Jan East Hanks Paper 8 $ 19.00 $ 152.00 002 04-Jan East Hanks Pens 10 $ 9.00 $ 90.00 003 05-Jan East Hanks Sticky Notes 20 $ 8.50 $ 170.00 5 004 06-Jan East Allen Envelopes 8 $ 4.50 $ 36.00 6 005 06-Jan East Smith Paper 9 $ 19.00 $ 171.00 006 07-Jan East Smith Pens 10 $ 9.00 $ 90.00 007 08-Jan South Harris Sticky Notes 23 $ 8.50 $ 195.50 9 008 08-Jan East Hanks Envelopes 9 $ 4.50 $ 40.50 10 009 09-Jan West Moore Paper 10 $ 19.00 $ 190.00 11 010 10-Jan Midwest Phillips Paper 10 $ 19.00 $ 190.00 12 011 10-Jan South Wilson Sticky Notes 25 $ 8.50 $ 212.50 13 012 11-Jan West Garcia Envelopes 10 $ 4.50 $ 45.00 14 013 12-Jan South Harris Paper 11 $ 19.00 $ 209.00 15 014 12-Jan East Allen Paper 10 $ 19.00 $ 190.00 16 015 13-Jan East Smith Sticky Notes 27 $ 8.50 $ 229.50 17 016 14-Jan West Moore Envelopes 9 $ 4.50 $ 40.50 18 017 14-Jan East Allen Paper 12 $ 19.00 $ 228.00 19 018 15-Jan West Garcia Pens 10 $ 9.00 $ 90.00 20 019 16-Jan Midwest Johnson Sticky Notes 30 $ 8.50 $ 255.00 21 020 16-Jan South Brown Envelopes 7 $ 4.50 $ 31.50 22 021 17-Jan South Brown Paper 13 $ 19.00 $ 247.00 23 022 18-Jan East Hanks Pens 10 $ 9.00 $ 90.00 24 023 18-Jan Midwest Johnson Sticky Notes 29 $ 8.50 $ 246.50 25 024 19-Jan South Brown Envelopes 12 $ 4.50 $ 54.00 28 025 20-Jan South Wilson Paper 14 $ 19.00 $ 266.00 27 026 20-Jan South Brown Pens 10 $ 9.00 $ 90.00 28 027 21-Jan East Allen Sticky Notes 28 $ 8.50 $ 238.00 29 028 22-Jan South Harris Envelopes 13 $ 4.50 $ 58.50 30 029 22-Jan Midwest Johnson Paper 15 $ 19.00 $ 285.00 31 030 23-Jan South Harris Pens 11 $ 9.00 $ 99.00 32 031 24-Jan Midwest Johnson Sticky Notes 21 $ 8.50 $ 178.50 33 032 24-Jan East Allen Envelopes 9 $ 4.50 $ 40.50 34 033 25-Jan South Harris Paper 13 $ 19.00 $ 247.00 35 034 26-Jan East Smith Paper 12 $ 19.00 $ 228.00 035 26-Jan Midwest Peters Sticky Notes 23 $ 8.50 $ 195.50 036 27-Jan South Wilson Envelopes 8 $ 4.50 $ 36.00 037 28-Jan Midwest Johnson Paper 11 $ 19.00 $ 209.00 038 28-Jan South Wilson Paper 13 $ 19.00 $ 247.00 40 039 29-Jan West Garcia Sticky Notes 24 $ 8.50 $ 204.00 41 040 30-Jan Midwest Johnson Envelopes 11 $ 4.50 $ 49.50 42 041 30-Jan East Allen Paper 8 $ 19.00 $ 152.00 43 042 31-Jan Midwest Johnson Pens 10 $ 9.00 $ 90.00 043 01-Feb Midwest Peters Sticky Notes 27 $ 8.50 $ 229.50 38 37 39 39 44 Question Page 4 Products Available Paper Pens Sticky Notes Envelopes Price per Unit $19.00 per case $ 9.00 per box $ 8.50 per package $ 4.50 per box Create Pivot Table(s) and determine the following information while analyzing the data: 1. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Product Total Units Ordered Total Sales 2. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) Rep Name Total Sales Region East Midwest South West 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales Region East Midwest South West 4. Using the data from requirement 3, determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Region East Midwest South Sales Percentage % % % % West 5. Now, using the Pivot Table, determine the monthly sales earned by each region. Identify the regions that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) Region Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month