The PPA PMO Executive dashboard provides a Project Executive the ability to review all active portfolios at a high-level in terms of costs and variances, view a break-down of all projects based on their states. It also allows the Project Executive to analyze the performance of all selected portfolios by analyzing Resource utilization against Resource Cost, Planned and actual operating costs, and Resource allocation against capacity by role. It also displays the Project Success Ratio and Portfolio Good Health Ratio metrics for the selected portfolios.
This dashboard consists of the following reports:
| Metric Name | Description | Formula | Expected Values |
|---|---|---|---|
| Total Cost | Total cost incurred on a project | Sum([Project Actual Cost]) | 0 or >0 |
| Demand Planned Cost | The estimate of cost for Demands | Sum ([Demand Planned Cost]) | 0 or >0 |
| Budgeted Cost | The planned cost for the project. This is the reference cost and usually is not updated unlike planned cost which can be updated as the project progresses. | Sum([Project Budgeted Cost]) | 0 or >0 |
| Actual Operating Cost | Amount of operating cost incurred as part of the actual amount spent on a project | Sum([Project Actual Operating Cost]) | 0 or >0 |
| Project Success Ratio | The percentage of projects that are within budget and within schedule. | ([No. of Projects Within Budget & Schedule] / [No. of Projects]) | 0 % to 100 %, closer to 100% is ideal |
| Portfolio Good Health Ratio | Percentage of green portfolios as compared to the total number of portfolios | [No. of Green Portfolios] / [No. of Portfolios] | 0% to 100%, closer to 100% is ideal |
| No. of High Risk Projects | Total number of projects where risk is set to High | Count ([No. of Projects]) <[Project Risk = HIGH];> | 0 or >0 |
| EVM_Cost Variance % | The percentage difference between actual cost and earned value of the project. | Avg([Project Cost Variance %]) | 0 % to 100 %, closer to 100% is ideal |
| EVM_Schedule Variance % | The percentage difference between the Actual and the Planned duration of a project. | Avg([Project Schedule Variance %]) | 0 % to 100 %, closer to 100% is ideal |
| No. of Projects | Total number of projects | Count([No. of Projects]) | 0 or >0 |
| Project Utilization % | Percentage of actual hours logged by a resource as compared to their allocated hours | ([Resource Actual Hours] / [Resource Allocated Hours]) | 0 % to 100 %, closer to 100% is ideal |
| Resource Actual Cost | The actual cost of all the resources associated with all the tasks within a project | [Resource Actual Hours] * [Resource Per Hour Cost] | 0 or >0 |
| Total Cost Target | Total amount that the organization is allowed to incur including capital and operational costs | [Operating Cost Target] + [Capital Cost Target] | 0 or >0 |
| Project Planned Cost | The estimate of cost for a Project. This could be updated as the project progresses. | Sum([Project Planned Cost]) | 0 or >0 |
| Project Actual Cost | Actual amount spent on the project | Sum([Project Actual Cost]) | 0 or >0 |
| Resource Allocation % | Percentage of allocation done to a resource as per the resource's capacity | [Resource Allocated Hours] / [Capacity Hours] | 0 or >0, closer to 100% is ideal |
| Net Available Capacity | Available capacity of resource after removing all engagements | [Capacity Hours] - [Resource Planned Effort (Hours)] | 0 or >0, greater than 0 is ideal |
| No. of Resources | Count of all resources across projects | Max [No. of Resources] | 0 or >0 |
© 2022 Digital.ai Inc. All rights reserved.