GMartin

asked on

# needing help in calculating expected pay increase

Hello and Good Evening Everyone,

Recently, Middle Tennessee State University decided to provide salary enhancements for its employees. This decision was made as an effort to address the gap between actual employee salaries and market salaries as reported by CUPA for 2014-15. The link to https://www.mtsu.edu/hrs/compensation/docs/Market_Adjustments.pdf provides a couple of examples of how the raises are calculated. However, the example calculations are complex with no attempt given to explaining where some of the numbers actually come from. For example, how is the minimum and midpoint range determined? Is there a site that lists these values based upon the individual's skill level and years of experience? Here is an example scenario of interest that is in need of determining any salary adjustment.

John Doe at Pay Grade 2 with 17 years of MTSU experience

Current Salary --- $24,179.23

I can not list the Minimum and Midpoint Range because I do not know where these values really come from. That said, could someone possibly track down the source for determining this information? I am assuming the Pay Grade Scale is located somewhere within the mtsu.edu site, but, I am uncertain. Or, perhaps it comes from the CUPA statistics for 2014-15.

Any suggestions or tips for filling in the gaps so the numbers can be plugged into the calculations as shown in the examples given within the link of https://www.mtsu.edu/hrs/compensation/docs/Market_Adjustments.pdf will be greatly appreciated.

Thank you

George

Recently, Middle Tennessee State University decided to provide salary enhancements for its employees. This decision was made as an effort to address the gap between actual employee salaries and market salaries as reported by CUPA for 2014-15. The link to https://www.mtsu.edu/hrs/compensation/docs/Market_Adjustments.pdf provides a couple of examples of how the raises are calculated. However, the example calculations are complex with no attempt given to explaining where some of the numbers actually come from. For example, how is the minimum and midpoint range determined? Is there a site that lists these values based upon the individual's skill level and years of experience? Here is an example scenario of interest that is in need of determining any salary adjustment.

John Doe at Pay Grade 2 with 17 years of MTSU experience

Current Salary --- $24,179.23

I can not list the Minimum and Midpoint Range because I do not know where these values really come from. That said, could someone possibly track down the source for determining this information? I am assuming the Pay Grade Scale is located somewhere within the mtsu.edu site, but, I am uncertain. Or, perhaps it comes from the CUPA statistics for 2014-15.

Any suggestions or tips for filling in the gaps so the numbers can be plugged into the calculations as shown in the examples given within the link of https://www.mtsu.edu/hrs/compensation/docs/Market_Adjustments.pdf will be greatly appreciated.

Thank you

George

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
What questions do you have about the pay chart at the bottom of that pdf file you posted?

ASKER

Hello and Good Morning Nick,

I am sorry for not being more specific with my question. Basically, I am wondering what the minimum and midpoint range is for a Pay Grade 2 staff employee with 17 years of experience at MTSU using the pdf file posted. I thought there might be a simple chart to go by for determining this information so I can plug it into the calculations given within this pdf file.

Thank you

George

I am sorry for not being more specific with my question. Basically, I am wondering what the minimum and midpoint range is for a Pay Grade 2 staff employee with 17 years of experience at MTSU using the pdf file posted. I thought there might be a simple chart to go by for determining this information so I can plug it into the calculations given within this pdf file.

Thank you

George

Hi George,

I'm working on what may be a formula and i'll try to get to it tonight or tomorrow. If byundt has satisfactorily given you the answer you seek then go ahead and close the question. Comments can be made even

I'm working on what may be a formula and i'll try to get to it tonight or tomorrow. If byundt has satisfactorily given you the answer you seek then go ahead and close the question. Comments can be made even

*after*questions are closed.SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
I'm trying to track down the source of a number in the charts. There is a source..........

If you don't mind investing $170 for a CUPA-HR annual report that may or may not be the exact figures used at your institution: https://www.cupahr.org/surveys/results/pricing-and-ordering/

SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Hello and Good Afternoon Everyone,

With respect to the question asked, I am afraid the answer is not easily made available online using charts and tables as originally thought. However, I do sincerely thank you both for taking the time to offer thorough and detailed feedback.

On a side note, I did contact the HR Department of MTSU. Apparently, the decision regarding the increased amount, if any, of the full-time employees is voted upon by a formal committee (TBR), passed down to the VP of Business and Finance for determination of the amounts, and further passed down to the department heads for needed adjustments for said amounts. At least, this is my understanding of what was said.

With respect to a time table, eligible pay raises will become active during January. The exact details will be forthcoming during that month.

Thanks again for taking the time to share your thoughts about this question :-)

George

With respect to the question asked, I am afraid the answer is not easily made available online using charts and tables as originally thought. However, I do sincerely thank you both for taking the time to offer thorough and detailed feedback.

On a side note, I did contact the HR Department of MTSU. Apparently, the decision regarding the increased amount, if any, of the full-time employees is voted upon by a formal committee (TBR), passed down to the VP of Business and Finance for determination of the amounts, and further passed down to the department heads for needed adjustments for said amounts. At least, this is my understanding of what was said.

With respect to a time table, eligible pay raises will become active during January. The exact details will be forthcoming during that month.

Thanks again for taking the time to share your thoughts about this question :-)

George

Thank you George.