Employee Payroll Table in Ms-Excel

In this video we can discuss about Employee Payroll Table in Excel

Ex Problem:-

Take Employee Number=012025
Name= K. Kishore
Basic=8650/-

Then find the following calculations 

1. HRA is 13.7% on Basic =? 

2. TA is 8.3% on basic =?
3. DA is 6.2% on basic =?
4. MA is 16.2% on basic =?
5. Allowances =? (HRA + TA+DA+MA)
6. Gross =? (Basic + Allowances)
7. IT is 2.7% on Gross =?
8. PF is 3.2% on Gross =?
9. LIC is 1.6% on Gross =?
10. Deductions =? (IT+PF+LIC)
11. Net Salary =? (Gross – Deductions)