Span of Control Analyzer

Average span of control is the number people get wrong

A thousand people with a hundred managers has an average span of ten. Put the same file in a spreadsheet, count the reporting lines and divide by the row count, and you get one. Both are arithmetic. Only the first is about the organization, because the second is really measuring what proportion of your staff are managers, which is a different question with a different answer.

This tool divides by the people who actually manage somebody, says so beside the number, and shows you what the other version would have read so you can tell which one you were handed last time.

The reporting line is a graph, and it usually has holes in it

Loops. A reports to B and B reports to A. It happens when a reorganization is half entered. Anything that walks up the management chain hangs forever, and anything that calculates depth either hangs or returns a number it made up. Nobody inside a loop gets a depth here. The loop is named instead.

Missing managers. A manager id that is not in the file, usually because that person has left or the export covers one division. That whole branch is detached, and a report that quietly hangs it off the top understates the depth of everybody in it.

The wrong column. Most rosters carry both a manager name and a manager id. Point any org tool at the name and every single person becomes an orphan. This one notices when almost nothing matches and tells you to check the column, rather than listing five hundred missing managers.

Direct reports and total reports are different questions

A director with four direct reports may have two hundred people beneath them. Span of control is about how many people one person manages directly, which is a question about their week. Total below is about scope. Both are shown, and conflating them is how a reorganization proposal ends up defending the wrong number.

A manager with one report is a question, not a verdict

It is flagged because it is often a layer that exists for a title rather than for a job. It is flagged as something to look at, not as something to remove, because sometimes it is a deputy, a specialist being developed, or a team that has just been through departures. This tool does not know which, and it does not pretend to.