# 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
Math / Science

Last Comment
nickg5

8/22/2022 - Mon
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
nickg5

What questions do you have about the pay chart at the bottom of that pdf file you posted?
GMartin

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
nickg5

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 after questions are closed.
SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
nickg5

I'm trying to track down the source of a number in the charts. There is a source..........
byundt

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
nickg5

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
GMartin

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
nickg5

Thank you George.