BE_SAMPLE_USERCALC

BE - 401K Maximum#

Requirement#

For the 401K deduction, employees may only contribute $9,000 or 25% of their annual earnings, which ever is less.

401K Maximum Amount#

This UserCalc is step one in determining the maximum 401K deduction for an employee by looking at actual and forecasted earnings.

Statement
Determine the maximum of the 401K deduction each employee, stored in a Statistic (401K Max).
Set up
IMVRUser Variable
Pays this YearNumeric 27
401K Max PrcNumeric 25
401K Max AmtNumeric 9000
IMUCVariables
Pays RemainingNumeric 0
BW WageNumeric 0
Total EarningsNumeric 0
Max PercNumeric 0
IPPCPay Components
9014401K Max AmtStatistic attached to Stat 401K Max Amt
IDSCStatistic Components
401K Max AmtReplace

UserCalc#

Product:PR
Type:Calculation

LineCMDOTOperand 1OPEROTOperand2OTOperand3If GotoElse GoTo
00010LETVPAYS REMAININGSUB$CPAYS THIS YEARDBPPP.PAY_OF_YEAR00020
00020LETVBW WAGEWAGEWBBW 00030
00030LETVTOTAL EARNINGSMLTVPAYS REMIANINGVBW EARNINGS00040
00040LETVTOTAL EARNINGSADDVTOTAL EARNINGSECGROSS PAY 00050
00050LETVTOTAL EARNINGSADDVTOTAL EARNINGSEYGROSS PAY 00100
00100LETVMAX PERCMLTVTOTAL EARNINGS$C401K MAX PRC00200
00200IFVMAX PERCLT$C401K MAX AMT 0030000400
00300LETPC9014RDNVMAX PRCN.0199999
00400LETPC9014EQ$C401K MAX AMT 99999
99999EXIT

Completion#

After publishing this UserCalc, attach it to the Pay Point prior to the 401K Benefit being executed.

401K Maximum Deduction#

This UserCalc is step two in determining the maximum 401K deduction for an employee.

Statement
Determine if the employee deduction for 401K is to be taken fully or if the 401K maximum has been reached.
Set up
IMUC UserCalc
401K Maximum Amount
IMUC Variables
Deduction Numeric 0
Total Deduction Numeric 0
Message Char
Max Amount Char
IPPC Pay Components
3015 401k Deduction
UserCalc
Product BE
Type Function
Return Value Number

LineCMDOTOperand 1OPEROTOperand2OTOperand3If GotoElse GoTo
00010 LET V DEDUCTION EQ $P NUMBER-PARAMETER 00020
00020 LET V TOTAL DEDUCTION ADD PY 3015 V DEDUCTION 00030
00030 LET V MAX AMOUNT CHAR PC 9014 00100
00100 IF PY 3015 GE PC 9014 0011000200
00110 LET V DEDUCTION EQ N 0 00120
00120 LETVMESSAGEEQANo 401K taken
EE over max of
VMAX AMOUNT09000
00200 IF V TOTAL DEDUCTION GT PC 9014 00210 99999
00210 LET V DEDUCTION SUB PC 9014 PY 3015 00220
00220 LETVMESSAGEEQAEE has reached 401K Max Ded ofVMAX AMOUNT00230
00230 LETVMESSAGEEQVMESSAGEA401K Ded. Reduced - PC 301509000
09000 MSGVMESSAGE 99999
99999 RETVDEDUCTION 99999
Completion
After publishing this UserCalc attach it to Benefit Component 1010 - Deduction Method.
The Benefits Component does not have to be Rule 00 - UserCalc Only. Users may choose the appropriate rule and then by placing the UserCalc in the UserCalc field it will be executed.


Notes #

Click to create a new notes page