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)