Help with formula for deduction of dues

The dues have changed, it used to be 4% of gross wages + .05 per hour.

It is now 3.65% of: straight time hourly, total package multiplied by the number of all hours worked.

Inclusive of:

hourly wages (including overtime)

Health & Welfare

Pension

vacation

fti

lmci

I need a formula to figure this.

  • 0

    It sounds like the calculation method has changed substantially where the dues now need to calculate on the total package as opposed to only the direct labor cost and hours.   It is going to be difficult to outline how to create a formula to do within this forum, as the process to perform the calculation will be specific to your setup. Addtionally the processing order in Payroll needs to be considered as Union Deductions calculate before the Union Fringes.  I recommend you work with your Sage 300 CRE consultant to develop the appropriate setup, workflow and formulas. Feel free to email me if you would like us to refer you to a qualitied consultant for assistance with this.  ([email protected]) Please include your Sage client ID number in the email.

  • 0

    Hello 

    I need to do the same type of calculation for our Union Dues:

    Wages @ 1.75%

    plus

    total Fringe package @ 1.75%

    Is there any type of formula that you can refer to that would help us get this into our system.  What do we need to pull to get each of the calculated fringes to add them to the Gross wages @ 1.75%