D G H 1 Order Number Order Date Region Rep Product Ordered Units Ordered Price per Unit Total Sales 8 $ 10 $ 20 $ 8 $ 9 $ 10 $ 23 $ 9 $ 19.00 $ 152.00 9.00 $ 90.00 2 001 04-Jan East Hanks Paper 002 04-Jan East Hanks Pens 003 05-Jan East Hanks Sticky Notes Envelopes Paper 8.50 $ 170.00 004 06-Jan East Allen 4.50 36.00 Smith 19.00 $ 171.00 9.00 $ 8.50 $ 195.50 005 06-Jan East East 6 006 07-Jan Smith Pens 90.00 007 08-Jan South Harris Sticky Notes Hanks Envelopes Moore Paper Midwest Phillips Paper 008 08-Jan East West 4.50 $ 19.00 $ 190.00 19.00 $ 190.00 $ 212.50 9 40.50 009 09-Jan 10 $ 10 $ 25 $ 10 010 10-Jan 10-Jan 11 011 South Wilson Sticky Notes Garcia Envelopes Paper per Sticky Notes Moore Envelopes Paper 12 8.50 012 11-Jan West 10 $ 11 $ 10 $ 27 $ 9 $ 4.50 24 $ 209.00 $ 190.00 $ 229.50 13 45.00 14 013 12-Jan South Harris 19.00 014 12-Jan East Allen 19.00 15 16 015 13-Jan East Smith 8.50 West 4.50 $ 19.00 $ 228.00 9.00 $ 8.50 $ 255.00 4.50 $ 17 016 14-Jan 40.50 017 14-Jan East Allen 12 $ 10 $ 30 $ 7 $ 13 $ 10 $ 18 018 15-Jan 16-Jan 16-Jan 19 West Garcia Pens 90.00 Midwest Johnson Sticky Notes Brown Envelopes Brown Paper Pens Midwest Johnson Sticky Notes Brown Envelopes Wilson Paper 20 019 21 020 South 31.50 021 17-Jan South 19.00 $ 247.00 22 022 18-Jan East Hanks 9.00 $ 8.50 $ 246.50 4.50 $ 19.00 $ 266.00 9.00 $ 8.50 $ 238.00 23 90.00 023 18-Jan 29 $ 12 $ 24 25 024 19-Jan South 54.00 025 20-Jan South 14 $ 10 $ 26 026 20-Jan South Brown Pens 90.00 27 Sticky Notes Envelopes 027 21-Jan East Allen 28 $ 13 $ 28 028 22-Jan South Harris Midwest Johnson Paper Harris 4.50 $ 19.00 $ 285.00 9.00 $ 8.50 $ 178.50 4.50 $ 19.00 $ 247.00 19.00 $ 228.00 8.50 $ 195.50 29 58.50 029 22-Jan 15 $ 11 $ 21 $ 9 $ 13 $ 12 $ 23 $ 8 $ 11 $ 13 $ 24 $ 30 31 030 23-Jan South Pens 99.00 031 24-Jan Midwest Johnson Sticky Notes 32 032 24-Jan East Allen Envelopes 40.50 33 Harris Paper Paper Midwest Peters Sticky Notes Wilson Envelopes Midwest Johnson Paper Wilson Paper Garcia Sticky Notes Midwest Johnson Envelopes Paper Midwest Johnson Pens Midwest Peters Sticky Notes 34 033 25-Jan South 35 034 26-Jan East Smith 38 035 26-Jan 036 27-Jan South 4.50 $ 19.00 $ 209.00 37 36.00 38 037 28-Jan 038 28-Jan South 19.00 $ 247.00 8.50 $ 204.00 39 40 039 29-Jan West 040 30-Jan 11 $ 8 $ 10 $ 27 $ 4.50 24 49.50 $ 152.00 $4 41 42 041 30-Jan East Allen 19.00 042 9.00 31-Jan 01-Feb 43 90.00 44 043 8.50 $ 229.50 Products Available Price per Unit $19.00 per case $ 9.00 per box $ 8.50 per package $ 4.50 per box Paper Pens Sticky Notes Envelopes 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.) Region Rep Name Total Sales East Midwest South West 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Region Total Sales 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.) Sales Region Percentage % % % East Midwest South 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