AuditBible

General Forums => AuditBible Tools => Topic started by: DToutain on September 29, 2011, 09:59:34 PM



Title: split rate calculator?
Post by: DToutain on September 29, 2011, 09:59:34 PM
Hi!  Anyone know where I can find an online split rate online calculator that I can use to apply to an audit?  Need to divide the year up, for 2 different rating periods, then apply to all class codes.  Any help would be appreciated!


Title: Re: split rate calculator?
Post by: beancounter on October 03, 2011, 03:59:01 PM
Is this what you're looking for?  Let me know if you need it customized in any way  ;)


Title: Re: split rate calculator?
Post by: DToutain on October 03, 2011, 07:22:32 PM
Ah,,,I didn't see your reply til just now. I'm not exactly sure how to use this....I remember the nice round wheel I used to have.  Wish I had one of those! I can just break down and count how many days in each month etc etc....
Thanks alot for your help though.
Debra


Title: Re: split rate calculator?
Post by: beancounter on October 05, 2011, 12:03:51 AM
It's just an Excel version of the wheel...enter the dates (delete the example dates I entered) and it gives you the decimal prorata to use for multiplying your payrolls to accomodate the splits.

For example:
If you have a 1/1/2011 to 1/1/2012 policy with a rate split at 2/23/2011, enter the effective date of the policy and the split date to obtain the prorata factors.

Effective      Expiration      
Date            Date          Pro-rata   Days
01/01/2011   02/23/2011   0.15        53
02/23/2011   01/01/2012   0.85       312
Let me know if you have any more questions  :)