How to calculate dearness allowance(DA) - excel formula Pdf Download Page 2
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

how to calculate dearness allowance(DA) - Page 2

malikjs - Senior Member
dear all
i have gone all posts given by friends but most of us donot have idea of DA or VDA.
Basically in private sector we call it VDA and govt sector it is call it DA.
VDA it is basically varaible and it is not at all percentage based as mentioned by our few friends.it is calculated on the basis of all india conumer price index.
now i will explain with example of utter pradesh because it varies state to state.
in U P we check and change VDA in twice a year ie in oct and apr.
EXAMPLE OF U.P.
-------------------
U.P. govt with their notification dated 24 th feb 2006 fixed basic of all category of workers on average price index 522 and these rates were as given below
unslikked-Rs 2600
semiskilled-Rs2964
skelled--rs 3290
mind it it was basic and no vDA that time now VDA will change every year in the month of oct and apr.
now in oct 2008 rates of minimum wages were as given below

BASIC VDA TOTAL
UNSKILLED 2600 562.83 3163
SEMI-SKILL 2964 641.63 3606 (IN ROUND FIGURE)
SKILLED 3290 712 4202

now VDA has to increase wef 01 apr 2009.for that we have to find out the average of all india price index from jan 2008 to june 2008.

ALL INDIA CONSUMER PRICE INDEX
JAN2008 662
FEB2008 671
MAR2008 676
APR2008 685
MAY2008 685
JUN2008 681
--------
TOTAL 4060
NOW WE HAVE TO DIVDE 4060 BY 6 TO GET AVERAGE WHICH COMES TO 676.67
SAY 677
NOW WE CAN CALCULATE VDA WEF 01 APR 2009

UNSKILLED------(677-522 )*2600
----------------- = 772.03
522
NOW MINIMUM WAGES for unskilled is 2600+772.03=3373

SEMISKILLED-----(677-522)*2964
------------------ =880.11
522
NOW MINIMUM WAGES FOR SEMI SKILLED IS 2964+880.11=3845

SKILLED----------(677-522)*3290
------------- =976.92
522
NOW WAGES FOR SKILLED IS 3290+976.92=4267
this is how we calculate VDA
tks
j s malik

mam i didnot get clearly idea about your calculation formula of DA. So please explane in easy way of formula.. plea..........se:-?

rradhika - 
Dear Sudipta i am not able to understand the DA calculation., can u please explain in briefly. with step bu step calculations Regards Rajendra

mham07 - Contributing Member
Hi, Can any one help me to get a excel formula for calculating DA as per the latest and current trend? Thanx

milli.cool - 
hey all, could u plse let me know what is the imp of D.A in salalry slip, and how can we calculate this.. plz help me

Sir, I want to know that what is the procedure of calculating DA in industries. Please povide me the format with percentages. Please clarify the same by showing an example. Regards Vishal Harjani

tssank - 
Dear Friends, I want to know the exact method of calculating the DA. I have gone through the pay commission still i need better clarity Regards,

Dear to all

As per act coverage will be 20 or more employees for PF Contribution. Presently if the strength is below 20 it is possible for applying PF Contribution or not required.

Thanks

Raj Narayanan

Dear all can any one please explain me the meaning of Compensation & Benefits Administration and how is it done? My email id is praveshshukla@rediffmail.com pravesh.shukla@ymail.com

pinks_rk - Contributing Member
hey, jus find the attachment here...may be of some use to you. regards, priyanka:)


Attached FilesProvided by community member pinks_rk. Join us to learn and grow with your peers.
File Type: pdf DA.pdf (270.5 KB, 840 views)
Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Viewing - Page 2 - Review Discussion Topic


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
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.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


6
LIKES

23498
VIEWS

23
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network