How compensation frameworks are developed by hr teams

Assignment Help Other Subject

Reference no: EM133945381

Task - Coaching Manager and Other Business Leaders

How compensation frameworks are developed by HR teams
How comparative ratios and pay ranges help companies to ensure employee pay is compliant with regulations and internal policy
How to use comparative ratios to determine whether employees should receive pay rises or adjustments
What you'll do
Use a dataset to understand mid-range pay for a selection of employee
Make recommendations to managers in terms of which employees should receive pay rises or adjustments

Case Scenario
As a C&B leader, you are expected to share insights and coach your HR customers (often times Managers and Business Leaders) on the upcoming salary planning cycle. Specifically, they want your advice on how salary increases should be distributed and to which employees. You will base your recommendations on data analysis, which includes determining comparative ratios (also known as compa-ratios) and understanding what they mean in context. Get expert assignment help online from PhD writers.
You will perform the data analysis in the spreadsheet provided in the case (GE Aerospace: Explore Human ResourcesLinks to an external site.). We know that not everyone is experienced with spreadsheet software like Excel, so this exercise can either be done using formulas or by looking up values and doing the calculations individually.
We suggest that everyone try to use formulas before attempting to do the calculations individually. Consider this a safe environment in which to learn more about spreadsheet software and challenge yourself!
You should formulate your suggestions by following the step-by-step instructions below. Please read the instructions carefully before making an attempt.
Step-By-Step Instructions
Download the Template in Task 3.
Start on the first tab, "Employee details", and note that you have information about the jobs and salaries of fifteen employees. You will be coaching their manager on whether any of these employees requires a major pay increase this salary planning cycle.
Move over to the second tab - "All employees with pay ranges". This document shows pay range information for every single employee in the company, including the fifteen on the team you are advising.
Move back to the "employee details tab". If you scroll over to the right, you'll see two blank columns, I and J. Your goal is to find or calculate the information that goes in these columns.
For column I, "Pay Range Mid Point", you will need to use information from the "All employees with pay ranges" tab to find the pay range Midpoint associated with each of your fifteen employees.
Be sure to use employee ID rather than name to look up this information.
If you are experienced with Excel/spreadsheet software or would like to learn something new, you can use a "VLOOKUP" to do this very quickly. If you'd like to learn about VLOOKUP, go hereLinks to an external site..

After you have filled in the pay reference midpoint for each employee, find the comparative ratio (compa-ratio) for each.
The formula for this can be found in section 2 of the resource documents - these are the same as the documents provided in the previous step.
Again, you can calculate each by hand, or you can use a formula to move more quickly or challenge yourself.

Now we must tell the manager who requires a raise. To do this, segment the comparative ratio values into three segments (less than 80%, between 80%-100% and greater than 100%). Highlight those who are below 80% and those who are between 80-100% using two different colors.

Reference no: EM133945381

Questions Cloud

Which statements by the client should indicate to the nurse : Which statements by the client should indicate to the nurse that the surgical treatment has been effective?

What role should the u.s. government play : What role should the U.S. Government play in regulating monopolies or other industries with market power? Do you think the government do enough to regulate

What is the most likely cause of richards symptoms : When he stood up to leave the table, he became lightheaded and passed out. What is the most likely cause of Richard's symptoms?

What do you suspect could be contributing to this : He reports that this came on just last night. He has a history of liver and kidney disease. What do you suspect could be contributing to this?

How compensation frameworks are developed by hr teams : How comparative ratios and pay ranges help companies to ensure employee pay is compliant with regulations and internal policy

What is one thing that you enjoy about it : What is one thing that you enjoy about it or one feeling / experience that you associate with it? Write loosely for about two minutes, paying more attention

Review the contract with polly penner and dysnomia studios : Penner also wants to recover her travel costs she incurred, prior to learning about the movie, for shopping her script around world to international markets.

What size prostate would be consistent with the diagnosis : You are performing a prostate exam on the patient reports nocturia, frequency, and urgency. What size prostate would be consistent with this diagnosis?

Determine votes of no confidence against the prime minister : Briefly state the methods to determine votes of no confidence against the Prime Minister?

User Account

All Pages