Module Two Homework

ModuleTwoHomework_1 xSalesPivot.xls
  

Module Two Homework

Answer the following questions in a Word document.

1) If you have not done so already, download the sales pivot file in the Module Two Resources folder. Using the pivot table sales resource, which sales person had the highest total sales for the:
UK?
USA?
Overall?
How many orders were placed on 2/18/2005?
What were the total sales for that day?

2) Name at least two types of sales analyses that the controller might perform for the sales team. How would these help the sales team?

3) Breakeven Questions
What are the breakeven points for Widgets A, B, and C given the following information?
Fixed costs for A = 500, B = 500, C = 500
Pricing for A = $20, B= $30, C = $40
Variable costs for A =$10, B= $5, C= $20
Breakeven A =  __________
Breakeven B =  __________
Breakeven C =  __________
Suppose the sales manager wanted to discuss lowering the price of product C to $15. What would you tell him?
Which product is the most profitable if 60 units of each were sold?

4) Think of any large company. Look up their mission statement. What is their mission statement? Do you think this company lives up to their mission statement?  Why or why not?

5) If you had as much money as Bill Gates and decided to create any company you wanted, what would your business be? What would your mission statement be? How did you come up with this statement? What aspects of your business did you think about to determine your statement?

6) List several pros and cons of using only one fixed budget for the year.

ATTACHED FILE(S)

Module Two Homework

Answer the following questions in a Word document.

1) If you have not done so already, download the sales pivot file in the Module Two Resources folder. Using the pivot table sales resource, which sales person had the highest total sales for the:
UK?
USA?
Overall?
How many orders were placed on 2/18/2005?
What were the total sales for that day?

2) Name at least two types of sales analyses that the controller might perform for the sales team. How would these help the sales team?

3) Breakeven Questions
What are the breakeven points for Widgets A, B, and C given the following information?
Fixed costs for A = 500, B = 500, C = 500
Pricing for A = $20, B= $30, C = $40
Variable costs for A =$10, B= $5, C= $20
Breakeven A = __________
Breakeven B =  __________
Breakeven C =  __________
Suppose the sales manager wanted to discuss lowering the price of product C to $15. What would you tell him?
Which product is the most profitable if 60 units of each were sold?

4) Think of any large company. Look up their mission statement. What is their mission statement? Do you think this company lives up to their mission statement?  Why or why not?

5) If you had as much money as Bill Gates and decided to create any company you wanted, what would your business be? What would your mission statement be? How did you come up with this statement? What aspects of your business did you think about to determine your statement?

6) List several pros and cons of using only one fixed budget for the year.

SourceData

UK

USA Peacock

UK

USA

7/15/03

UK

USA Leverling 7/16/03

USA Leverling

USA Peacock

UK Buchanan

USA

7/23/03

USA

USA Peacock 7/25/03

USA Peacock

USA Peacock

UK Dodsworth

USA Leverling 7/31/03

USA Callahan

USA Davolio 8/2/03

USA Peacock

UK Suyama 8/6/03

UK Buchanan

USA Davolio 8/9/03

USA

USA Leverling 8/12/03

USA Fuller

USA Callahan

USA Callahan

USA Callahan 8/16/03

UK Suyama 8/16/03

USA Peacock

USA Peacock 8/21/03

USA Leverling

UK Suyama 8/23/03

USA Davolio

USA Peacock

USA Callahan

UK

8/28/03

USA Callahan

UK Suyama 8/30/03

USA Davolio

USA Callahan

USA Peacock 9/3/03

UK Suyama

USA Peacock

UK Buchanan

USA Fuller 9/10/03

USA Davolio

UK Suyama 9/11/03

UK Suyama 9/11/03

USA Fuller

USA Peacock

USA Callahan

USA Davolio 9/17/03

USA Fuller

UK King 9/18/03

USA Davolio

UK King

USA Fuller

USA Davolio

USA Callahan

USA Fuller

USA Peacock 10/3/03

USA Callahan

USA Davolio 10/4/03

USA Fuller 10/4/03

USA Davolio

USA Callahan

USA Peacock 10/9/03

UK Dodsworth

UK Suyama 10/10/03

UK King

USA Leverling 10/11/03

USA Davolio

USA Fuller 10/14/03

USA Peacock 10/14/03

USA Peacock 10/14/03

USA Peacock

UK Buchanan

UK Dodsworth

USA Leverling 10/21/03

UK King

USA Leverling 10/23/03

USA Peacock 10/23/03

UK King

UK Buchanan

UK King 10/25/03

USA Callahan

USA Leverling 10/28/03

USA Peacock

USA Peacock 10/29/03

USA Fuller

USA Peacock 11/4/03

UK King

USA Peacock 11/5/03

USA Peacock

USA Davolio

USA Leverling 11/8/03

USA Peacock 11/8/03

USA Fuller

UK King

USA Peacock 11/15/03

USA Leverling

USA Callahan

USA Davolio 11/20/03

UK Suyama 11/20/03

UK King

UK Buchanan

UK Buchanan

UK Suyama 11/27/03

USA Leverling

USA Davolio

USA Fuller 12/2/03

UK King 12/2/03

USA Leverling 12/2/03

USA Peacock 12/2/03

USA Davolio

UK Suyama 12/3/03

USA Davolio

USA Peacock 12/4/03

UK Buchanan

USA Callahan 12/9/03

USA Davolio 12/9/03

USA Leverling 12/9/03

USA Peacock

USA Davolio

USA Davolio 12/13/03

USA Fuller 12/13/03

USA Leverling 12/13/03

$112.00

USA Peacock

USA Callahan

UK Buchanan

USA Davolio

USA Fuller 12/20/03

USA Leverling 12/20/03

USA Davolio

USA Davolio

USA Peacock 12/24/03

UK Dodsworth

UK Suyama

UK Suyama

USA Callahan

USA Leverling

USA Fuller

UK Buchanan

UK Dodsworth 1/2/04

USA Davolio

USA Davolio 1/3/04

UK Suyama 1/3/04

USA Davolio

USA Callahan

USA Fuller 1/8/04

USA Fuller

USA Peacock 1/9/04

USA Callahan

USA Davolio 1/10/04

UK King

USA Callahan

USA Leverling 1/14/04

USA Callahan

USA Leverling 1/15/04

USA Callahan

USA Davolio 1/16/04

USA Leverling 1/16/04

USA Fuller

UK Dodsworth

USA Davolio

USA Leverling

USA Peacock 1/24/04

USA Callahan

USA Callahan 1/27/04

UK King 1/27/04

USA Leverling 1/27/04

USA Peacock

USA Fuller

USA Peacock 1/30/04

USA Fuller

USA Peacock

UK King

USA Peacock

USA Callahan

USA Leverling 2/7/04

USA Leverling 2/7/04

USA Peacock 2/7/04

UK Suyama

USA Leverling

USA Callahan

USA Leverling

USA Callahan

USA Leverling 2/14/04

UK Suyama 2/14/04

USA Leverling

UK Suyama

USA Leverling

USA Leverling

USA Peacock

UK Suyama 2/24/04

USA Peacock

USA Callahan

USA Davolio 2/26/04

USA Leverling

USA Callahan

USA Peacock 2/28/04

USA Peacock 2/28/04

USA Callahan

USA Callahan 3/3/04

USA Fuller 3/3/04

$1,584.00

USA Peacock 3/3/04

UK King

USA Leverling 3/4/04

USA Davolio

UK Buchanan

USA Peacock

USA Callahan

USA Callahan 3/11/04

USA Leverling

USA Peacock 3/12/04

USA Peacock

USA Davolio

USA Davolio 3/14/04

USA Leverling 3/14/04

USA Peacock 3/14/04

USA Peacock 3/14/04

USA Fuller

USA Fuller 3/18/04

USA Callahan

UK Buchanan

USA Davolio 3/21/04

USA Leverling 3/21/04

USA Callahan

UK Suyama 3/24/04

UK Buchanan

USA Callahan 3/25/04

USA Fuller

USA Fuller

USA Peacock

$1,584.00

USA Leverling

USA Callahan

USA Davolio 4/2/04

UK King

UK Dodsworth

UK King

UK King 4/7/04

USA Callahan

USA Peacock

UK Suyama 4/9/04

USA Davolio

USA Peacock 4/10/04

USA Callahan

USA Leverling 4/11/04

$851.20

USA Leverling 4/11/04

UK Dodsworth

USA Peacock 4/16/04

UK Suyama 4/16/04

UK Suyama

USA Peacock

USA Leverling

USA Peacock 4/21/04

UK King

UK King

UK King

UK King

UK Suyama 4/28/04

USA Fuller

USA Leverling 4/29/04

USA Peacock 4/29/04

USA Fuller

UK King 5/1/04

UK Suyama 5/1/04

USA Callahan

UK Dodsworth 5/2/04

USA Peacock

USA Peacock

USA Davolio

UK King 5/7/04

UK Buchanan

UK Suyama 5/9/04

UK King

USA Leverling 5/12/04

USA Davolio

USA Callahan

USA Peacock

UK Dodsworth

USA Leverling 5/16/04

USA Davolio

UK King 5/19/04

USA Peacock

USA Callahan

USA Callahan

USA Davolio 5/23/04

USA Fuller 5/23/04

UK Suyama 5/23/04

USA Davolio

USA Davolio

USA Fuller

UK Buchanan

UK King 5/30/04

USA Peacock 5/30/04

USA Leverling

USA Leverling 6/2/04

USA Fuller

UK Suyama

USA Fuller

USA Peacock 6/5/04

UK Dodsworth

UK King 6/6/04

USA Leverling 6/6/04

USA Peacock 6/6/04

USA Callahan

USA Fuller 6/9/04

USA Davolio

USA Davolio

USA Fuller

USA Leverling 6/13/04

UK Suyama 6/13/04

USA Peacock

USA Davolio

USA Callahan

UK Dodsworth 6/18/04

USA Leverling

UK King

USA Fuller

USA Leverling

USA Callahan

UK Buchanan

UK Dodsworth 6/30/04

USA Leverling 6/30/04

USA Peacock 6/30/04

USA Peacock

USA Leverling

USA Callahan

USA Davolio 7/4/04

USA Fuller 7/4/04

USA Peacock 7/4/04

USA Davolio

UK Dodsworth 7/9/04

USA Leverling 7/9/04

USA Fuller

UK King 7/10/04

UK Buchanan

USA Callahan

USA Fuller 7/14/04

USA Leverling 7/14/04

USA Peacock 7/14/04

USA Davolio

USA Leverling 7/16/04

USA Leverling 7/16/04

USA Davolio

UK King 7/18/04

USA Peacock

UK Suyama 7/21/04

USA Callahan

UK King 7/22/04

UK Buchanan

USA Peacock 7/25/04

USA Davolio

USA Davolio 7/29/04

UK King

$424.00

USA Peacock

USA Callahan

USA Davolio 8/1/04

USA Peacock 8/1/04

USA Peacock 8/1/04

UK Suyama 8/1/04

USA Peacock

USA Davolio

USA Callahan

USA Fuller 8/6/04

USA Leverling

USA Callahan

USA Davolio 8/8/04

USA Peacock

USA Peacock 8/11/04

USA Callahan

USA Callahan 8/12/04

UK King

USA Fuller

USA Leverling 8/14/04

USA Callahan

UK King

USA Callahan

USA Davolio 8/19/04

USA Peacock 8/19/04

USA Davolio

USA Peacock 8/20/04

USA Peacock 8/20/04

USA Callahan

USA Callahan 8/21/04

USA Peacock 8/21/04

USA Peacock

USA Peacock 8/26/04

UK Suyama 8/26/04

UK King

USA Peacock

UK Buchanan

USA Leverling

USA Leverling 9/1/04

USA Peacock

UK Suyama 9/2/04

UK Buchanan

UK Dodsworth 9/3/04

USA Peacock 9/3/04

UK King

USA Peacock

USA Peacock 9/8/04

UK Buchanan

UK King

UK Suyama 9/10/04

UK Buchanan

USA Callahan 9/11/04

USA Davolio 9/11/04

USA Fuller

UK King 9/15/04

USA Davolio

USA Leverling

USA Peacock 9/18/04

USA Davolio

USA Davolio 9/19/04

USA Fuller 9/19/04

UK King 9/19/04

USA Fuller

UK King 9/22/04

UK Buchanan

USA Davolio 9/23/04

USA Davolio

USA Davolio

USA Davolio 9/26/04

UK Dodsworth 9/26/04

USA Fuller

USA Callahan

USA Leverling 9/30/04

USA Leverling 9/30/04

USA Peacock 9/30/04

USA Fuller

USA Leverling 10/1/04

USA Davolio

USA Fuller 10/3/04

USA Peacock 10/3/04

USA Davolio

USA Peacock 10/7/04

USA Fuller

USA Callahan

USA Leverling

USA Leverling

USA Peacock 10/13/04

USA Callahan

UK King 10/14/04

USA Leverling 10/14/04

USA Callahan

UK Suyama 10/15/04

UK King

USA Leverling 10/16/04

USA Peacock

UK Suyama

USA Callahan

USA Peacock 10/21/04

$330.00

USA Fuller

USA Davolio

USA Peacock 10/23/04

USA Davolio

UK Buchanan

USA Peacock 10/27/04

UK Buchanan

USA Davolio 10/29/04

USA Davolio 10/29/04

USA Leverling 10/29/04

$1,296.00

UK Dodsworth

UK Buchanan

USA Leverling 10/31/04

USA Callahan

USA Callahan

USA Callahan 11/5/04

USA Callahan 11/5/04

USA Peacock 11/5/04

UK Suyama 11/5/04

USA Leverling

$360.00

UK Suyama 11/7/04

USA Davolio

USA Peacock

USA Fuller

UK Buchanan

USA Callahan 11/14/04

UK King 11/14/04

USA Leverling

$240.00

UK Dodsworth

USA Fuller 11/18/04

$139.80

USA Fuller 11/18/04

USA Leverling 11/18/04

USA Peacock 11/18/04

USA Davolio

USA Davolio

$319.20

USA Davolio 11/21/04

UK Dodsworth 11/21/04

UK Suyama 11/21/04

UK Dodsworth

UK Suyama 11/24/04

USA Leverling

USA Peacock 11/25/04

UK Suyama

UK Dodsworth

USA Leverling 11/27/04

UK Suyama 11/27/04

USA Fuller

USA Leverling 11/28/04

USA Peacock 11/28/04

USA Callahan

USA Leverling

USA Leverling

USA Fuller

USA Peacock 12/5/04

UK Buchanan

USA Leverling 12/8/04

UK Suyama 12/8/04

USA Leverling

USA Leverling 12/9/04

USA Peacock 12/9/04

USA Peacock

USA Leverling

USA Leverling 12/12/04

USA Peacock 12/12/04

USA Leverling

USA Peacock 12/15/04

UK Suyama 12/15/04

USA Davolio

USA Callahan

USA Davolio

USA Fuller

USA Leverling 12/19/04

USA Peacock 12/19/04

USA Peacock 12/19/04

UK Dodsworth

USA Peacock 12/22/04

USA Callahan

USA Davolio

USA Leverling 12/24/04

USA Fuller

$720.00

USA Fuller

UK King 12/26/04

$228.00

UK Suyama 12/26/04

USA Davolio

USA Davolio 12/31/04

USA Peacock 12/31/04

UK Suyama

USA Peacock

UK Suyama 1/2/05

USA Davolio

UK Dodsworth 1/5/05

USA Fuller 1/5/05

UK King 1/5/05

$420.00

USA Leverling 1/5/05

USA Peacock

USA Fuller

UK King 1/7/05

UK Suyama 1/7/05

USA Callahan

USA Leverling 1/8/05

USA Davolio

USA Fuller 1/9/05

USA Fuller 1/9/05

UK Buchanan

UK King 1/12/05

UK Buchanan

USA Leverling 1/13/05

USA Leverling 1/13/05

USA Davolio

USA Fuller 1/14/05

USA Leverling 1/14/05

USA Leverling 1/14/05

USA Leverling 1/14/05

USA Davolio

USA Fuller

$477.00

UK Suyama 1/16/05

USA Davolio

USA Davolio 1/19/05

USA Fuller 1/19/05

USA Callahan

USA Davolio

UK King 1/21/05

UK King 1/21/05

USA Peacock 1/21/05

USA Leverling

UK Dodsworth

UK Dodsworth 1/23/05

USA Fuller 1/23/05

USA Leverling 1/23/05

USA Leverling 1/23/05

UK Suyama 1/23/05

USA Callahan

USA Peacock 1/26/05

UK Buchanan

USA Davolio 1/29/05

UK King 1/29/05

USA Callahan

USA Callahan 1/30/05

USA Callahan 1/30/05

USA Davolio 1/30/05

UK Dodsworth 1/30/05

USA Peacock 1/30/05

UK Buchanan

USA Callahan 2/2/05

USA Davolio 2/2/05

UK Dodsworth

USA Fuller 2/3/05

UK Dodsworth

USA Leverling 2/4/05

USA Leverling 2/4/05

USA Peacock 2/4/05

USA Leverling

USA Callahan

USA Davolio 2/6/05

UK Suyama 2/6/05

UK Buchanan

UK Buchanan 2/9/05

USA Peacock 2/9/05

USA Peacock 2/9/05

UK Dodsworth

USA Leverling 2/10/05

$660.00

USA Peacock 2/10/05

UK Buchanan

$310.00

UK Suyama 2/11/05

UK Buchanan

USA Fuller 2/12/05

UK King 2/12/05

USA Leverling 2/12/05

USA Peacock 2/12/05

UK Buchanan

USA Peacock 2/13/05

USA Callahan

USA Peacock 2/16/05

USA Peacock

USA Peacock 2/17/05

UK King

UK King 2/18/05

USA Peacock 2/18/05

UK Suyama 2/18/05

USA Davolio

UK King 2/19/05

USA Peacock 2/19/05

USA Callahan

USA Davolio 2/20/05

UK Dodsworth 2/20/05

USA Peacock 2/20/05

USA Davolio

UK Dodsworth 2/23/05

UK King 2/23/05

USA Leverling 2/23/05

USA Leverling

UK Buchanan

USA Peacock 2/26/05

$934.50

UK King

USA Leverling 2/27/05

UK Suyama 2/27/05

USA Davolio

USA Fuller 3/2/05

UK Suyama 3/2/05

USA Davolio

USA Peacock 3/3/05

USA Peacock 3/3/05

USA Davolio

USA Davolio 3/4/05

USA Fuller 3/4/05

USA Leverling 3/4/05

USA Peacock 3/4/05

UK Buchanan

USA Leverling 3/5/05

UK Dodsworth

USA Peacock 3/6/05

USA Peacock 3/6/05

USA Davolio

USA Davolio 3/9/05

USA Peacock 3/9/05

USA Davolio

USA Leverling

USA Peacock 3/11/05

USA Peacock 3/11/05

USA Leverling

$500.00

UK Suyama 3/12/05

USA Fuller

UK King 3/13/05

UK King 3/13/05

USA Leverling 3/13/05

UK Suyama 3/13/05

USA Leverling

USA Leverling 3/16/05

UK Suyama 3/16/05

USA Fuller

USA Davolio

UK Dodsworth 3/18/05

$560.00

USA Fuller 3/18/05

USA Leverling 3/18/05

USA Peacock 3/18/05

USA Peacock 3/18/05

USA Peacock 3/18/05

USA Davolio

USA Leverling 3/19/05

USA Peacock 3/19/05

USA Peacock 3/19/05

UK Buchanan

USA Callahan 3/20/05

UK King 3/20/05

UK Suyama 3/20/05

USA Callahan

$360.00

USA Callahan 3/23/05

USA Davolio 3/23/05

$110.00

UK Suyama 3/23/05

USA Callahan

USA Davolio 3/24/05

$471.20

USA Leverling 3/24/05

UK Dodsworth

UK Dodsworth

USA Peacock 3/26/05

USA Callahan

USA Davolio 3/27/05

UK King 3/27/05

UK Suyama 3/27/05

USA Callahan

$1,119.90

USA Davolio 3/30/05

UK Suyama 3/30/05

USA Callahan

USA Davolio

USA Davolio

USA Fuller 4/2/05

USA Fuller 4/2/05

USA Fuller 4/2/05

USA Fuller 4/2/05

USA Davolio

$912.00

USA Davolio 4/3/05

USA Davolio 4/3/05

USA Leverling 4/3/05

USA Callahan

USA Davolio 4/6/05

USA Fuller 4/6/05

USA Davolio

$2,296.00

UK Dodsworth 4/7/05

USA Fuller 4/7/05

USA Fuller

USA Leverling 4/8/05

USA Leverling 4/8/05

USA Leverling 4/8/05

USA Peacock 4/8/05

USA Peacock 4/8/05

USA Fuller

USA Callahan

USA Fuller 4/10/05

USA Fuller 4/10/05

USA Fuller 4/10/05

UK King 4/10/05

USA Leverling 4/10/05

USA Peacock 4/10/05

$560.00

UK Suyama 4/10/05

USA Callahan

USA Callahan 4/13/05

UK Dodsworth 4/13/05

USA Leverling 4/13/05

USA Fuller

USA Fuller 4/14/05

USA Fuller

USA Leverling 4/15/05

USA Fuller

USA Peacock 4/16/05

USA Peacock 4/16/05

USA Callahan

USA Davolio 4/17/05

USA Peacock 4/17/05

USA Davolio

UK Dodsworth 4/20/05

USA Fuller 4/20/05

USA Leverling 4/20/05

USA Peacock 4/20/05

USA Callahan

USA Fuller 4/21/05

USA Leverling 4/21/05

USA Callahan

USA Fuller 4/22/05

UK Dodsworth

USA Fuller 4/23/05

UK King 4/23/05

USA Callahan

USA Davolio 4/24/05

$1,500.00

UK Dodsworth 4/24/05

$224.00

USA Fuller 4/24/05

UK Suyama 4/24/05

UK Suyama 4/24/05

USA Callahan

UK King 4/27/05

UK King 4/27/05

USA Peacock 4/27/05

USA Leverling

USA Peacock 4/28/05

UK Buchanan

$210.00

USA Fuller 4/29/05

USA Davolio

UK King 4/30/05

USA Callahan

USA Fuller 5/1/05

UK King 5/1/05

USA Leverling 5/1/05

USA Leverling 5/1/05

$45.00

USA Peacock 5/1/05

Country Salesperson Order Date OrderID Order Amount
Suyama 7/10/03 10249 $1,863.40
USA Peacock 7/11/03 10252 $3,597.90
7/12/03 10250 $1,552.60
Dodsworth 7/15/03 10255 $2,490.50
Leverling 10251 $654.06
Buchanan 7/16/03 10248 $440.00
10253 $1,444.80
7/17/03 10256 $517.80
7/22/03 10257 $1,119.90
7/23/03 10254 $556.62
Davolio 10258 $1,614.88
Callahan 7/25/03 10262 $584.00
10259 $100.80
7/29/03 10260 $1,504.65
7/30/03 10261 $448.00
7/31/03 10263 $1,873.80
10266 $346.56
8/2/03 10268 $1,101.20
10270 $1,376.00
8/6/03 10267 $3,536.60
10272 $1,456.00
8/9/03 10269 $642.20
10275 $291.84
Fuller 8/12/03 10265 $1,176.00
10273 $2,037.28
8/13/03 10277 $1,200.80
8/14/03 10276 $420.00
8/16/03 10278 $1,488.80
10279 $351.00
10274 $538.60
8/21/03 10281 $86.50
10282 $155.40
8/23/03 10283 $1,414.80
10264 $695.62
8/26/03 10285 $1,743.36
8/27/03 10284 $1,170.37
8/28/03 10287 $819.00
King 10289 $479.40
8/30/03 10286 $3,016.00
10271 $48.00
9/2/03 10292 $1,296.00
9/3/03 10290 $2,169.00
10288 $80.10
9/4/03 10291 $497.52
9/5/03 10294 $1,887.60
9/10/03 10297 $1,420.00
10295 $121.60
9/11/03 10293 $848.70
10296 $1,050.60
10298 $2,645.00
9/12/03 10280 $613.20
9/13/03 10299 $349.50
9/17/03 10301 $755.00
10304 $954.40
9/18/03 10300 $608.00
10303 $1,117.80
9/23/03 10306 $498.50
9/24/03 10308 $88.80
9/25/03 10307 $424.00
9/26/03 10311 $268.80
9/27/03 10310 $336.00
10/3/03 10312 $1,614.80
10315 $516.80
10/4/03 10318 $240.40
10314 $2,094.30
10313 $182.40
10/8/03 10316 $2,835.00
10/9/03 10305 $3,741.30
10302 $2,708.80
10/10/03 10324 $5,275.71
10317 $288.00
10/11/03 10319 $1,191.20
10321 $144.00
10/14/03 10325 $1,497.00
10327 $1,810.00
10323 $164.40
10326 $982.00
10/17/03 10328 $1,168.00
10/18/03 10320 $516.00
10/21/03 10331 $88.50
10332 $1,786.88
10/23/03 10322 $112.00
10309 $1,762.00
10329 $4,578.43
10/24/03 10335 $2,036.16
10/25/03 10333 $877.20
10336 $285.12
10/28/03 10334 $144.80
10330 $1,649.00
10/29/03 10337 $2,467.00
10338 $934.50
11/4/03 10339 $3,354.00
10342 $1,840.64
11/5/03 10341 $352.60
10344 $2,296.00
11/6/03 10343 $1,584.00
11/8/03 10340 $2,436.18
10346 $1,618.88
10347 $814.42
11/11/03 10345 $2,924.80
11/15/03 10349 $141.60
10348 $363.60
11/18/03 10352 $136.30
11/20/03 10354 $568.80
10351 $5,398.72
10355 $480.00
11/25/03 10353 $8,593.28
11/26/03 10359 $3,471.68
11/27/03 10358 $429.40
10356 $1,106.40
11/28/03 10362 $1,549.60
12/2/03 10357 $1,167.68
10368 $1,689.78
10367 $834.20
10365 $403.20
10360 $7,390.20
12/3/03 10361 $2,046.24
10350 $642.06
12/4/03 10364 $950.00
10363 $447.20
12/9/03 10372 $9,210.90
10369 $2,390.40
10374 $459.00
10375 $338.00
12/11/03 10373 $1,366.40
12/13/03 10376 $399.00
10377 $863.60
10379 $863.28
10381
12/16/03 10382 $2,900.00
12/18/03 10383 $899.00
12/19/03 10378 $103.20
12/20/03 10387 $1,058.40
10388 $1,228.80
10384 $2,222.40
12/23/03 10385 $691.20
12/24/03 10371 $72.96
10389 $1,832.80
12/25/03 10386 $166.00
12/26/03 10390 $2,090.88
12/27/03 10370 $1,117.60
12/30/03 10366 $136.00
12/31/03 10391 $86.40
1/1/04 10392 $1,440.00
1/2/04 10397 $716.72
10771 $344.00
1/3/04 10393 $2,556.95
10394 $442.00
10395 $2,122.92
1/6/04 10396 $1,903.80
1/8/04 10399 $1,765.60
10404 $1,591.25
1/9/04 10398 $2,505.60
10403 $855.01
1/10/04 10402 $2,713.50
10401 $3,868.60
1/13/04 10406 $1,830.78
1/14/04 10408 $1,622.40
10409 $319.20
1/15/04 10412 $334.80
10410 $802.00
1/16/04 10380 $1,313.82
10400 $3,063.00
10413 $2,123.20
1/17/04 10414 $224.83
1/21/04 10411 $966.80
1/22/04 10405 $400.00
1/24/04 10415 $102.40
10418 $1,814.80
1/27/04 10416 $720.00
10421 $1,194.27
10424 $9,194.56
10420 $1,707.84
1/28/04 10417 $11,188.40
1/30/04 10407 $1,194.00
10419 $2,097.60
1/31/04 10422 $49.80
2/3/04 10430 $4,899.20
2/4/04 10428 $192.00
2/6/04 10426 $338.20
2/7/04 10435 $631.60
10429 $1,441.37
10432 $485.00
10431 $1,892.25
2/10/04 10439 $1,078.00
2/11/04 10436 $1,994.52
2/12/04 10437 $393.00
2/13/04 10434 $321.12
2/14/04 10443 $517.44
10438 $454.00
10425 $360.00
2/18/04 10442 $1,792.00
2/19/04 10446 $246.24
2/20/04 10445 $174.90
2/21/04 10444 $1,031.70
2/24/04 10448 $443.40
10423 $1,020.00
2/25/04 10454 $331.20
2/26/04 10452 $2,018.50
10453 $407.70
2/27/04 10449 $1,838.20
2/28/04 10456 $557.60
10440 $4,924.13
10459 $1,659.20
3/3/04 10455 $2,684.00
10460 $176.10
10457
10427 $651.00
3/4/04 10458 $3,891.00
10433 $851.20
3/5/04 10461 $1,538.70
3/6/04 10463 $713.30
3/7/04 10447 $914.40
3/11/04 10450 $425.12
10467 $235.20
3/12/04 10468 $717.60
10451 $3,849.66
3/13/04 10466 $216.00
3/14/04 10465 $2,518.00
10469 $956.67
10441 $1,755.00
10464 $1,609.28
10470 $1,820.80
3/18/04 10462 $156.00
10471 $1,328.00
3/19/04 10472 $1,036.80
3/21/04 10474 $1,249.10
10473 $230.40
10479 $10,495.60
3/24/04 10476 $180.48
10480 $756.00
3/25/04 10477 $558.00
10481 $1,472.00
3/26/04 10478 $471.20
3/28/04 10487 $889.70
3/31/04 10485
4/1/04 10484 $386.20
4/2/04 10488 $1,512.00
10486 $1,272.00
4/3/04 10490 $3,163.20
4/4/04 10475 $1,505.18
4/7/04 10496 $190.00
10497 $1,380.60
4/8/04 10491 $259.50
4/9/04 10494 $912.00
10489 $439.20
4/10/04 10482 $147.00
10493 $608.40
4/11/04 10498 $575.00
10492
10495 $278.00
4/16/04 10501 $149.00
10499 $1,412.00
10503 $2,048.50
4/17/04 10500 $523.26
4/18/04 10504 $1,388.50
4/21/04 10505 $147.90
10511 $2,550.00
4/22/04 10507 $749.06
4/24/04 10512 $525.30
4/25/04 10483 $668.80
4/28/04 10513 $1,942.00
10510 $4,707.54
4/29/04 10502 $816.30
10517 $352.00
10509 $136.80
5/1/04 10516 $2,381.05
10520 $200.00
10519 $2,314.20
5/2/04 10521 $225.50
10506 $415.80
5/5/04 10518 $4,150.05
5/6/04 10522 $2,318.24
5/7/04 10524 $3,192.65
10527 $1,503.00
5/9/04 10529 $946.00
10528 $392.20
5/12/04 10532 $796.35
10530 $4,180.00
5/13/04 10508 $240.00
5/14/04 10534 $465.70
5/15/04 10526 $1,151.40
5/16/04 10538 $139.80
10514 $8,623.45
5/19/04 10537 $1,823.80
10531 $110.00
5/21/04 10535 $1,940.85
5/22/04 10533 $2,222.20
5/23/04 10543 $1,504.50
10525 $818.40
10515 $9,921.30
10539 $355.50
5/26/04 10542 $469.11
5/27/04 10546 $2,812.00
5/29/04 10541 $1,946.52
5/30/04 10549 $3,554.27
10523 $2,444.31
10544 $417.20
6/2/04 10547 $1,792.80
10548 $240.10
6/3/04 10553 $1,546.30
6/4/04 10555 $2,944.40
6/5/04 10552 $880.50
10554 $1,728.52
6/6/04 10557 $1,152.50
10550 $683.30
10536 $1,645.00
10551 $1,677.30
6/9/04 10560 $1,072.42
10561 $2,844.50
6/10/04 10558 $2,142.90
6/12/04 10562 $488.70
6/13/04 10556 $835.20
10540 $10,191.70
10559 $520.41
6/16/04 10564 $1,234.05
6/17/04 10567 $2,519.00
6/18/04 10565 $639.90
10566 $1,761.00
6/19/04 10570 $2,465.25
6/20/04 10573 $2,082.00
6/24/04 10563 $965.00
6/25/04 10572 $1,501.08
6/26/04 10545 $210.00
6/30/04 10575 $2,147.40
10577 $569.00
10576 $838.45
10574 $764.30
7/1/04 10580 $1,013.74
7/2/04 10581 $310.00
7/4/04 10571 $550.59
10579 $317.75
10583 $2,237.50
10584 $593.75
7/9/04 10587 $807.38
10586 $23.80
10568 $155.00
7/10/04 10588 $3,120.00
10585 $142.50
7/11/04 10569 $890.00
7/14/04 10589 $72.00
10595 $4,725.00
10582 $330.00
10590 $1,101.00
7/16/04 10591 $812.50
10592 $516.46
10594 $565.50
7/18/04 10598 $2,388.50
10597 $718.08
7/21/04 10600 $479.80
10599 $493.00
7/22/04 10602 $48.75
10601 $2,285.00
7/25/04 10607 $6,475.40
10578 $477.00
7/29/04 10604 $230.85
10605 $4,109.69
7/30/04 10609
7/31/04 10606 $1,130.40
8/1/04 10614 $464.00
10612 $6,375.00
10608 $1,064.00
10613 $353.20
10611 $808.00
8/4/04 10617 $1,402.50
8/5/04 10616 $4,806.99
8/6/04 10610 $299.25
10615 $120.00
8/7/04 10619 $1,260.00
8/8/04 10603 $1,483.00
10618 $2,697.50
8/11/04 10621 $758.50
10622 $560.00
8/12/04 10596 $1,180.88
10623 $1,336.95
8/13/04 10593 $1,994.40
8/14/04 10620 $57.50
10625 $479.75
8/15/04 10631 $55.80
8/18/04 10633 $5,510.59
8/19/04 10632 $589.00
10630 $903.60
10624 $1,393.24
8/20/04 10626 $1,503.60
10628 $450.00
10629 $2,775.05
8/21/04 10627 $1,185.75
10635 $1,326.22
10634 $4,985.50
8/26/04 10636 $629.50
10641 $2,054.00
10637 $2,761.94
8/27/04 10639 $500.00
8/28/04 10640 $708.75
8/29/04 10649 $1,434.00
9/1/04 10638 $2,720.05
10644 $1,371.80
9/2/04 10645 $1,535.00
10643 $814.50
9/3/04 10650 $1,779.20
10646 $1,446.00
10647 $636.00
9/5/04 10642 $696.00
9/8/04 10652 $318.84
10658 $4,464.60
9/9/04 10648 $372.37
9/10/04 10659 $1,227.02
10656 $604.21
9/11/04 10654 $601.83
10651 $397.80
10655 $154.40
9/15/04 10657 $4,371.60
10661 $562.60
9/17/04 10665 $1,295.00
9/18/04 10662 $125.00
10670 $2,301.75
9/19/04 10653 $1,083.15
10664 $1,288.39
10673 $412.35
10667 $1,536.80
9/22/04 10669 $570.00
10666 $4,666.94
9/23/04 10675 $1,423.00
10668 $625.27
9/24/04 10671 $920.10
9/26/04 10677 $813.36
10680 $1,261.88
10672 $3,815.25
9/29/04 10676 $534.85
9/30/04 10679 $660.00
10681 $1,287.40
10684 $1,768.00
10674 $45.00
10/1/04 10683 $63.00
10682 $375.50
10/3/04 10690 $862.50
10663 $1,930.40
10685 $801.10
10/7/04 10689 $472.50
10688 $3,160.60
10/8/04 10686 $1,404.45
10/9/04 10694 $4,825.00
10/10/04 10693 $2,071.20
10/13/04 10699 $114.00
10692 $878.00
10/14/04 10696 $996.00
10695 $642.00
10697 $805.43
10/15/04 10660 $1,701.00
10701 $2,864.50
10/16/04 10678 $5,256.50
10700 $1,638.40
10/17/04 10698 $3,436.45
10/20/04 10703 $2,545.00
10/21/04 10706 $1,893.00
10702
10/22/04 10691 $10,164.80
10/23/04 10710 $93.50
10707 $1,641.00
10/24/04 10713 $2,827.90
10/27/04 10714 $2,205.75
10716 $706.00
10/29/04 10711 $4,451.70
10717 $1,270.75
10718 $3,463.00
10715
10/30/04 10687 $4,960.90
10/31/04 10721 $923.87
10712 $1,233.48
11/4/04 10722 $1,570.00
11/5/04 10719 $844.25
10720 $550.00
10724 $638.50
10725 $287.80
10708 $180.40
11/7/04 10732
10704 $595.50
11/10/04 10733 $1,459.00
11/11/04 10728 $1,296.75
11/12/04 10734 $1,498.35
11/14/04 10730 $484.25
10729 $1,850.00
10731 $1,890.50
11/17/04 10739
11/18/04 10705 $378.00
10737
10738 $52.35
10742 $3,118.00
10741 $228.00
11/20/04 10709 $3,424.00
11/21/04 10743
10746 $2,311.70
10736 $997.00
10735 $536.40
11/24/04 10750 $1,590.56
10744 $736.00
11/25/04 10723 $468.45
10740 $1,416.00
11/26/04 10747 $1,912.85
11/27/04 10745 $4,529.80
10753 $88.00
10754 $55.20
11/28/04 10752 $252.00
10748 $2,196.00
10755 $1,948.50
12/2/04 10756 $1,990.00
12/3/04 10751 $1,631.48
12/4/04 10758 $1,644.60
12/5/04 10727 $1,624.50
10726 $655.00
12/8/04 10761 $507.00
10763 $616.00
10764 $2,286.00
12/9/04 10762 $4,337.00
10765 $1,515.60
10766 $2,310.00
12/10/04 10760 $2,917.00
12/12/04 10759 $320.00
10769 $1,684.27
10774 $868.75
12/15/04 10768 $1,477.00
10767 $28.00
10757 $3,082.00
12/16/04 10773 $2,030.40
12/17/04 10770 $236.25
12/18/04 10776 $6,635.27
12/19/04 10781 $975.88
10772 $3,603.22
10749 $1,080.00
10783 $1,442.50
12/22/04 10782 $12.50
10784 $1,488.00
12/23/04 10786 $1,531.08
12/24/04 10785 $387.50
10778 $96.50
12/25/04 10780
12/26/04 10787 $2,622.76
10775
10790 $722.50
12/31/04 10789 $3,687.00
10792 $399.85
10801 $3,026.85
1/1/05 10791 $1,829.76
1/2/05 10802 $2,942.81
10794 $314.76
1/5/05 10800 $1,468.93
10799 $1,553.50
10798 $446.60
10797
10806 $439.60
1/6/05 10803 $1,193.01
1/7/05 10810 $187.00
10809 $140.00
10804 $2,278.40
1/8/05 10811 $852.00
10793 $191.10
1/9/05 10813 $602.40
10805 $2,775.00
10808 $1,411.00
1/12/05 10812 $1,692.80
10818 $833.00
1/13/05 10823 $2,826.00
10817 $10,952.84
10820 $1,140.00
1/14/05 10825 $1,030.76
10815 $40.00
10779 $1,335.00
10796 $2,341.36
10814 $1,788.45
1/15/05 10821 $678.00
1/16/05 10819
10822 $237.90
1/19/05 10788 $731.50
10834 $1,432.71
10832 $475.11
1/20/05 10795 $2,158.00
1/21/05 10835 $845.80
10777 $224.00
10836 $4,705.50
10830 $1,974.00
1/22/05 10839 $827.55
1/23/05 10829 $1,764.00
10837 $1,064.50
10846 $1,112.00
10831 $2,684.40
10838 $1,938.38
10833 $906.93
1/26/05 10844 $735.00
10843 $159.00
1/29/05 10841 $4,581.00
10842 $975.00
10848 $931.50
1/30/05 10824 $250.80
10845 $3,812.70
10852 $2,984.00
10850 $629.00
10849 $967.82
10807 $18.40
2/2/05 10851 $2,603.00
10862 $581.00
10859 $1,078.69
2/3/05 10853 $625.00
10858 $649.00
2/4/05 10828 $932.00
10855 $2,227.89
10860 $519.00
10816 $8,446.45
2/5/05 10854 $2,966.50
2/6/05 10857 $2,048.22
10827 $843.00
10826 $730.00
2/9/05 10869 $1,630.00
10872 $2,058.46
10864 $282.00
10873 $336.80
2/10/05 10871 $1,979.23
10856
10847 $4,931.92
2/11/05 10874
10867 $98.40
2/12/05 10866 $1,096.20
10865 $16,387.50
10876 $917.00
10879 $611.30
10878 $1,539.00
2/13/05 10870 $160.00
10884 $1,378.07
2/16/05 10887 $70.00
10840 $211.20
2/17/05 10861 $3,523.40
10863 $441.15
2/18/05 10880 $1,500.00
10890 $860.10
10881 $150.00
10885 $1,209.00
2/19/05 10877 $1,955.13
10891 $368.93
10892 $2,090.00
2/20/05 10883 $36.00
10894 $2,753.10
10893 $5,502.11
10882 $892.64
2/23/05 10888 $605.00
10889 $11,380.00
10868 $1,920.60
10895 $6,379.40
2/25/05 10897 $10,835.24
2/26/05 10899 $122.40
10901
2/27/05 10896 $750.50
10904 $1,924.25
10907 $108.50
3/2/05 10886 $3,127.50
10915 $539.50
10914 $537.50
3/3/05 10902 $863.43
10875 $709.55
10906 $427.50
3/4/05 10900 $33.75
10910 $452.90
10919 $1,122.80
10903 $932.05
10913 $768.75
3/5/05 10922 $742.50
10911 $858.00
3/6/05 10905 $342.00
10898 $30.00
10908 $663.10
3/9/05 10916 $686.70
10921 $1,936.00
10920 $390.00
3/10/05 10909 $670.00
3/11/05 10918 $1,447.50
10917 $365.89
10926 $514.40
3/12/05 10934
10929 $1,174.75
3/13/05 10939 $637.50
10923 $748.80
10937 $644.80
10925 $475.15
10944 $1,025.33
3/16/05 10938 $2,731.87
10947 $220.00
10933 $920.60
3/17/05 10949 $4,422.00
3/18/05 10928 $137.50
10942
10912 $6,200.55
10936 $456.00
10930 $2,255.50
10935 $619.50
10945 $245.00
3/19/05 10946 $1,407.50
10948 $2,362.25
10931 $799.20
10943 $711.00
3/20/05 10954 $1,659.53
10955 $74.40
10941 $4,011.75
10956 $677.00
3/23/05 10940
10962 $3,584.00
10950
10959 $131.75
3/24/05 10932 $1,788.63
10952
10964 $2,052.50
3/25/05 10953 $4,441.25
3/26/05 10963 $57.80
10972 $251.50
3/27/05 10957 $1,762.70
10975 $717.50
10958 $781.00
10973 $291.55
3/30/05 10961
10969 $108.00
10965 $848.00
3/31/05 10979 $4,813.50
4/1/05 10968 $1,408.00
4/2/05 10981 $15,810.00
10967 $910.40
10971 $1,733.06
10985 $2,023.38
10989 $1,353.60
4/3/05 10976
10984 $1,809.75
10992 $69.60
10974 $439.00
4/6/05 10987 $2,772.00
10995 $1,196.00
10983 $720.90
4/7/05 10991
10951 $458.74
10990 $4,288.85
4/8/05 10982 $1,014.00
10924 $1,835.70
10960 $265.35
11003 $326.00
10927 $800.00
10966 $1,098.46
4/9/05 10994 $940.50
4/10/05 10977 $2,233.00
11005 $586.00
11009 $616.50
11013 $361.00
10993 $4,895.44
10988 $3,574.80
10996
10999 $1,197.95
4/13/05 10997 $1,885.00
11007 $2,633.90
11016 $491.50
11011 $933.50
4/14/05 11000 $903.75
11001 $2,769.00
4/15/05 11014 $243.18
11006 $329.69
4/16/05 11020 $632.40
11002 $1,811.10
11018 $1,575.00
4/17/05 10998 $686.00
11012 $2,825.30
10980 $248.00
4/20/05 11027 $877.72
11017 $6,750.00
11015 $622.35
11004 $295.38
11024 $1,966.81
4/21/05 10986 $2,220.00
11010 $645.00
11021 $6,306.24
4/22/05 11036 $1,692.00
11028 $2,160.00
4/23/05 10978 $1,303.19
11032 $8,902.50
11033 $3,232.80
4/24/05 11046 $1,485.80
11023
10970
11035 $1,754.50
11025 $270.00
11031 $2,393.50
4/27/05 11034 $539.40
11030 $12,615.05
11037 $60.00
11029 $1,286.80
4/28/05 11041 $1,773.00
11026 $1,030.00
4/29/05 11043
11053 $3,055.00
4/30/05 11038 $732.60
11048 $525.00
5/1/05 11056 $3,740.00
11042 $405.75
11047 $817.87
11052 $1,332.00
11057
11044 $591.60

Source data for PivotTable report
You can use the data to the left to experiment with creating sample PivotTable reports using the PivotTable template on the worksheet named

PivotTable Template

.
If you scan through this source data, you’ll notice that it’s difficult to see the trends and results, even if you sort or filter the data. There are just too many records to analyze at a glance.
Compared with the large databases your company may have available, or you may have found on the Internet, this 800-row list is fairly short and simple. Excel can retrieve much larger amounts of data than this, and PivotTable reports are one of the best Excel tools for extracting the significance from a large, detailed data set.
The data is organized in list format, similar to how a query returns database records: each column contains similar data, the columns have headings in the first row, and the list isn’t interrupted by any blank rows or columns (although blank cells within the data are OK). The list is sorted by Order Date.
This workbook contains sample source data (on the current worksheet named Source Data), a PivotTable structure based on the source data (on the worksheet named PivotTable Template), and a sample PivotTable that was created from the source data and PivotTable structure. The sample is on the worksheet named

Sample PivotTable Report

.

PivotTable Template

Sample PivotTable Report

Country

Salesperson

Buchanan

Callahan

Davolio

Dodsworth

Fuller

King

Leverling

Peacock

Suyama

(All)
Sum of Order Amount
Total
68792.25
123032.67
182500.09
75048.04
162503.78
116962.99
201196.27
225763.68
72527.63
Grand Total 1228327.4

Sample PivotTable report
This PivotTable report was created using the source data on the worksheet named Source Data. To see the sales activity for a particular country, click the drop-down arrow next to Country and select the country from the list.
This PivotTable was created by placing the Salesperson field in the Drop Row Fields Here area of the PivotTable structure. Then, the Order Amount field was placed in the Drop Data Items Here area. The Country field was placed in the Drop Page Fields Here area.

Paper Assignments
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.