# Strategic Initiative Portfolio Tracker Worksheet

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

## Short answer

Track every improvement and transformation initiative in one table: owner, budget, spend, percent complete, expected benefit and status.

## Category

manufacturing

## Industry

Discrete Manufacturing

## Audience

- COO
- Plant manager
- Continuous improvement lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Initiative

**Key:** initiative

**Type:** text

#### Owner

**Key:** owner

**Type:** text

#### Pillar

**Key:** pillar

**Type:** select

**Options:**

- Safety
- Quality
- Delivery
- Cost
- People
- Growth

#### Budget

**Key:** budget

**Type:** number

**Format:** currency

#### Spent to date

**Key:** spent

**Type:** number

**Format:** currency

#### Percent complete

**Key:** pct

**Type:** number

**Unit:** %

#### Annual benefit target

**Key:** benefit

**Type:** number

**Format:** currency

#### Budget remaining

**Key:** remaining

**Type:** number

**Expr:** budget - spent

**Format:** currency

#### Spend vs progress gap

**Key:** burn

**Type:** number

**Expr:** if(gt(budget,0), spent / budget * 100 - pct, 0)

**Format:** decimal

**Help:** Positive means spending is ahead of progress

#### Status

**Key:** status

**Type:** select

**Options:**

- On track
- At risk
- Off track
- Complete
- On hold

#### Due date

**Key:** due

**Type:** date

**Rows:**

**Initiative:** Daily management system rollout

**Owner:** Ops manager

**Pillar:** Delivery

**Budget:** 40000

**Spent:** 22000

**Pct:** 60

**Benefit:** 150000

**Status:** On track

**Due:** 2027-03-31

**Initiative:** SMED on press line 2

**Owner:** CI lead

**Pillar:** Cost

**Budget:** 25000

**Spent:** 21000

**Pct:** 50

**Benefit:** 120000

**Status:** At risk

**Due:** 2027-02-15

**Initiative:** Supplier quality program

**Owner:** Quality manager

**Pillar:** Quality

**Budget:** 60000

**Spent:** 18000

**Pct:** 30

**Benefit:** 200000

**Status:** On track

**Due:** 2027-06-30

**Initiative:** Maintenance planning and scheduling

**Owner:** Maintenance manager

**Pillar:** Delivery

**Budget:** 55000

**Spent:** 50000

**Pct:** 40

**Benefit:** 180000

**Status:** Off track

**Due:** 2027-01-31

**Initiative:** Supervisor development program

**Owner:** HR partner

**Pillar:** People

**Budget:** 35000

**Spent:** 35000

**Pct:** 100

**Benefit:** 0

**Status:** Complete

**Due:** 2026-09-30

**Totals:**

#### Total budget

**Key:** budget

**Agg:** sum

**Format:** currency

#### Total spent

**Key:** spent

**Agg:** sum

**Format:** currency

#### Total annual benefit target

**Key:** benefit

**Agg:** sum

**Format:** currency

#### Initiatives

**Key:** initiative

**Agg:** count

**Format:** integer

**Summary:**

#### Portfolio spend vs budget

**Key:** spend_pct

**Expr:** if(gt(sum_budget,0), sum_spent / sum_budget * 100, 0)

**Format:** percent

#### Target benefit per budget dollar

**Key:** benefit_per_dollar

**Expr:** if(gt(sum_budget,0), sum_benefit / sum_budget, 0)

**Format:** decimal

**Notes:** Update weekly or monthly. A spend vs progress gap above 15 points is a signal to review that initiative. Benefits listed are targets, not realized savings. Confirm realized benefit with finance before reporting it.

## Content

**Intro:** Most plants run more initiatives than they can finish, and nobody sees them all in one place. This tracker puts every initiative on one page with owner, budget, progress and benefit.

**Sections:**

#### How to use the tracker

**Body:** Enter one row per initiative. Assign a single named owner, a pillar such as safety or quality, a budget and a due date. Update spend and percent complete on a fixed rhythm, weekly for the plant staff meeting and monthly for the operations review. The sheet calculates budget remaining and a spend vs progress gap. Filter or sort by status before each meeting and spend your time on the amber and red items, not the greens.

**Bullets:**

- One owner per initiative
- Update on a fixed day each week
- Review At risk and Off track first
- Close finished items so the list stays short

#### Reading the numbers

**Body:** The spend vs progress gap compares percent of budget used with percent of work done. If an initiative has spent 70% of budget and is 40% complete, the gap is 30 points and the project is likely to overrun. The summary shows portfolio spend and target benefit per budget dollar. Treat benefit as a target until finance validates it. If the portfolio total exceeds what your team can staff, stop or pause the lowest value items rather than running everything slowly.

#### Common mistakes

**Body:** Plants often track activity instead of outcomes, so each row should state a measurable benefit. Another mistake is never closing initiatives, which leaves the list too long to manage. Ensure budget includes internal labor if your policy requires it. Finally, link each initiative to a site goal. If it does not connect to a goal, ask why it is running.

**Bullets:**

- Define a measurable benefit per row
- Limit active initiatives to what the team can staff
- Have finance validate realized benefits
- Link each row to a site goal

**Cta:** If you want initiative spend and operational results pulled from your ERP automatically, Netray can build a private, read-only reporting layer on your data.

**Faq:**

#### How many initiatives should a plant run at once?

**Answer:** It depends on capacity, but many plants do well with five to ten active initiatives, each with a named owner. More than that and progress slows because the same people are in every project. Pause lower value items.

#### What does the spend vs progress gap mean?

**Answer:** It subtracts percent complete from percent of budget spent. A positive gap means you have spent more than the work done would justify, which often predicts a budget overrun. A negative gap may signal delays or unrecorded costs.

#### Should benefits be counted before they are realized?

**Answer:** Track them as targets and report realized benefits separately once finance confirms them. Mixing the two overstates results and damages trust in the improvement program.

#### Can I use this for a company wide portfolio?

**Answer:** Yes. Add a Site column by exporting to Excel, or keep one tracker per plant and consolidate them monthly. Keep the same status definitions across sites so the roll-up is meaningful.

## Search terms

initiative tracker excel, strategic initiative tracker template, operations project portfolio tracker, continuous improvement project tracker, manufacturing transformation tracker, plant initiative status report excel, project portfolio dashboard manufacturing

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