How to set up DBAs for Medical Insurance
Hi to everybody,
Based on our policy the employee Medical Contribution is calculated as a percentage on a flat amount: one amount regarding the employee and one amount for each of his dependents. The percentage and the amount vary per employee and dependent.
Example:
Employee Med Amount = 50 , Percentage = 50%
Dependent 1 Amount = 40 , Percentage = 60%
Dependent 2 Amoount = 30 , Percentage = 50%
…….
Dependent X Amount = 30 , Percentage = 20%
Medical Contribution = (50 * 50%) + (40 * 60%) + (30 * 50%) +…+ (30 * 20%) = …
Can anyone suggest a way to setup the system (with less DBAs as possible) apart from creating one DBA for the employee and one DBA for each dependent?
Antonis