Feeling Shortchanged? Help Needed to Understand My Revised Salary and Benefits

Dear Readers & Experts,

I am working in an MNC in Baroda (as an Implant at the customer's plant).

I need your suggestions and help in my salary revision matter.

My salary increment was done in April 2010 after a long period of 2 years, with a rise in Basic of Rs. 836 per month. But I requested a revision and asked for a hike to our Branch Manager.

The customer has instructed my branch manager to set my net salary at Rs. 12,000 with all other benefits remaining the same.

Today, I received my revised salary statement showing a CTC comparison with the old CTC to the latest (today's) CTC.

Attached file for your better understanding.

Can you please help me calculate the actual revision figure and what the actual benefit in net salary is? There are some questions in the Excel sheet too if you can sort them out for me.

Thanks & Regards,
RajVeer.

Calculating Revised Salary Figures and Net Benefits

To calculate the actual revision figure and understand the net benefit in your salary, you can follow these steps:

1. Review the Salary Statement: Start by carefully examining the revised salary statement provided to you. Identify the components such as basic salary, allowances, deductions, and any new benefits included in the updated structure.

2. Understand the Changes: Compare the old salary structure with the new one to pinpoint the specific adjustments made. Pay close attention to any changes in the basic salary, allowances, or deductions mentioned in the statement.

3. Calculate the Actual Revision Figure: To determine the actual revision figure, subtract the old CTC from the new CTC. This will give you the total amount of change in your overall compensation package.

4. Analyze the Net Salary Impact: Calculate the difference between your previous net salary and the new net salary after the revision. This will help you understand the direct impact of the changes on your take-home pay.

5. Consider Total Compensation: While focusing on the net salary is essential, also take into account any additional benefits or perks that may have been adjusted as part of the revision. Evaluate how these changes contribute to your overall compensation package.

6. Seek Clarifications: If there are any discrepancies or unclear points in the salary statement, don't hesitate to seek clarification from your HR department or the relevant authority responsible for the revision.

By following these steps, you can gain a clearer understanding of the revised salary structure and assess the actual benefits or drawbacks in terms of your total compensation. If you encounter any specific questions in the attached Excel sheet, feel free to provide details for further assistance.