HR Essential Video 8
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
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, […]
Task
Task 1 – Boolean String Building Write 3 Boolean strings to find candidates for the following roles: Java Developer in Bangalore Data Analyst with SQL and Tableau HR Recruiter (exclude “intern”) Task 2 – X-Ray Search Practice Perform a Google X-Ray search for LinkedIn profiles of “Digital Marketing Managers” in Delhi. Submit the search string […]
Task
Draft an onboarding journey map for a new employee in your organization (or a hypothetical one). Include pre-boarding → first day → first week → first 30/90 days. Indicate key milestones, stakeholders (HR, manager, buddy, IT, etc.), communication points, and engagement activities.Create a short pulse survey (5–7 questions) to gauge early satisfaction & sentiment of […]
Task
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.