Solved

Vacation Accrual

Posted on 2016-08-09
10
117 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 95

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 95

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
 
LVL 95

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 95

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 95

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing is at the top of most security top 10 efforts you should be pursuing in 2016 and beyond. If you don't have phishing incorporated into your Security Awareness Program yet, now is the time. Phishers, and the scams they use, are only going to …
I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

732 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