Answered: Fill up the table attached. b.…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Assign the 4 departments in Table X to locations A, B, C, and D, which are separated by the distances shown in Table y, in such a way that transportation cost is minimized. Use this heuristic: assign departments with the greatest interdepartmental workflow first.

See attached table.

a.Fill up the table attached.

b. Compute the total transportation cost if the cost to move one workload 1 meter apart is P5.00.

Table X
Distance Between Locations (Meters)
From
A
B
C
D
A
25
15
45
To: Location
B
25
20
30
C
15
20
50
D
45
30
50
-
Table Y
Interdepartmental Work Flow (Loads/Day)
From
1
2
3
4
1
15
10
50
To: Department
2
45
20
60
3
20
35
-
55
4
30
40
70

Departments: Number of Loads
to:
:
1
2
3
4
:
:
:
Location
Distance to:
:
:
:
:
:
:
:
:
:
:
Total of Loads X Distance =
Loads X Distance
X
X
X
X
XXX
X
X
X
X
X
=
||
II
|||||
=
=
=
=

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Illustrate the configuration of the 4 departments in each of the 4 locations. Show the distances between departments and total interdepartmental workflows of department pairs

Solution