1. No category

AirPlus Ancillary Fee Reports
Airline Fees
Sample Company
Report Date Range: 01 Jan 2011 to 31 Mar 2011
Ancillary Fees
Amount
Average
%
$959
$37
1%
$32,352
$28
46%
$729
$7
1%
Service
$24,054
$97
34%
Miscellaneous
$12,789
$37
18%
Total
$70,882
$41
Award
Bag
Onboard
Percentage Spend
18%
Award
Bag
Onboard
Service
Miscellaneous
1%
46%
34%
1%
Average Spend
$0
$20
$40
$60
$80
$100
$120
Award
Bag
Onboard
Service
Miscellaneous
Report Type
Award
Bag
Miscellaneous
Onboard
Service
Report Run Date: 6/14/2011
Examples of Fees
Reward Change, Accelerator, Mileage Purchase
First Bag, Second Bag, Overweight Bag
MCO, Small Value
Beverage, Meal, Headset
Reissue Charge, Penalty, Bulkhead, Standby, Upgrade
1 of 9
AirPlus Ancillary Fee Reports
Overall Fees Summary
Sample Company
Report Date Range: 01 Jan 2011 to 31 Mar 2011
Summary
Report
Fee Type
Fee Sub Type
Billing Amount
# Transactions
Average Fee
Award
Miles Fee/Club Fee
$50.00
2
$25.00
Miles/Taxes/Lost Ticket Fee
$35.00
1
$35.00
Point Redemption
$45.00
3
$15.00
Reward Booking
$150.00
4
$37.50
Reward Change
$300.00
8
$37.50
Skymiles Fee
$350.00
7
$50.00
US Air Club Membership*
$29.00
1
$29.00
$959.00
26
$36.88
$959.00
26
$36.88
First Checked Bag
$17,980.69
672
$26.76
First Checked Bag*
$5,646.00
230
$24.55
Second Checked Bag
$611.47
15
$40.76
Second Checked Bag*
$1,580.00
34
$46.47
$25,818.16
951
$27.15
Baggage
$5,614.47
191
$29.40
Excess Bag
$819.24
2
$409.62
Award
Award Subtotal
Award Subtotal
Bag
Checked Bag
Checked Bag Subtotal
General Bag
Report Run Date: 6/14/2011
Page 2 of 9
AirPlus Ancillary Fee Reports
Overall Fees Summary
Sample Company
Overweight
$100.00
2
$50.00
$6,533.71
195
$33.51
$32,351.87
1146
$28.23
Amount < $10
$330.81
48
$6.89
Amount < $120
$6,238.45
81
$77.02
Amount < $50
$4,775.13
176
$27.13
MCO
$1,138.11
23
$49.48
Other
$306.00
14
$21.86
$12,788.50
342
$37.39
$12,788.50
342
$37.39
$441.00
50
$8.82
$441.00
50
$8.82
Inflight Food
$84.25
15
$5.62
Inflight Meal
$9.50
2
$4.75
Inflight Snack
$94.50
15
$6.30
$188.25
32
$5.88
Headset
$15.00
5
$3.00
Inflight Snack*
$12.00
4
$3.00
General Bag Subtotal
Bag Subtotal
Misc
Misc
Misc Subtotal
Misc Subtotal
Onboard
Beverage
Liquor
Beverage Subtotal
Food
Food Subtotal
Onboard Sale
Report Run Date: 6/14/2011
Page 3 of 9
AirPlus Ancillary Fee Reports
Overall Fees Summary
Sample Company
Misc
$72.45
10
$7.25
$99.45
19
$5.23
$728.70
101
$7.21
Bulkhead Standby
$39.00
1
$39.00
Change
$25.00
1
$25.00
Confirmation Charge
$75.00
1
$75.00
Inflight Voucher
$78.00
3
$26.00
Same Day Change
$101.56
2
$50.78
Same Day Confirmed
$3,145.20
70
$44.93
Same Day Standby
$625.00
13
$48.08
Standby
$947.52
19
$49.87
Unconf Charge
$150.00
3
$50.00
$5,186.28
113
$45.90
Annual Membership
$1,825.00
5
$365.00
Club Fee
$275.00
1
$275.00
Day Pass
$45.00
1
$45.00
Initiation
$50.00
1
$50.00
$2,195.00
8
$274.38
$7,955.63
51
$155.99
Onboard Sale Subtotal
Onboard Subtotal
Service
Change
Change Subtotal
Club
Club Subtotal
Penalty
Report Run Date: 6/14/2011
Change Penalty
Page 4 of 9
AirPlus Ancillary Fee Reports
Overall Fees Summary
Sample Company
Reissue Charge
$300.00
2
$150.00
$8,255.63
53
$155.77
Past Date Receipt
$20.00
1
$20.00
QANTAS DPS TEL
$875.00
1
$875.00
Reservations
$120.00
5
$24.00
Service
$588.16
4
$147.04
Special Services
$24.75
2
$12.38
Voided Ticket
$15.36
1
$15.36
$1,643.27
14
$117.38
Bulkhead Premium
$733.03
8
$91.63
Economy+ Charge
$639.00
10
$63.90
Extra Legroom
$993.00
17
$58.41
First Class
$345.00
3
$115.00
First Class Plus
$3,600.00
1
$3,600.00
Go First/Go Sleeper
$415.00
19
$21.84
Premier Line
$39.00
1
$39.00
Priority Boarding
$10.00
1
$10.00
$6,774.03
60
$112.90
Service Subtotal
$24,054.21
248
$96.99
Total:
$70,882.28
1863
$38.05
Penalty Subtotal
Ticket
Ticket Subtotal
Upgrade
Upgrade Subtotal
Report Run Date: 6/14/2011
Page 5 of 9
AirPlus Ancillary Fee Reports
Merchant Summary
Sample Company
Total Fees by Merchant
$45,000
$40,000
$35,000
$30,000
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Merchant
Aer Lingus
Air Canada
Air Tran
Alaska Airlines
American Airlines
Avianca
British Airways
British Midlands
Central WI Airport
Comair
Continental
Delta Airlines
Easyjet
Frontier
Great Lakes Airlines
IndiGo Airlines
Report Run Date: 6/14/2011
Amount
# Transactions
Average Spend
$651
$796
$100
$275
$3,294
$115
$164
$64
$120
$51
$40,095
$10,496
$111
$100
$25
$132
12
15
5
11
109
1
3
1
5
1
956
328
4
5
1
2
$54.24
$53.06
$20.00
$24.99
$30.22
$114.55
$54.50
$63.98
$24.00
$51.45
$41.94
$32.00
$27.69
$20.00
$25.00
$65.85
Page 6 of 9
AirPlus Ancillary Fee Reports
Fees Summary by Merchant
Sample Company
American Airlines
Report
Fee Type
Fee Sub Type
Billing Amount
# Transactions
Average Fee
General Bag
General Bag Subtotal
Baggage
$2,745.00
$2,745.00
$2,745.00
90
90
90
$30.50
$30.50
$30.50
Misc
Misc Subtotal
Other
$186.00
$186.00
$186.00
7
7
7
$26.57
$26.57
$26.57
Onboard Sale
Onboard Sale Subtotal
Misc
$72.45
$72.45
$72.45
10
10
10
$7.25
$7.25
$7.25
Club
Club Subtotal
Club Fee
$275.00
$275.00
1
1
$275.00
$275.00
Ticket
Ticket Subtotal
Voided Ticket
$15.36
$15.36
$290.36
1
1
2
$15.36
$15.36
$145.18
$3,293.81
109
$30.22
Bag
Bag Subtotal
Misc
Misc Subtotal
Onboard
Onboard Subtotal
Service
Service Subtotal
Total:
Report Run Date: 6/14/2011
*These fees are derived from published rate information
Page 7 of 9
AirPlus Ancillary Fee Reports
Fees Summary by Merchant
Sample Company
United Airlines
Report
Fee Type
Fee Sub Type
Billing Amount
# Transactions
Average Fee
Checked Bag
First Checked Bag
Second Checked Bag
$1,015.02
$50.00
$1,065.02
43
1
44
$23.61
$50.00
$24.21
General Bag
General Bag Subtotal
Baggage
$356.38
$356.38
$1,421.40
6
6
50
$59.40
$59.40
$28.43
Change
Confirmation Charge
Unconf Charge
$75.00
$150.00
$225.00
1
3
4
$75.00
$50.00
$56.25
Ticket
Ticket Subtotal
Service
$588.16
$588.16
4
4
$147.04
$147.04
Upgrade
Economy+ Charge
Premier Line
Service Subtotal
$639.00
$39.00
$678.00
$1,491.16
10
1
11
19
$63.90
$39.00
$61.64
$78.48
Total:
$2,912.56
69
$42.21
Bag
Checked Bag Subtotal
Bag Subtotal
Service
Change Subtotal
Upgrade Subtotal
Report Run Date: 6/14/2011
*These fees are derived from published rate information
Page 8 of 9
AirPlus Ancillary Fee Reports
Baggage Fees
Sample Company
Report Date Range: 01 Jan 2011 to 31 Mar 2011
Fee Type
Fee Subtype
Airline
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
First Checked Bag
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Report Run Date: 6/14/2011
Date
2/5/2011
2/10/2011
2/12/2011
2/17/2011
3/11/2011
3/17/2011
3/7/2011
3/17/2011
3/3/2011
2/8/2011
1/26/2011
2/9/2011
2/14/2011
3/29/2011
2/7/2011
1/10/2011
1/13/2011
3/28/2011
2/7/2011
3/7/2011
2/18/2011
3/13/2011
3/15/2011
1/11/2011
1/13/2011
1/20/2011
1/20/2011
1/23/2011
3/1/2011
3/1/2011
1/6/2011
2/9/2011
2/14/2011
2/17/2011
3/3/2011
2/3/2011
1/7/2011
3/7/2011
1/1/2011
1/6/2011
1/18/2011
1/18/2011
2/6/2011
2/9/2011
1/18/2011
Cardholder Name
Passenger Name
Merchant Name
Ticket Number
Sean Connery
Sean Connery
Sean Connery
Sean Connery
Sean Connery
Sean Connery
Roger Moore
Roger Moore
Timothy Dalton
Timothy Dalton
George Lazenby
Pierce Brosnan
Pierce Brosnan
Daniel Craig
Daniel Craig
Donald Pleasance
Donald Pleasance
Ursula Andress
Ursula Andress
Ursula Andress
Ursula Andress
Jack Lord
Jack Lord
Jack Lord
Jack Lord
Daniel Craig
Daniel Craig
Daniel Craig
George Lazenby
George Lazenby
Sean Connery
Sean Connery
Lois Maxwell
Lois Maxwell
Desmond Llewelyn
Desmond Llewelyn
Desmond Llewelyn
Desmond Llewelyn
Bernard Lee
Bernard Lee
Honor Blackman
Honor Blackman
Shirley Eaton
Shirley Eaton
Adolfo Celi
Connery
Connery
Connery
Connery
Connery
Connery
Moore
Moore
Dalton
Dalton
Lazenby
Brosnan
Brosnan
Craig
Craig
Pleasance
Pleasance
Andress
Andress
Andress
Andress
Lord
Lord
Lord
Lord
Craig
Craig
Craig
Lazenby
Lazenby
Connery
Connery
Maxwell
Maxwell
Llewelyn
Llewelyn
Llewelyn
Llewelyn
Lee
Lee
Blackman
Blackman
Eaton
Eaton
Celi
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
Continental
00526002014470
00526007724151
00526007884241
00526005178705
00526011007472
00526012582001
00526064655222
00526065488776
00526056787476
00526058005777
00526044428282
00526018874581
00526020404106
00526048124777
00526050768422
00526087204467
00526087740746
00526015577606
00526018414651
00526026827471
00526024447581
00526011611467
00526012157800
00526058708441
00526054048716
00526057677717
00526057677717
00526054761761
00526008245444
00526008245444
00526050008201
00526050818506
00526041112024
00526041404527
00526017402474
00526017402474
00526018257515
00526018257515
00526042707476
00526044077842
00526057008244
00526057008244
00526084227646
00526040025845
00526047428570
*These fees are derived from published rate information
Agency Name
Amount
$23.00
$60.00
$55.00
$60.00
$155.00
$160.00
$23.00
$55.00
$25.00
$25.00
$25.00
$23.00
$75.00
$23.00
$25.00
$50.00
$45.00
$25.00
$60.00
$55.00
$55.00
$25.00
$25.00
$25.00
$25.00
$25.00
$25.00
$25.00
$25.00
$25.00
$23.00
$23.00
$25.00
$25.00
$23.00
$23.00
$25.00
$25.00
$25.00
$25.00
$23.00
$23.00
$20.00
$20.00
$25.00
9 of 9