HR Planning & Inventory: Forecasting, Inventory, and HRIS

TAKEAWAYS:

• HR planning ensures the right people are available at the right time by matching demand (future needs) with supply (current workforce).
• HR inventory tracks employee skills, experience, and potential to fill future roles—critical for succession planning.
• HRIS (Human Resource Information Systems) automates data collection, analysis, and reporting (e.g., Ncell’s employee database).
• Replacement charts and skills matrices help identify high-potential employees for leadership roles (used in Nepal Rastra Bank).
• Workforce forecasting uses quantitative (statistical trends) and qualitative (expert judgment) methods.
• Inventory gaps (skills shortages/surpluses) trigger recruitment, training, or layoffs—seen in Daraz’s seasonal hiring.

1. Human Resource Planning: The Foundation

Human Resource (HR) planning is the process of anticipating and meeting an organization’s future human resource needs. It aligns workforce capabilities with business goals, ensuring no shortages or surpluses of talent.

Why is HR Planning Critical?

• Cost-effective: Avoids over-hiring (wasted salaries) or under-hiring (lost productivity).
• Strategic alignment: Supports company growth (e.g., Nepal Investment Bank’s expansion).
• Legal compliance: Meets labor laws (e.g., Nepal’s Labor Act 2017 on minimum staffing).
• Talent retention: Identifies future leaders early (e.g., Nabil Bank’s leadership pipeline).

Key Steps in HR Planning

flowchart TD
    A["1. Analyze Current Workforce"] --> B["2. Forecast Future Needs"]
    B --> C["3. Determine Supply/Demand Gap"]
    C --> D["4. Develop Action Plan"]
    D --> E["5. Implement & Monitor"]

A. Analyzing the Current Workforce

• HR Inventory: A snapshot of employees’ skills, experience, and potential.
  • Example: Daraz’s HR inventory tracks warehouse staff’s proficiency in inventory management.
• Workforce Audit: Reviews demographics (age, tenure), skills, and performance.
  • Worked Example:

    Category	Nabil Bank (2023)	Daraz (2023)
    Average Age	35 years	28 years
    Tenure	8 years	3 years
    Critical Skills	Risk management, IT	Logistics, digital marketing
    Gender Ratio	60% Male, 40% Female	55% Male, 45% Female

B. Forecasting Future Needs

Two methods:

1. Quantitative (Statistical)
   • Trend Analysis: Extends past hiring patterns (e.g., NTC’s seasonal hiring for monsoon repairs).
   • Ratio Analysis: Uses business metrics (e.g., sales per employee in Himalayan Java).
   • Workload Analysis: Estimates staff needed for new projects (e.g., Nepal Rastra Bank’s digital banking rollout).
2. Qualitative (Judgmental)
   • Delphi Technique: Experts (HR, managers) predict needs (used in Chaudhary Group’s expansion).
   • Management Judgment: Top leaders estimate requirements (e.g., Pathao’s driver hiring).

Worked Example: Nepal Investment Bank forecasts a 20% increase in loan officers by 2025 due to rising mortgage demand.

• Current staff: 50 loan officers
• Projected loans: +30% → 65 officers needed
• Action: Hire 15 new officers or upskill 10 existing staff.

C. Supply vs. Demand Gap

• Gap Analysis: Compares current supply (skills, numbers) with future demand.
  • Surplus: Too many employees (→ layoffs, retraining).
  • Shortage: Not enough skills (→ recruitment, training).
• Example:
  • NTC faces a shortage of IT specialists for smart meter projects → partners with TU for internships.

D. Action Plan & Implementation

• Recruitment: Fill shortages (e.g., Daraz hires 500 seasonal staff for Dashain sales).
• Training: Upskill employees (e.g., Nabil Bank trains tellers in digital banking).
• Succession Planning: Prepare replacements (e.g., Nepal Rastra Bank’s deputy governor pipeline).
• Outplacement: Manage surpluses (e.g., retiring NTC engineers).

2. HR Inventory: Tracking the Workforce

HR inventory is a database of employee skills, experience, and potential, used for planning, development, and succession.

Components of HR Inventory

mindmap
  root((HR Inventory))
    Skills["Technical (IT, Finance) & Soft (Leadership, Communication)"]
    Experience["Years in Role, Projects Led"]
    Education["Degrees, Certifications"]
    Performance["Appraisal Ratings, Promotions"]
    Potential["High/Medium/Low Potential for Leadership"]
    Demographics["Age, Gender, Tenure"]

How HR Inventory Works

1. Data Collection: Surveys, performance reviews, and HRIS (e.g., Ncell’s employee portal).
2. Analysis: Identifies skills gaps and high-potential employees.
3. Action:
   • Training for gaps (e.g., Nepal Bankers’ Association upskills staff in fintech).
   • Succession planning (e.g., Nabil Bank’s "Fast Track" program for high potentials).

Worked Example: Nepal Rastra Bank’s HR Inventory (2023)

• Findings:
  • 30% of auditors lack data analytics skills.
  • 5 high-potential managers identified for deputy governor roles.
• Actions:
  • Training: 6-month data analytics course for auditors.
  • Succession Plan: Fast-track the 5 managers for leadership roles.

HR Inventory vs. HRIS

3. Human Resource Information Systems (HRIS)

HRIS is software that automates HR tasks like recruitment, payroll, and performance tracking. Nepal’s banks and telecoms (Ncell, NTC) use HRIS for efficiency.

Key Functions of HRIS

flowchart TD
    A["HRIS Core Functions"] --> B["1. Recruitment & Applicant Tracking"]
    A --> C["2. Payroll & Benefits Management"]
    A --> D["3. Performance Appraisal"]
    A --> E["4. Training & Development"]
    A --> F["5. HR Analytics & Reporting"]

How HRIS Supports HR Planning

1. Demand Forecasting: Predicts hiring needs (e.g., Daraz’s seasonal staffing).
2. Supply Analysis: Tracks employee attrition (e.g., NTC’s engineer turnover).
3. Skills Gap Analysis: Identifies training needs (e.g., Nepal Investment Bank’s fintech skills).
4. Succession Planning: Flags high-potential employees (e.g., Nabil Bank’s leadership pipeline).

Worked Example: Ncell’s HRIS (Workday)

• Problem: High turnover in customer service roles.
• HRIS Insight:
  • 60% of reps leave within 2 years.
  • Lowest satisfaction in "career growth" surveys.
• Action:
  • Training: Certified customer service managers.
  • Promotion Path: Created supervisor roles to retain talent.

4. Succession Planning & Replacement Charts

Succession planning ensures critical roles are filled internally when leaders leave.

Replacement Charts

A visual tool showing who replaces whom in key positions.

graph TD
    subgraph CEO["CEO - Mr. ABC"]
    subgraph MD["Managing Director - Ms. XYZ"]
    subgraph CFO["CFO - Mr. PQR"]
    subgraph HRD["HR Director - Ms. LMN"]
    end
    MD -->|"Succession"| CFO
    CFO -->|"Backup"| HRD
    HRD -->|"Succession"| Ms. STU["Ms. STU (High Potential)"]

Steps in Succession Planning

1. Identify Critical Roles: CEO, CFO, department heads (e.g., Nepal Rastra Bank’s board members).
2. Assess Internal Talent: Who has skills and potential?
3. Develop a Plan:
   • Fast-track training (e.g., Nabil Bank’s leadership program).
   • Mentorship (e.g., Chaudhary Group’s CEO mentoring heirs).
4. Monitor & Update: Review annually (e.g., NTC’s leadership reviews).

Worked Example: Nepal Investment Bank’s Succession Plan

• Critical Role: Chief Risk Officer (CRO)
• Current CRO: 58 years old (retiring in 2 years).
• Internal Candidate: Ms. R. Sharma (42), currently Deputy CRO.
  • Gaps: Needs advanced risk modeling training.
• Action Plan:
  • 1-year certification in financial risk management.
  • Shadowing the current CRO for 6 months.

5. Emerging Issues in HR Planning

Modern HR planning faces new challenges:

1. AI & Automation
   • Impact: Reduces need for routine jobs (e.g., Khalti’s chatbot replacing customer service reps).
   • Solution: Upskill workers in AI tools (e.g., Nepal Bankers’ Association’s digital training).
2. Remote & Hybrid Work
   • Impact: Global talent pools but harder to manage (e.g., Daraz’s remote warehouse coordinators).
   • Solution: Flexible HR policies (e.g., Ncell’s work-from-home guidelines).
3. Gig Economy
   • Impact: Short-term staffing (e.g., Pathao’s driver partners).
   • Solution: Contract management systems in HRIS.
4. Diversity & Inclusion
   • Impact: Bias in promotions (e.g., Nepal’s male-dominated banking sector).
   • Solution: Blind recruitment, diversity quotas (e.g., Nabil Bank’s 30% female leadership target).
5. Data Privacy & Ethics
   • Impact: HRIS stores sensitive data (e.g., Nepal’s labor laws on employee records).
   • Solution: GDPR-like policies (e.g., Nepal Investment Bank’s data protection training).

In the Real World

1. Nabil Bank’s HR Planning

   • Idea Used: Succession planning & HRIS
   • How: Uses SAP HRIS to track 200+ employees’ skills and identifies 10 high-potential managers for board roles annually.
   • Result: Zero leadership gaps in the last 5 years.

2. Daraz’s Seasonal Hiring

   • Idea Used: Workforce forecasting
   • How: Uses past sales data to predict 500+ seasonal staff for Dashain sales (Oct-Nov).
   • Tool: Excel + manual tracking (due to budget constraints).

3. Nepal Rastra Bank’s Fintech Upskilling

   • Idea Used: Skills gap analysis
   • How: Found 40% of staff lacked digital banking skills → partnered with TU for certifications.
   • Result: Reduced IT dependency by 30%.

4. Pathao’s Driver Management

   • Idea Used: HR inventory for gig workers
   • How: Tracks driver ratings, availability, and complaints to optimize fleet.
   • Tool: Custom HRIS integrated with ride-hailing app.

5. NTC’s Engineer Retirement Crisis

   • Idea Used: Replacement charts
   • How: 30% of engineers retire in 3 years → fast-tracked 15 junior engineers for promotions.
   • Result: No service disruptions during monsoon repairs.

Exam Tip

This unit is highly practical—expect:

1. Definitions & Differences

   • Example Question: "Distinguish between HR inventory and HRIS."
   • Answer Tip: Use the comparison table above (HR Inventory = manual skills data; HRIS = automated system).

2. Worked Examples

   • Example Question: "Calculate the number of new hires needed if Nabil Bank expects 20% growth in loans and currently has 50 loan officers."
   • Answer Tip:
     • Current staff: 50
     • Growth: 20% → 60 officers needed
     • New hires: 10 (60 - 50).

3. Case Study Applications

   • Example Question: "How would you apply HR planning to reduce turnover in NTC?"
   • Answer Tip:
     • Step 1: Conduct HR inventory → Find high attrition in IT roles.
     • Step 2: Use HRIS to analyze exit surveys → Low career growth.
     • Step 3: Action Plan:
       • Promotion path for IT staff.
       • Partner with TU for certifications.

4. Diagrams & Flowcharts

   • Example Question: "Draw a replacement chart for a company’s CEO, MD, and CFO."
   • Answer Tip: Use the Mermaid graph above as a template.

5. Real-World Links

   • Example Question: "How does Daraz use HR planning?"
   • Answer Tip: Mention seasonal hiring forecasts and Excel-based tracking.

Final Advice:

• Memorize the 5 steps of HR planning (Analyze → Forecast → Gap → Action → Monitor).
• Practice calculations (e.g., hiring needs, turnover rates).
• Relate to Nepali companies (Nabil Bank, NTC, Daraz) for case study questions.