skip to Main Content

ASSIGNMENT DETAILS Review the SHRM case: Designing a Pay StructureÂ  You will p

ASSIGNMENT DETAILS Review the SHRM case: Designing a Pay Structure You will prepare the SHRM case analysis on Designing a Pay Structure  which consists of your completion of Tasks A“J that simulate 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 by usingExcel. Your case analysis should consist of: Task A:Create a complete job description for the benefits manager position using O*NET. Task B: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. Task C:If there were any outliers (i.e. extreme data points) in the data what would you recommend doing with them? From this point forward assume no extreme data points exist in the dataset. Task D:Conduct a simple regression in Excel to create a market pay line by entering the job evaluation points (on the X axis) and the respective weighted average market base pay (on the Y axis) for each benchmark job. Task E:What is your R squared (variance explained)? Is it sufficient to proceed? Task F:Calculate the predicted base pay for each benchmark job. Task 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. Task 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 any benchmark jobs to form a grade. Task I:Use your answer to Task H to determine the pay range (i.e. minimum and maximum) for each pay grade. Task J:Given the pay structure you have generated consider the following: Does this pay structure make good business sense? Do you think it is consistent with the organizations business strategy? What are the implications of this pay structure for other HR systems such as retention and recruiting? Your analysis of this case and your written submission should reflect an understanding of the critical issues of the case integrating the material covered in the text and present concise and well-reasoned justifications for the stance that you take. You are to complete this case analysis using Excel in a spreadsheet analysis format. You may discuss your case analysis assignment with the class but you must submit your own original work. Case analysis tips: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 cases data. Obscuring the quantitative analysis or making it difficult to understand. Typical minus (“) grades result from submissions that: 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. Make sure your document includes: 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 in Excel. Check for correct spelling grammar punctuation mechanics and usage. Citations should be in APA style. Here is the assignment grading rubric. Assignment submission: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.

Features You Can Count On

We have a quality check process in place for every assignment we complete for the students. This process assure that students receive nothing but THE BEST

Your Grades Soar

With our specific and personalized attention, you get the dual benefits of understanding the concepts and fundamentals of your subject and its nuances. And you can always keep up with class room teaching and get good grades too!

Trusted Experts

Our team of experts are drawn from group of academicians who hold doctorates in their chosen fields. They have been teachers all their lives. They understand your needs and can help you with exams, homework and assignments.

Delivery Guarantee

Our online tutors know the importance of handing in tasks on-time and in the format required by each college. Our discipline is reflected in our strict adherence to on-time delivery of your assignments and homework.

24X7 Availability

We draw the best talent in the form of lecturers, professors, online tutors and subject experts from all over the world. For this reason, when ever you may need help, it’s always there for you. Available, reliable and guaranteed.

Privacy Guaranteed

We respect your privacy. We never disclose your personal or contact details to anyone under any circumstances. So, you can communicate with our team confidently and always be 100{0afbfe2db91aa1d41f515ba8d9a3a5568a6417cbf60a0175c7628d43a1875498} assured of complete privacy of all your dealings with us.

Satisfaction Guaranteed

We have built a reputation of offering professional homework and assignment services. We assure you of our continued support for as long as you want it, each time to guarantee you 100{0afbfe2db91aa1d41f515ba8d9a3a5568a6417cbf60a0175c7628d43a1875498} satisfaction.

We're Here For You 24/7

We are known for our impressive quality of work. Students around the globe prefer our assignment writing services as we provide them the excellent features and benefits. Take a look at the alluring features.

Plagiarism-Free Affordable Papers
Money-Back Guarantee
Timely Delivery
Zero-Plagiarism Guarantee
Find out More

Our Services

Exquisite Essay Writings specializes with preparation and writing of all your premium writing projects. We mainly deal with academic research and project writing services but offer a wide verity of additional writing services like coursework, dissertation and thesis essay writing. We have a team of highly trained and skilled professionals from every sector and profession thus insuring your projects are handled in the best possible manner. We have been in the academic assistance service since 2008 and managed to build a large network of clients from across the globe and covering practically every sector of business and education available today.

Custom Essay Writing Service

Looking for the best custom assignment writing service online? Relax! is a trustworthy affordable writing service that delivers clients with quality custom assignments.

Creative Essay Writing

Do you feel like you lack the skills to write creative essays? Then you need help. is the only creative essay writing service that will deliver creativity with a magic touch

Term Paper Writing

Get an excellent grade on any custom term paper writing service. All of our customers remain anonymous throughout the entire ordering process. We guarantee that your education will not suffer.

Research Paper Writing

Looking for a legitimate and trustworthy High School/College custom research paper writing service? That exceeds your expectations to become that number website write papers for you! Well, here it is. Receive high-quality papers, 24/7 support

Annotated Bibliography

Are you looking for someone to write your MLA, APA, Chicago Style annotated bibliography? Good News! hire us, Our annotated bibliography writers are always ready to offer Custom annotated bibliography writing in all fields.

Thesis Writing Service

Are you searching for thesis writing service? Do not blame anyone. The professional PhD/ MA writers at are here to help. Contact support to find out more information about our writing service.

We're Obsessed with Your Privacy
1. Anonymous Chatting
At, you can communicate directly with your writer on a no-name basis.

2. Secure Payment Methods

We accept only Visa, MasterCard, American Express and Discover for online orders.
3. Complete Confidentiality
Your personal details remain confidential and won’t be disclosed to the writer or other parties.


Have a look at some of the wonderful things people say about us.


“Believe it or not, but I’m fully satisfied with the essay you’ve written for me. I have got an excellent mark and I’m now convinced in the truth of your promises. Thanks”

Good Service

“Thanks for good service and high quality. The research paper was much more than I expected!Thanks”


“Unbelievable. The writer followed all my instructions and created a brilliant essay, I would say. What I like most of all, no one suspects even that my essay wasn’t written by me. Thanks”


“Thanks. Without you I would not have been a Master of Psychology.”

I’m so happy about it

“Just when I was about to give up on my dissertation, my friend advised me to use your service. It was timely advice because I was stuck and didn’t know what to do. Now I am a PhD degree-holder and I’m so happy about it”


“I thought paper writing services are the fiction and rip-off for naïve students. But when it came to my research paper that was to be handed in in 72 hours , I had no variants. I made the right choice when I ordered my paper from you and I’ll definitely use your services in the future.”

We Are A Leader In The Academic Writing Industry.

Share via
Copy link
Powered by Social Snap