Question

In: Statistics and Probability

New Offices at Atlantic Management Systems Atlantic Management Systems is a consulting firm that specializes in...

New Offices at Atlantic Management Systems

Atlantic Management Systems is a consulting firm that specializes in developing computerized decision support systems for computer manufacturing companies. The firm currently has offices in Chicago, Charlotte, Pittsburgh, and Houston. It is considering opening new offices in one or more cities – including Atlanta, Boston, Washington, DC, St. Louis, Miami, Denver, and Detroit – and it has $14 million available for this purpose. Because of the highly specialized nature of its high-tech consulting work, the firm must necessarily staff any new offices with a minimum number of its employees from its existing offices. However, it has a limited number of employees available to transfer to any new offices. In addition, the cost of transferring employees depends on the city they are leaving and the city to which they might move.

Following are the costs for opening a new office in each of the prospective cities and the start-up staffing needs at each office:

Prospective Office

Setup Cost ($1,000,000s)

Staffing Needs (employees)

1. Atlanta

$1.7

9

2. Boston

3.6

14

3. Denver

2.1

8

4. Detroit

2.5

12

5. Miami

3.1

11

6. St. Louis

2.7

7

7. Washington, DC

4.1

18

The numbers of employees available for transfer from e

ach of the current offices are as follows:

Existing Office

Available Employees

Chicago

24

Charlotte

19

Pittsburgh

16

Houston

21

Existing Office (below)

1. Atlanta

2. Boston

3. Denver

4. Detroit

5. Miami

6. St. Louis

7. Washington, DC

1. Chicago

$19

$32

$27

$14

$23

$14

$41

2. Charlotte

14

47

31

28

35

18

53

3. Pittsburgh

16

39

26

23

31

19

48

4. Houston

22

26

21

18

28

24

43

The above table contains costs (in thousands of dollars) of transferring an employee from an existing office to a new office. The costs differ according to housing costs and moving expenses plus cost of living adjustments.

The firm has ranked the possible new offices according to their profit potential, with Washington, DC, being the best (i.e., greatest potential), as follows:

New Office

Rank

Washington, DC

1

Miami

2

Atlanta

3

Boston

4

Denver

5

St. Louis

6

Detroit

7

In addition, the firm wants at least one new office in the Midwest (i.e., Detroit and/or St. Louis) and one new office in the Southeast (i.e., Atlanta or Miami). Atlantic’s top management is wondering which NEW offices to open, and where from/to and how many employees should be transferred, based on the above information.

Now, please prepare a managerial report with the following General Format:

A managerial report should be prepared and should be easily understood by the general recipients of the report (supervisors, COO, CEO, clients, etc.)

The report should include:

An executive summary (a short description of the case, alternatives considered, recommendations based on different objectives and a final recommendation)

A network diagram showing the connections and respective costs between the origins and destinations.

A short description of key assumptions used in the model / analysis

Integer Linear Programming (ILP) model formulation including defining all decision variables. You would need to formulate an Integer Linear Programming model to solve this office opening and employee transferring problem.

Narrative discussion explaining the ILP model, alternatives considered, brief analysis and discussions on what if questions Q1 – Q6 below:

A schedule showing how many new offices it should open, where they should be located, and how to transfer employees.

How would the result change if an additional $2 million were added to the budget?

Independent of Q2, suppose that due to NBA Championship this year, the setup cost in Miami has increased by 10%. What would be the result then?

In addition to Q3, suppose that the ranks of profit potential of Miami and Atlanta are exchanged (Potential customers in Miami are moving from computer manufacturing consulting to professional basketball consulting…). What would be the result then?

Independent of Q2 – Q4, discuss how would the result change if both employees available and staffing needs are doubled simultaneously?

Independent of Q2 – Q5, how would the result change if the objective of the firm was to minimize the cost?

Printouts of the optimal solution obtained by using Excel. Include printouts from various alternatives/objectives considered

Solutions

Expert Solution


Related Solutions

THE CASE: Kaizer Consulting Kaizer Consulting is an international management consulting firm that specializes in business...
THE CASE: Kaizer Consulting Kaizer Consulting is an international management consulting firm that specializes in business strategy and serves as a key advisor to the world’s leading companies. It provides its clients with the unique insight to drive critical decision-making and solve their most pressing problems. Every year, the majority of Kaizer’s business comes from clients with whom they have worked in the previous year – an indicator of Kaizer’s ability to achieve lasting results for its clients. Kaizer’s client...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis.
  Exercise 6-16 Working with a Segmented Income Statement; Break-Even Analysis [LO6-4, LO6-5] Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given:       Office   Total Company   Chicago   Minneapolis Sales...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 412,500 100.0 % $ 82,500 100 % $ 330,000 100 % Variable expenses 222,750 54.0 % 24,750 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 637,500 100.0 % $ 127,500 100 % $ 510,000 100 % Variable expenses 344,250 54.0 % 38,250 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given Office Total Company Chicago Minneapolis Sales $ 562,500 100.0 % $ 112,500 100 % $ 450,000 100 % Variable expenses 303,750 54.0 % 33,750 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 492,000 100 % $ 171,000 100 % $ 321,000 1 % Variable expenses 253,000 50 % 59,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Assume that Minneapolis’ sales by major market are: Market Minneapolis Medical Dental Sales $ 330,000 100 % $ 220,000 100 % $ 110,000 100 %...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 450,000 100 % $ 150,000 100 % $ 300,000 100 % Variable expenses 225,000 50 % 45,000 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 825,000 100.0 % $ 165,000 100 % $ 660,000 100 % Variable expenses 445,500 54.0 % 49,500 30...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and...
Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices—one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company’s most recent year is given: Office Total Company Chicago Minneapolis Sales $ 1,050,000 100.0 % $ 210,000 100 % $ 840,000 100 % Variable expenses 567,000 54.0 % 63,000 30...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT