Case $$ Designing a Pay structure

In your role as the company$$s HR manager you are expected to set up a pay structure for the company$$s expansion in Chattanooga, Tenn. This is accomplished in the following manner.

A$.$ Create a complete job description for the benefits manager position using O$$Net and any additional sources. $(2$ Points$)$

B$.$ I $-$ Calculate the job evaluation points for the Administrative assistant, payroll assistant, operational analyst and benefits manager jobs. Provide a rationale for assigning specific degrees to the various jobs. $(2$ Points$)$

B$.$ II $$ Produce a degree key so that the assignment of degrees to various jobs is clearly thought out and applied consistently. $(1$ Points$)$ added requirement

C$.$ If there were any outliers $($ie: Extreme data points$)$ in these data, what would you recommend doing with them? $($From this point forward assume no extreme data points exist in the dataset.$)(1$ Points$)$

D$.$ Conduct a simple regression in Excel to create a market pay line by entering the job evaluation points $($X Axis$)$ and the respective weighted average market base pay $($Y axis$)$ for each benchmark job. $(2$ Points$)$

E$.$ What is your R squared $($Variance explained$)?$ Is it enough to proceed? $(1$ Points$)$

F$.$ Calculate the predicted base pay for each benchmark Job$).(2$ Points$)$

G$.$ Because your company wants to lead in base pay by $3\%,$ adjust the predicted pay rates to determine the base pay rate you will offer for each benchmark job. $(1$ Points$)$

H$.$ Create pay grades by combining any benchmark jobs that are substantially comparable for pay purposes. Clearly label your pay grades and explain why you combined and benchmark jobs to form a grade. $(3$ Points$)$

I. Use your answer in H to determine the pay range $($Ie$-$ minimum and maximum$)$ for each pay grade. $(2$ Points$)$

J$.$ Given the pay structure you have generated, consider the following:

J$.$I Does this pay structure make good business sense? Do you think it is consistent with the organization$$s business strategy? $(1$ Points$)$

J$.$II What are the implications of this pay structure for other HR systems, such as retention and recruiting? $(1$ Points$)$

K$.$ Overall professionalism of written proposal $($editing$,$ typos, Composition$)(1$ Points$)$