MGMT$8520$

Human Resources Data Analytics

ASSIGNMENT $1$: Employment Capital Cost and Value HR Metrics

OBECTIVE

The objective of this assignment is to determine the financial contribution of our workforce to the company's profitability. You will use key employment metrics to achieve this goal, enhancing your understanding of HR$\text{'}$s impact on a company's financial position. You may complete this assignment individually or in teams of two $(2),$ e$.$g$.,(1+1,3-1,4-2,13-11,427,036-427,034,$ etc.$)$

TASES

This assignment consists of four main questions, which require data analysis in Excel, including performing calculations to answer these questions. Additionally, you will create a $3-$slide PowerPoint presentation to synthesize your findings. Focus on concise communication by limiting your presentation to three slides. Think in terms of solutions. Ask yourself: What does the management team need to know?

CASE SCENARIO

You are an HR professional at Headgames inc, a manufacturer of helmet inserts. After six months in your role, the CEO, John Daily, questions you about the total cost of the workforce and its contribution to the compary's revenue. To address his concerns, you will perform a series of calculations to present at the next manager meeting.

DATA CLEANING TIP: Before using ary rumbels, use the Excel uNiouE function to verify that the key columns have correct values, eliminating any unexpected values. This step is part of the data cleaning process, which should be performed on all data befiore analysis.

CALCULATIONS

Using the provided Employees Database for HCVA $-$ Assignment $1-$ ACTUALxisx workbook and the Employee Data worksheet, calculate the HCVA $($Human Capital value Added$)$ and the HCROI $($Human Capital Raturn on Investment$)$ using the formulas supplied below.

a$.$ HC$.$A formula: HCVA $=($Operating Profit $+$ Employment cost