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:

DO THE FOLLOWING:

1.First, compute the total compensation expense factors and total compensation revenue factors across 3 years.

2.Second, compute the pay-for-performance expense factors and pay-for-performance revenue factors across the same 3 years.

3.What trends did you notice? What implications do they have?

S5 - File Chapter 12 - Excel Extension.xlsx - Excel Home Insert Page Layout Formulas Data Review View Developer Tell me... Sign in 2 Share Calibri 11 General & Conditional Formatting $ - % Format as Table Cells Editing Cell Styles Font Alignment Number Styles Paste 60 .00 .00 0 Clipboard