European Excursions Agent Sales and Commissions - 93455

Solution Posted by
academicgeek

academicgeek

Rating : (8)A+
Solution Detail
Price: $30.00
  • From: Computer Science,
  • Posted on: Sun 27 Sep, 2015
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
European Excursions Agent Sales and Commissions Input Area Taxes and Fees 20% Tot Loan APR 7% Ave Months Per Year 12 Me Total Payments 3 Agent Name Student ID Tour Code Trip Description Departure Date Avery 10001 20 Collins 10002 30 Avery 10003 10 McDonnough 10004 50 Ross 10005 60 Shannon 10006 70 Collins 10007 10 Ross 10008 40 McDonnough 10009 50 Ross 10010 60 Shannon 10011 70 Avery 10012 20 Kinsley 10013 40 Collins 10014 70 Avery 10015 30 McDonnough 10016 20 McDonnough 10017 30 Collins 10018 10 Kinsley 10019 10 Avery 10020 50 Ross 10021 40 Avery 10022 60 Ross 10023 10 Ross 10024 10 Collins 10025 20 Kinsley 10026 20 McDonnough 10027 20 Kinsley 10028 40 McDonnough 10029 40 Kinsley 10030 50 Avery 10031 70 McDonnough 10032 60 Collins 10033 60 Ross 10034 70 Collins 10035 30 Ross 10036 30 Ross 10037 20 Summary Statistics al for all trips: rage trip cost: dian trip cost: Lowest cost: Highest cost: Today's date: ase Cost of Trial Cost with Ta ent Payment ent Commission 2016 Total Sales by Agent January - June January February March April May June Trends Bonus Avery $3,671 $2,973 $4,017 $5,040 $4,963 $5,497 Collins $1,549 $992 $2,267 $3,201 $4,008 $3,798 Kinsley $2,996 $6,948 $4,205 $5,523 $6,597 $5,147 McDonnough $2,003 $4,190 $3,496 $1,975 $2,936 $3,498 Ross $4,038 $2,064 $7,015 $6,832 $5,971 $5,497 Shannon $1,172 $866 $2,109 $3,385 $4,078 $3,598 Bonus $500
Solution Description

Text Box: Base Price	Commission
$1,699	2.5%
$1,749	3.0%
$1,799	3.5%
$1,849	4.0%
$1,899	4.5%

                     Text Box: Package	Tour Description	Departure	Base Cost
10	Adventures in Canada	6/11/2016	$1,699.00
20	Check Out the Czech Republic!	6/4/2016	$1,799.00
30	Croatian Wonders	6/11/2016	$1,899.00
40	Live it Up London	6/18/2016	$1,699.00
50	Parisian Pleasures	6/25/2016	$1,749.00
60	Roaming Rome	6/11/2016	$1,849.00
70	Viva EspaƱa	6/25/2016	$1,799.00

 

European Excursions

Agent Sales and Commissions

 

Input Area

 

Taxes and Fees

20%

Tot

Loan APR

7%

Ave

Months Per Year

12

Me

Total Payments

3

 

 

 

 

Agent Name

Student ID

Tour Code

Trip Description

Departure Date

Avery

10001

20

 

 

Collins

10002

30

 

 

Avery

10003

10

 

 

McDonnough

10004

50

 

 

Ross

10005

Attachments
Trips.xlsx_CooperBrandt.xls
Trips.xlsx_Coop...