topic Re: Salary Calculations in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46798#M5828
<P>Hi Shweta, </P><P> </P><P>The salary calculation is an interesting topic and at the same time quite different from company to company, and enev inside a company from country to country. Let me try to give you some general guidance</P><P> </P><P>Companies are analyzing salary by components such as Base salary, Social Charges, Health Insurance, Allowances, Other benefits, etc which all of those adds up in the Full Salary Package. To calculate those costs, which most of the time represent the biggest part of the P&L, is needed to understand <U>the way a salary is calculated</U>,<U> company policies and country-specific laws</U> (this is specified by the subject matter experts). Anaplan itself has a model on AppHub regarding Workforce Planning so you can check it out in order to get familiarised with how salary components are calculated.</P><P> </P><P>When calculating increases, there is quite some pre-word needed (workshops with the business) in order to get the correct salary base on which the increase is calculated. The starting point is what you take as a base: monthly or annual salary. Normally the base for increases does not include other salary components (e.g. allowances) so you need to ask to what base the increase is applied and whether other components of salary will be affected once with the salary rise (e.g social charges). </P><P> </P><P>Let’s suppose you want to calculate the salary increase for next year, and your base is the salary of this month. In this case, you need to calculate forward the base salary for your budget at the end of this year (usually what is the salary in Dec 2019) by including any potential increases happening this year, in order to get as close as possible to the base of next year, and use it in calculating <STRONG><U>monthly salary of Y+1, </U></STRONG>which is starting base for all the other components which depends on salary.</P><P> </P><P>After you get the correct monthly salary of Y+1 (which includes the increase) then all the other dependent components will be affected. How the salary should look like for a 1000£ monthly salary, supposing there is a 10% increase in June:</P><P> </P><TABLE><TBODY><TR><TD><P><FONT size="1 2 3 4 5 6 7">Jan 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Feb 201</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Mar 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Apr 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">May 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jun 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jul 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Aug 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Sep 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Oct 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Nov 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Dec 20</FONT></P></TD></TR><TR><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT face="arial black,avant garde"><STRONG><FONT size="1 2 3 4 5 6 7">1100£</FONT></STRONG></FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD></TR></TBODY></TABLE><P> </P><P>If<U> Social Charges</U> are calculated as a % of the monthly salary, then on the month of increase and months after, the social charges will also change. Based on example above, social charges will look like this (calculated as 15% of base):</P><P> </P><TABLE><TBODY><TR><TD><P><FONT size="1 2 3 4 5 6 7">Jan 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Feb 201</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Mar 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Apr 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">May 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jun 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jul 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Aug 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Sep 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Oct 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Nov 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Dec 20</FONT></P></TD></TR><TR><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><FONT size="1 2 3 4 5 6 7"><STRONG>165£</STRONG><BR /></FONT></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD></TR></TBODY></TABLE><P> </P><P>To wrap up and answer your question, the hardest part, in my opinion, is to get the salary increase calculation correct, and all the other components which depend on it will basically change according to the calculated monthly base, and the rest of the components will need to be defined based on their rules. I have just scratched the surface above, but I hope this is helpful and gave you some more understanding of the process!</P>Thu, 06 Jun 2019 11:28:44 GMTManuela_Apostol2019-06-06T11:28:44ZSalary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46779#M5818
<P>Hi,</P><P> </P><P>Can someone help me to understand the salary calculation, how it will calculated on the basis of merit increase% </P><P> </P><P>Thanks </P><P>Shweta</P>Thu, 06 Jun 2019 07:00:30 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46779#M5818Shweta2019-06-06T07:00:30ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46798#M5828
<P>Hi Shweta, </P><P> </P><P>The salary calculation is an interesting topic and at the same time quite different from company to company, and enev inside a company from country to country. Let me try to give you some general guidance</P><P> </P><P>Companies are analyzing salary by components such as Base salary, Social Charges, Health Insurance, Allowances, Other benefits, etc which all of those adds up in the Full Salary Package. To calculate those costs, which most of the time represent the biggest part of the P&L, is needed to understand <U>the way a salary is calculated</U>,<U> company policies and country-specific laws</U> (this is specified by the subject matter experts). Anaplan itself has a model on AppHub regarding Workforce Planning so you can check it out in order to get familiarised with how salary components are calculated.</P><P> </P><P>When calculating increases, there is quite some pre-word needed (workshops with the business) in order to get the correct salary base on which the increase is calculated. The starting point is what you take as a base: monthly or annual salary. Normally the base for increases does not include other salary components (e.g. allowances) so you need to ask to what base the increase is applied and whether other components of salary will be affected once with the salary rise (e.g social charges). </P><P> </P><P>Let’s suppose you want to calculate the salary increase for next year, and your base is the salary of this month. In this case, you need to calculate forward the base salary for your budget at the end of this year (usually what is the salary in Dec 2019) by including any potential increases happening this year, in order to get as close as possible to the base of next year, and use it in calculating <STRONG><U>monthly salary of Y+1, </U></STRONG>which is starting base for all the other components which depends on salary.</P><P> </P><P>After you get the correct monthly salary of Y+1 (which includes the increase) then all the other dependent components will be affected. How the salary should look like for a 1000£ monthly salary, supposing there is a 10% increase in June:</P><P> </P><TABLE><TBODY><TR><TD><P><FONT size="1 2 3 4 5 6 7">Jan 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Feb 201</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Mar 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Apr 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">May 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jun 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jul 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Aug 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Sep 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Oct 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Nov 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Dec 20</FONT></P></TD></TR><TR><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1000£</FONT></P></TD><TD><P><FONT face="arial black,avant garde"><STRONG><FONT size="1 2 3 4 5 6 7">1100£</FONT></STRONG></FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">1100£</FONT></P></TD></TR></TBODY></TABLE><P> </P><P>If<U> Social Charges</U> are calculated as a % of the monthly salary, then on the month of increase and months after, the social charges will also change. Based on example above, social charges will look like this (calculated as 15% of base):</P><P> </P><TABLE><TBODY><TR><TD><P><FONT size="1 2 3 4 5 6 7">Jan 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Feb 201</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Mar 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Apr 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">May 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jun 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Jul 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Aug 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Sep 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Oct 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Nov 20</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">Dec 20</FONT></P></TD></TR><TR><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><FONT size="1 2 3 4 5 6 7">150£</FONT></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><FONT size="1 2 3 4 5 6 7"><STRONG>165£</STRONG><BR /></FONT></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD><TD><P><STRONG><FONT size="1 2 3 4 5 6 7">165£</FONT></STRONG></P></TD></TR></TBODY></TABLE><P> </P><P>To wrap up and answer your question, the hardest part, in my opinion, is to get the salary increase calculation correct, and all the other components which depend on it will basically change according to the calculated monthly base, and the rest of the components will need to be defined based on their rules. I have just scratched the surface above, but I hope this is helpful and gave you some more understanding of the process!</P>Thu, 06 Jun 2019 11:28:44 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46798#M5828Manuela_Apostol2019-06-06T11:28:44ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46799#M5829
<P>Hi Manuela,</P><P> </P><P>Thank you for your quick response...</P><P> </P><P>The information you have provided me has resolved my so many doubts, which i am supposed to ask..</P><P>It actually cleared the calculation part, however i am going to take this logic for my model creation..</P><P> </P><P>will keep posted where ever i stuck again..</P><P> </P><P>Really appreciated <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P> </P><P>Shweta </P>Thu, 06 Jun 2019 11:44:53 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46799#M5829Shweta2019-06-06T11:44:53ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46802#M5830
<P>Best of luck! It is indeed an entire process and what matters the most is how it is defined!</P>Thu, 06 Jun 2019 12:28:01 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46802#M5830Manuela_Apostol2019-06-06T12:28:01ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46861#M5854
Thanks a lot Manuela! Great and detailed explanation <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>Fri, 07 Jun 2019 09:43:43 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46861#M5854Costa2019-06-07T09:43:43ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46931#M5870
<P>Hi,</P><P> </P><P>Sorry i am asking you a may be a silly question,</P><P> </P><P>Is merit increase% will effect salary?</P><P> </P><P>Reagrds:</P><P>Shweta</P>Mon, 10 Jun 2019 11:20:53 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46931#M5870Shweta2019-06-10T11:20:53ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46932#M5871
<P>HI <LI-USER uid="18170"></LI-USER> , </P><P> </P><P>merit increase it does affect the salary, and as explain above, the base salary and other components. </P><P> </P><P>Can you give, however, more details of your case, so I can better help?</P><P> </P><P>Thanks</P>Mon, 10 Jun 2019 11:41:38 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/46932#M5871Manuela_Apostol2019-06-10T11:41:38ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/47259#M5982
<P>Hi <LI-USER uid="18170"></LI-USER>,</P><P> </P><P>Has the answer helped you in solving your issue? </P><P>If so, can we close this topic or you have more questions? </P><P> </P><P>Cheers,</P><P>Manuela </P>Mon, 17 Jun 2019 14:16:16 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/47259#M5982Manuela_Apostol2019-06-17T14:16:16ZRe: Salary Calculations
https://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/47298#M5993
<P>Hi Manuela,</P><P> </P><P>Yes, the issue has been resolved you can close the topic..</P><P> </P><P>Thanks & Regards:</P><P>Shweta</P>Tue, 18 Jun 2019 05:46:06 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Salary-Calculations/m-p/47298#M5993Shweta2019-06-18T05:46:06Z