Excercise 17: Read Annual Pay Raises (W-68-69) and complete steps 1 and 2. For this assignment, you will create an excel spreadsheet and embed the spreadsheet into your paper.
Prepare a spreadsheet that included the employee’s name, productivity index, current salary, percent, and dollar amount of suggested raise. Insert the excel spreadsheet into a word document and answer the following questions.

What was your rationale for each person’s raise?
Did you include all information? Did you omit any information?
What were your challenges?
Describe equity theory of motivation. Why is it important?

The final deliverable is a paper. Write a 2-4 page paper that includes your spreadsheet. Your excel spreadsheet will be inserted into your paper and referred to as Figure 1. Your response to the questions should be written in narrative (paragraph) format rather than individual responses to the questions.
Format your paper in APA and include a title page. Organize your paper with an Introduction, Conclusion, and a Reference List. In addition, create headings in the body of the paper (between the Introduction and Conclusion) that are named based on the content in that section of the reflection paper. Please review the APA Heading Format Guidelines (Links to an external site.)Links to an external site. in order to develop a good understanding of how to format the headings in your paper.

Annual Pay Raises Instructions
1. Read the following job descriptions and decide on a percentage pay increase for each of the eight employees.
2. Make salary increase recommendations for each of the eight managers that you supervise.
There are no formal company restrictions on the size of raises you give, but the total for everyone should not exceed the $10,900 (a 4 percent increase in the salary pool) that has been budgeted for this purpose. You have a variety of information on which to base the decisions, including a “productivity index” (PI), which Industrial Engineering computes as a quantitative measure of operating efficiency for each managerâ€s work unit. This index ranges from a high of 10 to a low of 1.
Indicate the percentage increase you would give each manager in the blank space next to each managerâ€s name. Be prepared to explain why.
A. Alvarez Alvarez is new this year and has a tough workgroup whose task is dirty and difficult. This is a hard position to fill, but you donâ€t feel Alvarez is particularly good. The word around is that the other managers agree with you. PI 3. Salary $33,000.
B. J. Cook Cook is single and a “swinger” who enjoys leisure time. Everyone laughs at the problems Cook has getting the work out, and you feel it certainly is lacking. Cook has been in the job two years. PI 3. Salary $34,500. ____
Z. Davis In the position three years, Davis is one of your best people, even though some of the other managers donâ€t agree. With a spouse who is independently wealthy, Davis doesnâ€t need money but likes to work. PI 7. Salary $36,600. ____ M. Frame Frame has personal problems and is hurting financially. Others gossip about Frameâ€s performance, but you are quite satisfied with this second-year employee. PI 7. Salary $34,700. ____
C. M. Liu Liu is just finishing a fine first year in a tough job. Highly respected by the others, Liu has a job offer in another company at a 15 percent increase in salary. You are impressed, and the word is that the money is important. PI 9. Salary $34,000. ____
B. Ratin Ratin is a first-year manager whom you and the others think is doing a good job. This is a bit surprising since Ratin turned out to be a “free spirit” who doesnâ€t seem to care much about money or status. PI 9. Salary $33,800. ____
H. Smith Smith is a first-year manager recently divorced and with two children to support as a single parent. The others like Smith a lot, but your evaluation is not very high. Smith could certainly use extra money. PI 5. Salary $33,000. ____
G. White White is a big spender who always has the latest clothes and a new car. In the first year on what you would call an easy job, White doesnâ€t seem to be doing very well. For some reason, though, the others talk about White as the “cream of the new crop.” PI 5. Salary $33,000.

Uhl-Bien, Mary; Schermerhorn, John R.; Osborn, Richard N.. Organizational Behavior, 13th Edition (Page W-68). Wiley. Kindle Edition.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post annual-pay-raises-excercise-paper appeared first on Essay Fount.


What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"