Cross Functional Flowchart

and more Excel flow chart templates for business process mapping

 

The Functional Flowchart
Most business process engineering starts with a flow chart template that has a swim lane for each person, department, or functional team that is involved with the process - showing an intuitive graphic depiction of who is doing what, when, where, and for how long.

Similar to a value stream map, the Time Sum Line at the bottom of the Systems2win cross functional flow chart auto-calculates cycle time (hours or minutes spent actually working) & lead time (days or weeks sitting in someone's in basket) for the entire process, and for each swim lane - so you know how many hours are needed for each Department to staff your re-designed process.

 

on order page

Free Online Training
Download free trial

 

Download a free trial - and try if for yourself

The above animation shows how you can use Excel Scenarios to depict and analyze different scenarios on a single flowchart
(in this case a typical process vs. a rush order)

Things to notice:

  1. The background color changes to highlight the processes that have a Path code matching the currently-selected Path code

  2. The same process can have a different Path code in each scenario

  3. All of the Lean metrics are calculated based on only those processes included within the currently-selected Path

  4. The error-checking cell turns purple when the Path code does match the Path code for the Imported Comparison Data - thereby alerting you that if you want to view valid comparisons, you would need to also include the comparison data for the X Path code within your scenario data

 

 

Purposes of a Cross Functional Flow Chart

also known as Metrics Based Process Map

  1. You start by drawing a simple flowchart - to graphically depict any business process that crosses functional workgroups
  2. When you're ready, you can optionally enter data to auto-calculate Lean metrics - to identify and eliminate waste
       See our free online training for Lean Time definitions

 

Paths and Scenarios

On the same flowchart, you can use Excel Scenarios to illustrate (and calculate) different paths through which the thing being processed might flow.

In the animated picture above, we illustrate two different scenarios:

  1. The Typical Path
  2. A Rush Order

Notice that the background color changes to indicate which processes are (and are not) included within the currently-selected Path, and that any or all of the Lean metrics data for each process can be different in each Path scenario.

By using Path scenarios, you can depict and analyze multiple possible process flows - without wasting your time re-drawing a similar or identical flowchart for each scenario.

 

Bottom Line Lean Metrics
that auto-calculate if and when you enter your data

See our free on-line training for Lean Time Definitions

 

Value Add Metrics

If a process has a Value Add code of "V", then it will always be included within Value Add metrics.

If the process has any other (user-defined) Value Add code, then it will also be included in Value Add metrics if (and only if) the Value Add code matches the Value Add Include code that you have currently selected.

This allows you the flexibility to do value add analysis both the traditional way - and to invent creative ways to analyze productivity in ways that are more useful than traditional value add analysis.

For example, for many back office processes, every process step is technically "non-value-add" from the customer's perspective, which isn't very useful or motivating for the people charged with improving the process

 

Metrics per Swim Lane
to answer each Vice President's question: "How will these proposed changes affect my people?"

Unit of Measure Conversions

At any time, click a button to switch Lead Time Unit of Measure between:

  • Working days
  • Calendar days
  • Weeks
  • Hours

Choose Cycle Time Unit of Measure:

  • Seconds
  • Minutes
  • Hours
Side-by-Side State Comparisons

 

With the click of a button, Import Old State Comparison Data

 

Things to notice:

  • It does error checking - to make sure that the imported data is a valid comparison
  • The ∆ Delta Change formulas are directionally correct:
    • Black is good
    • Red is bad
    • Grey requires human judgment to determine whether an up or down change is good or bad
  • You have the option of either entering manual comparison data and/or importing from another worksheet with the click of a button
  • When you click on any row or column heading (in any Systems2win template) pop-up help will appear

 

This Systems2win Cross Functional Flowchart is designed to make it truly easy for you to:

  1. Start out by making a simple flowchart drawing
    then, when you're ready...
  2. Enter data to easily analyze the effects of proposed changes

 

 

At Systems2win, our mission is to continuously improve tools for continuous improvement
So what do you think? Is this flowcharting tool a little more capable than the one you've been using?

Why not try it out?

with a 30-day money-back guarantee

 

 

Flow Chart Training & Demo Videos

Tip: It may be a few weeks before our flowchart training videos are updated to showcase new version 7 features (released in December), but why wait? Why not download a free trial and see for yourself what's new?

 

 

 

Flow Chart Software Comparison:
When to use a flowchart vs. other Lean tools

Compare flowchart software to other Lean tools

Value Stream Mapping flowchart

Value Stream Map

Value Stream Mapping is a strategic tool that uses special symbols and Lean metrics to depict the flow of a product or service (and the information needed to plan and control the flow of that product or service) through an entire stream of value-adding processes - each of which might drill down to further details illustrated using one or all of the following tactical tools.

Spaghetti Map flow chart

Spaghetti Diagram
also known as Standard Work Chart or Layout Diagram

A Spaghetti Diagram is a process mapping template that shows a floor plan of your work area, and graphically shows the walk paths of each worker, and which operations are done where, and how much of the thing being processed is stored where.

Standard Work flowchart

Standard Work Combination Sheet

The Standard Work Sheet is the ideal tool for designing and documenting Lean processes with short cycle times. (For example a manufacturing process that takes five minutes, or a loan approval process that takes 2 hours)

Simple Flowchart

A simple flow chart (without swim lanes) is probably the most familiar process mapping software to graphically illustrate "who does what", and what decisions need to be made along the way. And we all know how many words one picture is worth...

Note: When you purchase the Systems2win Process Engineering bundle, you get multiple flow chart templates. You get the simple flow chart template and the cross functional flow chart and the reengineering matrix and even more Excel templates for deeply analyzing your process flow chart.

Cross Functional Flowchart

The swim lane flow chart is the ideal process flowchart for designing and documenting processes with medium-length cycle times. (For example a sales order process, engineering changes, or any process that takes days or weeks rather than minutes)

 

It is not uncommon for a company to "throw in" the Process Engineering tools when buying multiple bundles of Systems2win process improvement tools when they originally came shopping for Value Stream Mapping software, a Spaghetti Diagram, Standard Work, or Kaizen tools, and then in a year or so come to notice that the template that they actually use the most is the Functional Flowchart.

Fortunately, when you purchase the Systems2win process flowchart templates, you don't need to choose. Every one of these power tools can be packaged together when you take advantage of our discounts for multiple bundles - so that you can empower your team members with all of the flow chart tools that they need for any lean process improvement project.

 

 

 

 

Comparison: Flow chart software vs. flow chart templates

  Systems2win Excel
flowchart templates
Less capable flowchart software
Functionality

Systems2win offers ALL of the types of flowcharting tools described above - so that you have the right tool for every process and phase of continuous improvement

?

Ease of use

Everything you know about Excel - you can use in these flow chart templates
Everything you learn about these templates - you can use in any other Excel worksheet

?

Online help

Extensive help includes:
a) Sample page with extensive training
b) Online help for how to use Excel & Drawings
c) Video training

?

Online education

Extensive on-line education to ensure that your people understand the foundation teaching of Lean & Kaizen

?

1 year free technical support

Yes

?

Price

Steep quantity discounts and volume licensing for unlimited users -
to empower every one of your team members with the tools they need to participate in the continuous improvement of their own work

 

on order page

Why not try it out?

with a 30-day money-back guarantee

 


See discounts for multiple bundles
and optional pricing for unlimited users

View Demo