What is scope creep?

Scope creep = client wants more work done for the same money.   Not pretty.  It’s no surprise that consultants dread it.  It usually means late nights, grumpy analysts, dissatisfied clients, and potentially lower project margins.  All bad things.

In the end, it is a fancy word for misunderstanding.  What the consultant and client expect the project to deliver is different.  Sometimes it is the consultant’s fault for being unclear, sometimes it is the client’s fault for adding things on last-minute.  The consultant thinks he is  solving problem A, and the client thinks the consultant agreed to solve A+B+C.

Scope

It takes all kinds of forms.  This monster has many different shapes and sizes.  Ask any consultant, and he will commiserate with you about scope creep for several beers.

It happens all the time.  Although it rarely derails a project completely, scope creep is like the common house cold.  It happens on every project in one form or another.  Sometimes it’s just a client’s passing suggestion and other times it’s phrased more like a demand.

Scope creep = out of control.  Beyond the work and the money, I think there are other reasons why consultants find scope creep so demoralizing.  It’s a barometer that the project is not under control.  And trust me, consultants like to be in control.

Consultants are effective because clients have loaned us some of their organizational and political clout to set the pace, nudge clients into action, and keep the takt time of the work.  We have the leverage to get things done through our interviews, workshops, surveys etc. .

So when the client question the scope of the work, well. . . .  it’s a bummer.  It’s like one parent being second-guessed by the other parent in front of the kids.  What will the kids think?  This type of push-back chips away at the perceived (or actual) control we have of the project.  Even though clients are advocating for the consultants to do more work, perversely, the clients are making it harder for the work to get done.

Scope creep = longer project.  Consultants like project-based work.  We like the challenge of new projects and tend to get bored doing the same thing month-after-month, or -gasp-, year-after-year.  Project work is great because it has a start / middle / end.  There is a sense of accomplishment when all the work is turned in and the client says “thank you”.  Scope creep means delaying the celebration and satisfaction of a job well done.

Remedy #1: Be smart from the beginning.  Ideally, the project scope is clearly outlined in the proposal and the statement of work (SoW).  It is common for the SoW to be fairly explicit on what will get done during the course of the project.  Clients sometimes find it a bit repetitive and process-oriented, but it is really the only thing that protects the team and keeps guard-rails on the project.

Remedy #2: Re-iterate scope.  Don’t want to be too heavy-handed about this, but it’s helpful to remind the clients of the project scope.  Have them confirm your progress, and implicitly, agree on the end point.  There are subtle ways to do this too.  For example, you might have a page in your interim presentations which looks like this.

Controling scope creepYou can update it regularly to track progress.  The storyline goes. . . “We finished phases 1 and 2, and now we are focused on phase 3.”  If this is the same diagram that the client saw in the SoW, even better.  The more clients see it, the less likely they will fiddle with it.

It’s like a rock climber who puts anchors in the rock as he climbs; even if he falls, he doesn’t fall that far.  In the same way, the project milestones anchor the project’s progress.

Remedy #3: Say no the right way.  Scope is the senior manager / partner / director’s job.  They must protect the project team and manage the client’s expectations.  It only makes sense that the “boss” of the project is the one to gently push-back on the client:

  • They are usually the ones who have the client relationship
  • They are the ones who approved or wrote the statement of work
  • They own the project profitability and can decide to add more resources if needed
  • They are the “bad cops”. The day-to-day team can stay in the client’s good graces

Remedy #4: Be flexible.  There are times when it makes sense to give a little and do the extra work.  Sometimes, it doesn’t.  Saying YES to clients can get consultants in trouble.

Clients want to feel like savvy buyers of consulting services.  Clients want to have an answer to their boss’ sharp question, “Did we really need to hire the consultants?”  Our job is to give the client enough value (and coaching) so they say “Yes.”

Remedy #5: Think like Ferrari.  Clients pay us for our experience, objectivity and professionalism.  As Enzo Ferrari said, “The client is not always right”

Scope Creep - Enzo FerrariRelated Posts:

Misleading Graph #1: Starbucks Investor Presentation

Charts can mislead.  In most cases, it’s accidental.  Perhaps someone was over-eager to show good results, or maybe, just did a sloppy job of formatting.  Whatever the cause, it’s bad mojo to put together analyses or charts that mislead.  Here are some bad examples  from Starbucks’ recently investor conference.  You can see all the slides here:

#1.  No axis label.  This is no-no.  A chart without a labeled X&Y axis is like a car without an odometer.  Not a good idea.

Bad graph - no axis

#2. Not drawn to scale.  Below, you can see that Starbucks is comparing its revenue with operating income.   Since the scale is different, the operating income actually looks bigger than revenue.  That ain’t right.

Bad graph - Not drawn to scale3. False or unnecessary comparisons.  Same problem below.  The coffee executives compare US & Canada & Latin America but use different – seemingly random – scales.

The 2012 revenues are shown with red dotted lines.  When you line them up, they look similar in size – when in reality – it should look like the graph at the bottom right.  The US is where the current revenues come from and Latin America is a rounding error.

Bad graph - inaccurate comparisons

Why make the comparison?  There was no reason to compare the US, Canada and Latin America.  They are at different stages of their growth.  Why force the comparison?

Comparing the US and Canada makes sense.  They are both mature markets with similar GDP per headcount and analogous cultures.  Taking the population for the US and Canada here, you can see that the average American and Canadian spends about the same on Starbucks annually.

Starbucks per AmericanAnalyze Latin America by itself or against other emerging markets.  Looking at Latin America over the last 3 years, looks like they went from $76M to $115M to $143M.  Nothing shabby about that.  Why not focus on that story separately.

Clarity is your job.  At the core, a consultant’s job is to drive clarity – through the data, analysis, and presentation.  Anything you do to over-simplify, obfuscate, or muddle the issue is bad.  The client can be confused by themselves – without paying your fees.

Why do consultants use PowerPoint so much?

Consultants spend hours making slides.  It’s a common sight to see consultants pouring over their PowerPoint slides – moving pages around, adjusting the colors on graphs, mulling over wording, checking verb agreement and proof-reading.  Presentations are also called “deliverables” because they are the products that we deliver to clients.  It is a core part of the job, but commonly misunderstood.

To the casual observer, it might seem excessive or a waste of time.  Who knows, some might even think it is narcissistic – like someone who spends too much time in front of the mirror in the morning.  After all, isn’t it the content that is important?  Why bother with all the structured presentation?  Couldn’t this all just be put into a written document or memo?

“Oh, you are so good making pretty presentations.” I have heard this more than once and it drives me a little crazy.  The “pretty” part of the presentation is the equivalent of choosing the garnish for a plate of pasta, or the jacket design for a book.   Are clients paying $250-$500 per billable hour for presentation jockeys?  Doubt it.

So why do consultants use PowerPoint so much?

1. It forces brevity.  Good presentations are succinct.  They may have a 60 page appendix, but the executive summary will be terse and have a point of view.  Using the analogy of a tree, the presentation is the fruit.  The consultant may have paid their dues with endless late nights, analysis and interviews, but the end result is a presentation.  There is no glory in showing the client all the gory details.  You need to really boil it down to its essence.  Apply the 80/20 principle, and give the client only the good stuff.  Harvard Business School essays have a limit of 400 words, which is damn tough to do.

I would have written a shorter letter, but I did not have the time – Blaise Pascal, mathematician logician, physicist 

Powerpoint - Graph2. Executives are short on time.  Often times, the executive sponsor of a project will really only commit 10-12 hours of total time for a 4 month project.  The client project lead will be working with you on a day-to-day basis, but you have to remember that executives are short on time, and long on opinion.  They are not going to read a 100 page MS Word doc.

Powerpoint - Graph3.  Communication is the goal.  Consultants are hired to effectively solve problems.  This often means persuading people to take action.  It’s not enough to put smart things on paper; there needs to be results.

Often times, pieces and parts of the presentation are used by the client to “sell” the recommendation to other people – the boss, peers and others.

4. Executives are visual people.  Maybe it’s because they deal with lots of information (reports, emails etc) every day. Maybe they just watch too much TV like everyone else.  Graphs, tables, lists, groups, diagrams all help to convey a lot of information in a concise way. Each of the shapes below can help convey meaning.  They are archetype frameworks:

Powerpoint - Graph

  1. Stage-gate process – narrowing down of options, projects, investment ideas
  2. Phases of a project – start, middle, and end
  3. Venn diagram – the overlap of 2 distinct things
  4. S curve – the evolution, growth, and plateau of a function
  5. 2 x 2 matrix – simple X vs. Y axis

5. Most people are terrible at it. This might be counter-intuitive, or just cynical, but most people are terrible at putting together compelling presentations.  Just go to www.slideshare.net and randomly look up presentations.  They are generally awful.  Full of text, no narrative, no takeaway.  They are essentially a compilation of facts, or a copy/paste from a document.

Big win for consultants. As long as people are crappy at distilling complex problems into easy-to-follow, logical recommendations that are easily communicated to executives. . . more billable hours for us consultants.

What is a good excel model?

Recently, I was given an excel model that was like the Titanic: large, slow, overly ornate, and structurally unsound.  Not only was it frustrating to work with and laborious to fix, it was also a bit laughable.  It did not answer even the most basic questions:
.
Who is the customer?  In my mind, this is the very first question you have to ask because frankly – not all of your excel work will be seen by other people.  Often, it is just something basic that you put together.  It may be just a glorified calculator.  Perhaps it is just a pivot table with some VLOOKUP formulas.  No need to format it and make fancy graphs because, honestly, you are the only one to use it.
.
The more complex the problem, numerous the potential solutions, or discerning the customer – the better your model needs to be.  Using this graphic below, you have to start at the bottom with the basics and build up to a real client-ready excel model.
Good Excel Model - Excel Levels - Graph#1. Is the model logical and accurate?   At the very least, the excel needs to make sense to you.  Using the analogy of boat-building, think of this like a raft.  Something Tom Hanks built on Cast Away or similar to the photo.  It needs to float and not leak water.
Good Excel Model - Wooden raft
Translating that to excel, it means asking yourself basic questions like:

  • What am I trying to calculate?
  • What data am I using and is it clean?
  • Is my data sample size (n = ?) big enough to be meaningful?
  • How am I organizing my data so it does not look like a sock drawer?
  • How is the data going to be analyzed?  How do I stitch it together with math?

Good Excel Model - Sailboat#2 Is it flexible?  Once the data is organized and the calculations are working, you can start the “thinking part” of the exercise – the actual modeling.  Since the whole point of an excel model is to test the results, make sure it is convenient to change things around.  The last thing you want to do is make the excel model hard to work with.

This is a tool to prototype solutions and run “what-if” analyses.  The excel should be like the dinghy: simple, efficient, fast, nimble.   A few pointers might be:

  • Don’t hard code (type in the number) for any calculations
  • Reference the same source cells (so that 1 change affects everything)
  • Use consistent formatting and structure when possible
  • Don’t merge cells because it makes it hard to sum, sort, or filter
  • Keep the data separate and clean (no subtotals, no blank columns between data)
#3 Is it easy to use? The goal here is to make the model both easy-to-use and also easy-to-audit.  After spending 40-50 hours putting this monster together, spend a little time cleaning it up.  You don’t want half-baked, left-over calculations everywhere.
This is critical because you want your team’s help to stress-test the model.  Make sure it is accurate and comprehensive.  A good consultant knows how to use the team.  Have other people to double-check your work.  You need to have some thick skin and know how to take constructive criticism.  Think of it like a pontoon boat that is easy-to-use and generally fun.  Make it a smooth review process for everyone:
.
Good Excel Model - Pontoon Boat
  • Document the assumptions (data sources, links etc) so it is easy to audit
  • Take out unnecessary data sheets or things unrelated to the model.  Just like an appendix of a book, put all the boring data tables and reference stuff in the back
  • If you have analyses (charts, tables), put them in the front of the workbook

#4 Is it visual? If your excel made it this far, it is actually a client-facing model.  You have to assume that everything is transparent, so nothing should be hidden.  No hidden tabs, no hidden columns.  Make sure that the fonts match and the calculations are spot on.

  • Put an introduction or table of contents to explain the way the Excel is organized.  If you want the reviewer to print out pages, set up the print margins
  • Save the file so it opens up at beginning (top left).  It is disorienting to open the file up and it starts in the middle of a random worksheet, cell AL453
  • Use macros to automate messy calculations, but use this sparingly
  • Create a dashboard on the first page that shows all the major metrics and status.  Ideally, this is the only thing they look at because it is so comprehensive

Good Excel Model - YachtA client-facing excel model is like a yacht.  It has all the bells and whistles and is very refined.  A lot of the models made by investment bankers or valuation specialists are like this.  Each font color has a different meaning (e.g., black = input, blue = calculation), and the excels are formatted for easy navigation without a mouse.  Note: investment banking analysts pride themselves on the fact that they don’t use a mouse.  All keyboard.

Source: Flickr commons: Raft (NathanGibbs), Dinghy (Singapore 2010 Youth Olympic Games), Pontoon Boat (Phil_g), Yacht (Alex Proimis)