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

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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

From India, New Delhi
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

From India, New Delhi
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

From India, New Delhi
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 ....
From India, Kota

Attached Files
File Type: xls Increment.xls (17.0 KB, 1716 views)

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


Attached Files
File Type: xls arrears.xls (21.5 KB, 1859 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.

From India, New Delhi
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.
From India, Kota

Attached Files
File Type: xls Increment.xls (17.5 KB, 617 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™