KPIs

Total Open Jobs

The count of all active or open jobs.

The jobs can be calculated using this formula: Count (Job where Status = Open)

On Time Completion%

The percentage of jobs completed on or before due date. The jobs can be calculated using this formula: (Jobs Completed On Time / Total Jobs Completed) *100

Actual Qty vs Plan Qty%

The comparison of actual produced quantity vs planned quantity. The quantity can be calculated using this formula: (Actual Qty / Planned Qty) *100

Job Cost Variance

The difference between actual job cost and planned job cost. This difference can be calculated using this formula: Actual Cost - Planned Cost

Job Cost Variance%

The percentage variance in job cost. The difference can be calculated using this formula:(Actual - Planned/Planned) *100

WIP Jobs Count

The total jobs currently in WIP status.

These jobs can be calculated using this formula: Count (Job where Status = WIP)

WIP Value

The total value of work in progress jobs.

The total value can be calculated using this formula: Sum (WIP Cost)