Organization Staffing Review: Spans & Layers

What this site does

The tool uses employee IDs and reporting relationships to calculate active headcount, FTE, managers, direct reports, reporting layers, and team-size status. It summarizes results by department and functional area and creates review lists for records requiring validation.

How to import data

1. Open Data Manager and select Import Data. Import is the first step when replacing the sample dataset.

2. Download the CSV template or prepare a file. Use the required headings and consistent values.

3. Replace or update records. Select Replace current records to remove the sample data, or Update and add records to merge by Employee ID.

4. Select Import and Validate. Review the import summary and correct validation issues before interpreting results.

Required structure: Every employee needs a unique Employee ID. Every active employee except the top institutional leader should have a Manager ID that matches another record.

How to use it after importing

1. Review Validation & Assumptions. Correct duplicate IDs, missing managers, invalid FTE values, and unresolved hierarchy issues.

2. Scan the Dashboard. Review organization scale, manager density, team-size patterns, layers, and records requiring follow-up.

3. Apply filters. Focus on a functional area, department, or team-size status.

4. Open the Review Workbench. Review why each record was flagged and what context must be validated.

5. Export deliberately. Handle exported files according to institutional confidentiality and personnel-data policies.

About team-size thresholds

The default thresholds are illustrative planning assumptions included to demonstrate the tool. They are not industry standards, benchmarks, or recommended targets.

Institutional leaders should review and approve the thresholds before using team-size flags in planning or decision-making. Changing a threshold may change which managers are flagged.

Interpretation rules

Below-range and above-range managers receive the same follow-up priority.
Small teams may be appropriate for specialized, regulated, high-risk, or geographically distributed work.
Large teams may be appropriate when work is standardized or experienced employees require limited supervision.
Resolve data-quality issues before interpreting organizational patterns.
Compare results with workload, service expectations, vacancies, employee capabilities, and institutional priorities.

Data Manager

Import, validate, review, edit, export, or clear organizational records. Changes recalculate the tool immediately in the current browser.

Import employee data

Upload or paste a CSV file. The file is processed locally in the current browser.

CSV supported

Upload CSV file

Or paste CSV data

How should the import be applied?

Before importing: Confirm unique Employee IDs, valid Manager IDs, consistent labels, and one active top leader with a blank Manager ID.

Required CSV headings

Heading	What to enter
Employee ID	A unique identifier for each employee or position. Do not use employee names.
Job Title	The employee's current job title.
Department	The department or operating unit.
Functional Area	A broader grouping such as Academic Affairs, Finance, or Student Affairs.
Campus	Campus or location. Optional for a single-location institution.
Manager ID	The Employee ID of the direct manager. Leave blank only for the top institutional leader.
Employment Status	Active, Inactive, Vacant, or Leave of Absence.
FTE	A numeric full-time-equivalent value, normally from 0 to 1.0.
Position Type	The role category used for thresholds, such as Executive, Dean, Director, Manager, or Individual Contributor.

Data entered here is processed locally and is not sent to MGT, rpk GROUP, your institution, or an external server.

Add or edit one record

Use this form to add a single record or correct an existing record.

50 sample records loaded

The embedded sample contains 50 records with IDs P001 through P050. Names are intentionally excluded.

Current employee records

Search, review, edit, or delete the records currently loaded in the tool.

50 records

Search current records

Employee ID

Team-size thresholds

Thresholds define the minimum and maximum active direct reports used to identify team-size exceptions.

7 threshold rules

Illustrative assumptions: The default thresholds are not industry standards, benchmarks, or recommended targets. Institutional leaders should review and approve them before using flags in planning or decision-making. Saving changes may alter which managers are flagged.

Position Type

Dashboard

Review the current organizational structure and identify where follow-up should begin.

Use this measure to understand manager density across the filtered organization.

Review records include team-size exceptions and data-quality issues.

Local-device storage only.No entered data is sent to an external server.

Dashboard metric definitions

Active headcountActive employee records. This is a record count, not an FTE total.

Active FTETotal FTE for active employee records.

Active managersActive employees with at least one active direct report.

Active individual contributorsActive records classified as Individual Contributor, regardless of whether other role types have no direct reports.

Average team sizeAverage number of active direct reports for active managers.

Below-range managersManagers with fewer direct reports than the current illustrative minimum. Also called a narrow span.

Above-range managersManagers with more direct reports than the current illustrative maximum. Also called a wide span.

Records needing reviewRecords with a data issue or a team size outside the current illustrative range.

Staffing Pattern Diagnostics

Use these visuals to identify where follow-up records and reporting layers are concentrated.

Review records by functional area

Number of team-size exceptions or data-quality records in each functional area. This is a record count, not an FTE measure.

How to interpret this visual

Use the visual to identify functional areas where validation work is concentrated. A higher count does not establish that a function is inefficient.

Layer distribution

Active employee records by reporting layer.

active headcount

What layers mean

Layer 0 is the top institutional leader. Layer 1 reports to Layer 0, Layer 2 reports to Layer 1, and so forth. Use the distribution to understand how many reporting levels exist and where employees are concentrated. A deeper or flatter structure is not automatically better.

Department and Functional Area Summaries

These tables aggregate staffing measures and review records. Use them to identify where more detailed validation should occur, not as stand-alone recommendations.

Department summary

Staffing measures and follow-up records grouped by department.

Department

Functional area summary

Staffing measures and follow-up records grouped by functional area.

Functional Area

Review Workbench

Identify records requiring validation and determine what information should be reviewed next. Flags are follow-up prompts, not staffing recommendations.

Records requiring review

Includes data issues and managers whose team size is outside the current illustrative range. Select a row to see the full reason and validation guidance.

23 records

Correct dataValidate structure

Action Status

Manager review list

All active managers, sorted by required follow-up. Below-range and above-range managers have the same priority.

24 managers

Correct dataValidate structureNo threshold exception

Action Status

Validation & Assumptions

Resolve high-severity data issues and confirm the illustrative thresholds before relying on dashboard or workbench results.

Data checks

Check	Status	Owner Action	Severity
Blank employee IDs	OK	Add a unique employee ID to every record.	High
Duplicate employee IDs	OK	Each employee ID must be unique.	High
Employee reports to self	OK	Correct the manager ID.	High
Missing manager IDs	OK	Add the missing manager record or correct the manager ID.	High
Blank departments	OK	Add department values.	Medium
Blank functional areas	OK	Add functional area values.	Medium
Invalid employment statuses	OK	Use approved status values.	Medium
Invalid FTE values	OK	Enter numeric FTE values between 0 and 1.5.	Medium
Single active top leader	OK	Only one active record should have a blank manager ID.	High
Threshold coverage	OK	Add a threshold rule for the role type and layer.	High

Threshold provenance: These values are illustrative planning assumptions. They are not industry standards, benchmarks, or recommended targets.

Current threshold table

Position Type	Layer Min	Layer Max	Min Team Size	Max Team Size
Executive	0	1	4	8
Dean	2	3	3	8
Director	2	4	4	10
Manager	3	8	5	12
Individual Contributor	0	8	0	0
Faculty	0	8	0	0
Other	0	8	4	8

Privacy, Copyright, and Use

Data-handling requirements and public-use terms for this tool.

Privacy and data handling

This tool is browser based and is not connected to a database, cloud storage environment, analytics platform, or external data-collection process. Information entered by the user is processed locally in the current browser and is not transmitted to MGT, rpk GROUP, or a third party through the tool.

Neither MGT nor rpk GROUP receives, stores, reviews, or has access to user-entered data. Data or outputs leave the device only through an action taken by the user, such as exporting, downloading, printing, saving, emailing, uploading, or otherwise sharing the information.

Users should treat entered and exported data as confidential institutional information and handle it according to institutional policies governing personnel data, organizational planning materials, and other sensitive records.

Copyright and public-use terms

This tool is made publicly available for educational, organizational-planning, and noncommercial institutional use. Users may use the tool and enter their own data but may not sell, sublicense, redistribute modified versions, remove MGT attribution, or incorporate the tool into another commercial product or service without prior written permission from MGT Impact Solutions, LLC.

MGT, rpk GROUP, and associated names, logos, and marks remain the property of their respective owners.

Planning disclaimer

Outputs are planning signals, not staffing recommendations. Users must validate source data, threshold assumptions, workload, operational context, service needs, legal requirements, and institutional priorities before making organizational decisions.