Develop a plan for the distribution of salary increases. Suppose you are employe

Develop a plan for the distribution of salary increases. Suppose you are employed in a local industry and your supervisor has assigned you to distribute annual raises that must average 4% per department among 6 team members. No team member can get exactly 4% and the raise must be at least 2% and no more than 6%.You may establish your own criteria for distributing the raises but you are given the years of experience and the rating on annual performance reviews for each member. A performance rating of 1 is the lowest rating possible and a rating of 5 is the highest.Employee 1 has 4 years experience a performance rating of 4 and a salary of $28500.Employee 2 has 3 years experience a performance rating of 4 and a salary of $28500.Employee 3 has 10 years experience a performance rating of 4 and a salary of $32700.Employee 4 has 7 years experience a performance rating of 3 and a salary of $31400.Employee 5 has 15 years experience a performance rating of 3 and a salary of $34500.Employee 6 has 12 years experience a performance rating of 5 and a salary of $32400.Decide the amount of increase for each member.1. Prepare your recommendations for your supervisor that includes the following:A table showing the original salary the amount of increase the new salary and the percent of increase for each employee.Show the calculations to verify that the total amount of increases is exactly 4% of the total original salaries except for rounding discrepancies.Will the percent of change also average 4%? Why or why not?What other factors could have been used to calculate pay raise?Many feel that pay raises should reflect seniority only? Do you agree? Why or why not2. The interest formula shows how interest rate and time are related. It gives you a way of finding one of these values if the other three values are known. Even though you try to be careful in your calculations there will always be that occasion when you make an error and end up with an incorrect answer. You can avoid such errors by first predicting what a reasonable answer might be by estimating. As an example if you have an 11.2% interest you could use 11% to estimate what the correct result would be.Search the internet to find an application of simple interest that you find interesting that you encounter on a daily basis or that you find in your profession.How could you avoid an error by using a pre-estimation? Present this application to the class and explain why you choose the example.In what ways do you use estimating in your everyday life?Include the URL for the site you used. Do not copy the text in the site verbatim. You should summarize your findings.This section lists options that can be used to view responses.