I have a algorithms for 13 different states on how to calculate insurance premiums.
For example, part of an algorithm for Nevada could be:
MANUAL PREMIUM [(Payroll / 100) * RATE]
+ Supplementary Disease [(SUBJECT PAYROLL / 100) * DISEASE RATE]
TOTAL MANUAL PREMIUM
+Waiver of Subrogation factor [% applied to the portion of Total Manual Premium where waiver is applicable]
That is just a small portion of an algorithm for a particular state. Each line can be considered a "Premium Element". The issue is that different states have differences in Premium Elements (i.e. TN will not have a Waiver of Subrogation factor).
The first thing I want to do, before even figuring out the best way to configure it, is compare the differences in premium elements for the various states.
Right now, I can manually look over the data for all 13 states and create 3 columns: Premium Elements, States that have it, and States that don't have it. However, this seems very tedious and inefficient - there has to be a better way to at least present this data.
Any tips/suggestions would be appreciated!