User Account

All Pages

Calculate the hcva and hcroi

Assignment Help HR Management
Reference no: EM133027425

BACKGROUND

Every Monday morning your company has a manager meeting to discuss ongoing issues and the upcoming week. You have been in the HR position at Headgames Inc. (a manufacturer of inserts for all kinds of helmets) for six months, and you are starting to feel comfortable about your role in the company. Benefits, compensation, job descriptions, all these core HR features are your comfort zone. But when the CEO, John Daily, asked you a couple of pointed questions around human resources, you were stumped. And everyone else in the boardroom knew it. Profits were down, and mangers were looking for ways to cut costs or to improve the revenue on products, and that's when John Daily turned to you and asked: "What is the total cost of our workforce and how does it contribute to our revenues?"

There were many things you were investigating from an HR perspective, but this wasn't one of them. You flipped through your notes, checked the company intranet on your laptop, and then said: "Sorry, John, I will have to get back to you with those numbers."

John said: "If we don't know what our workforce costs us, how do we know what to price our services at for better revenue?"

The redness you felt in your face was something you never wanted to experience again.

Back in your office you got to work on calculating the required metrics for next week's meeting.

CALCULATIONS

  1. Using the workbook EMPLOYEES, and the Employees worksheet, calculate the HCVA (Human Capital Value Added) and the HCROI (Human Capital Return on Investment) using the formulas supplied below.
    1. The formula for HCVA is: HCVA=Operating Profit+Employment CostFTEHCVA=Operating Profit+Employment CostFTE.
      • Operating Profit is in the tab labelled: Operating Profit.
      • Employment Costs = Pay + Benefits
      • FTE stands for average number of full-time employees (or full-time equivalents). In other words, if a company has 9 full-time employees and 2 part-time employees who work half days, then FTE would be equal to 9 + 0.5 + 0.5.
    2. The formula for HCROI is: Revenue-(Costs-(Compensation+Benefits))Compensation+BenefitsRevenue-Costs-Compensation+BenefitsCompensation+Benefits.
    3. The formula for the HCROI percentage is HCROI%=Revenue-(Costs-(Compensation+Benefits))Compensation+Benefits-1HCROI%=Revenue-Costs-Compensation+BenefitsCompensation+Benefits-1.
    4. The employee base salary is labeled Annual Salary 2018.
    5. The annual bonus in the Job Codes worksheet is the percentage increase on the annual salary. Use a VLOOKUP to help calculate this amount.
    6. The benefits are determined using a VLOOKUP and matching with the benefits plan lookup table. This is a per month value, so you will have to convert it to a yearly cost by multiplying it by 12.
    7. To calculate the metric Revenue per Employee: revenue/no. of employees.
      • Note that only FT & PT employees are counted.
    8. Use the VLOOKUP function to bring in the positions from the jobcode table.
    9. Note that some employees have left the company (employed = NO) and should not be included in calculations.
    10. Compensation in the formula includes salaries, benefits, and bonuses.

Reference no: EM133027425

Questions Cloud

Explain the company global workforce : Much has been written about diversity (or more accurately the lack of diversity) at Google and at other tech giants. According to recent numbers released by Goo
Research and present the compensation trends : As we know that benefits are of two types: mandatory and discretionary, advise Coca Cola as to what benefits is it required to pay to its employees as per the B
Excellent record of achieving goals : -You are considering a major change in the way your company does business. Your staff has an excellent record of achieving goals, and your relationship with the
Describe the best buy competitive advantage : Describe the Best Buy's competitive advantage and how the organization manages its supply chain(s).
Calculate the hcva and hcroi : Every Monday morning your company has a manager meeting to discuss ongoing issues and the upcoming week. You have been in the HR position at Headgames Inc.
Compensation in direct financial compensation : Classify each component of the compensation in direct financial compensation, indirect financial compensation, and non-financial compensation (if any).
Cummins connects business strategy : 1) Why is planning and forecasting a global workforce so difficult? What are some approaches/tools that might be helpful from a global HR perspective?
Create a correlation table of all the continuous variables : Question - Make R studio syntax for this - Create a correlation table of all the continuous variables with the 'Hmisc' library
Identify five prohibited grounds of discrimination : Identify five prohibited grounds of discrimination and describe how ONE of the five you identify can be the source of constructive discrimination

Reviews

Write a Review

HR Management Questions & Answers

  What are social and emotional competence

What are social and emotional competence? How do they come into play?

  Differences between a group and a teamshow the differences

differences between a group and a teamshow the differences between a group and a team include the importance of

  Disengaged employees and counterproductive behaviors

Disengaged employees and counterproductive behaviors have become the norm in many organizations, and as a result, organizations are implementing more stringent policies, enforcing regular trainings, and installing cameras throughout the workforce

  Drug and opioid-involved overdose deaths

For the selected article: Drug and Opioid-Involved Overdose Deaths - United States, 2013-2017 from the Morbidity and Mortality Weekly Report website.

  Distribution and deployment of women in health workforce

What are some of the issues affecting the distribution and deployment of women in the health workforce? And what could be the solution?

  Identify methods for evaluating operational processes

Identify methods for assessing operational needs in a healthcare setting.Identify methods for evaluating operational processes.

  Dramatic impact on hrd implementation

You have seen in this chapter how technological changes have had a dramatic impact on HRD implementation.

  How you would evaluate the teams and team members

Include questions that ask leaders to evaluate their teams and team members, as well as to rate themselves. Questions could include items referring to.

  Main functions of the hospitality industry

1. What are the main functions of the hospitality industry?

  Discuss about the ethics and the global economy

From the case study, examine HR's role in ensuring that organizations comply with the United States Foreign Corrupt Practices Act (FCPA) and the United Kingdom Bribery Act. Determine what you believe to be HR's biggest challenge in ensuring compli..

  Benefits of collaborative and team-oriented workplace

What are the benefits of collaborative and team-oriented workplace and What activities help to influence team-oriented and collaborative workplace

  Discuss a role within the hr department

you are going to place yourself into a role within the HR Department. It is your sole responsibility to educate your fellow employees to in turn better protect.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd