Use the Excel spreadsheet to construct a Merit Pay Grid to assign individual pay increases (the Excel data spreadsheet for this problem is already built in merit grid in the assignment spreadsheet, all you have to do is fill in the numbers and do the math). Assume that your budget is 4.5% . Your answers have to be logical and consistent and the result must use a minimum of 4.4% but no more than 4.5%.

Current Pay and Other Information for 25 employees Pay Range Information midpoint maximum Compa Ratio Pay Quartile pay grade minimum Employee # % inc Sex min=1 PA 1 Min y 4 Years 2 1 4 f f $ $ sex (f=1) 1 1 24 0 1 25 I f 5 3 24 0 1 25 I f 5 3