S.no. Ename. HRA. DA. total sl
1. Ram
2. shyam
3. ibrar
4. satyendra
5. surendra
a. Calculate the HRA as 10% of Basic Salary.
b. DA is to be calculated as 6% of Basic Salary.
Calculate the total Salary.
d. Write the formula to find the average Salary.
please answer give me right
ata ha tab hi answer type karna please ok .....
Answers
calculte the HRA as10/ of basic salary
Given : HRA as 10% of Basic Salary.
DA as 6% of Basic Salary.
To Find : HRA , DA , Total Salary , Average Salary
Solution:
HRA = (10/100) Basic
DA = (6/100) Basic
Total Salary = Basic + HRA + DA
Average Salary = ( Sum of Total Salary of Each employee)/number of employees
S.no. Ename. Basic HRA. DA. Total sl
1. Ram B1 H1=(10/100)B1 D1=(6/100)B1 S1=B1+H1+D1
2. shyam B2 H2=(10/100)B2 D2=(6/100)B2 S2=B2+H2+D2
3. ibrar B3 H3=(10/100)B3 D3=(6/100)B3 S3=B3+H3+D3
4. satyendra B4 H4=(10/100)B4 D4=(6/100)B4 S4=B4+H4+D4
5. surendra B5 H5=(10/100)B5 D5=(6/100)B5 S5=B5+H5+D5
Average Salary = ( S1 + S2 + S3 + S4 + S5)/5
Learn More:
Difference between sorting and filtering in excel - Brainly.in
https://brainly.in/question/8773232
a) (1)Give answer using Excel formula/function on the following ...
https://brainly.in/question/13949918