Question
Calculate the total sales based on each Region 2.Total Sales, Total Units and Average Unit selling price for the entire data sheet 3. Create Pivot
Calculate the total sales based on each Region
2.Total Sales, Total Units and Average Unit selling price for the entire data sheet
3. Create Pivot table , based on Rep and Item, to show total sales by each Rep for each item, divided by Region (column).
| OrderDate | Region | Rep | Item | Units | UnitCost | Total |
| 6/1/2020 | East | Jones | Eraser | 95 | 1.99 | 189.05 |
| 1/23/2020 | Central | Kivell | Binder | 50 | 19.99 | 999.5 |
| 9/2/2020 | Central | Jardine | Eraser | 36 | 4.99 | 179.64 |
| 2/26/2020 | Central | Gill | Pen | 27 | 19.99 | 539.73 |
| 3/15/2020 | West | Sorvino | Eraser | 56 | 2.99 | 167.44 |
| 1/4/2020 | East | Jones | Binder | 60 | 4.99 | 299.4 |
| 4/18/2020 | Central | Andrews | Eraser | 75 | 1.99 | 149.25 |
| 5/5/2020 | Central | Jardine | Eraser | 90 | 4.99 | 449.1 |
| 5/22/2020 | West | Thompson | Eraser | 32 | 1.99 | 63.68 |
| 8/6/2020 | East | Jones | Binder | 60 | 8.99 | 539.4 |
| 6/25/2020 | Central | Morgan | Eraser | 90 | 4.99 | 449.1 |
| 12/7/2020 | East | Howard | Binder | 29 | 1.99 | 57.71 |
| 7/29/2020 | East | Parent | Binder | 81 | 19.99 | 1,619.19 |
| 8/15/2020 | East | Jones | Eraser | 35 | 4.99 | 174.65 |
| 1/9/2020 | Central | Smith | Desk | 2 | 125 | 250 |
| 9/18/2020 | East | Jones | Pen Set | 16 | 15.99 | 255.84 |
| 5/10/2020 | Central | Morgan | Binder | 28 | 8.99 | 251.72 |
| 10/22/2020 | East | Jones | Pen | 64 | 8.99 | 575.36 |
| 8/11/2020 | East | Parent | Pen | 15 | 19.99 | 299.85 |
| 11/25/2020 | Central | Kivell | Pen Set | 96 | 4.99 | 479.04 |
| 12/12/2020 | Central | Smith | Eraser | 67 | 1.29 | 86.43 |
| 12/29/2020 | East | Parent | Pen Set | 74 | 15.99 | 1,183.26 |
| 1/15/2021 | Central | Gill | Binder | 46 | 8.99 | 413.54 |
| 1/2/2021 | Central | Smith | Binder | 87 | 15 | 1,305.00 |
| 2/18/2021 | East | Jones | Binder | 4 | 4.99 | 19.96 |
| 7/3/2021 | West | Sorvino | Binder | 7 | 19.99 | 139.93 |
| 3/24/2021 | Central | Jardine | Pen Set | 50 | 4.99 | 249.5 |
| 10/4/2021 | Central | Andrews | Eraser | 66 | 1.99 | 131.34 |
| 4/27/2021 | East | Howard | Pen | 96 | 4.99 | 479.04 |
| 5/14/2021 | Central | Gill | Eraser | 53 | 1.29 | 68.37 |
| 5/31/2021 | Central | Gill | Binder | 80 | 8.99 | 719.2 |
| 6/17/2021 | Central | Kivell | Desk | 5 | 125 | 625 |
| 4/7/2021 | East | Jones | Pen Set | 62 | 4.99 | 309.38 |
| 7/21/2021 | Central | Morgan | Pen Set | 55 | 12.49 | 686.95 |
| 7/8/2021 | Central | Kivell | Pen Set | 42 | 23.95 | 1,005.90 |
| 8/24/2021 | West | Sorvino | Desk | 3 | 275 | 825 |
| 10/9/2021 | Central | Gill | Eraser | 7 | 1.29 | 9.03 |
| 9/27/2021 | West | Sorvino | Pen | 76 | 1.99 | 151.24 |
| 10/14/2021 | West | Thompson | Binder | 57 | 19.99 | 1,139.43 |
| 10/31/2021 | Central | Andrews | Eraser | 14 | 1.29 | 18.06 |
| 11/17/2021 | Central | Jardine | Binder | 11 | 4.99 | 54.89 |
Step by Step Solution
3.44 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
1Calculating total sales based on each region using pivot tableexcel Region Sum of Total sales Central 912029 East 600209 West 248672 Grand Total 1760...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial and Managerial Accounting
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
12th edition
978-1133952428, 1285078578, 1133952429, 978-1285078571
