Review the SHRM case: “ ” You will prepare the SHRM case analysis on “Designing a Pay Structure” which consists of your completion of Tasks

Review the SHRM case: “ ” You will prepare the SHRM case analysis on “Designing a Pay Structure” which consists of your completion of Tasks A–J that simulates the creation of a compensation system for an organization in meeting its goals and supporting its mission. In your analysis, respond to the following tasks found in the case study. Your case analysis should consist of: You may discuss your case analysis Assignment with the class, but you must submit your own original work. Avoid common errors in case analyses, such as: ●  Focusing too heavily on minor issues. ●  Lamenting because of insufficient data in the case and ignoring creative alternatives. ●  Rehashing of case data — you should assume the reader knows the case. ●  Not appropriately evaluating the quality of the case’s data. ●  Obscuring the quantitative analysis or making it difficult to understand. ●  Are late. ●  Are not well integrated and lack clarity. ●  Do not address timing issues. ●  Do not recognize the cost implications or are not practical. ●  Get carried away with personal biases and are not pertinent to the key issues. ●  Are not thoroughly proofread and corrected. • Your name • Date • Course name and section number • Unit number • Case name • Page numbers The case analysis should contain Tasks A–J stated in the case. Check for correct spelling, grammar, punctuation, mechanics, and usage. Citations should be in APA style. Before you submit your Assignment, you should save your work on your computer in a location that you will remember in Excel format. Save the document using the naming convention: Username_Unit4_Assignment.xlsx. Submit your file by selecting the Unit 4: Assignment Dropbox. To My Students: I just wanted to reach out in advance regarding the Unit 4 Assignment.  The case study presented asks you to work through calculations for a pay structure involving 5 different positions.  This is a pretty heavy set of tasks to accomplish in one week.  Fortunately, I have been able to readjust this a bit so that the work load would be manageable in a week’s time. Additionally, since this involves math (and a little statistics), I have put together supportive material (see below) to guide you through how to do this.  PLEASE just follow the guidance below and you will be able to move through this easily. PLEASE be sure to not wait until the last minute to do the Unit 4 Assignment.  There’s a lot to it, so I don’t want anyone to be surprised. I can’t provide a sample since that would contain the answers… But that’s okay, you can take this piece by piece..!  PLEASE READ THESE DETAILS BELOW CAREFULLY.  If you take it slowly, this goes pretty well.  (And!  If you get to the math portion below and you feel out of your element, PLEASE touch base with the Math Tutor (see separate announcement about Academic Support Centers for links).  They offer wonderful assistance! First, let’s take this steps..! , you have to create one job description for the Benefits Manager. There are details in how to approach this and in the Appendix there are other job descriptions for the other positions so you can see how these should look. The case study provides suggestions about where to go to get info on this job description. So read through those details for more guidance. Next, ,  you will calculate the job evaluation points for positions. If you look just above the Task B item (on the previous page), you’ll see info and a sample of how to do this based on the receptionist position. You can change up the percentages these are worth as you see fit for each job… – again read the sample that gets you started.  For instance, in the education area, remember that the weight would be more for a job that needs a Bachelor’s degree rather than a high school diploma/GED. And each one should have a different Points total as they have different requirements from each other. And , here’s a little further /guidance with regard to completing this.  The first part deals with what to do with outliers. That would require you to address this via text in your document. (Again your readings will support this, and you can also do more research online if you’d like.  Don’t forget to use supporting citations when you can – these strengthen your academic work..!) The second part deals with calculating weighted means. (This isn’t as bad as it sounds – I promise..!) Weighted means of base pay should be calculated for each benchmark job from the survey data. Weighted means, as compared to simple means, are calculated to better represent the market data (Milkovich & Newman, 2008). A simple mean would be calculated by adding up the average base pay rates and dividing by the number of organizations (six in this case); but small and large companies would both be given the same weight if using a simple mean. A weighted mean gives equal weight to each job incumbent’s wage and thus is more representative of the data. For example: For each position, you take the number of employees in Co. A, which is 2.  Divide that into the total number of employees in all companies, which is 12.  Or 2/12…  Which equals 0.16667. Then multiply that by the mean salary in Co. A, which is $30,000. So, 30,000 times 0.16667 equals 5,000. Then for the next company, Co. B, you do the same with those numbers. You take the number of employees in Co. B, which is 10.  Divide that into the total number of employees in all companies, which is 12.  Or 10/12…  Which equals 0.833333. Then multiply that by the mean salary in Co. B, which is $15,000. So, 15,000 times 0. 0.833333 equals 12,500. Then you take the $5,000 from the first company and the $12,500 from the second company and add them together to get the $17,500 weighted means. —————————– , you are asked to do some statistics with a regression analysis.  Don’t worry..!  Keep reading and you will see a link to an online calculator that can you with this!  😉 Regression analysis is “the statistical tool for the investigation of the relationship between variables” (Sykes n.d.). It is used when data is analyzed to determine the causal effect of one variable upon another variable. For example, the effect of the increased cost of a gallon/litre of gasoline/petrol on the demand for that product is determined via “regression analysis”. If you want to do the regression analysis calculation in Excel (rather than using the online calculator link that is below), you can go to: – here you will find the article “An introduction to Regression Analysis” by Dr. Alan Sykes that may you understand regression analysis more clearly and you in answering the discussion questions below. Video for how to run the regression analysis in Excel: NOTE: I have Excel 2010, so getting the Regression Toolpak added in was easy. You may have to add this Excel Analysis Toolpak in – no matter what version of Excel you may have. Here is link to how to add that toolpak, for the various Excel versions: Here you would plug in your Job Evaluation Points for each position in Task B (under the X column), and also the corresponding weighted average salary for each position in Task C (under the Y column).  It would look something like this: Regression Analysis Job Evaluation Weighted Points Avg. $ X    Y Recept. 120 19944.44 Admin Asst. 145 29458.33 Pay Asst. 175 34000 Ops Analyst 215 56875 Ben Mgr. 245 62900 NOTE:  THE JOB EVALUATION POINTS YOU HAVE WILL BE DIFFERENT FROM THE EXAMPLE ABOVE.  EVERYONE WILL HAVE SLIGHTLY DIFFERENT POINT VALUES, AND THAT IS PERFECTLY OKAY.  THE WEIGHTED AVERAGE SALARIES THOUGH MUST MATCH THE ONES IN THIS EXAMPLE.  SO IF YOU DIDN’T QUITE GET THE ANSWERS RIGHT FOR TASK C, PLEASE GO AHEAD AND USE THESE WEIGHTED AVERAGE SALARY FIGURES. Once you run your simple regression through the calculator link ( ), you will get results that will look something like this (yours will be different since everyone will have different job evaluation points that they created in Task B – again, that’s perfectly okay): Slope 360.33 ± 36.29 Y-intercept -24324.19 ± 6737 X-intercept 66.31 1/Slope 0.002798 Slope 241.9 to 472.9 Y-intercept -45137 to -2262 X-intercept 9.211 to 96.90 R square 0.9700 Sy.x 3683 F 96.99 DFn,DFd 1,3 P Value 0.0022 Deviation from horizontal? Significant Number of XY pairs 5 Equation Y = 360.33*X – 24324.19 ************** Note: I’ve gone through this material and it really does provide useful info that can basically hold your hand through this process. So I encourage you to take a look and follow along – I hope it you find this ful! (I really think you will!) The first item that Task D asks for is: Identify the slope and y-intercept and write the equation for the market pay line. Regression creates a “line of best fit” by merging the job evaluation points (X) and the external salary data (Y). The resulting regression line is used to predict the base pay (Y) for a specific number of job evaluation points (X). The equation for the simple regression line (as it is for any line) can be represented as: y=mx+b; in which: y =the predicted base pay m =the slope of the line x =the job evaluation points b =the y-intercept So, for example, if the regression results show that m = 400 and b is -20000, then the equation is y=400(x) – 20000 and the predicted pay rate for a job assigned 100 points would be y= 400(100)-20000, or $20,000. The regression output will also show information about how good the regression line fits the data. Specifically, look at the “R squared” in the regression output. Generally, the R squared, referred to as variance explained, should be .95 or higher. If R squared is significantly lower than this, there may be problems stemming from the job evaluation step. For example, the points assigned to certain benchmark jobs may be off – i.e., not make sense given the level of tasks, duties and responsibilities required for the job and the knowledge, skills and abilities needed by the job incumbent. If this is the case, re-examine the job descriptions and reconsider the points assigned to the benchmark jobs. Alternatively, there may be errors in the weighted average calculations. After conducting the regression again, examine the new R squared. , look in the Excel regression output for the “Coefficient of the X Variable.” The y-intercept is located in the regression output as the “Coefficient of the Intercept.” Be sure to write out the regression equation appropriately. Here’s an example: Y = m(x)+b Y = 360.33(x) -24324.19 , the sample R squared from above is .9699 (or .97 when rounded up).  The description below tells you about R squared and how to interpret it: R-squared is a statistical measure of how close the data are to the fitted regression line. It is also known as the coefficient of determination, or the coefficient of multiple determination for multiple regression. The definition of R-squared is fairly straight-forward; it is the percentage of the response variable variation that is explained by a linear model. Or: R-squared = Explained variation / Total variation ——————————————- PLEASE BE SURE TO ANSWER TASK E’S QUESTION:  What is the R squared?  And is it sufficient to proceed? Let’s have you do the basic math: Here’s the formula to use: y=mx+b, where x is the job evaluation points, b is the y-intercept, and m is the slope coefficient from the regression. So you can use this formula: Y = (x) as the predicted base pay for each job. (x) -Y = 360.33 times (the job evaluation point number that you created in Task B for the receptionist) minus 24324.19     (Note:  Y would be the answer to the calculations above…) -Y = 360.33 times (the job evaluation point number that you created in Task B for the benefits manager) minus 24324.19     (Note:  Y would be the answer to the calculations above…) , you take each of the answers for Task F, and increase them by 3% (as the case states the policy will be to lead base pay by 3%). -Take your answer for the receptionist in Task F, and multiply it by 1.03. -Take your answer for the business manager in Task F, and multiply it by 1.03. , you create pay grades for the job, put them in the grades, and be sure to explain what each pay grade represents and why you put the positions into those grades. No calculations are needed here.  You can select 2 pay grades (you can name them A, B, or 1, 2,…  or whatever you would like).  Then based on the predicted pay that you just did, and taking into consideration the skills required, place these into the necessary pay grade and provide a rationale as to why you you put that job there.  (Everyone may end up with a slightly different answer to this item, and that’s fine!) , you’ll show the minimum and maximum for each pay grade. You’ll use the pay figures for the positions from Task H here to show these. So if you have 2 positions in one pay grade – the lower position would be the minimum… The higher one would be the maximum.  Then calculate the average for the two positions.  (Add them together, and divide by 2 for the average.) Then finally, apply the percent guidelines provided in the case to determine the pay ranges.  So if the case calls for 10% above and below the midpoint, calculate as follows: Take the minimum pay, and multiply by 1.10.  Take the maximum pay, and multiply by 1.10.  (If you only have one position in a pay grade, take that pay and multiply by 1.10 (which is 10% above) and then multiply again with that same pay and this time multiply by .90 (which is 10% below the midpoint).  Now you’ve created minimums and maximums as defined by the case for each pay grade..! , just answer the questions..! I think that should give you a basic guide through the assignment. I hope this is ful, and I look forward to reading your work! Okay, you can breathe now… (Really, this is NOT bad… I just know how folks who are math-phobic can worry, so I wanted to walk you through this..!) Again, since this may take some folks some extra time/effort, it might not be bad to set aside time to start working on this ahead of time…  Hint, Hint, Hint…  😉 Dr. Sue

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer