Indian Payroll Video 5
Enter 5 dummy employees with CTC, allowances, and perks.Calculate gross salary, taxable income, TDS, and net pay.Generate a sample payroll register.
Task
Design a salary breakup for a ₹10 LPA CTC, including allowances: HRA, DA, LTA, Medical, Conveyance.
Task
For an employee earning ₹30,000 Basic, paying ₹15,000 rent in Bangalore, calculate HRA exemption.
Task
Calculate the basic salary for a CTC of ₹6,00,000 per annum
Task
Prepare a Factories Act compliance checklist with 10 key requirements (health, safety, welfare, registers). Task 2 – Audit Simulation Choose one HR law (e.g., Payment of Wages, PF, or Maternity Benefit). Conduct a mini-audit: check compliance points, identify gaps, and propose corrections.
Task
Import a dataset of 30 employees (dummy HR data – Name, Department, DOJ, Salary, Attrition status).Create a Power BI dashboard with visuals showing:Attrition by department,Gender diversity,Average salary by role.Add at least two slicers (e.g., by Department, by Gender)
Task
Build an Excel dashboard for 20 employees, showing:Recruitment source mix,Offer-to-join ratio,Attrition rate,Average training hours.Use at least one formula (COUNTIF/AVERAGEIF) and one chart
Task
Task 1 – Audit Checklist Creation
Task
Write a JD for “Marketing Manager – SaaS Industry” and suggest 3 suitable job posting platforms.
Task
Task 1 – Manpower Forecasting Your company currently employs 100 sales executives. Based on business expansion, sales are expected to grow 20% next year. Estimate how many additional sales executives you will need using ratio-trend analysis. Task 2 – Recruitment Tracker Creation Build a Recruitment Tracker in Excel with the following columns: Requisition ID, Position, […]