Indices Report The Expenses report presents a uniform and accurate report of expenses for a given time frameIndices report shows the evolution of a portfolio's EVM metrics over time. EVM metrics are grouped in three (3) categories: the Variance, Performance and Estimate At Completion indices. Their evolution over time is represented in charts, one for each of the three indices categories. The report can be generated for both planned and actual expenses in a variety of ways by setting any or all of the many parameters it offers. And as you can expect, you can get a printable version of it using the report's action menu or by hitting "p" while consulting it. Anchor |
---|
| Params | Params | Report Parameters
Contentproduced for printing and its data can be exported to Excel spreadsheet.
Image Added
Configuring the reportImage Added
Variance IndicesThe variance chart shows the trend of variance-related indices. The variance indices indicate how well the actual data compares to what was planned.
Image Added
CV | Cost Variance | This index (CV) determines if the project is under or over the budget. It is computed by subtracting the Actual Cost (AC) from the Earned Value(EV). A negative value indicates that the project is over budget. Ex: at the end of the fourth week the AC is 11,000.00$ and the EV is 8,000.00$ then the CV will be 3,000.00$ at the end of this period |
---|
SV | Schedule Variance | This index (SV) determines whether the project is ahead of or behind schedule. It is computed by subtracting the Planned Value(PV) to date from the Earned Value(EV) to date. A negative value indicates that the project is behind schedule. Ex: at the end of the fourth week the PV is 10,000.00$ and the EV is 8,000.00$ then the SV will be 2,000.00$ at the end of this period |
---|
VAC | Variance At Completion | This index (VAC) determines whether the project will finish under or over budget. The Amount shown is the difference between the total budgeted cost and the Estimate at Completion It is computed by subtracting the Estimate at Completion (EAC)from the Budget at Completion(BAC). A negative value indicates how much more resources will need to be injected to achieve the project goal. Ex: at the end of the fourth week the EAC is 250,000.00$ and the BAC is 200,000.00$ then the VAC will be 50,000.00$ |
---|
TOL | Tolerance | The tolerance you have selected in your portfolio configuration |
---|
Image Added | Inline help |
---|
Performance Indices
The performance chart shows the trend of performance-related indices. Performance indices attempt to capture how efficient the team is to convert money into earned value.
Image Added
CPI | Cost Performance Index | This index (CPI) determines how efficiently the team is using its resources. It is computed by dividing the Earned Value by the Actual Cost. A value lower than one indicates a loss of efficiency. |
---|
SPI | Schedule Performance Index | This index (SPI) determines how efficiently the project team is using its time. It is computed by dividing the Earned Value by the Planned Value to date. A value lower than one indicates a loss of efficiency. |
---|
TCPI | To-Complete Performance Index | This index (TCPI) determines the efficiency that must be achieved on the remaining work for a project to meet the Budget at Completion. It is computed by dividing the work remaining (BAC - EV to date) by the budget remaining (BAC - AC to date). A value greater than one indicates that the performance must improve. |
---|
TOL | Tolerance | The tolerance you have selected in your portfolio configuration |
---|
Image Added | Inline help |
---|
Estimate At CompletionThis chart demonstrates the risk level trends. It displays the EAC (Estimate At Completion) based on three different approaches as describe below.
Image Added
EAC | Estimate At Completion | This method assumes what the project has experienced to date can be expected to continue in the future. |
---|
EAC [budget] | Estimate At Completion Based on budget | This method accepts the actual project performance to date and predicts that all future ETC(Estimate to Complete) work will be accomplished at the budgeted rate. |
---|
EAC [CPIxSPI] | Estimate At Completion Based on cpi and spi indices | This method assumes that the ETC work will be performed at an efficiency rate that considers both the cost and schedule performance indices. |
---|
BAC | Budget at Completion | |
---|
TOL | Tolerance | The tolerance you have selected in your portfolio configuration |
---|
Image Added | Inline help |
---|
Menu Options
Printable | Display a printable version of the report |
---|
Export to Excel | Export report to Excel |
---|
View Available Reports | Bring you back to Portfolio Report List Note that you can also use the shortcut keyboard "xesc" key |
---|
Printing the reportPrintable Version Select the "Printable" item in the report's action menu found at the top right of the report's parameters panel or by hit "p" to get a printer-friendly version of the report.
Image Added
Anchor |
---|
| ExportToExcel |
---|
| ExportToExcel |
---|
|
Exporting to ExcelThe Indices report can be exported to Excel format to give you all the latitude to generate your own graph. Do it by selecting the "Export to Excel
" item in the report's action menu found at the top right of the report's parameters panel.
Image Added
The parameters that were used to generate the report can be found on the second tab of the generated spreadsheet. On the parameter sheet you get all acronyms definitions and the formulas used to calculate indices
Image Added