Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing At The Speed Of Risk With An Agile Continuous Audit Plan

Authors: Norman Marks

1st Edition

B09PMBSWSC, 979-8787044393

More Books

Students also viewed these Accounting questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago