Question
Company Departments Industry Average Salary Accounting $89,000 Marketing $114,000 Information Systems $127,000 Accounting Department Employees Salary Davidson Kaye 103,000 Corovic,Jose 85,000 Lane, Brandon 125,000 Wei,
Company Departments | Industry Average Salary |
Accounting | $89,000 |
Marketing | $114,000 |
Information Systems | $127,000 |
Accounting Department Employees | Salary |
Davidson Kaye | 103,000 |
Corovic,Jose | 85,000 |
Lane, Brandon | 125,000 |
Wei, Guang | 70,000 |
Drew, Richard | 105,000 |
Adams, James | 65,000 |
Spenser, William | 102,000 |
Ray, Tony | 83,000 |
Ryan, Mark | 75,000 |
Warrem, Jason | 105,000 |
Marketing Department Employees | Salary |
Ashley, Jane | 117,000 |
Corning,Sandra | 92,000 |
Scott, Rex | 112,000 |
Duong,Linda | 104,500 |
Bosa, Victor | 74,000 |
UTran,Diem Thi | 89,000 |
Dixon, James T | 107,000 |
Goston, Sayeh | 97,000 |
Jordan, Matthew | 76,000 |
Menstell,Lori Lee | 138,000 |
Information Systems Department Employees | Salary |
Ching, Kam Hoong | 135,000 |
Collins,Giovanni | 110,000 |
Dixon,Eleonor | 131,000 |
Lee,Brandon | 120,000 |
Lunden,Haley | 114,000 |
Rikki, Nicole | 75,000 |
Scott, Bryan | 113,000 |
Angel, Kathy | 88,000 |
Quigly, James | 69,000 |
Pham,Mary | 116,000 |
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 Ch02Ex01_U8e.docx (Links to an external site.) 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started