Share

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus convallis sem tellus, vitae egestas felis vestibule ut.

Error message details.

Reuse Permissions

Request permission to republish or redistribute SHRM content and materials.

Compa-Ratio Calculation Spreadsheet




This spreadsheet contains formulas to calculate individual employee compa-ratios, also known as compensation ratios. Where the midpoint of a pay range represents full market pay, the ratio of the employee's actual salary to that midpoint indicates whether he or she is paid below, at or above market rates. This data can then be used to ensure job candidates are being offered competitive rates and can help determine pay increases for current employees as their job competency rises. A graph will automatically be created as data is entered.

Advertisement

​An organization run by AI is not a futuristic concept. Such technology is already a part of many workplaces and will continue to shape the labor market and HR. Here's how employers and employees can successfully manage generative AI and other AI-powered systems.

Advertisement