Create an Estimate Bill Format in Excel for Human Resources Effortlessly

Estimate bill format in excel for Human Resources

[Music] now under each of these we're going to have two categories of people Junior and senior okay we we still don't know the exact designations of these people they could be called managers directors vice presidents but very broadly we're going to say they're going to be junior host they're going to be senior host uh so that so so there are Junior and senior marketing people the Junior and senior chefs the uh well call centers only one kind of people let's say and administrator only one kind of people all right so now let's focus on the junior host let's say in January right below each of these you put the salary and right next to these numbers on a monthly basis is where you'll say how many people you want to hire so let's say in January you're going to hire one person in February you're going to hire one more so you're going to have two people march you're not let's say in March you're going to hire two more people four people uh and then let's say in April you're going to have some more people so six uh you're going to stay six that's for some time until you're going to open a new restaurant in August so let's say immediately you're going to have 12 people you're going to say you're going to have 12 people every month from until December so you see what is happening here I'm basically saying that you want to hire this is the number of these host who work with you who work in your who work in your restaurant January there's only one person February there's two people march there's four people and in December there's 12 people and let's say in the year two in the first quarter you uh you add uh you want to add one more restaurant so you're going to increase the number you're going to have 20 people um right there because you're having three restaurants and all that uh and then right here let's say you have 22 people sameh here you have 30 people and in quarter 4 you're going to hire 34 people that's the number of people who are working in that role in your company as a junior staff okay now similarly actually before we go to the senior staff let's see how much you going to pay these guys let's say these guys are really smart dedicated customer friendly kind of H uh who welcome people greet them nicely smile at them so we're going to pay them let's say uh 30 no 30,000 rupees per month okay I'm going to go make this comma and all that so that this thing looks good you're going to pay 30,000 rupees per month keep that constant so to keep it constant I'm going to I I'm not going to type the number again I'm just going to say equal to and link to that and I'm just going to drag this across and then for the next year we're going to assume that you're a generous boss and you're going to give them all a 20 per rise that's the formula for a 20 per rise the 30,000 multiplied by 1+2 which is 1.2 yeah that the 02 is the 20% so you see watch this 36,000 the reason we put everything into formulas is because let's say now you want to change your assumption to 25,000 then you just see how this changes to 30,000 automatically you don't have to do anything [Music]