Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Need help annualizing WC

0

Hello,

I am learning excel but cannot understand how to annualize my data.  I am needing to take my WC rate of .18 and annualize from the start date of 5/22/17 to 6/28/2017.  I cant seem to get it right.  Can someone help me?

Start Date Employee ID SUI State for Check Workers Comp Rate Regular Hours 5/22/2017   SC 0.18 80
Answer
Discuss

Discussion

Hi there, Im not sure what is WC? Can you explain the issue in more detail? If you could include a sample file showing before and after that would be even better.
cappymer1 (rep: 120) Jul 3, '17 at 9:41 am
Add to Discussion

Answers

0

I would get so many weeks worth of data (try to say 4 weeks of data), then get the wages by person for the 4 weeks.  Multiply by 13 (to make 4 weeks a full year or 52 weeks, you would multiply by 13 to get annualized wages, then multiply by your WC factor. if it is an odd number of weeks you will have factor with decimal (for 7 weeks ~ 52 / 7 = 7.43)

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login