In your spreadsheet, compute the average increase needed to meet the industry av
ID: 2464276 • Letter: I
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.
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
Explanation / Answer
Industry Average Salary
Accounting $89,000
Marketing $114,000
Information Systems $127,000
Company Average:
Accounting =918000/10 = $91800
Marketing =1006500/10 = $100650
Information Systems =1071000/10 = $107100
the average increase needed to meet the industry average for each department:
Accounting Above average, no increase required
Marketing Average increase required : 13.26%
Information Systems Average increase required : 18.58%