Financial planning: sharing experience
In yesterday's article, I wrote about the release development management plan template .
Today I will talk about the department’s financial plan in its most basic form. Everyone can, taking it as a basis, do something different.
We begin, as always, with goals and objectives.
The purpose of the financial plan is to estimate the expenses on the wage fund for the coming year in the context of the department controlled by you. Since this is a plan, the key word is to evaluate. For simplicity, taxes are not included in the plan template, as this is a rather specific topic for each company. However, it is quite easy to make a tax plan out of a tax-free plan.
')
// I do not touch on any other items of expenditure except for the payroll, since I do not want to mix everything in one pile. Perhaps I will write about this separately.
What tasks do we solve using such a plan?
Unlike the release development management plan, this template is full of formulas and they really make it easier to update during the year. Therefore, the requirements for spreadsheets are higher: MS Excel is desirable, it may not work in open office.
So, what are the blocks in the plan:
Let's start from the end. First you need to update the directory of posts and departments for your business. Each position and department is associated with a code, which then appears in other tables.
Will add new lines - try to insert them in the middle, but not at the end or at the beginning. In general, there is everywhere “protection from a fool”, but suddenly I forgot where. Otherwise, a set of rows that are viewed by other tables may float away. For example, if summation in Excel went A1-A10, then adding the eleventh line to the sum will not turn on. This applies to all other tables. Therefore, I always try to capture an extra empty line in the ranges, just in case.
Secondly, you need to update the posts:
One of the columns, as can be seen from the figure, has the style "oblique font." Hereinafter, this will mean that you do not need to touch this column - it is calculated automatically. And the rest is just necessary. In particular, for each position, you must specify the salary "for the plan." This is usually a little more than the average salary for the position. Due to the "delta" we have the opportunity to take an employee somewhere "more expensive", and to someone to raise salaries a little. The post code does not need to be in square brackets, but it is a little more convenient, as you will see later.
Go to the tab "Staffing". Here you need to enter data for all existing employees, plus add vacancies.
The wide table here is presented in two "rows". The entire table can be viewed here.
For each job you need:
Calculate automatically:
Now the fun part. In the tab "Finplan by department" you need to ensure that the codes of departments and positions in all three tables were filled in correctly. If you have only leading programmers in the department, then these tables will have one row. If also layout designers, no matter how many they are, then two.
In the first table you should indicate the position code, department and number of employees by months.
In the second and third tables you only need to specify the exact same set of posts as in the first. You don’t need to touch anything else, everything is calculated on its own (remember that italic selected cells where everything is calculated for you)
The third table - the planned average salaries by month - auxiliary:
The second table is the most important. This is a table of payroll expenditures without taxes by months and positions.
At once I will make a reservation, here everywhere filling of tables is delusional. Therefore, two testers in the IT department randomly entered here for different positions. In principle, this would have had no effect on the numbers, but since this is still a template ... In general, this should not happen.
That's basically it. You can download templates on my blog or on my website, RaufAliev.ru .
Today I will talk about the department’s financial plan in its most basic form. Everyone can, taking it as a basis, do something different.
We begin, as always, with goals and objectives.
The purpose of the financial plan is to estimate the expenses on the wage fund for the coming year in the context of the department controlled by you. Since this is a plan, the key word is to evaluate. For simplicity, taxes are not included in the plan template, as this is a rather specific topic for each company. However, it is quite easy to make a tax plan out of a tax-free plan.
')
// I do not touch on any other items of expenditure except for the payroll, since I do not want to mix everything in one pile. Perhaps I will write about this separately.
What tasks do we solve using such a plan?
- We get an idea of ​​the order of expenses on the wage fund in the context of your department;
- We fix these figures with the financial director or your immediate supervisor or CEO;
- We get data for the personnel department and the supply department - how many people will be at what point, which will allow them to plan jobs, as well as their own time (all of a sudden you have explosive growth in May!);
- We obtain data on average salaries for posts - it will allow us to estimate how much each salary of your employee differs from the average for this position;
- and much more.
Unlike the release development management plan, this template is full of formulas and they really make it easier to update during the year. Therefore, the requirements for spreadsheets are higher: MS Excel is desirable, it may not work in open office.
So, what are the blocks in the plan:
- bookmark with common words about the plan (tab "Help")
- Actually monthly plan in the context of months and positions (tab "Finplan by department")
- List of employees (tab "Staff list")
- Directory of positions and departments (tab "Positions and departments")
Let's start from the end. First you need to update the directory of posts and departments for your business. Each position and department is associated with a code, which then appears in other tables.
Will add new lines - try to insert them in the middle, but not at the end or at the beginning. In general, there is everywhere “protection from a fool”, but suddenly I forgot where. Otherwise, a set of rows that are viewed by other tables may float away. For example, if summation in Excel went A1-A10, then adding the eleventh line to the sum will not turn on. This applies to all other tables. Therefore, I always try to capture an extra empty line in the ranges, just in case.
Secondly, you need to update the posts:
One of the columns, as can be seen from the figure, has the style "oblique font." Hereinafter, this will mean that you do not need to touch this column - it is calculated automatically. And the rest is just necessary. In particular, for each position, you must specify the salary "for the plan." This is usually a little more than the average salary for the position. Due to the "delta" we have the opportunity to take an employee somewhere "more expensive", and to someone to raise salaries a little. The post code does not need to be in square brackets, but it is a little more convenient, as you will see later.
Go to the tab "Staffing". Here you need to enter data for all existing employees, plus add vacancies.
The wide table here is presented in two "rows". The entire table can be viewed here.
For each job you need:
- Choose from the Job Code drop-down list
- Choose from the drop-down list "Department Code"
- The sequence number or unique code of the employee within the position;
- Enter the full name or the word "Vacancy"
- Indicate the salary and bonus.
Calculate automatically:
- The full code of the employee, including the department, position and unique number / code within the position;
- A position with the text indicating the department (just “for beauty”, as they say - to check whether the codes are specified correctly);
- The average salary for his position and the deviation from the average salary is absolute and relative ;
Now the fun part. In the tab "Finplan by department" you need to ensure that the codes of departments and positions in all three tables were filled in correctly. If you have only leading programmers in the department, then these tables will have one row. If also layout designers, no matter how many they are, then two.
In the first table you should indicate the position code, department and number of employees by months.
In the second and third tables you only need to specify the exact same set of posts as in the first. You don’t need to touch anything else, everything is calculated on its own (remember that italic selected cells where everything is calculated for you)
The third table - the planned average salaries by month - auxiliary:
The second table is the most important. This is a table of payroll expenditures without taxes by months and positions.
At once I will make a reservation, here everywhere filling of tables is delusional. Therefore, two testers in the IT department randomly entered here for different positions. In principle, this would have had no effect on the numbers, but since this is still a template ... In general, this should not happen.
That's basically it. You can download templates on my blog or on my website, RaufAliev.ru .
Source: https://habr.com/ru/post/112108/
All Articles