Our Workforce Planning template will allow you to have all of yoru workforce metrics in one area. You can track your workforce planning inititatives by geographic distribution, business units, and job levels. It is very easy to update, maintain and share. The data center tab houses all of the data that all of the metrics are dependent on and all you have to do is enter the data, the charts are dependent on the data you enter on the data center tab as well as the geographic distribution and job level. With our Excel Templates for HR, the templates do all of the math for you, easy, no formulas or charts to figure out.
You want your business to be as profitable as possible. When it comes to running your business successfully you need to have a good system in place which allows you to keep track of your company’s headcount and take care of your payroll planning with ease.
When you use the correct forms you will find that keeping track of this information will be simple and convenient. Our headcount and payroll planning worksheet is the perfect solution. Soal un sd 2013 dan kunci jawaban. Our headcount and payroll planning worksheet will assist with forecasting and planning for the company’s annual headcount, as well as its total compensation. Not only does our worksheet account for expenses such as fringe benefits for example, but it will also help to forecast your company’s compensation expense by using the projected number of staff per quarter within each of the departments.
The worksheet can be downloaded quickly and provide your company with a valuable tool which will make things easier on your staff. How to Use the Headcount and Payroll Planning Worksheet. The first thing you need to do is download the worksheet template which is available on this page for free. You will find this template very easy to customize for your needs.
It’s fully customizable design allows you to enter the pertinent information quickly and in a structured manner. You can download the headcount and payroll planning worksheet template right here for free and begin using it for your company’s headcount and payroll needs. Tips for Using the Headcount and Payroll Planning Worksheet.
Start with downloading the worksheet template for free off of this site. It only takes a moment to download it and you won’t be charged.
Once you have downloaded the template you want to you will need to choose an extraction program to extract the template. After it is extracted you will double click on it to open it. The process for downloading and using the template is a step by step one. Make sure the proper department teams are provided with access to the worksheet and enter all the relevant information correctly. Download: Related Templates:.
Headcount Forecasts in Excel For a software company, personnel-related expenses are usually the largest operating expense by far on the P&L (Profit and Loss Statement). As a large expense, you’ll want to forecast this as accurately as possible. I’ll walk you through how I create detailed headcount forecasts.
You can download the Excel model I used in this example at the bottom of this post. When forecasting operating expenses, I follow the 80/20 rule on where I spend my forecast energy.
If it is a large expense item, I’ll spend 80% of my time on those expenses or expense categories. When setting up my model, I’ll take the time to build forecast automation and detailed calculations into my spreadsheet model. Headcount Forecasting and Planning I forecast headcount by position and name. We are still of the size where this makes sense and it is not tedious to maintain. However, if you have large labor pools, say Pilots or Mechanics in my former life or several hundred sales representatives, you’ll obviously not want to forecast at the named person level.
Headcount Tracking Template
You would be in tears trying to track this. Rather, you will forecast this labor in aggregate using average wage rates, headcount levels, productivity, and so on. And you’ll want to include an open headcount assumption so that you don’t overstate your forecasted labor expenses. Headcount Forecast Model Setup I use one tab in my spreadsheet where I forecast all named positions by department. This tab is my labor “HQ” and all wage and medical changes in this tab flow out through the entire forecast model. I group each department together on rows for ease of use.
On the left side of the tab, I have my inputs. On the right side, my outputs (wages & taxes, benefits, FTE’s physicals). Headcount Model Inputs My columns on the left include Department, Roster (Name), Title, Full/Part-time, Wage Rate, Hours, Tax Rate, Benefits Rate, Start Date, and End Date.
I’ll explain these in detail below. Department – the employee’s department Roster – obviously, the name of your staff Title – again, just their title FT or PT – this field is in calculating the correctly monthly wage expense Hours – number of hours worked per month for part-time employees Payroll Taxes – current employer’s wage tax rate Medical Rate – I forecast medical expenses by head. Often, you see medical expense as a percent of wages which is not really accurate. It usually doesn’t matter if that staff is earning 200K or 20K, your medical premiums are set under a fully-insured plan. If self-insured, I take total medical expenses and the number of participants to determine an average rate per head.
Start Date – start date of the position. End Date – end date of the position Required Fields The only required fields are Wage Rate, PT/FT, Hours, Taxes, Medical Rate, and Start and End Date. I’ve built date logic into my model so that if an employee starts on the 17th of the month, for example, the model calculates the wages for the remaining days in the month. Same goes for the end date. Also, aggregate merit and wage inflation increases can be easily forecasted on its own row. Headcount Model Output With my inputs complete, my headcount model will forecast my monthly wages, physical headcount, FTE’s (full-time equivalent), and medical expenses. FTE’s are determined by how many days in the month the employee worked.
At the very bottom of the model, I have a total row and use the SUMIF Excel function to sum these outputs by department. Excel Formulas Used SUMIF, IF, AND, EOMONTH Conclusion Headcount expenses often represent the largest expense on a software company’s P&L. It’s important to spend the time to develop a detailed headcount forecast model so that not only your wage forecast is accurate but also your cash flow forecast. In any software company, there are always new hires, terminations, and transfers so make your forecast life easier with an automated Excel model.
I can literally update wage expenses in ten minutes or less and be accurate to the day (assuming our hiring managers are not too optimistic!). Please let me know if you have any questions or comments.
I would love to hear feedback? How do you forecast headcount or personnel-related expenses?
Comment below. UPDATE (Dec-16) – I added flexibility to the model so that you can forecast the same position multiple times on the same row.
Instead of a row for each hire, you can enter the number of positions for that role. Much easier to scale. This headcount forecast template is incorporated into my.
Download below. Please enter your email address (no spam) below to download the model.
I’ll keep you updated on future models and posts. 'Most comprehensive and accessible SaaS metrics explanation I've found.' 'Great materials, excellent models' 'Great content, which is highly applicable!'
'Informative - adds value to my life THANK YOU' 'Great resources that save a lot of time and brain damage to replicate.' 'Very informative' 'Excellent look at SaaS planning spreadsheets' 'A usable sales conversion model was a big bonus. It saves a lot of us from reinventing the wheel.' 'Well written, interesting topics. My CFO will love this:)' 'Clearly itemized & explained' 'So specific, clear delivery and incredible time saver' 'Straightforward and informed language on metrics essential to tracking success in a SaaS business.'
'Practical and detailed info on calculating SaaS metrics' 'Good content, real life applicability' When the NPS Survey appears, please take a moment to rate TheSaaSCFO.com and provide a comment.