Training-Formulas
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.Category.Rate] |
$/Hour |
User category rate |
|
[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.Paytype] |
|
The users pay type |
|
[User.Department] |
1 or 0 |
if the user is part of the department |
|
[User.Shift] |
1 or 0 |
if the user is part of a shift |
|
[User.Hired] |
Date |
The users hired date |
|
[User.DaysHired] |
|
The number of days since hired date |
|
[Company.Guarantee] |
$/Hour |
Current Company Guarantee/Minimum |
|
[User.TopDepartment.XXX] |
1 or 0 |
The top department of the user department hierarchy |
|
[OutsideShift] |
1 or 0 |
Whether the users time is outside their assigned shift hours or inside |
|
[User.HolidayRate] |
$ |
The $ rate that the holiday time will be paid at |
|
[User.VacationRate] |
$ |
The $ rate that the vacation time will be paid at |
|
[Department.ProductCategory] |
1 or 0 |
The product category assigned to the location department |
|
[Department.ProductCategory.Goal] |
Value |
The goal assigned to the department |
|
[Department.ProductCategory.Produced] |
Value |
The actual production output of the department |
|
[Department.ProductCategory.StyleChangingBonus] |
$ |
The $ to pay as a bonus for changing to a different syle |
|
[Department.ProductCategory.GoalsDaysOfWeek] |
Value |
The number of days that will be included in the goal of the week |
|
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 |
|
|
[Total.WorkDays] |
Value |
Days |
|
[Total.ShiftBreak] |
Hours |
Total hours for break from the shift definition |
|
[DepartmentTotal.ModularSAM] |
Value |
Total accumulated onstandard SAMs produced by a module linked by milestone |
|
[DepartmentTotal.Hours] |
Hours |
Total onstandard work hours for a given department |
|
[DepartmentTotal.PieceRate] |
Value |
Total onstandard piecerate earned by department module |
|
[DepartmentTotal.Efficiency] |
% |
Total overall effieciency earned by department module |
|
[DepartmentTotal.ModularEfficiency] |
% |
Total onstandard effieciency earned by department module |
|
[DepartmentTotal.GrossPay] |
$ |
Total gross pay earnings by department module |
[User.Department.GoalEfficiency] |
% |
Goal efficiency assigned to the department |
|
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 |
|
[ProductionCount] |
|
Total production by user |
|
[DeviationCount] |
|
Total quality defects per user |
|
[AuditCount] |
Value |
Total number of audits that will be made |
|
[AuditsMade] |
Value |
Total number of audits made throughout the day |
|
[AuditsFailed] |
Value |
Total number of failed audits made throughout the day |
|
[CurvePayGoal] |
Value |
The curve goal that should be obtained |
|
[User.BreakHours] |
Hours |
The number of break hours that a given user has |
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 )
Copyright © 2020 by Exenta. All rights reserved.
Created with the Personal Edition of HelpNDoc: Free PDF documentation generator