3. How can you use this analysis to contribute to the employee salary decision?

Question

3. How can you use this analysis to contribute to the employee salary decision?

4. Based on this data, what conclusions can you make?

5. 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.

Company Departments I Accountin Marketin Information Systerm Industry Average Salar 89,000 114, 000 127,000 Percent their salary Difference between Salarywould need to be Information Systems Department Employees Salary and the Average Salaryincreased to meet the average Ching, Kam Ho $8,000 135,000 110, 000 131, 000 120,000 114, 000 75, 000 113,000 88, 000 69,000 116, 000 on 15.45% Collins, Giovanni Dixon, Eleonor Lee, Brandon Lunden, Hale Rikki, Nicole Scott, Bryan Angel, Kath $4, 000 5·83% 11.40% 69. 33% 12. 39% 44. 32% 84.06% 9.48% ames Pham, Ma 11,000 Average Sala 107,100 nformation Sys tem Average increase reguired 8·58% (127, 000/107, 000)

Explanation / Answer

3. Going through the analysis, we able to analyse that the employees are being paid at a very lower level in comparison to the industry average salary. The company could take necessary steps to upgrade the employees salary to the industry's average.

4. The Accounting Department employee are having salary more closest to the industry average salary. Technology and Marketing department's employee are the most under salaried and require the upgradation of the salary to the industry average salary.

5. The ways in which these data could be shared with other team members are:

-The difference in the employees salary with the average of the industry.

-The average of industry which others can follow.

-The percentage of the updation required in the Technology and the Marketing departments.

The advantages of using the data are:

1) Prior analyised data so no more analysis required.

2) Direct action i.e. upgradation of the employees salary.

3) Industry-wise camparison is making the employees stability.

Disadvantages of using the data are:

a) Based on the past and outdated data, needs updation.

b) The culture and professional environment of different company could be much different.

c) In the ever changing and dynamic economic environment, the past data and analysis is ineffective.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.