Solved

Vacation Accrual

Posted on 2016-08-09
10
87 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Copy a range from 1..n excel sheets to one destination sheet 2 35
Msbbox Notice (4 days) 27 59
Excel Drop Down List 13 35
Creating An Intelligent Dropdown 8 30
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.
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…

821 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