Dear all,
I want to know how to calculate VDA in West Bengal. If anyone can share an Excel calculation sheet with the procedure, that would be great. This will help us to get a clear knowledge of VDA Calculation.
Kindly help.
Warm Regards,
Shibaji Banerjee
From India, Bhubaneswar
Acknowledge(0)
Amend(0)
I want to know how to calculate VDA in West Bengal. If anyone can share an Excel calculation sheet with the procedure, that would be great. This will help us to get a clear knowledge of VDA Calculation.
Kindly help.
Warm Regards,
Shibaji Banerjee
From India, Bhubaneswar
Acknowledge(0)Amend(0)
Dear Shibaji Banerjee,
VDA, or Variable Dearness Allowance, is a key component of salary in India. It adjusts the basic wage to inflation or deflation. VDA depends on the Consumer Price Index (CPI) and varies from state to state. In West Bengal, it's calculated quarterly based on the Average Consumer Price Index for industrial workers.
Here's a simplified step-by-step guide to calculate VDA:
1. 👍 Get the average CPI for the relevant quarter from the Labour Bureau website.
2. 👍 Subtract the base CPI (which is 6357 for West Bengal) from the average CPI.
3. 👍 The result is the 'CPI Increase'.
4. 👍 Now, divide the 'CPI Increase' by the base CPI and multiply by 100. This gives you the 'Percentage Increase'.
5. 👍 Finally, multiply the 'Percentage Increase' by the Basic Wage. This gives you the VDA.
Unfortunately, I can't provide an Excel sheet here, but you can easily create one based on these steps.
Remember, VDA changes every quarter, and you need to recalculate it. Also, please note that the base CPI can change as per government notifications, so always check the most recent figure.
Please ensure you comply with the Minimum Wages Act, 1948, which mandates the payment of VDA to certain categories of workers.
I hope this helps! If you have more queries, feel free to ask.
Regards, [Your Name]
From India, Gurugram
Acknowledge(0)Amend(0)
26VDA, or Variable Dearness Allowance, is a key component of salary in India. It adjusts the basic wage to inflation or deflation. VDA depends on the Consumer Price Index (CPI) and varies from state to state. In West Bengal, it's calculated quarterly based on the Average Consumer Price Index for industrial workers.
Here's a simplified step-by-step guide to calculate VDA:
1. 👍 Get the average CPI for the relevant quarter from the Labour Bureau website.
2. 👍 Subtract the base CPI (which is 6357 for West Bengal) from the average CPI.
3. 👍 The result is the 'CPI Increase'.
4. 👍 Now, divide the 'CPI Increase' by the base CPI and multiply by 100. This gives you the 'Percentage Increase'.
5. 👍 Finally, multiply the 'Percentage Increase' by the Basic Wage. This gives you the VDA.
Unfortunately, I can't provide an Excel sheet here, but you can easily create one based on these steps.
Remember, VDA changes every quarter, and you need to recalculate it. Also, please note that the base CPI can change as per government notifications, so always check the most recent figure.
Please ensure you comply with the Minimum Wages Act, 1948, which mandates the payment of VDA to certain categories of workers.
I hope this helps! If you have more queries, feel free to ask.
Regards, [Your Name]
From India, Gurugram
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.
Share saving calculation.xls
MW - VDA - April '16 - March '17.pdf