Memo Case
Essay by Sharon • January 15, 2013 • Study Guide • 229 Words (1 Pages) • 1,435 Views
MEMO
To: Gil Joubert
From: Sharon Williams
Date: August 11, 2012
Re: Company Merger
Message:
Dear Mr. Joubert -
Attached below you will find a workbook detailing the merger between our two companies Washington office and Kobe, Japan.
This workbook is divided into 5 sheets labeled:
* Phase 4 Data
* Heads and Salary by Manager
* Head Count by Job Title
* Head by Job Title Pie
* DB Calculations
On the Head and Salary by Manager Sheet, it will show the salary data and we have 33 employees, 3 managers and average of salary, with customer service representative making $32,950 and software analyst $ 65,643.
Phase 4 data contains information on both companies with names and salary listed. Head count by job title pie chart contains 39 employees total and 20 of them are customer service representatives and 6 different job titles.
I also calculated the figures below for your plan; I can up with 2 options for you. The money that is needed for your plan is $ 56,813.51 that can be 1 lump total or split into two payments it is located in option 1 or option 2 where you could deposit $ 2,590.80 every month. You can find this information that is located in DB Calculations section of the spreadsheet.
Thank You,
Sharon Williams
...
...