 In this presentation, we will calculate regular pay and overtime pay and enter that information into this portion of our payroll register. First let's take a look at what we have so far in our payroll register. Support accounting instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. We're only dealing with two employees here those two employees then their filing status married or single number of allowances and then we'll get into the regular hours one has hours the others a salaried employee and then we got the regular rate. So note that this information would typically come from and if we were just to populate the payroll register for the first time or have a new employee this information would come from the W for so remember that the employee would fill out the W for W for would give us the address the name social security number number of allowances which is what we will need here and so we'll populate that information using the W for. So once we have that type of basic information we can calculate the regular pay now it's a straightforward calculation we're going to do these calculations over here so we can see it in more of a vertical fashion and then we'll go back and put that same calculations into our register. So the regular pay is is going to be the number of regular hours remember that in our example we're going to say that there's actually 43 hours total so there's 43 hours total and and if we're subject to overtime then you have to have a 40 hour work week for a federal overtime rate if it's if it's it could be more strict depending on the state if the state has more strict restrictions on overtime pay but we're going to say here that there's a 40 hour work week 43 hours were worked for our our employee that is an hourly employee and therefore 40 is our regular pay and three hours would then be the overtime pay. So for the regular pay then we're just going to take the number of regular hours 40 and we're going to multiply that times the rate 17 and then we'll just multiply that out which would be equals I'm going to say the 40 times with the asterisk the 17 and enter. So there's our regular pay now the overtime pay we're gonna have to do an overtime calculation to get the overtime rate and then we can calculate what the overtime pay will be. So to do that we're gonna do this a couple different ways just so we fully understand what's going on here with the overtime rate so we're going to start with the regular rate that's going to be the 17 and then we're going to increase it we'll start with the idea that the increase is typically we call it time and a half and we can represent that a couple different ways one is you can basically say what what that is is pretty much a 50% raise for anything that's overtime. So if we multiply times 50% or 0.5 we would say okay then the increase would be 17 times 0.5 and that would give us 8.5 increase if we add that to the original 17 then the overtime pay will equal the increase plus the original 17 or in this case 25 dollars and 50 cents. So that's kind of a long way to calculate it but just note that that's it's similar type of calculation if we were to say I do like a tip calculation where we're trying to say that how much will we pay if we had to add an addition in this case 50% which would be a large number but if we're saying 50% increase then how much would we have to pay well we might first calculate the increase and then add it to the original. The faster way to do that would be indicated by the name time and a half would be 17 and we're just going to multiply it times time one and a half 1.5 so overtime rate will be equal then to the 17 times 1.5 and that'll give us our 25.50 and then one more way just to look at that just to note that if we took our original 17 1.5 is a hundred and fifty percent so just note what we're doing is multiplying it times 100% plus another 50% or 150 so that's the 17 times the 150 is the same 25.50 so once we have that then we can calculate our overtime hours here or overtime pay which would be the number of overtime hours remember we had 43 total hours minus 40 for regular pay regular hours times our rate 25.50 gives us equals overtime pay of three dollars or three hours times the 25.50 or 76.50 so we'll just do their same calculation over here in our worksheet we're gonna say that the regular pay in cell f.50 will be equal to 40 times 17 the overtime rate will be equal to the regular rate of 17 times 1.5 one and a half percent so the overtime pay will then equal be equal to the overtime hours times the overtime rate and then we'll get to our total earnings so our total earnings are just gonna be the regular earnings then plus the overtime earnings so that will be equal to the 680 regular earnings plus the 76.50 overtime earnings okay so then the salaried employee we're just gonna say that their salary so that's typically gonna be pretty straightforward the salary pay that we have is three six five three point eight five so I'm just gonna give that and this problem and of course we don't have to worry typically for most salaries paid employees about the overtime meaning they're gonna be exempt from the overtime calculation so typically we don't need to track the hours and count the overtime and pay the overtime pay therefore we're just gonna say that this equals the regular pay then we're gonna sum up the totals and get the totals for the pay period for our two employees by using our sum function equals SUM double-click the sum function highlight these the 680 to the 3653 85 and there we have it we're gonna do the same thing for the total earnings note it doesn't make a whole lot of sense to do that for the overtime pay and the pay rate it doesn't that doesn't give us a whole lot more information total earnings how however does so we're gonna say equals SUM double-click the sum function highlight those two and total earnings then 4,410 and 35 cents