Question
In your spreadsheet, compute the average increase needed to meet the industry average for each department and the average increase, company-wide, to meet industry averages.
In your spreadsheet, compute the average increase needed to meet the industry average for each department and the average increase, company-wide, to meet industry averages.
Company DepartmentsIndustry 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
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