The planned premium multiplied on the sum of the index 1 and the index 2 for an each employee. The formula for calculating of the amount of premium to be accrued: =C3*(F3+G3).Therefore, for the calculating of the index 1 and the index 2 are used the same formulas (change only the cell references). The values of the coefficients are also equal. We accepted that the impact of the index 1 and the index 2 for the amount of the premium are the same. The formulas in Excel KPI calculation for each an employee.
For calculation of the premium are used to the coefficient.The percentage of the sales plan and the work plan are calculated as the ratio of actual performance to planned ones.For the convenience of calculations we assumed that the fixed and the variable part of the salary are equal. The salary – is the permanent part of the salary depends on the number of hours worked.The Key Performance Indicators and the weight of each of them:Īssume the following meanings of the coefficients (the same ones for 1 indicator and indicator 2): Suppose that the ratio of the fixed and the variable parts of the salary - 50 × 50. The motivational factor affects the formation of variable part. Almost always the wages of an employee is made up of salary (fixed part) and premium (the variable part /the changeable part). The key point in measuring of KPI – is the actual to planned ratios. This is only the option definition of motivational factors. During the reporting period there were no comments – the coefficient is 0.The absence of errors – the coefficient is 0.The implementation of the plan 100 - 115% - the coefficient is 0.The implementation of 100% of the plan - the coefficient is 0, 45.The implementation of the plan less than 80% - is unacceptable.The coefficient of variation (scales), the company also defines by itself. The system of measurement: the actual number of customers / the planned number of customers. The key indicator – is the number of clients in the company database. The task - to increase the number of customers by 15% in a particular region.The system of measurement: is the actual average value of the shipment / planned average value of the shipment. The key indicator – is the average amount of shipment. The task - to increase the amount of shipments in the period by 20%.The system of measurement: there are the actual amount of sales / the planned sales amount. The key performance indicator - is the sales plan. The purpose - to provide product sales plan of 500 000 rubles monthly.Dates are depended from the company's tasks. The compensation amount may be fixed or be expressed as a percentage of salary.Įach enterprise determines to the key performance indicators and the weight of each individual. The prize amount / bonus, depends from the result of a particular employee in the reporting period. To get it may be that an employee, who has fulfilled the task set before him. The stimulating factor in the system of motivation KPI – is the compensation. KPI key performance indicators: examples in Excel
0 kommentar(er)
