Solved

Vacation Accrual

Posted on 2016-08-09
10
66 Views
Last Modified: 2016-08-10
Hi, I'm moving away from a job where I was a contractor. I worked and got paid 110 hours every 4 weeks. I also, over the years, always got 4 weeks off, so I got 110 hours off every year.

I've will have worked 33 pay periods since Jan 1, 2016, when I leave at the end of the week. How can I calculate how much vacation time I've accrued?

I'm not sure if anyone here can answer, as it's basically an accounting question, but maybe, so here it is. Thanks.
0
Comment
Question by:mel200
  • 5
  • 4
10 Comments
 
LVL 90

Expert Comment

by:John Hurst
ID: 41749639
Assuming your vacation year is Jan 1 to Dec 31, you get

(33 / number of pay period in a year)  x 4 weeks less any vacation you took this year. That should suffice nicely and how I do it for clients.
1
 

Author Comment

by:mel200
ID: 41749650
Thanks, John, So that is 33 divided by 13 (52 weeks divided by 4) = 2.5x4=10. But I'm not sure what that 10 represents.
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 41749651
^John's formula is correct.

Since you stated you're on pay period 33, that agrees with a weekly pay cycle (August 7-13 is week 32 or 33, depending on the fiscal calendar).

No points, but that formula calculates to 69.81 hours total, less any vacation you've taken this year.
[(33/52)*110] = 69.81 (then subtract vacation used from that total).
0
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 41749655
It would be 33 / 52 x 4  = 2.54 weeks. (you have an extra 4)   2.54 weeks  / 4 allowed x 110 hours = about 70 hours.
0
 

Author Closing Comment

by:mel200
ID: 41749669
Thanks, all!!
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 90

Expert Comment

by:John Hurst
ID: 41749671
You are very welcome and I was happy to help
0
 

Author Comment

by:mel200
ID: 41750350
Hi- wait, one thing. The reason I had the extra four is this. You had 33x52 weeks in a year, But my pay period is for 4 weeks.
 
It does correspond to a weekly pay period, yes, but every 4 weeks, not every week. It seems off to me. I've worked 7.5 out of 12 months, so 62%  of my work year. 62% of 110 hours is 68.2 hours, I think I might use that.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41750373
You can do that. I said roughly 70 hours and you got 68 (I just approximate) so that is good.
0
 

Author Comment

by:mel200
ID: 41750375
Thanks, John. I'm ok at designing websites, but arithmetic has always made my head hurt. :)
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 41750377
Yes, I understand. I do accounting consulting so my head is always full of numbers.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Learn more about the importance of email disclaimers with our top 10 email disclaimer DOs and DON’Ts.
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now