10001
6/4/2012
1799

10012
6/4/2012
1799

10015
6/11/2012
1899

10002
6/11/2012
1899

10007
6/11/2012
1899

10003
6/18/2012
1699

10008
6/18/2012
1699

10013
6/25/2012
1749

10004
6/25/2012
1749

10009
6/25/2012
1749

10005
6/11/2012
1849

10010
6/11/2012
1849

10014
6/25/2012
1799

10006
6/25/2012
1799

10011
6/25/2012
1799

1699
2.5000000000000001E-2

1749
0.03

1799
3.5000000000000003E-2

1849
0.04

1899
4.4999999999999998E-2

3671
2973
4017
5040
4963
5497

1549
992
2267
3201
4008
3798

2996
6948
4205
5523
6597
5147

2003
4190
3496
1975
2936
3498

4038
2064
7015
6832
5971
5497

1172
866
2109
3385
4078
3598

Agent Sales and Commissions
European Excursions
Agent Last Name
Trip Description
Departure Date
Base Cost of Trip
Total Cost with Taxes
Agent Commission
Student ID
Student Payment Plan
Parisian Pleasures
Live it Up London
Viva Espana
Check Out the Czech Republic!
Roaming Rome
Croatian Wonders
Avery
Collins
Kinsley
McDonnough
Ross
Shannon
Lookup Table
Total for all trips:
Average trip cost:
Lowest cost:
Highest cost:
Today’s date:
Bonus?
Czech/Croatia trips:
2012 Total Sales by Agent
January – June
January
February
March
April
May
June