# Six Sigma Project Portfolio Tracker

> Source: https://netray.co/tools/six-sigma-project-portfolio-tracker
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Track every Six Sigma project by belt, DMAIC phase, owner, annual savings and project cost. Net benefit totals update as you edit.

## Category

quality

## Industry

Manufacturing

## Audience

- Master Black Belt
- Continuous improvement lead
- Quality manager
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Project

**Key:** project

**Type:** text

#### Belt level

**Key:** belt

**Type:** select

**Options:**

- Yellow
- Green
- Black

#### DMAIC phase

**Key:** phase

**Type:** select

**Options:**

- Define
- Measure
- Analyze
- Improve
- Control
- Closed

#### Project lead

**Key:** owner

**Type:** text

#### Projected annual savings

**Key:** savings

**Type:** number

**Format:** currency

#### Project cost

**Key:** cost

**Type:** number

**Format:** currency

#### Net first-year benefit

**Key:** net

**Type:** number

**Expr:** savings - cost

**Format:** currency

#### Target close date

**Key:** target

**Type:** date

**Rows:**

#### Analyze

**Project:** Reduce paint rework on housings

**Belt:** Green

**Owner:** R. Menon

**Savings:** 84000

**Cost:** 12000

**Target:** 2027-01-15

#### Improve

**Project:** Cut changeover time on CNC cell 4

**Belt:** Black

**Owner:** S. Patel

**Savings:** 160000

**Cost:** 35000

**Target:** 2026-12-10

#### Measure

**Project:** Improve first-pass yield on PCB assembly

**Belt:** Black

**Owner:** L. Chen

**Savings:** 210000

**Cost:** 40000

**Target:** 2027-03-01

#### Define

**Project:** Reduce supplier late deliveries

**Belt:** Green

**Owner:** J. Okafor

**Savings:** 56000

**Cost:** 8000

**Target:** 2027-02-12

#### Control

**Project:** Cut inspection wait time

**Belt:** Yellow

**Owner:** A. Brown

**Savings:** 18000

**Cost:** 2000

**Target:** 2026-11-20

**Totals:**

#### Total projected savings

**Key:** savings

**Agg:** sum

**Format:** currency

#### Total project cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total net benefit

**Key:** net

**Agg:** sum

**Format:** currency

#### Projects in portfolio

**Key:** project

**Agg:** count

**Format:** integer

**Summary:**

#### Return on project cost

**Key:** roi

**Expr:** sum_savings / sum_cost

**Format:** decimal

**Description:** Savings per dollar spent, as a ratio.

#### Average savings per project

**Key:** avg

**Expr:** avg_savings

**Format:** currency

**Notes:** Count only savings your finance team has validated. Many organizations separate hard savings (budget reductions, cost avoidance with evidence) from soft savings and track them in separate columns.

## Content

**Intro:** A Six Sigma program lives or dies on visibility. This tracker keeps each project's belt level, phase, lead, projected savings and cost in one table, with portfolio totals that update as you edit.

**Sections:**

#### How to use the tracker

**Body:** Add one row per project when the charter is approved. Update the DMAIC phase at each tollgate review. Enter the projected annual savings agreed with finance and the cost, including project time, training and any capital. Net first-year benefit is calculated for you, and the totals show the whole pipeline. Export to Excel before the monthly review so executives can filter by belt or phase. Move completed rows to Closed, and replace projections with realized savings after the control period.

**Bullets:**

- One row per chartered project
- Update phase at every tollgate
- Agree savings categories with finance first
- Re-baseline realized savings after 3 to 6 months

#### Reading the portfolio

**Body:** Look at the spread across phases. A portfolio with everything in Define and nothing in Control is not delivering savings yet. Many stuck projects in Analyze often point to data access problems. Compare return on project cost across belt levels: Black Belt projects tend to be larger and slower, Green Belt projects smaller and quicker. A healthy mix keeps savings flowing while bigger projects mature. Review target dates and escalate those that are slipping.

#### Common mistakes

**Body:** Overstating savings is the biggest credibility risk. Savings that do not appear in the budget or the P&L get discounted by finance. Another is never closing projects, which leaves dead rows in the Control phase. Teams also forget to count project cost, so the return looks inflated. Finally, a tracker with no link to the charter and baseline data becomes a list of names. Record where the baseline lives, such as the ERP report or inspection database.

**Cta:** If you would like project baselines and realized savings tied to ERP cost and quality data, Netray can help build that reporting.

**Faq:**

#### What belt level should a project be?

**Answer:** Yellow Belt projects are small local fixes, Green Belt projects usually run 3 to 6 months within one function, and Black Belt projects are larger, cross-functional and often worth more. Organizations set their own thresholds, so adjust the options on export.

#### How should I count savings?

**Answer:** Use your finance team's definitions. Hard savings reduce cost or increase profit in a measurable way, such as scrap reduction. Soft savings, like time freed, need separate tracking. Do not count savings that finance has not agreed to.

#### How often should I update the tracker?

**Answer:** At each tollgate and at least monthly. A monthly portfolio review with the plant leadership keeps projects moving and surfaces blockers early.

#### Can I track more than one site?

**Answer:** Yes. Add a site into the project name or export and add a column in Excel. For multi-site programs, use one tracker per site and consolidate them in your portfolio review.

## Search terms

six sigma project tracker excel, six sigma project portfolio template, DMAIC project tracker, continuous improvement project tracker, green belt project log, black belt project savings tracker, lean six sigma dashboard excel, CI project pipeline template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json