And then there was JATO

And then there was JATO

It was 1996 and the project for Volvo Cars of North America (VCNA) was in full swing.

Six months before, we had moved out of our dusty old wood-panelled office in Davies Street into a beautiful Georgian building at the end of Stratford Place, opposite Bond Street tube station – Mayfair, oh yeah! Sorry about the flex, but this was a high point. The only fly in the ointment was that, as I was quite junior, my desk was in the basement with no windows. (Seniority often seems to be proportional to floor numbering, doesn’t it?) However, the whole building had generously high ceilings, including the basement, so it didn’t feel cramped. If you read my previous article mentioning Nigel climbing in through the window when we were locked out, the picture at the top shows the front of the building he climbed in his business shoes, which is impressive.

My office was open plan and there were about 20 desks, of which on a typical day eight to ten would be occupied, the other consultants working at client sites. The desks were arranged in groups of four. Opposite me was an American guy who would not stop talking. He didn’t seem to have a project to work on and just kept rabbiting on about nothing while I was trying to work – rabbit-rabbit-rabbit. So after a month I was relieved to hear from my boss John that he had fired him, apparently for wearing white socks. That wasn’t the only misdemeanour, just the last in a list of issues that suggested the guy really was not cut out for a life as a consultant.

I had been working on my spreadsheets. Broadly, our area could be described as Strategic Marketing. We were analysing the four ’P’s: Price, Place, Product, Promotion. Which of these factors affects a client’s sales level and how much influence does each of them have? If you have good data, you can do a statistical regression analysis and measure this. The regression analysis gives a number, a ‘coefficient’, for each potential sales driver that says how important it is relative to the others in driving sales.

John had suggested to the client that we could include in the analysis a detailed description of the specification of the cars we were analysing. He found a company, JATO Dynamics, that provided extremely detailed data on the specification of makes, models and variants of cars. For example, for a given model and variant, the JATO database would say whether the wing mirrors were electrically controlled or electrically controlled and heated.

I used this data to create what are called ‘dummy variables’ for levels of comfort, engine power, safety features and ‘gizmos’ (i.e. electronic features). The dummy variables were decimal numbers that approximated a relative level of development of each of these qualities. A 9.5 for comfort meant positively luxurious, a 5.0 implied the interior was a bit spartan. The plan was to feed these dummy variables into the regression analysis and to work out the relative importance of each feature to customers buying the cars.

Each dummy variable was a weighted average of the relevant features shown on the JATO database. Choosing the weights carefully was critical to success and it was also rather subjective, so my boss John planned to get the client to sign off on the choice of weights that I proposed. I had to create a spreadsheet in which the weights could be clearly seen and changed when the client came to visit. This was not easy.

The client project manager Alicia (pronounced ‘Alisha’ in the US) had come over from New Jersey, gone through the weights with me and signed off on them. Next it was our turn to visit the client in the US and John asked me to write a presentation to summarise how I had done the analysis, which I was to present to a group of senior managers at VCNA in New Jersey.

This was my first business presentation. I had written many essays at school and university, I had written and delivered a full semester course ‘Mathematics for Decision Making’ at Ithaca College London Center, but this silly little presentation felt like the hardest I had ever written. How do you explain technical subjects to lay people in an engaging way… with pictures? I tried to make it into an engaging story, explaining the process I went through, with the occasional statistics joke and there was a line I had prepared after a general description of the easier parts of the analysis that went, ‘*beat*… and then there was JATO’, where I explained how hard that part of the analysis had been. I thought it would be funny. I spent hours on it and was quite pleased with the outcome. Finally, I was ready to show my efforts to John shortly before our flight to JFK. He read through quite quickly and delivered his verdict:

‘Gideon’, he said, ‘the client doesn’t want to know how difficult it was. They just want you to deliver what they paid you for’.

Ouch.

That was such a useful lesson for a young consultant. You continually have to keep putting yourself in the client’s mind:

  • What do they want?
  • What do they need? (If it’s different from what they want, how can you break it to them gently?)
  • What is valuable to them, what is not?

I rewrote the presentation and it went well, thanks to John’s input.

To view or add a comment, sign in

More articles by Gideon Mitchell

  • Cloak and dagger

    After the TUI project which you can read about here, we had continued for a few months and then my boss John was either…

  • The birthday

    Something happened on my 40th birthday in June 1998 that highlighted my two completely different types of friends and…

  • Overselling it

    This is a cautionary tale about overselling, with a side-plot on clashes of culture and a reminder that sometimes other…

  • Something to prove, part 2

    In my previous article (you can read it here) I described how an exciting project had come in from BMG records to study…

  • Something to prove, part 1

    Things had been going well at Berger for the last year, with two projects for Volvo in America delivering extremely…

  • The high life

    I had not been outside Europe before, so I was full of anticipation for my first trip to the States. In the 1990s the…

    2 Comments
  • Big regrets

    If you have ever done any personal growth work, you will have heard that it is unhealthy to regret your life choices…

  • Hiding from scary people

    I loved maths at university and I think now that the problems I had with the PhD were more down to my lack of friends…

    2 Comments
  • A strange route from academia to consulting

    In 1994 I was doing a PhD in graph theory at Queen Mary College in London on the busy Mile End Road. It seemed like I…

  • A Formula Masterclass for Excel power users

    You’re already good at Excel, or you wouldn’t be reading this. But, even if you are better than just about everyone you…

Explore content categories