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