# Infor LN Project Earned Value Calculator

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

## Short answer

Compute earned value, CPI, SPI and forecast cost at completion from budget, planned and actual percent complete and actual cost.

## Category

infor-ln

## Erp

Infor LN

## Audience

- Project manager
- Controller
- LN consultant

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Budget at completion

**Key:** bac

**Type:** number

**Default:** 850000

**Min:** 1

**Step:** 10000

**Unit:** $

#### Planned percent complete

**Key:** planned_pct

**Type:** number

**Default:** 55

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Actual percent complete

**Key:** actual_pct

**Type:** slider

**Default:** 48

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Actual cost to date

**Key:** ac

**Type:** number

**Default:** 470000

**Min:** 0

**Step:** 5000

**Unit:** $

**Outputs:**

#### Planned value (PV)

**Key:** pv

**Expr:** bac * planned_pct / 100

**Format:** currency

#### Earned value (EV)

**Key:** ev

**Expr:** bac * actual_pct / 100

**Format:** currency

#### Cost performance index (CPI)

**Key:** cpi

**Expr:** ev / ac

**Format:** decimal

**Primary:** true

**Description:** Below 1.0 means over budget for the work done.

#### Schedule performance index (SPI)

**Key:** spi

**Expr:** ev / pv

**Format:** decimal

**Primary:** true

**Description:** Below 1.0 means behind schedule.

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

**Key:** eac

**Expr:** bac / cpi

**Format:** currency

#### Estimate to complete

**Key:** etc

**Expr:** eac - ac

**Format:** currency

#### Variance at completion

**Key:** vac

**Expr:** bac - eac

**Format:** currency

**Chart:**

#### Estimate at completion vs actual cost

**Type:** line

**X:** ac

**From:** 300000

**To:** 700000

**Steps:** 30

**Series:**

- eac

**Disclaimer:** EAC uses the common assumption that current cost efficiency continues. Use a bottom up estimate if the cause of the variance is a one off.

## Content

**Intro:** Project accounting in Infor LN gives you budget, actual cost and progress, but the earned value indices are often worked out in a side spreadsheet. This calculator does that arithmetic in one place and exports to PDF or Excel for steering committees.

**Sections:**

#### How to use it

**Body:** Enter the total budget, the percent that should be complete today, the percent that is actually complete and the actual cost. Planned value is budget times planned percent, earned value is budget times actual percent. CPI is EV over actual cost and SPI is EV over PV. The chart shows how the forecast rises as actual cost grows for the same progress.

#### Reading the results

**Body:** A CPI of 0.9 means each dollar spent produces 90 cents of planned work, and the forecast at completion is the budget divided by CPI. An SPI under 1.0 says you are behind plan, but remember that earned value measures work value, not calendar days. Both indices below 1.0 together is the pattern that deserves escalation.

**Bullets:**

- CPI and SPI above 1.0 are favorable
- VAC negative means a forecast overrun
- Re-baseline only with sponsor approval

#### Common mistakes

**Body:** The most common issue is subjective percent complete: claim progress only on finished, reviewable deliverables. Another is leaving out accruals or unbilled partner time from actual cost, which flatters CPI. And using this on tiny projects where the numbers move too much to guide decisions.

**Cta:** If you would like project cost and progress pulled straight from LN into a live dashboard, we can build that with read-only access.

**Faq:**

#### What is a healthy CPI?

**Answer:** At or above 1.0 is on or under budget. Many teams act when CPI drops below about 0.9, because recovering later in the project is much harder than correcting early.

#### Is BAC divided by CPI the only forecast?

**Answer:** No. If the variance was caused by a one time event, a better forecast is actual cost plus the remaining budget. Use the formula that matches your understanding of the cause.

#### Can I use this for an ERP implementation?

**Answer:** Yes. Treat the implementation budget as BAC and measure percent complete by deliverables, such as configured and signed off processes, data loads and tested interfaces.

#### Where does LN hold the numbers?

**Answer:** LN Project holds budget and actual cost by project element and activity. Export those totals and enter them here, or check with your finance team which values are the agreed baseline.

## Search terms

infor ln project earned value, earned value management calculator, cpi spi calculator, estimate at completion calculator, ln project budget vs actual, erp implementation earned value

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