Akhil.Gupta
Hr Professional With 8 Years Of Exp.
Jkct15
Deputy Manager - Hr
+2 Others

Dear All,
Could you please help me confirm on the following calculations and let me know the results so that I could confirm if I had done it right.
Fixed Variable
A 6,00,000 60,000
B 6,70,000 67,000

Point 1- Apply a overall 5% increment to both A & B

Point 2- Calcualte the arrears from 20-aug-13 till 31-Dec-13 for A
Calculate the Arrears from 15-Oct-13 till 31-Dec-13 for B
Cite.Co is a repository of information created by your industry peers and experienced seniors made possible with help from our prime sponsors like:

TALENTEDGE Who provide a platform for "interactive anywhere learning". Courses from top reputed institutes like IIM, XLRI, MICA. View Courses

FACTOHR - Provides Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS that can help streamline your organisation. Explore Features

Register Here and help by adding your inputs. Contributions From Other Members Follow Below...
HI Your statement is not clear. Could you make it more elaborate as the statement/number given is vague (A 6,00,000 60,000 B 6,70,000 67,000 ).
Hello Christopher ,
here are the details:-
Fixed Salary Bonus Total CTC (Fixed Salary + Bonus ) Arrear Calculation date
Person A 6,00,000 60,000 6,60,000 20-Aug-13
Person B 6,70,000 67,000 6,67,000 15-Oct-13
Now I would like to confirm on the following:-
1) If a overall 5% increment applicable to both A & B what the amount will be.
2) If we are giving both of them a increment in Dec'13 then please let me know the amount of arrears for both of them from their Arrear Calculation date.
I hope I am able to present the facts in a better way now.
Eagerly waiting for your response
Guess the formatting is not working well here so I am writing it all again.
Hello Christopher ,
here are the details:-

Person A
Fixed Salary :
6,00,000
Bonus:
60,000
Total CTC (Fixed Salary + Bonus ):
6,60,000
Arrear Calculation date:
20-Aug-13
Person B
Fixed Salary :
6,70,000
Bonus:
67,000
Total CTC (Fixed Salary + Bonus ):
6,67,000
Arrear Calculation date:
15-Oct-13
Now I would like to confirm on the following:-
1) If a overall 5% increment applicable to both A & B what the amount will be.
2) If we are giving both of them a increment in Dec'13 then please let me know the amount of arrears for both of them from their Arrear Calculation date.
I hope I am able to present the facts in a better way now.
Eagerly waiting for your response
attribution https://www.citehr.com/479032-calcul...#ixzz2ndIyNFvb
Hi attaching the sheet for your reference. Do let me know whether it suffice your request or will work again and forward it to you.
Hi, Attaching sheet for your ready reference, go through it and share your view ....

Attached Files
Membership is required for download. Create An Account First
File Type: xls Increment.xls (17.0 KB, 1657 views)

Hi Christopher, I didn’t found any file attached. Please if you could attach again.
HI Attaching the workings for your reference. Please do let me know whether this address your query.

Attached Files
Membership is required for download. Create An Account First
File Type: xls arrears.xls (21.5 KB, 1810 views)

Dear Mr. Akhil,
Thank you very much for sharing the details however I am not sure if arrears for 4 months and 12 days could reach in lacs / thousands. Also if you could let me know if we have to calculate arrears only for the fixed salary then what it would be.
in my first attachment, calculation is based on assuming monthly salary as 6 L or 6.7 L. now i am attaching sheet according to your requirement as 6 L and 6.7 L as yearly salary.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Increment.xls (17.5 KB, 604 views)

Thank You Mr. Akhil , Also could you please let me know that if the increment is given in Dec'13 so the arrear in the given case mentioned above will be calculated from Aug till Nov'13 OR Dec will also be calculated for Arrear calculation for Person A and similarly for Person B arrear calculation will be done for Oct & Nov OR Dec will also be included for the calculation.
Dear Friend , Please find attached the Salary Arrears Calculation Sheet. Hope the calculations solves your problem.

Attached Files
Membership is required for download. Create An Account First
File Type: xls Arrear Calculation Solution.xls (21.5 KB, 691 views)

Odisha Govt 7th pay arr Salary Xls
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™