Solved

Vacation Accrual

Posted on 2016-08-09
10
94 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 93

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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
LVL 93

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 93

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 93

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 93

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IT Helpdesk e-mails sample 3 22
VBA: loop recent folder and copy txt file. 8 33
IR 1023 Scanning 4 22
Price for Fiber 13 27
Whether you believe the “gig economy,” as it has been dubbed, is the next big economic paradigm shift (https://www.theguardian.com/commentisfree/2015/jul/26/will-we-get-by-gig-economy) or an overstated trend (http://www.wsj.com/articles/proof-of-a-g…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

839 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