Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Jackson Travel Ltd
User Information
1. Different commission structures from different department for the
airline and the staff
Prescribe airline commission rates as per the contract department for
Airline Commission Rates
Code
Airline
Rate
1 Delta
0.01
2 USAirways
0.015
3 United
0.011
4 Southwest
0.007
5 Northwest
0.012
6 American
0.011
7 Continental
0.013
Commission incentive computation as per the payroll department
Years of Service
Percentage
10 years or more
15%
3 years to 10 years
10%
Less than 3 years
5%
Date of hiring for the staff as per the payroll department
Employee Number
Employee Name Hire Date
1 Gibbs
2 Smith
3 White
3/28/2004
11/15/2007
4/2/2013
2. Data analysis for the 3 months as retrived from the system.
3. Under the output worksheet only amend the yellow that is for the period under analysis.
4. When computing for any month enter the first day of the month.
Customer
Agner
Andrews
Barrick
Baucom
Baumann
Burkhead
Clegg
Dietz
Dollar
Donaldson
Dunnavant
Dunston
Furr
Galvin
Guidry
Hansen
Hillman
Hulslander
Johnston
Jones
Kastelberg
Lee
Lein
McGuire
McIntosh
Moose
Mowrey
Pearson
Roth
Roush
Stein
Wallis
Weis
Weisner
Carlton
Carlton
Carlton
Wag...