Please complete the following scenario based problem. You should upload a Word or PDF document containing your work.

Assume you are the manager for the team below. You have been given a budget merit increase of 5% for the department and the computer generated this report.

Name	Current Salary (K)	Current Evaluation	Relative Salary	% Increase	$ Increase (K)
1. E. Space	60	2nd	80%	8	4.8
2. J. Collins	120	2nd	105%	5	6.0
3. P. Miller	90	2nd	110%	4	3.6
4. D. Fry	85	3rd	85%	6	5.1
5. N. Lambert	100	3rd	105%	4	4.0
6. P. Austin	80	4th	115%	2	1.6
7. M. Quinn	70	1st	100%	7	4.9
8. F. Roberts	65	1st	85%	8	5.2
9. A. John	95	2nd	95%	6	5.7
10. K. Chung	105	4th	100	3	3.0
Totals	870				43.90

New Payroll: $870K * 5% = $913.5K

Consider the following changes to this computer prepared report.

Fry's performance has increased to 2nd quartile.

Quinn's performance has decreased to 2nd quartile.

Develop a new proposed merit plan. Be sure to indicate if you have merit budget to return to the department manager or if you need additional merit budget; that is, how many dollars are you over or under the 5% given to your department. (8 points)

Outline to your supervisor how you justify the overage or (2 points)