Spreadsheet: 57946d1258168998-finding-optimal-combination-in-a-matrix-blockdiagram
Sheet: Sheet2

 | Work Area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Converted to Alpha. To distinguish between values
1 | Injection Molding Area |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |  | Optimal Combination
2 | Extrusion Blow Molding Area |  |  |  | 1 | E | U | A | U | U | E | E | E | A | U | U | U | U | E | U | A |  | A | 1 | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 2 |  | D | J | Q | B
3 | Wire Bending Area |  |  |  | 2 |  | U | A | U | U | E | E | E | A | U | U | U | U | E | U | A |  | B |  | 0 | 2 | 0 | 0 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 2
4 | Assembly Lines |  |  |  | 3 |  |  | A | U | U | E | E | E | A | U | U | U | U | E | X | U |  | C |  |  | 2 | 0 | 0 | 1 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | -1 | 0
5 | Shipping |  |  |  | 4 |  |  |  | A | U | A | E | E | E | U | U | U | E | E | U | U |  | D |  |  |  | 2 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0
6 | Receiving |  |  |  | 5 |  |  |  |  | U | A | E | E | U | U | U | U | A | U | U | U |  | E |  |  |  |  | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
7 | Warehouse & Storage |  |  |  | 6 |  |  |  |  |  | A | U | U | U | U | U | U | A | U | U | U |  | F |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
8 | QA Department |  |  |  | 7 |  |  |  |  |  |  | U | U | U | U | U | U | A | U | U | U |  | G |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
9 | Manufacturing Engineering Department |  |  |  | 8 |  | Value |  |  |  |  |  | E | U | U | U | U | U | E | U | U |  | H |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
10 | Tool Room |  |  |  | 9 |  | A | E | U | X |  |  |  | E | U | U | U | U | U | U | U |  | I |  | Converted to value |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | Maintenance |  |  |  | 10 |  | 2 | 1 | 0 | -1 |  |  |  |  | E | U | U | U | U | U | U |  | J |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
12 | Employee Entrance & Locker Rooms |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  | U | U | E | U | U | U |  | K |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 0 | 0 | 0
13 | Cafeteria |  |  |  | 12 |  | A= | Absolutly Necessary |  |  |  |  |  |  |  |  | A | U | U | U | U |  | L |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0
14 | Forklift Area |  |  |  | 13 |  | E= | Extremely Necessary |  |  |  |  |  |  |  |  |  | X | U | E | U |  | M |  |  |  |  |  |  |  |  |  |  |  |  | -1 | 0 | 1 | 0
15 | Production Offices |  |  |  | 14 |  | U= | Necessary |  |  |  |  |  |  |  |  |  |  | U | U | U |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
16 | Front Offices |  |  |  | 15 |  | X= | Don’t Associate |  |  |  |  |  |  |  |  |  |  |  | A | U |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0
17 | Plastic Material Staging Area |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U |  | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q
 | RED = A
 | GREEN = E |  |  | Find Optimal Solution
 | BLACK = X |  |  | With Lowest Distance