Thursday, April 18, 2013

#10: Determining Online Booking Targets

Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: Yes                                               ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description


                                          48.23%.

I sat in a review with a TMC and that's the number they presented for my client's online adoption. 

I complimented them on their exactitude (I mean, down to the hundredths of a percent!) and then asked them why they were wasting our time. 

This number, as a stand-alone data point, meant nothing. It had no context, and most of all, it provided no explicit or even implicit guidance on what, if anything should be done.

Recovering stammeringly, they shared that their "clients' online adoption ranged from 24% to 88%, so this number is somewhere between those figures." Really? My client and I sat there quietly waiting for something useful. 

The account rep started saying something like "I think maybe companies like yours seem to..." and I took pity and cut him off, "Let's start at the beginning. How many airline tickets has the client booked overall?" Let's say the answer is 10,000.

I next asked what percentage of those were simple point-to-point itineraries (e.g. leaving Boston, flying to Chicago and returning directly back to Boston). For our purposes here, let's say 80% of the total trips (8,000) were simple itineraries. Except for the most skilled of traveler, multi-city itineraries are better booked using a live agent.

My client's firm travels to many far-flung destinations around the world, and he was concerned with making sure that travelers had all the information and visas needed for those trips. Therefore, we asked the TMC to exclude, from the 8,000 simple itineraries, any transcontinental flights other than those in and out of London, Frankfurt, and Paris. There was a total of 1,500 trips that were eliminated using this filter, leaving us with 6,500 trips, or 65% of the total trips booked through the TMC. 

This is the important number. This figure represents the total number of trips eligible to be booked online, based on the client's criteria. So...if the online adoption was the very exact 48.23% (or 4,823 trips out of the total 10,000), that would mean that 74.2% of my client's eligible trips were booked online (4,823 / 6,500 = 74.2%). Placing this figure in context makes it a more actionable figure.

Now we can decide how much effort, if any, we should apply in order to improve this number.  

If we were to get 100% of the eligible trips booked online, that would mean an additional 1,677 trips. If the fee differential between online and offline booking was $20, that would result in an incremental savings of $33,540. In this case, my client's total travel spend is roughly $8.5 million. So in the best case, reaching 100% would save his company 0.4% of his total travel spend. Not a huge impact, and it is of course unlikely that we can reach 100%, so the true savings would be less than that.

Now that we know the savings potential, my client can prioritize whether to spend his time trying to maximize this figure, or to spend his capital elsewhere; encouraging advance purchase, or booking hotels through the TMC, or whatever offers the greater potential return. 

This is not to say he will completely ignore online booking, but simply that he won't make it the primary focus in his communications. 

Context is king. Truly knowing where you stand let's you figure out where you should go.





Thursday, March 21, 2013

#9: Measuring YOUR value

Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: No                                                 ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description
So you're a travel manager. Are you worth it? What is your ROI?


What I mean is that do you, and your corporate travel management program, create more value for your company than your cost? 

If your company takes a strictly spend-and-savings approach to corporate travel management, then the numbers better add up in your favor. 

According to Business Travel News, the average travel manager made about $98,000 in total compensation in 2012. That means at the most basic level, in order to have a positive ROI, that travel manager should have created at least $98,001 in savings for the company. (Coming up short? Read the other entries in this blog to find additional ways of capturing savings that you may not be recognizing). 

But wait...to get the true picture of whether your program is worth its cost, you need to add in the total cost of program management. Here's your list:

  • Internal Cost: This includes not only your salary, but the other costs to the company related to you and any other employees supporting the corporate travel program. This means your T&E costs, equipment, phone charges, space allocation, training, etc. It may be hard to get the exact cost of these items, so I would suggest asking Finance for a suitable percentage based on the total employment and total costs to the company for supporting employees ("overhead costs"). Let's just say here that this figure is 10%, meaning you must add another $9,800 to the average salary to come up with the loaded costs. Do the same for each FTE that supports the program...so if there is another person who splits his/her time between travel management and facilities for example, add half of that person's costs to your program management costs.
  • TMC Cost: This should be simple to calculate. Just get a statement from the travel agency(ies) that support your program that shows how much your company paid them for services in a given time period. This typically includes transactions fees, account management fees, maybe licensing or reporting fees, services fees for RFPs or benchmarking.  Just the total amount paid to them. 
  • Other Cost: If you engaged a third-party to help support your program--like consultants (a wise investment), safety/security services, audit firms, RFP assistance, data aggregators, benchmarkers, etc.--then total up how much you spent on these services.
Now you have all the components of your program management costs. I assume you also have your spending and savings totals for the same period. That's all you need.


Formula
Program Savings / (Internal Cost + TMC Cost + Other Cost) = Program Management ROI


Let's do an example with the following data points:


  • Internal Cost = 1.5 employees with a total compensation of $115,000 plus a 10% overhead cost for a total Internal Cost of $126,500
  • TMC Cost = 10,000 transactions at an average of $20 per transaction, plus $10,000 in account management, plus $10,000 in hotel RFP fees. Total TMC Cost = $220,000
  • Other Cost = $10,000 for safety/security program, $25,000 for airline RFP help. Total TMC Cost = $35,000
  • Savings = total for airline, hotel, car rental, TMC, and behavioral savings = $500,000
So, the formula is:
      $500,000 / ($126,500+$220,000+$35,000) = $1.31

This means in this example, for every $1 spent on travel management, the company saves $1.31. 
     
Usage
Okay...now you have a number...what do you do with it?


First, if the number is less than $1.00, that means that your cost is higher than the savings you are generating/capturing for the company. You need to read this blog to find other ways of capturing savings that your program may be generating. Some of these metrics are a bit challenging to calculate, but let's face it, you need all the help you can get. 

Next, if your program seems to be saving less than it costs to administer, start benchmarking with peers to see where and why your program is falling short. Maybe your airline discount levels are too low compared to what your volume can typically justify. Maybe you need to expand your hotel program. Maybe you need to look into promoting travel alternatives like videoconferencing. 

Let's say your figure is over $1.00. That means you're saving more than  you cost. Congratulations. Your next step is to benchmark this result with other peer companies to see how you stack up. This is a safe metric to compare because it doesn't reveal your actual total spend, costs, or savings. It's just a benchmark number that can be easily compared with other companies' benchmarks.

If your number is higher than others, then you can point that out internally. Maybe use it to show that you are under-staffed compared to others and that your savings supports hiring more help. 

If your number is lower than others, then see the first couple paragraphs of this section.

Caveat
Relying strictly on spend-and-savings metrics can be a dangerous game. A well-managed corporate travel program creates value that can't be easily distilled into dollars. 

A strong safety program with processes and protocols helps the travelers and the company by minimizing risk. The value is real, but difficult to quantify.

Ensuring that the level of customer service delivered by the TMC and suppliers saves travelers time and grief. I suppose you could quantify some time-savings created by eliminating the traveler need to search for the lowest fares from multiple sources, or to measure the impact on employee morale of having a TMC available to help when events necessitate a change in plans, but those are hard to calculate and some people seem them as dubious measurements. 

Tracking and mitigating environmental impact supports many companies' green initiatives, but quantifying the dollar value that a supportive travel program creates is challenging as well.

So...it's good to have a positive ROI. It's also good to make sure that everyone at your company recognizes the other values your program creates. Be proactive in managing this, or someone else might do it for you.


Tuesday, March 12, 2013

#8: Valuing Hotel Amenities


Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: Yes                                               ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description
Okay. You've negotiated the best daily rate you could at a hotel. You then negotiate to include free breakfast and free WiFi. How do you realistically account for the savings generated by these 'free' extras?


Formula
Regular cost of amenity x % of population likely to use it x Room Nights = Projected Amenity Savings

For example, let's say the cost of WiFi, in the absence of your agreement, is $9.95 per day. You project that 80% of your travelers would have otherwise purchased WiFi access (and expensed it). You put 300 room nights into this hotel under this agreement.

     $9.95 x 80% x 300 = $2,400 in WiFi savings

Do the same for breakfast, airport shuttle service, and any other amenity that replaces costs that would have been spent otherwise.



Process
How do you come up with the percentage of travelers likely to purchase and expense these amenities? 

You could dig through a representative sampling of expense reports to come up with an answer. Depending upon how detailed your expense reporting requirements are, you may find this information challenging to sift through.

Ask the sales manager at the property what their take rate is for each amenity. I typically use this as my first data point. 

Then I augment what I've heard from the property by asking the travelers. A quick, targeted survey, done annually with your traveling population, can help you establish baseline percentages for your assumptions. (TIP: you may want to offer something in return for responses like a drawing for a free weekend stay at a hotel to ensure a strong enough response rate). 

I take what I've learned from these sources, drop it down a little to be conservative, and use the resultant percentages in my calculations. 

I usually see about 80% for WiFi usage (although this is dropping with greater use of smartphones that can access emails via cellular networks). I put breakfast at about 25% (or 0% if it's not reimburseable). The shuttle service can be a big savings, but it's very dependent upon location (i.e. do people still have to rent cars to get to the destination or is the hotel very close?). 



Usage
Let's assume you did a great job at negotiating a rate of $25 under the standard corporate rate at the hotel in the example above. You put 300 room nights in there for a rate savings of $7,500. Without adding in the value of the amenities you negotiated in as well, you are under-counting the value you created. You can add the $2,400 for WiFi savings, and maybe $1,000 for breakfast as well. That just improved your savings figure by almost 50%

Do this exercise for each of your top properties (in terms of room nights) and make conservative assumptions for the other properties that mirror percentage-wise what you're saving in the top hotels in your program. Add this savings figure to the total you report to senior management, your boss, and the traveling population. 

Thursday, March 7, 2013

#7: Travel Agency Transaction Fees


Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: No                                                 ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description
When it comes to metrics, I've always embraced the "Trust But Verify" approach. Your travel agency (or travel management company or TMC) should be your trusted partner in managing your company's travel program. You pay it a fee in exchange for its assistance in reservations and service.

But let's face it, sometimes wires get crossed. Sometimes you are paying more than your agreement outlines, but because no one is paying close enough attention, you never find this out. I'm not saying a TMC would do this purposefully (and hope to remain in business), but I have found that doing a quick and easy measurement of fees is worth your time and effort. 

This metric works if you are paying your TMC a transaction fee for each reservation. You simply measure the number of charges you receive compared against a benchmark like airline tickets issued. We know that the number of TMC fees should exceed the number of airline tickets issued because of changes and refunds, and the like. It's the change in the ratio between TMC fees and Airline Tickets that is the key here.


Formula
Total Number of Transaction Fees Charged / Total Number of Airline Tickets = Travel Agency Fee Ratio

For example, one of my clients began its partnership with a TMC with a ratio of 120 transaction fees for every 100 airline tickets issued (a ratio of 1.20). This metric slowly increased over the span of two years to 151 transaction fees for every 100 tickets (1.51). 


Usage
As you can imagine, this metric sent off some warning bells once we started measuring it. The funny thing is that we never would have noticed it in the normal course of business, but we were looking for the total we paid the TMC for a year and simply applied historical measurements to it. 

Turns out that both the TMC and the company were "at fault." The TMC was double-counting certain online transactions that were 'touched' by an agent (instead of simply reverting to a 'touched' fee, the TMC was charging both the initial fee and a touched fee). Because the company was pushing online adoption hard, but hadn't given enough training to the travelers on what information was required for billing, a larger number of transactions were transitioning from no-touch to touched.  The agency corrected its transaction billing, and the company increased training to streamline the booking process.


# 6: Travel as a Cost of Sales


Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: No                                                 ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description
In the ideal world, every business trip would generate more revenue than its cost. That's not the way the world works however. There are always trips that do not directly, or even indirectly, increase sales. While teasing out which trips pay for themselves and which do not is challenging, tracking overall travel costs compared to revenue can tell you if your program is getting better at reducing travel expense as a percentage of overall company revenue. Highlighting this metric can even encourage senior management to start paying more attention to what it truly costs from a travel perspective to acquire and retain business. 



Formula
Total Travel Spend / Total Company Revenue = Travel as a Cost of Sales

     alternatively

Total Managed Travel Spend  / Total Company Revenue = Managed Travel Spend as a Cost of Sales


Process
For Total Travel Spend take the sum of all Travel & Entertainment (T&E) reports. You can usually get this figure from Finance.  Next, for public companies, getting the revenue figure is easy. Simply take it from the annual report. If your company doesn't publicly release revenue figures, you can get this figure from Finance. 

Now divide the first into the second to get a percentage. If Total Travel Spend was $1M for a given time period, and company revenues was $14M, then the Travel as a Cost of Sales figure was 7.1%. 

You could do this with Managed Travel Spend (e.g. anything that's booked through your preferred agency or tracked under your negotiated agreements--typically airlines, hotels, car rental, and ground transport). This figure will be lower than the Total Travel Spend (which would include "un-managed" items like meals, taxis, etc.).  This may be a better metric for showing the value your program is creating, but it lacks the brutal simplicity of the former. 


Usage
This metric should be tracked over time, ideally quarter by quarter. It's usually easy to go back and get the historical data to get started. The goal of this metric is to a) highlight that travel is a manageable part of the Cost of Sales, b) identify any out-of-the-ordinary spikes or troughs that could identify potential problems, and c) to elevate travel management to a more strategic level in the company. Use this metric correctly, and senior management will be coming to you for ideas on how to optimize the cost of travel for the company.


Caveat
Of course, this number in a vacuum doesn't do you any good. "7.1%? You don't say? [yawn]"

I can see three clear uses for this metric.

  1. Oddness: this metric is good for identifying potential issues that might not normally be detected over time. Let's say your quarterly figure trends around 7% (with a couple of tenths of a point variance). Then one quarter it shoots up to 9.5%. Something is up. This metric won't tell you what it is, but it can help you bring it to senior management's attention. 
  2. Benchmarking: this is a handy benchmark figure that eliminates the impact of revenue and cost variances.  A company with $100M in sales can benchmark the Travel as a Cost of Sales against companies with $10M in sales and $1B. 
  3. Travel Alternatives: Let's say you want to see the impact of a new strategy or tactic in travel (e.g. videoconferencing, gamification, etc.). It is notoriously challenging to measure the ROI of videoconferencing for example. Rather than focus on a reduction of travel costs (typically the metric IT uses for installing videoconferencing), you can augment this with the Travel as a Cost of Sales. The number of trips taken may decline with the introduction of videoconferencing, but because the technology allows for more people to join in a meeting--the sales person on site could have his IT, Legal, and Product people join via videoconference--revenue should go up and travel costs should go down.  The Travel as a Cost of Sales helps measure this impact. 

Monday, February 25, 2013

# 5: The Preferred Hotel Savings Metric (Easy Version)


Metric Type                                                      Level
     SAVINGS: Yes                                              MASTER
     SERVICE: No                                                 ADVANCED
     SAFETY: No                                                   BASIC
     SUSTAINABILITY: No

Description
There are a number of different ways to calculate savings from contracts your company may have with hotels. None are perfect. Maybe that's why so many corporate travel managers and travel management companies shy away from even trying to quantify savings. Of course, if you have done the work to set up a list of preferred hotels, you might as well get credit for the savings. 

This posts shows the simplest form of calculating hotel savings from contracts (we called these 'preferred hotels'). 


Formula
Preferred Hotel Contract Savings = Dollars Spent in Preferred Hotels / (1 - Average Savings % for Preferred Hotels) x Average Savings % for Preferred Hotels


Process
At the time you negotiate your hotel rates (typically Q3/Q4 for the following calendar year), you must identify the difference between the standard rate your travelers would pay without a negotiated discount and your contracted rate. For example, if a hotel's typical corporate non-contract rate is $150, and you negotiate a rate of $125, your savings is $25 per night or 17%. 

Do this with each of the hotels you have in your preferred hotel program (some firms have only a few while others have hundreds). Average the savings percentages together to find the average (mean) discount.  [NOTE: you may want to weight the average if you have a few hotels with significantly more room nights than average, especially if your discount percentages with these hotels is significantly different than the median discount). 

Whichever way you do it (unweighted or weighted), you have now identified your Average Savings Percentage for the entire year (assuming your program and your travel trends don't change). 

Now, using data supplied by your travel agency, identify how much spend your firm had in these preferred hotels for a given time frame (quarterly is pretty standard). Then simply apply the formula above to come up with a good, yet conservative, savings projection. 


That Was Too Easy
You have to acknowledge that this is a relatively rough (although perfectly credible) estimate.  Things to keep in mind:

  • Because we are using an overall average, the "true" savings figure will most likely not be exactly what you calculated. When you think about the work that would go into researching and documenting every single reservation (whether it was made via the travel agency or not), the cost of getting a more accurate number seriously outweighs the value of having a truly accurate figure.
  • Some may argue that if the preferred rate wasn't there, the traveler would have stayed in some other place at the same rate (because the travelers is oh so budget conscious). Point out that the reasons hotels are selected for your list go beyond simple rate calculations. Consideration is given to proximity to office or client destination (saving ground transport costs), quality of the property (cheaper hotels may not be of a reasonable enough standard for your travelers), and savings from negotiated ancillary services (calculations for which to be discussed in another post).
  • Finally, for most companies, only a percentage of hotel bookings are actually made through the travel agency. Industry benchmarks show that 40 to 60% (more for non-US locations) of room nights are not booked through the agency. Some unknown portion of these 'unmanaged' room nights are booked in the preferred hotels at your preferred rate anyway. By only using the travel agency's reporting, you are purposely under-counting the savings. Therefore, the hotel savings you are claiming with this calculation are actually conservative if nothing else. 


Usage
This metric should be used in your communications to your boss, senior management, and the travelers. Clearly highlighting the value of these programs, and asking for more compliance (both in staying at these properties and booking through the agency) can help you improve the savings figures each year.

This type of metric is easily understood by non-travel professionals, although as we noted above, some push-back may be expected from some cranky quarters.

Sunday, February 24, 2013

# 4 Stakeholder Satisfaction


Metric Type                                                      Level
     SAVINGS: No                                                  MASTER
     SERVICE: Yes                                               ADVANCED
     SAFETY: No                                                    BASIC
     SUSTAINABILITY: No

Description
Simply put, corporate travel is in the customer-service business. If people do not like the service, they will push back, sandbag, complain, and work against the other goals of the program. It won't matter how much your program is saving if all senior management hears are complaints and criticism of the program. Employing and maintaining a structured set of satisfaction metrics enables you to a) get ahead of service issues before they blow up, b) communicate real results company-wide that minimize the impact of one-off anecdotes about horrible service, and c) show value to the company beyond simple spend-and-savings statistics.

To get started, all you need to do this are three questions and a survey tool (many online options to choose from). 

  1. How well does the company's travel program suits your needs as a business traveler and/or arranger of business travel? Rate your satisfaction on a scale of 1 (Not At All) to 100 (Perfectly).
  2. What do you think the travel program does particularly well? [Comment Box]
  3. What do you think the travel program could do better? [Comment Box]


Why These Three Questions
The first question provides you with a benchmark score to compare over time. The following two questions are where you find out what people really think about the program. Simply read all the comments, categorize them based on what the comments relate to (e.g. the agency, the online tool, airline, etc.), and you have all the information you need to improve the perception of the program. 


After That
Asking questions is the easy part. However, it is critical that once the survey is complete that you quickly perform the following tasks. 

  • Address any comments that require immediate attention (whether because of the timeliness of the complaint or the importance of the respondent). 
  • Next, review the results and the comments with the agency, the front-line agents, concerned travel suppliers, and other relevant parties. 
  • Draft action plans to address any significant and/or frequently cited concerns.
  • Publish a summary of the responses. Highlight the overall satisfaction score, note some of the positive comments received, and share a high-level summary of the action plan to address some of the common complaints or opportunities for improvement. This summary should be published no later than 1 month after the end of the survey period. 

It's been said that one of the best ways to demoralize a group of people is to hang out a suggestion box and to ignore it. Think of the surveys as a periodic suggestion box. Once people see you are listening to them, engagement and satisfaction increases. 


Whose Satisfaction Are We Measuring?
Certainly the travelers and travel arrangers. You should do this at least twice a year, and as frequently as once a quarter if you can. You can get a list of who traveled and/or who booked trips during the time period since your last survey. 

Department/line managers who have significant numbers of travelers should be surveyed twice a year. For them, modify the first question to "How well does the company's travel program support your department/line of business?" or something similar to change the focus from the individual to the department. The other two questions stay the same.

Senior/executive management should be surveyed once a year. Again, simply adjust the first question to focus more on the company overall rather than an individual or a department. 

Suppliers with whom you have contracts and/or a lot of business should be surveyed at least once a year. For them, the focus is on how your company is perceived as a client and the ways in which you can improve your relationship to better serve both entities. 


What about Other Questions
When designing surveys, people tend to get question-happy--piling on question after question to try to learn everything about everything--seemingly afraid that they'll never get another chance to ask a question.

You can certainly add a couple of questions to the Basic Three. Here  are a couple you might consider:

  • For the traveler/arranger survey, ask whether they felt they were quoted the lowest logical fare when making reservations (whether or not they took it). There is a strong correlation between low fare perception and overall satisfaction. Sometimes it's real, but sometimes the respondent doesn't take into account how the firm's travel policy affects what fares are offered.
    • Consider having your agents add this to their script: "The lowest fare, based on the company's travel policy, is $650. However, there are fares between these two cities that can run as low as $250, but you would need to be flexible with your times or dates. Do you want me to investigate those for you?"  A few will actually work with the agent to look for a lower fare, but the majority will simply gain a better perception of the low fare performance of the agency--in turn improving overall satisfaction rates. 
  • You may also wish to differentiate between satisfaction with the live travel agents and the online booking tool (if you employ one). The variance between these two modes of reservation can be stark. 
What you want to avoid when adding questions are those whose answers do not inform actions. For example, I've run across surveys that ask "Do you find the agents friendly, knowledgeable, and professional?" The results show that 67% of respondents do. What next? Does this mean that the agents are friendly and professional but not knowledgeable? Or some other combination? Do one-third of the respondents simply not like the agents? You can't tell from the way the question was phrased. This is the inverse of the old maxim which in case says:  If you can't manage it, do not bother measuring it.



Usage
The first question is used to evaluate, over time, changes in the perception of the travel program from a range of stakeholders. The others are used to inform your short-term action plans to improve and/or enhance certain aspects of the program based on respondents' feedback. 

This type of metric is easily understood by non-travel professionals.