ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Field NameSourceField NameFormula
2
Assignment Basis
Employee History File per user per assignement
Basis
3
Target Percent1Imported form Bonus Plan fileASSIGNMENT_TARGET_PERCENT1
4
Target Percent2Imported form Bonus Plan fileASSIGNMENT_TARGET_PERCENT2
5
Target Percent3Imported form Bonus Plan fileASSIGNMENT_TARGET_PERCENT3
6
Target Percent4Imported form Bonus Plan fileASSIGNMENT_TARGET_PERCENT4
7
Proration--[(Earlier of Bonus Plan end date and Assignment end date) - (Later of Bonus Plan begin Date and Assignment begin date) + 1] / [(bonus plan end date) - (bonus plan begin date) +1]
8
Target Amount--Proration * Assignment Basis
9
Goal WeightImported from Weight mappings fileGOAL_WEIGHT
10
Goal Basis--Total Target * Goal Weight
11
Performance MinimumImported from Business Goal filesperformanceMin
12
Performance TargetImported from Business Goal filesperformanceTarget
13
Performance MaximumImported from Business Goal filesperformanceMax
14
Goal ForecastImported from Business Goal filesforecast
15
Goal Forecast Payout Percent--Formula
16
The forecast, forecast2 and result are numbers that the application is to find payout percentages for. We support a maximum of 5 points to figure out the payout percentage. Below are combinations that the application can handle
17
1. min, target_low, target, target_high and max. (5point)
18
2. min, target_low, target, max (4point)
19
3. min, target, target_high, max (4point)
20
4. min, target, max (3 point) //most common
21
5. min, target. (2 point).
22
and their corresponding percentages.
23
The application figures which 2 points the subject lies between.
24
Example if min = 10 and target = 20 and max = 40 and given a number representing forecast etc to be 12 it will pick min and target to be the 2 points to do the calculation. If the subject is less than min we always associate zero to be the payout and if it is greater than the max we set it to max.
25
The detail of the search algorithm being used is in a different document.
26
Formulas:
27
Interpolate formula. Given the two points (xmin, ymin) (xmax, ymax) and x
28
find y ..
29
y = ymin + (x-xmin)(ymax-ymin)/(xmax-xmin)
30
Step Formula: we always take the floor when we get the two points which X (subject) lies between.
31
Direct: "Y" is set to the amount given irrespective of points etc.
32
Goal Forecast Payout Amount--Goal basis * Goal Forecast Payout Percent
33
Goal Forecast2Imported from Business Goal filesforecast2
34
Goal Forecast2 Payout PercentSame as Goal Forecast Payout Percent
35
Goal Forecast2 Payout AmountGoal basis * Goal Forecast2 Payout Percent
36
Goal ResultsImported from Business Goal filesresults
37
Goal Results Payout Percent--Same as Goal Forecast Payout Percent
38
Goal Results Payout Amount--Goal basis * Goal Results Payout Percent
39
Total Target Amount--Sum(Goal Basis for each Assignment)
40
Total Target--Sum of (Total Goal Basis for each Assignment)
41
Forecast Calc Amount--Sum ( All forecast amounts of all assignments for an employee)
42
Business Forecast Percent--Forecast Calc Amt / Total Target
43
Forecast2 Calc Amount--Sum ( All forecast2 amounts of all assignments for an employee)
44
Business Forecast2 Percent--Forecast2 Calc Amt / Total Target
45
Business Calc Amount--Sum (All Goal Result Payout amount of all the assignments for an employee)
46
Business Percent--Business Calc Amount / Total Target
47
Team Calc AmountN/A-N/A
48
Team RatingN/APM FormN/A
49
Team GuidelineN/A-N/A
50
Team PercentN/A-N/A
51
Team AmtN/A-N/A
52
Ind Calc AmountN/A-N/A
53
Ind RatingN/AN/A
54
Ind GuidelinesN/AN/A
55
Ind PercentN/AN/A
56
AmtN/A-N/A
57
Forecast Amt--Sum of (Group Total of Forecast Payout Amount for each Assignment)
58
Forecast Pecent of Tgt--Forecast Amount / Total Target Amount
59
Total--sum of (Group Total of Forecast2 Payout Amount for each Assignment)
60
Forecast2 Percent of Tgt--Total / Total Target Amount)
61
Final Payout--Business Calc Amount
62
Percent of Tgt--Final Payout  / Total Target amount.
63
Percent of Salary--Final Payout / Salary (Imported from User Directory)
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100