MS EXCEL Assignment- Create a professional memo to the CEO in Microsoft Word (2-3Paragraphs)
huton_
chutson_week4ipa.xlsx_.xlsHeads and Salary by Manager
| Data | ||||
| Manager | Job Title | Full Name | Count of Full Name | Average of Salary |
| Ku, Wah | Administrative Assistant | Yin, Miao | 1 | $26,000.00 |
| Administrative Assistant Total | 1 | $26,000.00 | ||
| Customer Service Representative | Chang, Kathy | 1 | $28,500.00 | |
| Chow, James | 1 | $35,200.00 | ||
| Hong, Ping | 1 | $24,900.00 | ||
| Linh, Mai | 1 | $34,000.00 | ||
| Otega, Jack | 1 | $30,000.00 | ||
| Pan, Lo | 1 | $40,000.00 | ||
| Park, Ria | 1 | $26,000.00 | ||
| Shen, Egg | 1 | $45,000.00 | ||
| Customer Service Representative Total | 8 | $32,950.00 | ||
| Software Analyst | Chan, Ben | 1 | $47,300.00 | |
| Chi, Wang | 1 | $78,000.00 | ||
| Chon, Janice | 1 | $69,000.00 | ||
| Kang, Raj | 1 | $54,000.00 | ||
| Lee, Eddie | 1 | $61,000.00 | ||
| Software Analyst Total | 5 | $61,860.00 | ||
| Ku, Wah Total | 14 | $42,778.57 | ||
| Sharpe, Nina | Software Analyst | Atwood, Leonard | 1 | $80,000.00 |
| Farell, Matthew | 1 | $73,700.00 | ||
| Law, Grace | 1 | $52,100.00 | ||
| Liteman, Cal | 1 | $77,700.00 | ||
| Sumner, Charles | 1 | $51,000.00 | ||
| Turner, Joe | 1 | $75,000.00 | ||
| Webster, Derek | 1 | $50,000.00 | ||
| Software Analyst Total | 7 | $65,642.86 | ||
| Sharpe, Nina Total | 7 | $65,642.86 | ||
| Wicks, S.W. | Customer Service Representative | Barber, Sam | 1 | $43,700.00 |
| Bowman, Michael | 1 | $49,600.00 | ||
| Burton, Jack | 1 | $37,000.00 | ||
| Emerson, Louis | 1 | $39,100.00 | ||
| Gabriel, Thomas | 1 | $54,700.00 | ||
| Galagher, Jack | 1 | $37,700.00 | ||
| Hale, Catherine | 1 | $36,000.00 | ||
| Hayden, Vernon | 1 | $25,000.00 | ||
| Higgins, Joe | 1 | $38,000.00 | ||
| Looker, Ely | 1 | $51,900.00 | ||
| Ruiz, Marisa | 1 | $28,000.00 | ||
| Walker, Jeremy | 1 | $44,800.00 | ||
| Customer Service Representative Total | 12 | $40,458.33 | ||
| Wicks, S.W. Total | 12 | $40,458.33 | ||
| Grand Total | 33 | $46,784.85 |
Heads by Job Description 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 Description Pie
| Administrative Assistant |
| Customer Service Representative |
| Finance |
| Manager |
| Office Manager |
| Software Analyst |
| Grand Total |
Count of Job Title Total
Head Count by Job Description
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 |
