Reports

PM Indexes

The module PM Indexes – Projects is used to store information about the project management indexes for each project.

The following indexes are stored in this module on a regular basis:

  • BAC – Budget at Completion: Total planned value of the project. Calculated as the sum of all offered (planned) hours (PV) for all project tasks (N).
  • EAC – Estimate at Completion: Estimated total cost of the project upon completion, calculated as BAC / CPI.
  • EV – Earned Value: Value of work actually completed so far. Calculated as the sum of planned hours for all closed tasks.
  • AC – Actual Cost: Total hours spent so far for completed tasks. Formula: ∑AC(n)
  • PV – Planned Value: Approved budget for tasks that should have been completed by now. Formula: ∑PV(nt)
  • CPI – Cost Performance Index: Efficiency of cost usage so far. Calculated as EV / AC.
  • EI – Effort Index: Comparison between planned and actual hours for completed tasks. Formula: PV / AC.
  • SPI – Scheduled Performance Index: Comparison between work performed and planned schedule. Formula: EV / PV.

Two jobs in the main scheduler populate the indexes with data daily at 08:00 and 16:00:

  • Generates pm_indexes_all_projects at 08:00
  • Generates pm_indexes_all_projects at 16:00

Staff Utilization

...

Task Violation Report

...

Time Tracking per Employee

...

Time Tracking per Employee and Category

...