Application
savgehawk
mhutchison_week4ip.xlsHeads and Salary By Manager
| Data | ||||
| Manager | Full Name | Job Title | Count of Full Name | Average of Salary |
| Ku, Wah | Chan, Ben | Software Analyst | 1 | $47,300 |
| Chan, Ben Total | 1 | $47,300 | ||
| Chang, Kathy | Customer Service Representative | 1 | $28,500 | |
| Chang, Kathy Total | 1 | $28,500 | ||
| Chi, Wang | Software Analyst | 1 | $78,000 | |
| Chi, Wang Total | 1 | $78,000 | ||
| Chon, Janice | Software Analyst | 1 | $69,000 | |
| Chon, Janice Total | 1 | $69,000 | ||
| Chow, James | Customer Service Representative | 1 | $35,200 | |
| Chow, James Total | 1 | $35,200 | ||
| Hong, Ping | Customer Service Representative | 1 | $24,900 | |
| Hong, Ping Total | 1 | $24,900 | ||
| Kang, Raj | Software Analyst | 1 | $54,000 | |
| Kang, Raj Total | 1 | $54,000 | ||
| Lee, Eddie | Software Analyst | 1 | $61,000 | |
| Lee, Eddie Total | 1 | $61,000 | ||
| Linh, Mai | Customer Service Representative | 1 | $34,000 | |
| Linh, Mai Total | 1 | $34,000 | ||
| Otega, Jack | Customer Service Representative | 1 | $30,000 | |
| Otega, Jack Total | 1 | $30,000 | ||
| Pan, Lo | Customer Service Representative | 1 | $40,000 | |
| Pan, Lo Total | 1 | $40,000 | ||
| Park, Ria | Customer Service Representative | 1 | $26,000 | |
| Park, Ria Total | 1 | $26,000 | ||
| Shen, Egg | Customer Service Representative | 1 | $45,000 | |
| Shen, Egg Total | 1 | $45,000 | ||
| Yin, Miao | Administrative Assistant | 1 | $26,000 | |
| Yin, Miao Total | 1 | $26,000 | ||
| Ku, Wah Total | 14 | $42,779 | ||
| Sharpe, Nina | Atwood, Leonard | Software Analyst | 1 | $80,000 |
| Atwood, Leonard Total | 1 | $80,000 | ||
| Farell, Matthew | Software Analyst | 1 | $73,700 | |
| Farell, Matthew Total | 1 | $73,700 | ||
| Law, Grace | Software Analyst | 1 | $52,100 | |
| Law, Grace Total | 1 | $52,100 | ||
| Liteman, Cal | Software Analyst | 1 | $77,700 | |
| Liteman, Cal Total | 1 | $77,700 | ||
| Sumner, Charles | Software Analyst | 1 | $51,000 | |
| Sumner, Charles Total | 1 | $51,000 | ||
| Turner, Joe | Software Analyst | 1 | $75,000 | |
| Turner, Joe Total | 1 | $75,000 | ||
| Webster, Derek | Software Analyst | 1 | $50,000 | |
| Webster, Derek Total | 1 | $50,000 | ||
| Sharpe, Nina Total | 7 | $65,643 | ||
| Wicks, S.W. | Barber, Sam | Customer Service Representative | 1 | $43,700 |
| Barber, Sam Total | 1 | $43,700 | ||
| Bowman, Michael | Customer Service Representative | 1 | $49,600 | |
| Bowman, Michael Total | 1 | $49,600 | ||
| Burton, Jack | Customer Service Representative | 1 | $37,000 | |
| Burton, Jack Total | 1 | $37,000 | ||
| Emerson, Louis | Customer Service Representative | 1 | $39,100 | |
| Emerson, Louis Total | 1 | $39,100 | ||
| Gabriel, Thomas | Customer Service Representative | 1 | $54,700 | |
| Gabriel, Thomas Total | 1 | $54,700 | ||
| Galagher, Jack | Customer Service Representative | 1 | $37,700 | |
| Galagher, Jack Total | 1 | $37,700 | ||
| Hale, Catherine | Customer Service Representative | 1 | $36,000 | |
| Hale, Catherine Total | 1 | $36,000 | ||
| Hayden, Vernon | Customer Service Representative | 1 | $25,000 | |
| Hayden, Vernon Total | 1 | $25,000 | ||
| Higgins, Joe | Customer Service Representative | 1 | $38,000 | |
| Higgins, Joe Total | 1 | $38,000 | ||
| Looker, Ely | Customer Service Representative | 1 | $51,900 | |
| Looker, Ely Total | 1 | $51,900 | ||
| Ruiz, Marisa | Customer Service Representative | 1 | $28,000 | |
| Ruiz, Marisa Total | 1 | $28,000 | ||
| Walker, Jeremy | Customer Service Representative | 1 | $44,800 | |
| Walker, Jeremy Total | 1 | $44,800 | ||
| Wicks, S.W. Total | 12 | $40,458 | ||
| Grand Total | 33 | $46,785 |
Heads By Job Title Pie
| Count of Job Title | |
| Job Title | Total |
| Administrative Assistant | 2 |
| Customer Service Representative | 20 |
| Finance | 1 |
| Manager | 3 |
| Office Manager | 1 |
| Software Analyst | 12 |
| Grand Total | 39 |
Heads By Job Title Pie
| Administrative Assistant |
| Customer Service Representative |
| Finance |
| Manager |
| Office Manager |
| Software Analyst |
| Grand Total |
Count of Job Title Total
2
20
1
3
1
12
39
Phase 4 Data
| First | Last | Full Name | Location | Job Title | Type | Salary | Manager |
| Miao | Yin | Yin, Miao | Kobe, Japan | Administrative Assistant | Hourly | $ 26,000.00 | Ku, Wah |
| Gillian | Forster | Forster, Gillian | Seattle, Washington | Administrative Assistant | Hourly | $ 27,500.00 | Joubert, Gil |
| Gil | Joubert | Joubert, Gil | Seattle, Washington | CEO | Salaried | $ 125,000.00 | |
| Jack | Otega | Otega, Jack | Kobe, Japan | Customer Service Representative | Hourly | $ 30,000.00 | Ku, Wah |
| Mai | Linh | Linh, Mai | Kobe, Japan | Customer Service Representative | Hourly | $ 34,000.00 | Ku, Wah |
| Kathy | Chang | Chang, Kathy | Kobe, Japan | Customer Service Representative | Hourly | $ 28,500.00 | Ku, Wah |
| Ria | Park | Park, Ria | Kobe, Japan | Customer Service Representative | Hourly | $ 26,000.00 | Ku, Wah |
| Ping | Hong | Hong, Ping | Kobe, Japan | Customer Service Representative | Hourly | $ 24,900.00 | Ku, Wah |
| James | Chow | Chow, James | Kobe, Japan | Customer Service Representative | Hourly | $ 35,200.00 | Ku, Wah |
| Lo | Pan | Pan, Lo | Kobe, Japan | Customer Service Representative | Hourly | $ 40,000.00 | Ku, Wah |
| Egg | Shen | Shen, Egg | Kobe, Japan | Customer Service Representative | Hourly | $ 45,000.00 | Ku, Wah |
| Catherine | Hale | Hale, Catherine | Seattle, Washington | Customer Service Representative | Hourly | $ 36,000.00 | Wicks, S.W. |
| Joe | Higgins | Higgins, Joe | Seattle, Washington | Customer Service Representative | Hourly | $ 38,000.00 | Wicks, S.W. |
| Sam | Barber | Barber, Sam | Seattle, Washington | Customer Service Representative | Hourly | $ 43,700.00 | Wicks, S.W. |
| Jack | Galagher | Galagher, Jack | Seattle, Washington | Customer Service Representative | Hourly | $ 37,700.00 | Wicks, S.W. |
| Vernon | Hayden | Hayden, Vernon | Seattle, Washington | Customer Service Representative | Hourly | $ 25,000.00 | Wicks, S.W. |
| Marisa | Ruiz | Ruiz, Marisa | Seattle, Washington | Customer Service Representative | Hourly | $ 28,000.00 | Wicks, S.W. |
| Thomas | Gabriel | Gabriel, Thomas | Seattle, Washington | Customer Service Representative | Hourly | $ 54,700.00 | Wicks, S.W. |
| Michael | Bowman | Bowman, Michael | Seattle, Washington | Customer Service Representative | Hourly | $ 49,600.00 | Wicks, S.W. |
| Louis | Emerson | Emerson, Louis | Seattle, Washington | Customer Service Representative | Hourly | $ 39,100.00 | Wicks, S.W. |
| Jeremy | Walker | Walker, Jeremy | Seattle, Washington | Customer Service Representative | Hourly | $ 44,800.00 | Wicks, S.W. |
| Ely | Looker | Looker, Ely | Seattle, Washington | Customer Service Representative | Hourly | $ 51,900.00 | Wicks, S.W. |
| Jack | Burton | Burton, Jack | Seattle, Washington | Customer Service Representative | Hourly | $ 37,000.00 | Wicks, S.W. |
| William | Bell | Bell, William | Seattle, Washington | Finance | Salaried | $ 111,000.00 | Joubert, Gil |
| Wah | Ku | Ku, Wah | Kobe, Japan | Manager | Salaried | $ 79,000.00 | Joubert, Gil |
| S.W. | Wicks | Wicks, S.W. | Seattle, Washington | Manager | Salaried | $ 84,000.00 | Joubert, Gil |
| Nina | Sharpe | Sharpe, Nina | Seattle, Washington | Manager | Salaried | $ 88,000.00 | Joubert, Gil |
| Jon | MacKlane | MacKlane, Jon | Seattle, Washington | Office Manager | Salaried | $ 63,000.00 | Joubert, Gil |
| Janice | Chon | Chon, Janice | Kobe, Japan | Software Analyst | Salaried | $ 69,000.00 | Ku, Wah |
| Raj | Kang | Kang, Raj | Kobe, Japan | Software Analyst | Salaried | $ 54,000.00 | Ku, Wah |
| Ben | Chan | Chan, Ben | Kobe, Japan | Software Analyst | Salaried | $ 47,300.00 | Ku, Wah |
| Wang | Chi | Chi, Wang | Kobe, Japan | Software Analyst | Salaried | $ 78,000.00 | Ku, Wah |
| Eddie | Lee | Lee, Eddie | Kobe, Japan | Software Analyst | Salaried | $ 61,000.00 | Ku, Wah |
| Joe | Turner | Turner, Joe | Seattle, Washington | Software Analyst | Salaried | $ 75,000.00 | Sharpe, Nina |
| Leonard | Atwood | Atwood, Leonard | Seattle, Washington | Software Analyst | Salaried | $ 80,000.00 | Sharpe, Nina |
| Derek | Webster | Webster, Derek | Seattle, Washington | Software Analyst | Salaried | $ 50,000.00 | Sharpe, Nina |
| Matthew | Farell | Farell, Matthew | Seattle, Washington | Software Analyst | Salaried | $ 73,700.00 | Sharpe, Nina |
| Charles | Sumner | Sumner, Charles | Seattle, Washington | Software Analyst | Salaried | $ 51,000.00 | Sharpe, Nina |
| Cal | Liteman | Liteman, Cal | Seattle, Washington | Software Analyst | Salaried | $ 77,700.00 | Sharpe, Nina |
| Grace | Law | Law, Grace | Seattle, Washington | Software Analyst | Salaried | $ 52,100.00 | Sharpe, Nina |
