MS EXCEL Assignment- Create a professional memo to the CEO in Microsoft Word (2-3Paragraphs)

Steps #1 & #2 are finished.  Just need step #3 done (based on the attached spreadsheets)

#3.Create a professional memo to the CEO in Microsoft Word, making sure you cover the following:

◦Manager Summary Pivot Table

◦Head Count Pie Chart

◦Brief Summary of the Organization and of the Report

 

1.      Create the Heading

 

Memo To:  Gil Joubert, CEO

From:         

Date:          August 3, 2013

Re:             Heads and Salary by Managers

 

2.      Write the Body

 

Ø 

Introduction– this should be a short paragraph of 2-3 sentences that let people know the reason for the memo.

Ø  Purpose– This is the meat of the message, using key points, highlights, and/or background information.  It may include supporting details, like facts, statistics, as well as examples and reasons for the memo.

Ø  Conclusion– It reiterates the timely news included in the memo.

 

3.     
Finalize document– Proof-read carefully!

ü 

Audience appropriate

ü  Concise

ü  Coherent

ü  Readability

ü  Terminology

ü  Factual Tone

ü  Appearance

       

2

>Heads and

Salary

by

Manager Manager

,

,

1 $26,000.00

g

,

1

,

00.00

,

1

5,

0.00

,

1

,

1

,

1

,

1

,

1 $26,000.00

,

1

8

1

,300.00

,

1

,

1

,

1

,

1

5

Total

,

Software Analyst

,

1

,

1

,

1

,

1

,

1

,

1

,

1

Software Analyst Total 7

Total

7 $65,642.86

,

Customer Service Representative

,

1

,

1

, Jack

1

,

1

,100.00

,

1

, Jack

1

,

1

,

1

, Joe

1

,

1

,

1

,

1

Customer Service Representative Total

Total

12 $40,458.33

33

Data

Job Title

Full Name

Count of Full Name

Average of Salary

Ku

Wah

Administrative Assistant

Yin

Miao

1

$26,000.00

Administrative Assistant

Total

Customer Service Representative

Chan

Kathy

$2

8

5

Chow

James

$

3

20

Hong

Ping

$24,900.00

Linh

Mai

$34,000.00

Otega

Jack

$30,000.00

Pan

Lo

$40,000.00

Park

Ria

Shen

Egg

$45,000.00

Customer Service Representative Total

$32,950.00

Software Analyst

Chan,

Ben

$4

7

Chi

Wang

$78,000.00

Chon

Janice

$69,000.00

Kang

Raj

$54,000.00

Lee

Eddie

$61,000.00

Software Analyst Total

$61,860.00

Ku, Wah

14

$42,778.57

Sharpe

Nina

Atwood

Leonard

$80,000.00

Farell

Matthew

$73,700.00

Law

Grace

$52,100.00

Liteman

Cal

$77,700.00

Sumner

Charles

$51,000.00

Turner

Joe

$75,000.00

Webster

Derek

$50,000.00

$65,642.86

Sharpe, Nina

Wicks

S.W.

Barber

Sam

$43,700.00

Bowman

Michael

$49,600.00

Burton

$37,000.00

Emerson

Louis

$

39

Gabriel

Thomas

$54,700.00

Galagher

$37,700.00

Hale

Catherine

$36,000.00

Hayden

Vernon

$25,000.00

Higgins

$38,000.00

Looker

Ely

$51,900.00

Ruiz

Marisa

$28,000.00

Walker

Jeremy

$44,800.00

12

$40,458.

33

Wicks, S.W.

Grand Total

$46,784.85

Heads by Job Description Pie

Job Title Total
Administrative Assistant 2
Customer Service Representative 20

1

Manager 3

1

Software Analyst 12
Grand Total 39

Count of Job Title
		Finance
		Office Manager

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

Full Name

Job Title

Salary Manager

Miao Yin

Administrative Assistant

Ku, Wah

lian

Administrative Assistant Hourly

, Gil

Gil Joubert

Seattle, Washington

Jack Otega

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Mai Linh

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Kathy Chang

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Ria Park

Kobe, Japan Customer Service Representative Hourly $ 26,000.00 Ku, Wah

Ping Hong

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

James Chow

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Lo Pan

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Egg Shen

Kobe, Japan Customer Service Representative Hourly

Ku, Wah

Catherine Hale

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Joe Higgins

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Sam Barber

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Jack Galagher

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Vernon Hayden

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Marisa Ruiz

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Thomas Gabriel

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Michael Bowman

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Louis Emerson

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Jeremy Walker

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Ely Looker

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Jack Burton

Seattle, Washington Customer Service Representative Hourly

Wicks, S.W.

Seattle, Washington Finance Salaried

Joubert, Gil

Wah Ku Ku, Wah Kobe, Japan Manager Salaried

Joubert, Gil

S.W. Wicks Wicks, S.W. Seattle, Washington Manager Salaried

Joubert, Gil

Nina Sharpe Sharpe, Nina Seattle, Washington Manager Salaried

Joubert, Gil

Seattle, Washington Office Manager Salaried

Joubert, Gil

Janice Chon

Kobe, Japan Software Analyst Salaried

Ku, Wah

Raj Kang

Kobe, Japan Software Analyst Salaried

Ku, Wah

Ben Chan

Kobe, Japan Software Analyst Salaried

Ku, Wah

Wang Chi

Kobe, Japan Software Analyst Salaried

Ku, Wah

Eddie Lee

Kobe, Japan Software Analyst Salaried

Ku, Wah

Joe Turner

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Leonard Atwood

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Derek Webster

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Matthew Farell

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Charles Sumner

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Cal Liteman

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

Grace Law

Seattle, Washington Software Analyst Salaried

Sharpe, Nina

First	Last	Location	Type
Yin, Miao															Kobe, Japan																						Hourly		$ 26,000.00
	Gil	Forster	Forster, Gillian																									Seattle, Washington	$ 27,500.00		Joubert
					Joubert, Gil	CEO																		Salaried	$ 125,000.00
Otega, Jack	$ 30,000.00
Linh, Mai	$ 34,000.00
Chang, Kathy	$ 28,500.00
Park, Ria
Hong, Ping	$ 24,900.00
Chow, James	$ 35,200.00
Pan, Lo	$ 40,000.00
Shen, Egg	$ 45,000.00
Hale, Catherine	$ 36,000.00
Higgins, Joe	$ 38,000.00
Barber, Sam	$ 43,700.00
Galagher, Jack	$ 37,700.00
Hayden, Vernon	$ 25,000.00
Ruiz, Marisa	$ 28,000.00
Gabriel, Thomas	$ 54,700.00
Bowman, Michael	$ 49,600.00
Emerson, Louis	$ 39,100.00
Walker, Jeremy	$ 44,800.00
Looker, Ely	$ 51,900.00
Burton, Jack	$ 37,000.00
William	Bell	Bell, William	$ 111,000.00
$ 79,000.00
$ 84,000.00
$ 88,000.00
Jon	MacKlane	MacKlane, Jon	$ 63,000.00
Chon, Janice	$ 69,000.00
Kang, Raj	$ 54,000.00
Chan, Ben	$ 47,300.00
Chi, Wang	$ 78,000.00
Lee, Eddie	$ 61,000.00
Turner, Joe	$ 75,000.00
Atwood, Leonard	$ 80,000.00
Webster, Derek	$ 50,000.00
Farell, Matthew	$ 73,700.00
Sumner, Charles	$ 51,000.00
Liteman, Cal	$ 77,700.00
Law, Grace	$ 52,100.00