How to calculate dearness allowance(DA) - excel formula Pdf Download Page 2
 .subbutton {border: none; overflow: hidden;cursor:hand;} HOME RISE NEW TEAM →|
malikjs -  Member Since: Nov 2007
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

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

rradhika -  Member Since: Jan 2008
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 -  Member Since: Jan 2008
Hi, Can any one help me to get a excel formula for calculating DA as per the latest and current trend? Thanx

milli.cool -  Member Since: Jul 2008
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

vishalharjani27 -  Member Since: Sep 2009
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 -  Member Since: Apr 2009
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,

rajnarayanan -  Member Since: Dec 2009
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

praveshshukla -  Member Since: Nov 2008
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 -  Member Since: Aug 2009
hey, jus find the attachment here...may be of some use to you. regards, priyanka:)

 DA.pdf (270.5 KB, 880 views)

POSTING RULES OF CONDUCT
• Do not post anything derogatory about any company or person.
• Sharing articles from other websites should be done by posting a link to the original article.
• To discuss sensitive issues create a pseudo/anonymous account.
• Please avoid repeat posting your company profile - such accounts are removed automatically.
• Viewing - Page 2 - Review Discussion Topic

Found This Useful? +Vote Up This Via Google.

Why Vote? User validation is extremely important for good content to prosper.
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.

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

Share »

Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Community Support & Professional Insights. Login or Register.