Proyecto Logistica.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Proyecto Logistica.xlsx as PDF for free.
More details
- Words: 2,369
- Pages: 13
Producto
Demanda de productos Cliente
Demanda/Mes
Refrigerante 1 concentrado al 40 %
Terpel GNV, El Tejar, La Naveta, Cajicá, Cundinamarca
5
Refrigerante 2 concentrado al 50 %
EDS CASABLANCA CAJICA, La Naveta, Cra. 6 #6-75, Cajicá, Cundinamarca
2
Refrigerante en 3 tambor
Texsa, El Tejar, Cajicá, Cundinamarca
4
Refrigerante 4 anticorrosivo
Brío Sol Oíl, El Tejar, La Naveta, Cajicá, Cundinamarca
5
Estación de Servicio Petrobras el Retorno, Chía, Cundinamarca
1
Texaco, Zipaquirá, Cundinamarca
3
Refrigerante en 5 tambor
Cajicá
Chía
Refrigerante 6 concentrado al 50 % Refrigerante 7 concentrado al 50 %
Zipaquirá Esso, Cra. 7 #9-19, Zipaquirá,
Cundinamarca
4
Refrigerante 8 concentrado al 40 %
Texaco, Zipaquirá, Cundinamarca
5
Refrigerante 9 concentrado al 40 %
Esso los Cerros, Cogua, Cundinamarca
5
Refrigerante 10 En tambor Refrigerante 11 concentrado al 50 %
Cogua
Tocancipá
Biomax, Cogua, Cundinamarca Terpel HCM Tocancipá, La CaroTocancipá, Tocancipá, Cundinamarca
1 6 41
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
3 15.9 11.4 5.6 6.2 20.7 8 7.6 6.5 10.8 12.7 18.6
Distancia Euclidiana 4 5 6 15 29.5 1.2 10.4 11.6 19.2 4.6 19.1 13.4 6.2 20.7 8 21.6 8.8 21.6 19.4 8.8 19.4 8.4 19 2.7 7.4 17.9 1.5 11.6 22.2 2.9 13.5 24.1 4.8 19.5 13 14
7 3.2 18.8 13 7.6 8.4 19 2.7 3.7 4.9 6.8 15.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
Cliente Demanda Ruta 1 Distancia Demanda Ruta 2 Distancia Demanda Ruta 3 Distancia Demanda Ruta 4 Distancia Demanda
1 5
2 2
3 4
0
6 1.2 3
8 2.7 8
0
10 3 2 0 5.1 17.8 23.4 37.1 1 5 7
0
11 5 0 12.8 25.8 55.3 6 7
0
4 15 5
4 5
5 1
6 3
7 9 0 6.4 11.3 13.8 12 17
1 0 25.4 44.3 10
7 4
8 5
9 5
10 1
11 6
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
Distancia Euclidiana 3 4 5 6 7 15.9 15 29.5 1.2 3.2 11.4 10.4 11.6 19.2 18.8 5.6 4.6 19.1 13.4 13 6.2 20.7 8 7.6 6.2 - 21.6 8.8 8.4 20.7 21.6 - 19.4 19 8 8.8 19.4 2.7 7.6 8.4 19 2.7 6.5 7.4 17.9 1.5 3.7 10.8 11.6 22.2 2.9 4.9 12.7 13.5 24.1 4.8 6.8 18.6 19.5 13 14 15.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
Cliente Demanda
1 5
2 2
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
3 4
4 5
5 1
6 3
7 4
8 5
9 5
10 1
11 6
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
0 1 2 3 4 5 6 7 8 9 10 11
0 18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
1 18.9 23.3 23.4 23.5 36.8 0.9 3.3 3.6 -0.6 0.1 13.9
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
Distancia Euclidiana 3 4 5 6 7 15.9 15 29.5 1.2 3.2 11.4 10.4 11.6 19.2 18.8 5.6 4.6 19.1 13.4 13 6.2 20.7 8 7.6 6.2 - 21.6 8.8 8.4 20.7 21.6 - 19.4 19 8 8.8 19.4 2.7 7.6 8.4 19 2.7 6.5 7.4 17.9 1.5 3.7 10.8 11.6 22.2 2.9 4.9 12.7 13.5 24.1 4.8 6.8 18.6 19.5 13 14 15.8
2 13.7 23.3 24 24.1 24.1 1.5 3.9 4.3 0 0.7 8.3
Matriz de ahorros 4 5 6 15 29.5 1.2 23.5 36.8 0.9 24.1 24.1 1.5 24.7 24.7 9.1 - 22.9 7.4 22.9 - 11.3 7.4 11.3 9.8 13.7 1.7 10.1 14.1 2.2 5.9 9.8 0.8 6.6 10.5 1.5 8.3 29.3 0
3 15.9 23.4 24 24.7 24.7 9.1 11.5 11.9 7.6 8.3 10.1
36.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
7
8
9
3.2 3.3 3.9 11.5 9.8 13.7 1.7 2 0.8 1.5 0.2
2.5 3.6 4.3 11.9 10.1 14.1 2.2 2 0.7 1.4 2.7
10 5.1 0.1 0.7 8.3 6.6 10.5 1.5 1.5 1.4 5.7 -0.8
11 12.8 13.9 8.3 10.1 8.3 29.3 0 0.2 2.7 -1.5 -0.8 -
2.5 -0.6 0 7.6 5.9 9.8 0.8 0.8 0.7 5.7 -1.5
Cliente Demanda
1
Ruta 1 Distancia Demanda
0
5
Ruta 2 Distancia Demanda
0
Ruta 3 Distancia Demanda
0
Ruta 4 Distancia Demanda
0
2
3 2
4 4
5 5
6 1
7 3
1 5 0 18.9 30.5 60 5 6 3 4 8 2 0 15.9 22.1 29.5 41.4 55.1 4 9 14 16 9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 10
8 4
9 5
10 5
11 1
6
Distancia Euclidiana 0 1 2 3 4 5 6 7 8 9 10 11 018.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8 1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8 2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2 3 15.9 11.4 5.6 6.2 20.7 8 7.6 6.5 10.8 12.7 18.6 4 15 10.4 4.6 6.2 21.6 8.8 8.4 7.4 11.6 13.5 19.5 5 29.5 11.6 19.1 20.7 21.6 19.4 19 17.9 22.2 24.1 13 6 1.2 19.2 13.4 8 8.8 19.4 2.7 1.5 2.9 4.8 14 7 3.2 18.8 13 7.6 8.4 19 2.7 3.7 4.9 6.8 15.8 8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6 9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8 10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7 11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 Matriz de ahorros 0 1 2 3 4 5 6 7 8 018.9 13.7 15.9 15 29.5 1.2 3.2 2.5 1 18.9 23.3 23.4 23.5 36.8 0.9 3.3 3.6 2 13.7 23.3 24 24.1 24.1 1.5 3.9 4.3 3 15.9 23.4 24 24.7 24.7 9.1 11.5 11.9 4 15 23.5 24.1 24.7 22.9 7.4 9.8 10.1 5 29.5 36.8 24.1 24.7 22.9 11.3 13.7 14.1 6 1.2 0.9 1.5 9.1 7.4 11.3 1.7 2.2 7 3.2 3.3 3.9 11.5 9.8 13.7 1.7 2 8 2.5 3.6 4.3 11.9 10.1 14.1 2.2 29 2.5 -0.6 0 7.6 5.9 9.8 0.8 0.8 0.7 10 5.1 0.1 0.7 8.3 6.6 10.5 1.5 1.5 1.4 11 12.8 13.9 8.3 10.1 8.3 29.3 0 0.2 2.7
9 10 11 2.5 5.1 12.8 -0.6 0.1 13.9 0 0.7 8.3 7.6 8.3 10.1 5.9 6.6 8.3 9.8 10.5 29.3 0.8 1.5 0 0.8 1.5 0.2 0.7 1.4 2.7 5.7 -1.5 5.7 -0.8 -1.5 -0.8 -
Cliente Demanda
1 5
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
2 2
3 4
4 5
5 1
6 3
7 4
8 5
9 5
10 1
11 6
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
Demanda de productos Cliente
Demanda/Mes
Refrigerante 1 concentrado al 40 %
Terpel GNV, El Tejar, La Naveta, Cajicá, Cundinamarca
5
Refrigerante 2 concentrado al 50 %
EDS CASABLANCA CAJICA, La Naveta, Cra. 6 #6-75, Cajicá, Cundinamarca
2
Refrigerante en 3 tambor
Texsa, El Tejar, Cajicá, Cundinamarca
4
Refrigerante 4 anticorrosivo
Brío Sol Oíl, El Tejar, La Naveta, Cajicá, Cundinamarca
5
Estación de Servicio Petrobras el Retorno, Chía, Cundinamarca
1
Texaco, Zipaquirá, Cundinamarca
3
Refrigerante en 5 tambor
Cajicá
Chía
Refrigerante 6 concentrado al 50 % Refrigerante 7 concentrado al 50 %
Zipaquirá Esso, Cra. 7 #9-19, Zipaquirá,
Cundinamarca
4
Refrigerante 8 concentrado al 40 %
Texaco, Zipaquirá, Cundinamarca
5
Refrigerante 9 concentrado al 40 %
Esso los Cerros, Cogua, Cundinamarca
5
Refrigerante 10 En tambor Refrigerante 11 concentrado al 50 %
Cogua
Tocancipá
Biomax, Cogua, Cundinamarca Terpel HCM Tocancipá, La CaroTocancipá, Tocancipá, Cundinamarca
1 6 41
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
3 15.9 11.4 5.6 6.2 20.7 8 7.6 6.5 10.8 12.7 18.6
Distancia Euclidiana 4 5 6 15 29.5 1.2 10.4 11.6 19.2 4.6 19.1 13.4 6.2 20.7 8 21.6 8.8 21.6 19.4 8.8 19.4 8.4 19 2.7 7.4 17.9 1.5 11.6 22.2 2.9 13.5 24.1 4.8 19.5 13 14
7 3.2 18.8 13 7.6 8.4 19 2.7 3.7 4.9 6.8 15.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
Cliente Demanda Ruta 1 Distancia Demanda Ruta 2 Distancia Demanda Ruta 3 Distancia Demanda Ruta 4 Distancia Demanda
1 5
2 2
3 4
0
6 1.2 3
8 2.7 8
0
10 3 2 0 5.1 17.8 23.4 37.1 1 5 7
0
11 5 0 12.8 25.8 55.3 6 7
0
4 15 5
4 5
5 1
6 3
7 9 0 6.4 11.3 13.8 12 17
1 0 25.4 44.3 10
7 4
8 5
9 5
10 1
11 6
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
Distancia Euclidiana 3 4 5 6 7 15.9 15 29.5 1.2 3.2 11.4 10.4 11.6 19.2 18.8 5.6 4.6 19.1 13.4 13 6.2 20.7 8 7.6 6.2 - 21.6 8.8 8.4 20.7 21.6 - 19.4 19 8 8.8 19.4 2.7 7.6 8.4 19 2.7 6.5 7.4 17.9 1.5 3.7 10.8 11.6 22.2 2.9 4.9 12.7 13.5 24.1 4.8 6.8 18.6 19.5 13 14 15.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
Cliente Demanda
1 5
2 2
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
Ruta Distancia Demanda
0
6 1.2 3
3 4
4 5
5 1
6 3
7 4
8 5
9 5
10 1
11 6
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
8 2.7 8
7 9 0 6.4 11.3 13.8 12 17
10 3 2 0 11 5 0 5.1 17.8 23.4 37.1 12.8 25.8 55.3 1 5 7 6 7
4 1 0 15 25.4 44.3 Total 5 10
150.5
0 1 2 3 4 5 6 7 8 9 10 11
0 18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
0 0 1 2 3 4 5 6 7 8 9 10 11
18.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8
1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8
1 18.9 23.3 23.4 23.5 36.8 0.9 3.3 3.6 -0.6 0.1 13.9
2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2
Distancia Euclidiana 3 4 5 6 7 15.9 15 29.5 1.2 3.2 11.4 10.4 11.6 19.2 18.8 5.6 4.6 19.1 13.4 13 6.2 20.7 8 7.6 6.2 - 21.6 8.8 8.4 20.7 21.6 - 19.4 19 8 8.8 19.4 2.7 7.6 8.4 19 2.7 6.5 7.4 17.9 1.5 3.7 10.8 11.6 22.2 2.9 4.9 12.7 13.5 24.1 4.8 6.8 18.6 19.5 13 14 15.8
2 13.7 23.3 24 24.1 24.1 1.5 3.9 4.3 0 0.7 8.3
Matriz de ahorros 4 5 6 15 29.5 1.2 23.5 36.8 0.9 24.1 24.1 1.5 24.7 24.7 9.1 - 22.9 7.4 22.9 - 11.3 7.4 11.3 9.8 13.7 1.7 10.1 14.1 2.2 5.9 9.8 0.8 6.6 10.5 1.5 8.3 29.3 0
3 15.9 23.4 24 24.7 24.7 9.1 11.5 11.9 7.6 8.3 10.1
36.8
8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6
9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8
10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7
11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 -
7
8
9
3.2 3.3 3.9 11.5 9.8 13.7 1.7 2 0.8 1.5 0.2
2.5 3.6 4.3 11.9 10.1 14.1 2.2 2 0.7 1.4 2.7
10 5.1 0.1 0.7 8.3 6.6 10.5 1.5 1.5 1.4 5.7 -0.8
11 12.8 13.9 8.3 10.1 8.3 29.3 0 0.2 2.7 -1.5 -0.8 -
2.5 -0.6 0 7.6 5.9 9.8 0.8 0.8 0.7 5.7 -1.5
Cliente Demanda
1
Ruta 1 Distancia Demanda
0
5
Ruta 2 Distancia Demanda
0
Ruta 3 Distancia Demanda
0
Ruta 4 Distancia Demanda
0
2
3 2
4 4
5 5
6 1
7 3
1 5 0 18.9 30.5 60 5 6 3 4 8 2 0 15.9 22.1 29.5 41.4 55.1 4 9 14 16 9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 10
8 4
9 5
10 5
11 1
6
Distancia Euclidiana 0 1 2 3 4 5 6 7 8 9 10 11 018.9 13.7 15.9 15 29.5 1.2 3.2 2.5 2.5 5.1 12.8 1 18.9 9.3 11.4 10.4 11.6 19.2 18.8 17.8 22 23.9 17.8 2 13.7 9.3 5.6 4.6 19.1 13.4 13 11.9 16.2 18.1 18.2 3 15.9 11.4 5.6 6.2 20.7 8 7.6 6.5 10.8 12.7 18.6 4 15 10.4 4.6 6.2 21.6 8.8 8.4 7.4 11.6 13.5 19.5 5 29.5 11.6 19.1 20.7 21.6 19.4 19 17.9 22.2 24.1 13 6 1.2 19.2 13.4 8 8.8 19.4 2.7 1.5 2.9 4.8 14 7 3.2 18.8 13 7.6 8.4 19 2.7 3.7 4.9 6.8 15.8 8 2.5 17.8 11.9 6.5 7.4 17.9 1.5 3.7 4.3 6.2 12.6 9 2.5 22 16.2 10.8 11.6 22.2 2.9 4.9 4.3 1.9 16.8 10 5.1 23.9 18.1 12.7 13.5 24.1 4.8 6.8 6.2 1.9 18.7 11 12.8 17.8 18.2 18.6 19.5 13 14 15.8 12.6 16.8 18.7 Matriz de ahorros 0 1 2 3 4 5 6 7 8 018.9 13.7 15.9 15 29.5 1.2 3.2 2.5 1 18.9 23.3 23.4 23.5 36.8 0.9 3.3 3.6 2 13.7 23.3 24 24.1 24.1 1.5 3.9 4.3 3 15.9 23.4 24 24.7 24.7 9.1 11.5 11.9 4 15 23.5 24.1 24.7 22.9 7.4 9.8 10.1 5 29.5 36.8 24.1 24.7 22.9 11.3 13.7 14.1 6 1.2 0.9 1.5 9.1 7.4 11.3 1.7 2.2 7 3.2 3.3 3.9 11.5 9.8 13.7 1.7 2 8 2.5 3.6 4.3 11.9 10.1 14.1 2.2 29 2.5 -0.6 0 7.6 5.9 9.8 0.8 0.8 0.7 10 5.1 0.1 0.7 8.3 6.6 10.5 1.5 1.5 1.4 11 12.8 13.9 8.3 10.1 8.3 29.3 0 0.2 2.7
9 10 11 2.5 5.1 12.8 -0.6 0.1 13.9 0 0.7 8.3 7.6 8.3 10.1 5.9 6.6 8.3 9.8 10.5 29.3 0.8 1.5 0 0.8 1.5 0.2 0.7 1.4 2.7 5.7 -1.5 5.7 -0.8 -1.5 -0.8 -
Cliente Demanda
1 5
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
Ruta 1 Distancia Demanda
0
2 2
3 4
4 5
5 1
6 3
7 4
8 5
9 5
10 1
11 6
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
1 5 18.9 30.5 5 6
0 3 4 8 2 0 60 15.9 22.1 29.5 41.4 55.1 4 9 14 16
9 2.5 5
10 4.4 6
6 0 9.2 10.4 9
7 3.2 4
11 0 19 31.8 Total 10
157.3
Related Documents
Proyecto
June 2020 13
Proyecto
December 2019 31
Proyecto
May 2020 18
Proyecto
May 2020 17
Proyecto
June 2020 12
Proyecto
June 2020 18More Documents from ""
Proyecto Logistica.xlsx
April 2020 22
Mi_diario_de_gratitud.pdf
April 2020 9
