Difference between revisions of "Custom KPI Data Entry"

From Profit Navigator
Line 1: Line 1:
 
Custom KPI Data Entry is designed to allow you to track any measurable performance metric.  When you visit this section you will be presented with a group of 10 numbered KPIs.  You can organize KPIs into specific ''KPI Groups''.  This allows you an unlimited number of available KPIs and allows you to group common KPIs or even assign specific KPI groups to other members of your company. For example to track specific performance goals for a specific division of your business, you can assign one or more groups of KPIs to that division.
 
Custom KPI Data Entry is designed to allow you to track any measurable performance metric.  When you visit this section you will be presented with a group of 10 numbered KPIs.  You can organize KPIs into specific ''KPI Groups''.  This allows you an unlimited number of available KPIs and allows you to group common KPIs or even assign specific KPI groups to other members of your company. For example to track specific performance goals for a specific division of your business, you can assign one or more groups of KPIs to that division.
 +
 +
In order to get started with your Custom KPIs, you have to decide what you want to track and how to measure your performance.  Start by selecting any one of the 10 KPIs using the numbered KPI buttons and enter a title.  Next set how you would like to display your information.  Choices are ''Percent %'', ''Dollars $'', ''Units'' or ''Custom''.
 +
 +
Choosing ''Percent'' will prompt you to make additional choices because we need to track two numbers for each month, a numerator and a denominator.  Percentage allows entry of decimal numbers (eg 1234.56)
 +
 +
Choosing ''Dollars'' will provide a ''$'' dollar sign, commas and tracks in dollars and cents.
 +
 +
Choosing ''Units'' will allow you to enter whole number units, fractional portions are discarded.
 +
 +
Choosing ''Custom'' will allow you to enter whole number units and provide a suffix that makes sense to you.
 +
 +
Next you will need to set the calculation method.  The default calculation method is ''Relational To Last Year Accumulating''.
 +
 +
Choices are:
 +
 +
* Fixed Value
 +
** A Fixed Value allows you to set a fixed value goal for all months through the year.  This is much like a Custom Defined goal, but only requires you to enter the value once for all months.  You may not use fixed values with percentages.
 +
* Fixed Range
 +
** The Fixed Range setting allows you to set an upper and lower bounds or range of acceptable values.  For example, an upper bounds of 500 and lower bounds of 300 means that you have hit your goal if you are within 300-500.  Note that using a fixed range disables the ability to set a decreasing goal and you may not use fixed values with percentages.
 +
* Custom Defined Accumulating
 +
** This will set an accumulating goal month to month.  You will be presented with 12 additional entry fields to set each specific month's goal, however overall goal progress will accumulate the total goal vs your total performance for each month.  For example, if you set each month's goal to 100, January's target will be 100, February's target will be 200, March's target will be 300 and so on.  This is the sum of all previous months, so if your results are 100 in Jan, 90 in Feb and 110 in March, your accumulated total will be 100 in Jan, 190 in Feb (missing your goal by 10) and 300 in March (hitting your March goal).
 +
* Custom Defined Averaging
 +
** This method will average your performance throughout the year.  You will be presented with 12 additional monthly entry fields for your custom goal but instead of accumulating performance, the system will average the goals for each month and compare that with your average performance.
 +
* Relational To Last Year Accumulating
 +
** This method is the easiest to understand and manage.  When you select this calculation method the system will prompt you for a ''Relational Percent Change''.  This will take the 12 months prior and apply the percentage multiplier as your goal.  This method is much like the ''Custom Defined Accumulating'', but goals are derived from the previous years' performance.
 +
* Relational To Last Year Averaging
 +
** Much like the custom defined averaging, this relational calculation method averages your performance and averages your monthly goals.  Again you will be presented with a ''Relational Percent Change'' form field to set your goal based on the prior year's performance.
 +
* Relational To Last Year Month to Month
 +
** Finally, the month to month relational goal uses the ''Relational Percent Change'' over the prior year; but does no averaging or accumulating and sets your goal to a month-to-month evaluation.

Revision as of 15:27, 22 January 2019

Custom KPI Data Entry is designed to allow you to track any measurable performance metric. When you visit this section you will be presented with a group of 10 numbered KPIs. You can organize KPIs into specific KPI Groups. This allows you an unlimited number of available KPIs and allows you to group common KPIs or even assign specific KPI groups to other members of your company. For example to track specific performance goals for a specific division of your business, you can assign one or more groups of KPIs to that division.

In order to get started with your Custom KPIs, you have to decide what you want to track and how to measure your performance. Start by selecting any one of the 10 KPIs using the numbered KPI buttons and enter a title. Next set how you would like to display your information. Choices are Percent %, Dollars $, Units or Custom.

Choosing Percent will prompt you to make additional choices because we need to track two numbers for each month, a numerator and a denominator. Percentage allows entry of decimal numbers (eg 1234.56)

Choosing Dollars will provide a $ dollar sign, commas and tracks in dollars and cents.

Choosing Units will allow you to enter whole number units, fractional portions are discarded.

Choosing Custom will allow you to enter whole number units and provide a suffix that makes sense to you.

Next you will need to set the calculation method. The default calculation method is Relational To Last Year Accumulating.

Choices are:

  • Fixed Value
    • A Fixed Value allows you to set a fixed value goal for all months through the year. This is much like a Custom Defined goal, but only requires you to enter the value once for all months. You may not use fixed values with percentages.
  • Fixed Range
    • The Fixed Range setting allows you to set an upper and lower bounds or range of acceptable values. For example, an upper bounds of 500 and lower bounds of 300 means that you have hit your goal if you are within 300-500. Note that using a fixed range disables the ability to set a decreasing goal and you may not use fixed values with percentages.
  • Custom Defined Accumulating
    • This will set an accumulating goal month to month. You will be presented with 12 additional entry fields to set each specific month's goal, however overall goal progress will accumulate the total goal vs your total performance for each month. For example, if you set each month's goal to 100, January's target will be 100, February's target will be 200, March's target will be 300 and so on. This is the sum of all previous months, so if your results are 100 in Jan, 90 in Feb and 110 in March, your accumulated total will be 100 in Jan, 190 in Feb (missing your goal by 10) and 300 in March (hitting your March goal).
  • Custom Defined Averaging
    • This method will average your performance throughout the year. You will be presented with 12 additional monthly entry fields for your custom goal but instead of accumulating performance, the system will average the goals for each month and compare that with your average performance.
  • Relational To Last Year Accumulating
    • This method is the easiest to understand and manage. When you select this calculation method the system will prompt you for a Relational Percent Change. This will take the 12 months prior and apply the percentage multiplier as your goal. This method is much like the Custom Defined Accumulating, but goals are derived from the previous years' performance.
  • Relational To Last Year Averaging
    • Much like the custom defined averaging, this relational calculation method averages your performance and averages your monthly goals. Again you will be presented with a Relational Percent Change form field to set your goal based on the prior year's performance.
  • Relational To Last Year Month to Month
    • Finally, the month to month relational goal uses the Relational Percent Change over the prior year; but does no averaging or accumulating and sets your goal to a month-to-month evaluation.