6. Computational Appendix
  • Print

Computational Appendix in LITEBI's BSC

In this appendix we will explain in detail how to calculate the status and trends of the elements that compose the Balanced Scorecard. The only objects that have these fields in the execution profile are the metrics, objectives, perspectives, tasks and initiatives. There are 4 possible status and 4 possible trends that may occur.

Status

The status may be:

  • Positive     green
  • Normal      normal
  • Negative   negative
  • "No data"  no data

Metrics:

To calculate the status of a metric, LiteScorecard uses its value, its target value and tolerance within a given period. To obtain the value and the target value of a metric in a period, the system is based in the selected:

- If "Sum" the system will add all the values ​​of the historical period of the metric.

- If "Avg" the system will calculate an average of all the values ​​of the historical period of the metric.

- If "Max" the system will take the maximum value of all the values ​​of the historical period of the metric.

- If "Min" the system will take the minimum value of all the values ​​of the historical period of the metric.

- If "Last" the system will take the last value stored in the database of the historical period of the metric.

After obtaining these values, we proceed to calculate their status by comparing the value to the target value using the tolerance:

- If the value is within the limits set by the tolerance, the status will be normal.

- If above, the status will be positive.

- If below, the status will be negative.

- If no data, the status will be "no data".

Objectives:

To calculate the status of an objective, LiteScorecard is based on the status of its metrics and its weights within that objective. It performs a calculation on these data and obtains a result that determines the status of the objective.

Perspectives:

To calculate the status of a perspective, LiteScorecard uses the status of its objectives and weights within the perspective. It make an internal calculation through these values ​​and obtains a value that defines the perspective's status.

Tasks:

To calculate the status of a task, LiteScorecard uses its progress in a given period and its start and end dates. We always get the last existing progress in the DB, previous or equal to the date of the period. Once obtained, the status is calculated from the start and end dates. The system calculates the estimated average of the daily progress and the real daily progress of the task. The first is calculated with the dates of start and end of the task and the current date. The second is calculated from the selected period and the real progress data of the task, stored in LITEBI for that period.

- If the dispute is over 90%, the status of the task will be positive.

- If in between 70% and 90%, the status will be normal.

- If less than 70%, the status will be negative.

- If there is no information in the DB on the progress, previous or equal to the date selected, the status will be "no data".

Initiatives:

To calculate the status of an initiative LiteScorecard calculates which takes into account the status of the tasks associated with the initiative and the weight of each task in the initiative. The resulting value determines the status of the initiative for the selected period.

 

Trends

The trend can be:

  • Positive      positive
  • Similar        similar
  • Negative    negative
  • "No data"   no data

 

To calculate the trends of the elements of the balanced scorecard, LiteScorecard compares the current status with the status of the previous period of the item:

- If they are equal, the trend will be similar.

- If the current status is higher than the previous status, the trend will be positive.

- If the current status is lower than the previous status, the trend will be negative.

- If any status is "no data" the trend will be "no data".