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:

The background color changes to highlight the processes that have a Path code matching the currently-selected Path code
The same process can have a different Path code in each scenario
All of the Lean metrics are calculated based on only those processes included within the currently-selected Path
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

You start by drawing a simple flowchart - to graphically depict any business process that crosses functional workgroups
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:

The Typical Path
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

Lead Time - the time it takes to complete the process - from start to finish
Process Time - time that work is being done by a human being (not just an unattended machine)
Value Add Time - work that is value add from your end customer's perspective
Value % of Time and Activity Ratio - often embarrassingly small numbers
that dramatically illustrate how much room there is for improvement
Total Steps - a "step" happens whenever the thing being processed is (our could be) handed off or delayed
Value Add Steps - steps that do something that is value add from your customer's perspective
Cycle Time - Process Time divided by number of workers
Total Cycle Time - how often another thing being processed comes out the end of the pipeline
Rolled First Pass Yield - product of % Complete and Accurate for each sub-process
Takt Time - how often another thing being processed needs to come out the end of the pipeline to meet customer demand
Work Time Available - with all the power of Excel to take into consideration all factors affecting your unique work schedule
Pitch - the pace at which work is released and moves through the value stream
Capacity - how many of these things can we produce?
Staffing - how many full time employee equivalents are required?

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?"

Process Time - "For every unit processed - how much time will be required from someone in this department or functional area?"
Queue Time - "How long do things sit in piles waiting for someone in this department or functional area to get around to working on them?"
% Complete and Accurate - "What percent of deliverables come out of this department without need for downstream correction, addition, clarification, or rework?"

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:

Start out by making a simple flowchart drawing
then, when you're ready...
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?

Flowchart-specific training videos
- How to use Excel to create drawings every bit as powerful as Visio
- Units of Measure (6 min video)
- Flowchart First Pass - Identify the Process Steps (video coming soon)
- Flowchart Second Pass - Add Metrics (video coming soon)
- Flowchart Third Pass - Analyze and Improve (video coming soon)
- Flowchart Continuous Improvement - Add Scenarios (video coming soon)
- Import Old Comparison Data (video coming soon)
Additional training relevant to this template
The Sample and Help worksheets of every template also contain training relevant to THAT template
- Quick Start for trial templates (5 min video)
- How to find Help & Training for any Systems2win template
- Lean Time Definitions
- Introduction to Systems2win templates (5 min video)
- Training & Demos home page
- Also see the rest of the Process Engineering templates that come bundled with your flowchart

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

Compare flowchart software to other Lean tools
	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 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 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