You are not logged in.
Pages: 1
Hello mathematicians,
Does anyone know how to solve a problem like this on excel?
There are six gambling departments, each is to be housed in one of six locations
P, A, M, C, F, T.
The distances between each house is as follows:
P A M C F T
P 10.6 7.1 8.6 9.4 8.1
A 10.6 7 2.4 1.9 2.6
M 7.1 7 4.3 4.3 5.3
C 8.6 2.4 4.3 6.7 2.5
F 9.4 1.9 4.3 6.7 2.1
T 8.1 2.6 5.3 2.5 2.1
The volumes of paperwork flowing each week from each department to every other are as follows. The unit of measurement is the number of departmental vans the documents would fill.
HORSES DOGS SLOT MAC LOTTERY CASINO INT. BETT
HORSES 22 16 41 12 18
DOGS 3 8 7 1 5
SLOT MAC 4 7 5 5 20
LOTTERY 26 17 18 16 17
CASINO 18 15 21 8 15
INT. BETT 4 13 5 14 19
Find where each department should be allocated whilst minimising cost (i.e. minimising distance)
Would really appreciate any help. Thanks!
J
Offline
Pages: 1