Consulting Problem - Statistics
Autor: MrDorakon . • October 24, 2017 • Coursework • 1,929 Words (8 Pages) • 540 Views
Question:
You are provided data on all the engagements for a consulting firm with offices in Toronto, Montreal, and Ottawa. The owners of the firm have noticed that they are losing money on certain engagements that they are undertaking. The firm was set up 50 years ago and has not changed its process, and they are outdated and inefficient. When the firm was set up it was organized with 1 Managing Director (MD) per area in Canada, and each MD was responsible for all the business in the area, no matter what their specialty was. The company is willing to reorganize and wonders if it should allocate MDs by specialty. Given modern transportation and communication networks, the company is confident that costs will not change if consultants based in one city start working in other cities. Use the data set to develop recommendations on how they can increase profitability within the firm.
The company works on four types of projects, and has the following price list for the specific types of projects.
Project No. | Type | Price Tag |
1 | Marketing | $600,000 |
2 | Operations | $500,000 |
3 | Finance | $800,000 |
4 | Human Resource | $300,000 |
In addition, below is a list of all the Managing Directors at the firm, how many years they have been with the firm, their specialty, rate per week, and where they work out of.
Employee
ID Name
Years with
Firm Specialty
Pay Rate per
Headquartered
_ Week _
14653 | Tom | 7 | Finance | 3 | $4,400.00 | Toronto |
14654 | Mary | 10 | Human Resources | 4 | $5,000.00 | Montreal |
14655 | Cathy | 2 | Finance | 3 | $3,400.00 | Ottawa |
14656 | Brian | 8 | Marketing | 1 | $4,600.00 | Montreal |
14657 | Gary | 21 | Operations | 2 | $7,200.00 | Ottawa |
14658 | Alex | 1 | Marketing | 1 | $3,200.00 | Toronto |
...