You just learned how to evaluate pay compression systems by the following metrics: Total Compensation Expense Factor, Pay-for-Performance Expense Factor, Total Compensation Revenue Factor, and Pay-for-Performance Revenue. In the “Practice” sheet of the Excel workbook, you will find a new set of compensation, operating, and revenue data for a different company. Again, you will focus on compensation expenses associated with nonproduction employees. Do and respond to the following: First, compute the total compensation expense factors and total compensation revenue factors across 3 years. Second, compute the pay-for-performance expense factors and pay-for-performance revenue factors across the same 3 years. Third, What trends did you notice? What implications do they have? 2016 2017 2018 Compensation Expenses (Base & Variable Pay): 38.5 41.7 40.6 Pay-for-Performance Expenses: 7.5 10.3 9.9 Benefits Expenses: 18.3 19.9 19.3 Total Operating Expenses: 65.6 72.7 74.0 Total Revenue: 199.1 191.9 178.7
You just learned how to evaluate pay compression systems by the following metrics: Total Compensation Expense Factor, Pay-for-Performance Expense Factor, Total Compensation Revenue Factor, and Pay-for-Performance Revenue. In the “Practice” sheet of the Excel workbook, you will find a new set of compensation, operating, and revenue data for a different company. Again, you will focus on compensation expenses associated with nonproduction employees.
Do and respond to the following:
First, compute the total compensation expense factors and total compensation revenue factors across 3 years.
Second, compute the pay-for-performance expense factors and pay-for-performance revenue factors across the same 3 years.
Third, What trends did you notice? What implications do they have?
2016 | 2017 | 2018 | |
Compensation Expenses (Base & Variable Pay): | 38.5 | 41.7 | 40.6 |
Pay-for-Performance Expenses: | 7.5 | 10.3 | 9.9 |
Benefits Expenses: | 18.3 | 19.9 | 19.3 |
Total Operating Expenses: | 65.6 | 72.7 | 74.0 |
Total Revenue: | 199.1 | 191.9 | 178.7 |
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 16 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Understanding Business](https://www.bartleby.com/isbn_cover_images/9781259929434/9781259929434_smallCoverImage.gif)
![Management (14th Edition)](https://www.bartleby.com/isbn_cover_images/9780134527604/9780134527604_smallCoverImage.gif)
![Spreadsheet Modeling & Decision Analysis: A Pract…](https://www.bartleby.com/isbn_cover_images/9781305947412/9781305947412_smallCoverImage.gif)
![Understanding Business](https://www.bartleby.com/isbn_cover_images/9781259929434/9781259929434_smallCoverImage.gif)
![Management (14th Edition)](https://www.bartleby.com/isbn_cover_images/9780134527604/9780134527604_smallCoverImage.gif)
![Spreadsheet Modeling & Decision Analysis: A Pract…](https://www.bartleby.com/isbn_cover_images/9781305947412/9781305947412_smallCoverImage.gif)
![Management Information Systems: Managing The Digi…](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780135191798/9780135191798_smallCoverImage.jpg)
![Business Essentials (12th Edition) (What's New in…](https://www.bartleby.com/isbn_cover_images/9780134728391/9780134728391_smallCoverImage.gif)
![Fundamentals of Management (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134237473/9780134237473_smallCoverImage.gif)