Design the worksheet as shown and answer the following question
E3
f
E
Total Salary
HRA
TA
1
Emp ID
Name
2 10488149 Ayush
3 10488167 Simram
4 10488151 Geetli
5 10488142 Mitali
6
10488175 Aarush
C с
D
Salary
DA
11500
9600
10700
12750
11050
a.
b.
C.
Calculate the DA of all the employees as 10% of their salary.
Calculate the TA of all the employees as 15% of their salary.
Calculate the HRA of all the employees as 25% of their salary.
Calculate the Total Salary by using the formula Salary+DA+TA+HRA.
Find the maximum, minimum, and average salaries being dispensed by this company.
d.
e.
F.
Employee getting the least salary must receive Rs.500 as bonus. Find the Total Salary of this employee.
Answers
Answered by
1
Answer:
500 is the correct answer
Explanation:
hope it's helps you happy teddy day
Similar questions