Suppose that you have been asked to assist in the managerial decision about how much to increase pay in the next year. Assume you are given a list of the departments in your company, along with the average salary for employees in each department for major companies in your industry. Additionally, you are given the names and salaries of 10 people in each of three departments in your company. Assume you have been asked to create a spreadsheet that shows the names of the 10 employees in each department, their current salary, the difference between their current salary and the industry average salary for their department, and the percent their salary would need to be increased to meet the industry average. Your spreadsheet should also compute the average increase needed to meet the industry average for each department and the average increase, company-wide, to meet industry averages.

A) Use the data in the file Ch07Ex01_U11e.docx and create the spreadsheet.

B) How can you use this analysis to contribute to the employee salary decision? Based on this data, what conclusions can you make?

C) Suppose other team members want to use your spreadsheet. Name three ways you can share it with them and describe the advantages and disadvantages of each.

Solve A, B, and C given the information

Company Departments Accounting Marketing Information Systems Industry Average Salary $89,000 $114,000 $127,000 Accounting Department Employees Davidson Kaye Corovic, Jose Lane, Brandon Wei, Guang Drew, Richard Adams, James Spenser, William Ray, Tony Salary 103,000 85,000 125,000 70,000 105,000 65,000 102,000 83,000 75,000 105,000 Ryan, Mark Warrem, Jason Marketing Department Employees Ashley, Jane Corning, Sandra Scott, Rex Duong, Linda Bosa, Victor UTran, Diem Thi Dixon, James T Goston, Sayeh Jordan, Matthew Menstell, Lori Lee Salary 117,000 92,000 112,000 104,500 74,000 89,000 107,000 97,000 76,000 138,000 Information Systems Department Employees Ching, Kam Hoong Collins, Giovanni Dixon, Eleonor Lee, Brandon Lunden, Haley Rikki, Nicole Scott, Bryan Angel, Kathy Quigly, James Pham, Mary Salary 135,000 110,000 131,000 120,000 114,000 75,000 113,000 88,000 69,000 116,000 Company Departments Accounting Marketing Information Systems Industry Average Salary $89,000 $114,000 $127,000 Accounting Department Employees Davidson Kaye Corovic, Jose Lane, Brandon Wei, Guang Drew, Richard Adams, James Spenser, William Ray, Tony Salary 103,000 85,000 125,000 70,000 105,000 65,000 102,000 83,000 75,000 105,000 Ryan, Mark Warrem, Jason Marketing Department Employees Ashley, Jane Corning, Sandra Scott, Rex Duong, Linda Bosa, Victor UTran, Diem Thi Dixon, James T Goston, Sayeh Jordan, Matthew Menstell, Lori Lee Salary 117,000 92,000 112,000 104,500 74,000 89,000 107,000 97,000 76,000 138,000 Information Systems Department Employees Ching, Kam Hoong Collins, Giovanni Dixon, Eleonor Lee, Brandon Lunden, Haley Rikki, Nicole Scott, Bryan Angel, Kathy Quigly, James Pham, Mary Salary 135,000 110,000 131,000 120,000 114,000 75,000 113,000 88,000 69,000 116,000