Need to Perform Gap Analysis But Don't Know Where to Start?

QI Macros for Excel has a Ready-Made Transition Planning Template to Help!

Why it Matters: As companies plan for an uncertain future, gap analysis can help. Wikipedia says that gap analysis answers two questions: "Where are we?" and "Where do we want to be?" And I'll add a third question: "How do we get there?" QI Macros Transition Planning Matrix template is a tool and a method for answering both questions.

Where Are We? Where Do We Want To Be?

The Transition Planning matrix has a column to describe the current environment and one to describe the future desired environment. While it's often easy to describe the current state of affairs, it takes some thinking and lots of Post-it notes to describe the desired state.

How Do We Get There?

Then there are four key steps that describe most transitions:

  1. Simplify, Streamline and Standardize (Lean)
  2. Optimize (Six Sigma)
  3. Expand into New Domains (Innovation)
  4. Competitive Advantage (pulling ahead of the competition)

The remainder of the matrix has four main sections: Strategy, Process, Organization and Technology (SPOT) that describe the key elements of a business transition. 


Business strategy consists of three key elements: innovation, improvement and impression. To survive and thrive, businesses need to maximize one of these elements and optimize the other two in service of the core strategy.

  • Innovation - Apple Computer
  • Improvement (Operational Efficiency) - Wal-Mart
  • Impression (Customer Satisfaction) - Nordstrom's


The ability to deliver consistently is a function of process. This section of the Transition Planning Matrix covers essential business processes. 


This section covers the various aspects of the human element of a company and its transitional needs. 


This section covers necessary technology changes.

Transition Planning

Once a company knows where it is and where it needs to go, the next step is to create the steps to move all four elements of the SPOT forward, in sync, to achieve the desired future. This involves more heavy thinking, because if you try to shift the Strategy without shifting the Process, Organization and Technology to support it, it will fail. The forces of inertia will hold the old behavior in place. 

Every step forward requires the synchronized movement of all four elements. This is why new technology often sits idle waiting for the SPO to catch up. Or a process change waits on technology. Or an organization change doesn't have the desired effect. 

Once a company starts shifting all four elements toward the desired future, it's easy to sustain the movement, but getting started is often hard.

Where do you want to be?

If your company or business or department isn't where you want it to be, the Transition Planning Matrix can help organize your thinking. The plan will change as you enact it, so keep updating it as you move forward. I think Woody Allen's joke in Annie Hall about relationships holds true in business: "A business, is like a shark. It has to constantly move forward or it dies. And I think what we got on our hands is a dead shark." 

Don't let your business become a dead shark. As Alan Kay said: "The best way to predict the future is to invent it." Invent your future with the Transition Planning Matrix.

Haven't you waited long enough?
Start creating your Transition Planning Matrix in just minutes.

Download a free 30-day trial. Get the Transition Planning Matrix now!

The Transition Planning Matrix is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu