monthlyairfareanalysis.docVIP

Monthly Air Fare Analysis This report provides a snap-shot of monthly air activity. Totals are provided for the amount invoiced, discount received, number of tickets, potential savings and reason codes for refusal of lower fares. Questions answered by this report include: ? What is the monthly expense and total tickets? ? What is the actual fare versus normal fare? ? What is the potential savings and reason if passenger declined lower fare? Data elements: Passenger: Traveler name. Adv Days: Days in advance passenger requested ticket CR: Carrier booked. Actual Fare: Fare booked. Normal Fare: Standard rate. Discount: Discount received on airline tickets. Policy Fare: Negotiated Rate. Potential Savings: Savings which could have been received and reason traveler declined the lower fare. Adv Actual Normal Discount Policy Potential Passenger Invoice Ticket # Days Date CR Itinerary Fare Fare Amount % Fare Savings Brenner, Diane 332938 1221824844 3 2/11/01 UA EWR PDX-SFO 686 836 150 18% 500 186 D: Alternate Carrier Refused Remarks: Journeycorp Discount Brenner, Diane 332944 1221834860 4 2/12/01 DL PDX BOI-PDX 389 500 119 0% 289 100 X: Lowest Fare Obtained Remarks: Mancus, Jay S 332416 1221396253 2 2/09/01 UA LGA ORD-LGA 781 973 192 20% 556 225 D: Alternate Airport Refused Remarks: Upgraded to first for free Mancus, Jay S 332308 1221138636 2 2/08/01 US LGA BOS-LGA 300 300 0 0% 220 80 D: Alternate Times Refused Remarks: Journeycorp Discount Schmidt, John 332419 1231396256 1 2/08/01 US LGA BOS 150 200 50 27% 110 40 N: Negotiated Fare Remarks: Journeycorp Discount Weber, Mark 332643 1221589506 3 2/09/01 UA LGA ORD-PVD 843 843 0 0% 700 143 X: Lowest Fare Obtained Remarks: Upgraded to first for free Weber, Mark 332692 1221589558 5 2/12/01 UA PVD LAX-DFW 2,601 2,835 234 9% 2,220 381 L: Lower Than Policy Remarks: Split Ticket Wohanka, Ed 332946 1221934852 6 2/12/01 DL PDX BOI 82 82 0 0% 82 0 X: Lowest Fare Obtained Remarks: Wohanka, E