Training-Formulas.html
- Welcome To Exenta Shop Floor Control
- Exenta Shop Floor Control Web Application
- Shopfloor Incentive Gross Pay
Training - Formulas
Training - Formulas
Definition and Functionality
IGP uses dynamic formulas to create pay for different types of users, i.e. Piece Rate, group incentive, individual, bonus, indirect users, etc.
Global Parameters
The global parameters have to setup to enable IGP module. There are parameters that create monetary values trough formulas, parameters that give fixed values or standard codes or parameters that use period to calculate averages.
Formula dictionary
|
Daily Pay Parameters |
||
|
[Hours] |
Hours |
Hours on the code for the period (day) |
|
[PieceRate] |
$ |
Sum of money earned calculated using either operation SMV and Base Rate or a fixed piece rate |
|
[StandardTime] |
Minutes |
Sum of minutes earned from operation default SMV |
|
[AddOnTime] |
Minutes |
Sum of minutes earned from operation add-on SMV |
|
[ExtraAddOnTime] |
Minutes |
Sum of minutes earned from operation extra add-on SMV |
|
[EcAddOnTime] |
Minutes |
Sum of minutes from operation “ec” add-on SMV |
|
[Efficiency] |
% |
The efficiency |
|
[OnCurve] |
1 or 0 |
If a user reached the efficiency goal for training |
|
[CurveGoal] |
% |
The actual goal according to training curve |
|
[CurveLow] |
% |
The low % according to training curve |
|
[CurveHigh] |
% |
The high % according to training curve |
|
[User.BaseRate] |
$/Hour |
Current User Base Rate |
|
[User.Guarantee] |
$/Hour |
Current User Guarantee/Minimum |
|
[User.Salary] |
$/Period |
User Salary for one pay period |
|
[User.AverageRate1] |
$/Hour |
User Average 1 |
|
[User.AverageRate2] |
$/Hour |
User Average 2 |
|
[User.AverageRate3] |
$/Hour |
User Average 3 |
|
[User.AverageRate4] |
$/Hour |
User Average 4 |
|
[User.Direct] |
1 or 0 |
If the user is direct |
|
[User.PartTime] |
1 or 0 |
If the user is part time |
|
[User.Temporary] |
1 or 0 |
If the user is temporary |
|
[User.Category] |
1 or 0 |
If the user is part of a category |
|
[User.Department] |
1 or 0 |
if the user is part of the department |
|
[Company.Guarantee] |
$/Hour |
Current Company Guarantee/Minimum |
|
Daily or Weekly Formulas |
||
|
[Total.WorkHours] |
Hours |
Worked hours for the day/week |
|
[Total.AbsenceHours] |
Hours |
Absence hours for the day/week |
|
Hours |
Overtime hours for the day/week |
|
|
Hours |
Shift hours for the day/week |
|
|
[Total.WorkPay] |
$ |
Sum of Gross Pay (ex. overtime) for the day/week |
|
$ |
Sum of overtime pay for the day/week |
|
|
Dynamic Parameters |
||
|
[OnStandard.Hours] |
Hours |
Hours in on-standard for the day/week |
|
[OnStandard.GrossPay] |
$ |
|
|
$ |
Sum of Piece Rate in on-standard for the day/week |
|
|
[OnStandard.StandardTime] |
Minutes |
Sum of all SVM earnings in on-standard for the day/week |
|
[OnStandard.Efficiency] |
% |
Over All Efficiency in on-standard for the day/week |
|
|
|
|
|
[101.Hours] |
Hours |
Hours in 101 for the day/week |
|
[101.GrossPay] |
$ |
Sum of Gross Pay in 101 for the day/week |
|
[101.PieceRate] |
$ |
Sum of Piece Rate in 101 for the day/week |
|
[101.CurvePayGoal] |
$ |
Special parameter for codes with training curve. |
|
|
|
In this case sum of pay goal in 101 for the day/week. |
|
[101.StandardTime] |
Minutes |
Sum of all SVM earnings in 101 for the day/week |
|
[101.Efficiency] |
% |
Over All Efficiency in 101 for the day/week |
|
|
|
|
|
… |
|
|
|
[Group1.Hours] |
Hours |
Hours in group 1 for the day/week |
|
[Group1.GrossPay] |
$ |
Sum of Gross Pay in group 1 for the day/week |
|
[Group1.PieceRate] |
$ |
Sum of Piece Rate in group 1 for the day/week |
|
[Group1.StandardTime] |
Minutes |
Sum of all SVM earnings in group 1 for the day/week |
|
[Group1.Efficiency] |
% |
Over All Efficiency in group 1 for the day/week |
Types of formulas
Mathematical
Uses parameters to create simple mathematical operations. i.e. Sums, multiplication, etc.
Logical
Uses logical test or identifies connections to evaluate the result. i.e. IF, COALESCE, etc.
Daily / Weekly
Uses the daily parameters to reports daily or weekly results.
How and Where to use them?
The IGP module allows you to create formulas on global settings and standards. Formulas are classified in two groups:
- Gross Pay formulas creates monetary gross values by standards codes.
- Hours formulas creates a group of hours to be used on the gross pay formulas.
The system uses the Daily pay parameters like [Hours] to be summed or multiplied by a [.Rate] (user base rate, average rate, etc).
Examples
Mathematical
|
Simple multiplication |
Hours worked X User guarantee/hr. |
[Hours] * [User.Guarantee] |
|
Evaluating Values |
Max or Min values |
[Hours] * MAX([User.Guarantee] , [User.BaseRate] ) |
Logical
- IF Function looks at one value to return the TRUE value formula or a FALSE value formula.
IF ( [User.Direct]=0 , [Hours] * [User.Guarantee] , [PieceRate] )
- COALESCE looks a value in order to return a false or true statement
IF ( COALESCE ( [User.Category.2] , false ),( [Hours] * [User.Guarantee] * [User.BaseRate] ) - ( [User.Guarantee] * [Hours] ) , 0 )
