IFS Project Earned Value Calculator (CPI, SPI, EAC)
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.
Your numbers
Total approved project budget.
Measured physical progress, not cost spent.
What the baseline schedule says should be done by now.
Booked cost: labour, material, subcontract.
Your results
Standard earned value formulas with the typical forecast of BAC divided by CPI. Other forecast methods exist and may suit your contract better.
Forecast vs percent complete
Sweeps Actual percent complete from 5 to 100, holding your other inputs fixed.
Project reporting automation
Optional conversation on pulling cost and progress straight from ERP into an earned value view.
Optional. The tool and every export work without this. No spam.
How to use it
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.
- 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
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
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
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.
Frequently Asked Questions
Where do the inputs come from in IFS?
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?
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?
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?
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.
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.
Related Tools
QAD Customization Migration Effort Calculator
Size the work to carry QAD customizations forward: count them by complexity, set the share you can retire, add testing and contingency.
Other ERPsIFS Shop Order Lead Time Calculator
Estimate how long a shop order really takes through its routing, and what share of that time is actual work, as a check on lead times stored in IFS.
Costing & FinanceCost Per Good Part Calculator
Build a cost per good part from labor, burden, machine rate, setup, material and scrap, and see how efficiency changes it.
More Other ERPs tools
See all- Infor VISUAL Work Order Status and Structure Reference
- Infor VISUAL Manufacturing Scheduling Checklist
- Infor XA (MAPICS) Period End Close Checklist
- Infor VISUAL Database Table Reference
- Infor XA (MAPICS) Application Module Reference
- IBM i Commands for Infor XA Administrators Reference
- Acumatica Generic Inquiry Design Template
- Acumatica Manufacturing Edition Setup Checklist
- Sage X3 Import Template Worksheet
New to IFS Applications? Start with the IFS Applications guide and toolkit.
Keep exploring
Free tools
- Infor LN Project Earned Value CalculatorCompute earned value, CPI, SPI and forecast cost at completion from budget, planned and actual percent complete and actual cost.
- IFS Shop Order Lead Time CalculatorEstimate how long a shop order really takes through its routing, and what share of that time is actual work, as a check on lead times stored in IFS.
- IFS Applications 10 AI Assistant Sizing and Value CalculatorEstimate GPUs, document index size and monthly value for a private AI assistant on IFS Applications 10. Maintenance and engineering documents often dominate index size.
ERP fixes and how-tos
- IFS Cloud Customer Order Supply Code and Project OrdersHow the supply code on an IFS Cloud customer order line drives planning for project-connected orders: inventory, purchase, shop order and project supply.
- IFS Cloud Integration Options: Projections, Connect, Events and a MES ExampleCompare IFS Cloud integration options: projections and OData, IFS Connect, business events and workflows, with a worked MES integration example.
- IFS Cloud Power BI Integration Using OData ProjectionsHow to connect IFS Cloud to Power BI using OData projections, which authentication to use, and how to avoid slow reports and overloading the ERP database.
Guides
- Implementing Earned Value Management in SyteLine ERPImplement earned value management in Infor SyteLine to track project cost and schedule performance. Configure EVM metrics like CPI, SPI, and EAC in your ERP.
- AI-Powered Project Manufacturing for Infor LNOptimize Infor LN project manufacturing with AI agents. Automated WBS management, earned value analysis, and project cost control for complex manufacturers.
- Infor LN Project-Based Manufacturing ConfigurationConfigure project-based manufacturing in Infor LN with PCS project setup, WBS structures, budget control, and earned value management for ETO manufacturers.
AI on your ERP
- AI for IFS Cloud Project Management: Cost, Schedule and Forecast Questions AnsweredPrivate AI on IFS Cloud projects: ask about budget versus actual, activities, milestones, forecasts and project material in plain English, read-only.
- AI for IFS Cloud in aerospace and defense manufacturingAdd AI to IFS Cloud for aerospace and defense: projections, Aurena UX, Lobby, and engineer-to-order data, deployed on-prem or in your private cloud.
Integrations
- How to use ChatGPT with IFS CloudHow to use ChatGPT with IFS Cloud: custom GPT actions over OData, exports versus live access, enterprise data controls, and when a private model is safer.
- How to add an AI chatbot to IFS CloudHow to add an AI chatbot to IFS Cloud: grounded answers from IFS data and documents, embedding in Aurena or a portal, role-aware access and fully on-prem models.
Software
- IFS CloudIndependent guide to IFS Cloud, the ERP and enterprise asset and service platform: modules, integration options, limitations, alternatives and AI use cases.
- IFS Field Service ManagementIFS Field Service Management covers service orders, scheduling optimisation and mobile work within IFS Cloud. Modules, integrations, AI uses and alternatives.