Region (AM) 2 3 Row Labels Sum of Total Sales 4 Phillips 7991.5 5 Smith 7842.5 8 Harris 7392 Wilson 7209.5 8 Johnson 7204.5 9 Hanks 7046.5 10 Peters 6643.5 11 Aben 5272.5 12 Moore 5031.5 13 Brown 4892 14 Garcia 4737.5 15 Williams 2490 18 Grand Total 73553.5 17 18 19 20 21 22 23 24 25 28 27 25 29 30 31 32 33 34 35 35 37 38 NNNNNNNN Go 40 42 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales 131,32 Region East Midwest South West 4. Using the data from requirement 3. determine the sales percentage for each region (Enter your Sales Percentage whole percent.) Region Sales Percentage Cast Midwest we 5. Now, using the Pivot Table, determine the monthly sales earned by each region Identify the regions that had the highest and lowes 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 Eaming Month 2. Which rep has the highest total sales for each r Region Total Sales Rep Name Smith East $ Midwest Phillips $ 7,642.50 7,991.50 7,392.00 South Harris $ West Moore $ 5,031.50 B4 A x V V fx 7642.5 00 1 Region East 2. 3 Row Labels - Sum of Total Sales 4 Smith 7642.5 5 Hanks 7046.5 6 Allen 5272.5 7 Grand Total 19961.5 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B 1 Region Midwest 2 3 Row Labels - sum of Total Sales 4 Phillips 7991.5 5 Johnson 7204.5 6 Peters 6843.5 Grand Total 21839.5 B 9 12 3 115 16 1T 18 19 20 21 22 23 24 25 26 B1 fx South A 1 Region 3 Row Labels -1 Sum of Total Sales 4 Harris 7392 5 Wilson 7209.5 6 Brown 4892 7 Grand Total 19493.5 14 15 10 B _ Region West Row Labels - - Sum of Total Sales Moore 5031.5 5 Garcia 4737.5 5 Williams 2490 7 Grand Total 12259 10 . 18| Region (AM) 2 3 Row Labels Sum of Total Sales 4 Phillips 7991.5 5 Smith 7842.5 8 Harris 7392 Wilson 7209.5 8 Johnson 7204.5 9 Hanks 7046.5 10 Peters 6643.5 11 Aben 5272.5 12 Moore 5031.5 13 Brown 4892 14 Garcia 4737.5 15 Williams 2490 18 Grand Total 73553.5 17 18 19 20 21 22 23 24 25 28 27 25 29 30 31 32 33 34 35 35 37 38 NNNNNNNN Go 40 42 3. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales 131,32 Region East Midwest South West 4. Using the data from requirement 3. determine the sales percentage for each region (Enter your Sales Percentage whole percent.) Region Sales Percentage Cast Midwest we 5. Now, using the Pivot Table, determine the monthly sales earned by each region Identify the regions that had the highest and lowes 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 Eaming Month 2. Which rep has the highest total sales for each r Region Total Sales Rep Name Smith East $ Midwest Phillips $ 7,642.50 7,991.50 7,392.00 South Harris $ West Moore $ 5,031.50 B4 A x V V fx 7642.5 00 1 Region East 2. 3 Row Labels - Sum of Total Sales 4 Smith 7642.5 5 Hanks 7046.5 6 Allen 5272.5 7 Grand Total 19961.5 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B 1 Region Midwest 2 3 Row Labels - sum of Total Sales 4 Phillips 7991.5 5 Johnson 7204.5 6 Peters 6843.5 Grand Total 21839.5 B 9 12 3 115 16 1T 18 19 20 21 22 23 24 25 26 B1 fx South A 1 Region 3 Row Labels -1 Sum of Total Sales 4 Harris 7392 5 Wilson 7209.5 6 Brown 4892 7 Grand Total 19493.5 14 15 10 B _ Region West Row Labels - - Sum of Total Sales Moore 5031.5 5 Garcia 4737.5 5 Williams 2490 7 Grand Total 12259 10 . 18|
