Question

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 .....
​

Answer 1

calculte the HRA as10/ of basic salary

Answer 2

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