Create a payroll sheet in which basic pay of 20 employees is given.You have to calculate DA,HRA.CCA and gross pay of each employee using the formulas with the following conditions:
a) HRA is 50% of Basic pay and CCA is 15% of Basic pay.
b) The rates of DA for different levels of Basic pay are given in cells G to I as
G H I
1 Lower Limit Upper limit DA rate
2 0 6000 0.28
3 6001 12000 0.25
4 12001 & above 0.20
You have to ensure that DA amount paid to an employee with lower basic pay should not exceed the DA paid to an employee with higher basic pay.
This condition is making it hard.My term exams are banging on the door and this making me sick.Help me out.
a) HRA is 50% of Basic pay and CCA is 15% of Basic pay.
b) The rates of DA for different levels of Basic pay are given in cells G to I as
G H I
1 Lower Limit Upper limit DA rate
2 0 6000 0.28
3 6001 12000 0.25
4 12001 & above 0.20
You have to ensure that DA amount paid to an employee with lower basic pay should not exceed the DA paid to an employee with higher basic pay.
This condition is making it hard.My term exams are banging on the door and this making me sick.Help me out.
