Worksheet_Demographic Analysis

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Worksheet_Demographic Analysis

Date of Analysis: {{analysis_date}}

Prepared By: {{analyst_name}}

Department: {{department}}

Overall Workforce Summary

Total Number of Employees: {{total_employees}}

Full-time Employees: {{full_time_employees}}

Part-time Employees: {{part_time_employees}}

Contractors/Consultants: {{contractors_consultants}}

Demographic Breakdown by Age

Age Group 18-24: {{age_18_24_count}} ({{age_18_24_percentage}}%)

Age Group 25-34: {{age_25_34_count}} ({{age_25_34_percentage}}%)

Age Group 35-44: {{age_35_44_count}} ({{age_35_44_percentage}}%)

Age Group 45-54: {{age_45_54_count}} ({{age_45_54_percentage}}%)

Age Group 55-64: {{age_55_64_count}} ({{age_55_64_percentage}}%)

Age Group 65+: {{age_65_plus_count}} ({{age_65_plus_percentage}}%)

Average Age: {{average_age}}

Median Age: {{median_age}}

Demographic Breakdown by Gender

Female Employees: {{female_employees_count}} ({{female_employees_percentage}}%)

Male Employees: {{male_employees_count}} ({{male_employees_percentage}}%)

Non-binary/Other Employees: {{non_binary_employees_count}} ({{non_binary_employees_percentage}}%)

Demographic Breakdown by Tenure

Less than 1 year: {{tenure_less_1_count}} ({{tenure_less_1_percentage}}%)

1-3 years: {{tenure_1_3_count}} ({{tenure_1_3_percentage}}%)

4-6 years: {{tenure_4_6_count}} ({{tenure_4_6_percentage}}%)

7-10 years: {{tenure_7_10_count}} ({{tenure_7_10_percentage}}%)

More than 10 years: {{tenure_over_10_count}} ({{tenure_over_10_percentage}}%)

Average Tenure: {{average_tenure}} years

Demographic Breakdown by Department/Division

Department 1 ({{department_1_name}}): {{department_1_count}} employees ({{department_1_percentage}}%)

Department 2 ({{department_2_name}}): {{department_2_count}} employees ({{department_2_percentage}}%)

Department 3 ({{department_3_name}}): {{department_3_count}} employees ({{department_3_percentage}}%)

Department 4 ({{department_4_name}}): {{department_4_count}} employees ({{department_4_percentage}}%)

Department 5 ({{department_5_name}}): {{department_5_count}} employees ({{department_5_percentage}}%)

Other Departments: {{other_departments_count}} employees ({{other_departments_percentage}}%)

Diversity and Inclusion Metrics (Optional)

Ethnic/Racial Background: (Breakdown as per company policy and legal guidelines - e.g., {{ethnicity_group_1}}: {{ethnicity_group_1_count}})

Disability Status: Employees with disabilities - {{disability_count}} ({{disability_percentage}}%)

Veterans: {{veteran_count}} ({{veteran_percentage}}%)

Analysis and Key Findings

Key demographic trends identified: {{key_trends}}

Potential areas for improvement in diversity and inclusion: {{areas_for_improvement}}

Recommendations for HR strategy: {{recommendations}}

Signature Block

________________________

{{analyst_name}}

{{analyst_title}}

{{date}}