Calculations Of Arrear Query - Xls Download - CiteHR
Akhil.Gupta
Hr Professional With 8 Years Of Exp.
Jkct15
Deputy Manager - Hr
+1 Other

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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

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, 1660 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, 1815 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, 605 views)


This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™