The Budget Variance Earned Value report presents the budget versus actual costs variance at a given datea comparison of earned value with planned and actual expenses, broke down by the team roles and expense types you definedspecified periods of time. To access this report, click on the Report tab (or hit '6') and then click on the 'View report' button next to the Budget Variance Earned Value report preview. This will bring up the report with the first day of the current month as the default start (From) date and today's date and all expense types and position titles selected as defaultas the default end (To) date. The report will be automatically refreshed when one of its parameters changes. The report first presents a bar chart showing two three bars for each selected expense type and position titleperiod: a blue bar indicating the earned value, a green bar indicating the budgeted amount at specified dateplanned expenses, a red bar indicating actual amountexpenses. Hovering the bars will open a tooltip showing the precise amounts. The dates labels on yx-axis can be clicked to navigate to the detailed expense and earned value information for that expense typethe period ending on that date.  Budget Variance Earned Value chart
Detailed information for all expense types and position titles periods follow the chart. Each of these sections shows the list of expenses, ordered alphabetically and grouped by category (OPEX, CAPEX or FINEX) and then by expense types (or position titles). The variance earned value for that period appears in a losange in the heading on the right. A green losange indicates a positive variance (budget ≥ actualearned value over planned value (earned ≥ planned) and a red losange indicates negative variancethe opposite (earned < planned). Detailed budget heading variance period section Configuring the reportTo change the date for which to get the varianceperiod covered by the report, simply change set the date dates in the 'From' and 'Date' fieldTo' fields to whatever dates you want. The expenses considered are the ones occurring between the start date of the portfolio and the one specified in the date field. The user can also actual period considered will span from the latest of portfolio's start date and the date entered in "From" field (expenses defined to occur before the portfolio start won't be taken into account). You can specify which frequency the report should use to break down the overall period. For example, selecting Monthly frequency will show you earned values and expenses broke down by calendar months. Select "Total" value in the Frequency to get earned value and all expenses for the complete period, with no break down. You can finally limit the expenses considered to a certain number of expense types and/or position titles. Simply select/deselect the expense types you are interested in and the report will be instantly refreshed to reflect the new selection. Selecting or deselecting a category will cause the list of available expense types and position titles to be updated accordingly. Budget Variance Earned Value report parameters Printing the reportSelecting the "Printable" item in the report's action menu found at the top right of the report's parameters panel to get a printer-friendly version of the report.
Printable version of the report | Anchor |
|---|
| ExportToExcel |
|---|
| ExportToExcel |
|---|
|
Exporting to ExcelThe Budget Variance Earned Value report can be exported to Excel format to give you all the latitude you need to further digest, analyze or graph the data. 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. The parameters that were used to generate the report can be found on the second tab of the generated spreadsheet Excel export of the report |