Question: *(COMPLETED IN A EXCEL FORMAT PLEASE)* A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III)

*(COMPLETED IN A EXCEL FORMAT PLEASE)*

  1. A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be $.40 per load per meter moved. An analyst has prepared the following distances and flow matrices:

Distance (meters) Flows (loads per week)

From/To I II III From/To X Y Z

I - 20 40 X - 100 80

II - 10 Y 70 - 120

III - Z 80 60 -

In what areas, I, II, and III, should departments X, Y, and Z be located that minimize the total cost of moving loads over the distance? (Identify assignments and total cost)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize nterdepartmental transportation costs, which are expected to be...

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

HW 2 Part 2- Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one...

Q:

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one excel file...

Q:

A company needs to locate three departments (X. Y, and Z) in the three areas (I, II and II) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

The company needs to locate three departments X, Y, and Z in the three areas l, ll, and lll of a new facility. They want to minimize inter-departmental transportation costs, which are expected to be...

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II, and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

A company needs to locate three departments (X, Y, and Z) in the three areas (I, II and III) of a new facility. They want to minimize interdepartmental transportation costs, which are expected to be...

Q:

Below is a data cube report that is available to end-user with sales figures. Identify Dimensions, Facts and Data Hierarchies What typical columns/fields can you think of the Dimensions and Facts...

Q:

1. Advise Leicester Ltd on how it can reduce its corporation tax liability by claiming rollover relief, outlining the conditions that apply, any time limits that should be adhered to, and the...

Q:

Matt, an individual, owned a nonbusiness debt that became partially worthless during the 2 0 2 3 tax year. He finally settled the debt in 2 0 2 4 . He will not be allowed any deduction on his 2 0 2 3...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...