# IFS Project Earned Value Calculator (CPI, SPI, EAC)

> Source: https://netray.co/tools/ifs-project-earned-value-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Turn percent complete, planned progress and actual cost from your IFS project into CPI, SPI, estimate at completion and the to-complete performance index.

## Category

other-erp

## Erp

IFS Cloud

## Industry

Project-based Manufacturing

## Audience

- Project manager
- Project controller
- Finance

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Budget at completion (BAC)

**Key:** bac

**Type:** number

**Default:** 1200000

**Min:** 0

**Step:** 10000

**Unit:** $

**Help:** Total approved project budget.

#### Actual percent complete

**Key:** pct_complete

**Type:** slider

**Default:** 40

**Min:** 5

**Max:** 100

**Step:** 1

**Unit:** %

**Help:** Measured physical progress, not cost spent.

#### Planned percent complete

**Key:** pct_planned

**Type:** number

**Default:** 50

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

**Help:** What the baseline schedule says should be done by now.

#### Actual cost to date (AC)

**Key:** ac

**Type:** number

**Default:** 540000

**Min:** 0

**Step:** 5000

**Unit:** $

**Help:** Booked cost: labour, material, subcontract.

**Outputs:**

#### Earned value (EV)

**Key:** ev

**Expr:** bac * pct_complete / 100

**Format:** currency

#### Cost variance (EV minus AC)

**Key:** cv

**Expr:** ev - ac

**Format:** currency

**Description:** Negative means over budget for work done.

#### Schedule variance (EV minus PV)

**Key:** sv

**Expr:** ev - bac * pct_planned / 100

**Format:** currency

**Description:** Negative means behind baseline.

#### Cost performance index

**Key:** cpi

**Expr:** ev / ac

**Format:** decimal

**Primary:** true

**Description:** Below 1.0 means each dollar spent earns less than a dollar of progress.

#### Schedule performance index

**Key:** spi

**Expr:** ev / (bac * pct_planned / 100)

**Format:** decimal

**Primary:** true

#### Estimate at completion (BAC / CPI)

**Key:** eac

**Expr:** bac / cpi

**Format:** currency

**Description:** Assumes current cost efficiency continues.

#### Variance at completion

**Key:** vac

**Expr:** bac - eac

**Format:** currency

#### To-complete performance index

**Key:** tcpi

**Expr:** (bac - ev) / (bac - ac)

**Format:** decimal

**Description:** Efficiency needed on remaining work to finish on budget.

**Chart:**

#### Forecast vs percent complete

**Type:** line

**X:** pct_complete

**From:** 5

**To:** 100

**Steps:** 20

**Series:**

- eac
- vac

**Disclaimer:** Standard earned value formulas with the typical forecast of BAC divided by CPI. Other forecast methods exist and may suit your contract better.

## Content

**Intro:** Earned value gives one honest view of cost and schedule on engineer-to-order and project-driven work. Enter four numbers from your IFS project report and this tool returns the indices and forecast a steering group asks for.

**Sections:**

#### How to use it

**Body:** Pull budget at completion and actual cost from the project cost report in IFS, or from your own finance export. Then supply two judgements: how much of the work is truly done and how much the baseline said would be done by now. Earned value is the budget attached to completed work, so progress measurement quality matters more than anything else here. Use milestones or weighted units rather than hours spent. Move the percent complete slider to see how the forecast reacts as progress improves.

**Bullets:**

- Measure progress by deliverables, not effort
- Use the same cost basis for BAC and AC
- Update planned percent from the baseline, not from a re-plan
- Run it at each reporting date and trend the indices

#### Formulas

**Body:** Earned value is BAC times percent complete. Cost variance is EV minus AC, schedule variance is EV minus planned value. CPI is EV divided by AC and SPI is EV divided by planned value. Estimate at completion is BAC divided by CPI, which assumes cost efficiency holds. Variance at completion is BAC minus EAC. TCPI is remaining work divided by remaining budget, showing the efficiency you must achieve from here to finish on plan.

#### Reading the result

**Body:** A CPI of 0.88 with 40 percent complete projects a final cost well above budget, and a TCPI far above 1.0 tells you recovery would require unrealistic efficiency. An SPI below 1.0 near the end of a project is a more serious signal than early on, because little time remains to catch up. Look at trends across periods: a stable CPI is more forecastable than a falling one. Where CPI and SPI both sit below 1.0, expect both a cost overrun and a late finish.

#### Common mistakes

**Body:** Confusing percent spent with percent complete produces a flattering CPI of exactly 1.0 and hides trouble. Including committed but unbooked cost in one measure and not the other skews the indices. Using EAC from CPI alone ignores known one-off events: if an unusual cost will not repeat, adjust the forecast by hand. Finally, earned value measures work, not value: a project can score well and still deliver the wrong thing.

**Cta:** If you want project cost, progress and forecast pulled from your ERP automatically and explained in plain language, Netray can help build that on your own data.

**Faq:**

#### Where do the inputs come from in IFS?

**Answer:** Budget and actual cost come from your project cost reporting. Percent complete is usually maintained by the project team against activities or milestones. Report names differ by version, so use whichever view your controller trusts.

#### What do CPI and SPI of 1.0 mean?

**Answer:** A value of 1.0 means you are exactly on budget or schedule. Above 1.0 is better than plan, below 1.0 is worse. Treat values between 0.95 and 1.05 as broadly on track, depending on contract risk.

#### Why is EAC sometimes unrealistic?

**Answer:** BAC divided by CPI assumes the current cost efficiency continues to the end. If early inefficiency was a one-off, the forecast is pessimistic. If problems are growing, it may be optimistic. Review it with the team.

#### Can I use it outside IFS?

**Answer:** Yes. Earned value is standard project management arithmetic and works with numbers from any system or spreadsheet. Only the source of the inputs depends on your ERP or project tool.

## Search terms

IFS project earned value, earned value calculator, CPI SPI calculator, estimate at completion formula, IFS projects EVM, TCPI calculator, project cost variance calculator, earned value management Excel

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