Research Article

Optimization of the Supply Chain in the Production of Ethanol from Agricultural Biomass Using Mixed-Integer Linear Programming (MILP): A Case Study

Table 1

Input parameters, (b= 1 corn biomass and b= 2 barley biomass).

SiteMunicipalityGrain yield from site for product , for Yields of biomass from site for product , for Hectares available for on-site cultivation for product at time
b=1b=2b=1b=2b=1b=2b=1b=2b=1b=2b=1b=2
t=1t=1t=2t=2t=1t=1t=2t=2t=1t=1t=2t=2

1Acatlán, HGO1.852.950.000.001.962.060.000.008173.00120.000.000.00
2Acaxochitlán, HGO2.402.800.000.002.541.960.000.007306.00115.000.000.00
3Actopan, HGO3.741.000.003.803.960.700.002.663860.00365.000.00259.00
4Agua Blanca de Iturbide, HGO1.600.000.000.001.690.000.000.002801.000.000.000.00
5Ajacuba, HGO4.603.000.003.804.872.100.002.666270.00544.000.00119.00
6Almoloya, HGO2.502.950.000.002.652.060.000.00670.008953.000.000.00
7Apan, HGO2.401.800.000.002.541.260.000.00800.0022856.000.000.00
8Atotonilco el Grande, HGO1.995.200.000.002.103.640.000.006826.4030.000.000.00
9Cuautepec de Hinojosa, HGO2.102.000.000.002.221.400.000.004717.0010790.000.000.00
10El Arenal, HGO4.451.800.000.004.711.260.000.001940.0045.000.000.00
11Emiliano Zapata, HGO2.202.150.000.002.331.500.000.00500.002181.000.000.00
12Epazoyucan, HGO1.580.800.000.001.660.560.000.00268.006952.000.000.00
13Francisco I. Madero, HGO5.433.000.003.805.752.100.002.662470.0060.000.00100.00
14Huasca de Ocampo, HGO1.931.450.000.002.041.010.000.006246.5085.000.000.00
15Huehuetla, HGO1.000.000.800.001.060.000.840.005100.000.001730.000.00
16Metepec, HGO1.581.600.000.001.661.120.000.005070.002120.000.000.00
17Metztitlán, HGO4.080.008.000.004.310.008.480.003680.000.00800.000.00
18Mineral de la Reforma, HGO2.802.250.004.002.961.570.002.80385.002575.000.0089.00
19Mineral del Chico, HGO2.031.100.000.002.140.770.000.001462.00136.000.000.00
20Mineral del Monte, HGO0.851.100.000.000.900.770.000.00370.0066.000.000.00
21Omitlán de Juárez, HGO1.081.000.000.001.140.700.000.001266.0063.000.000.00
22Pachuca de Soto, HGO1.800.900.000.001.900.630.000.0094.752760.000.000.00
23San Agustín Metzquititlán, HGO2.781.807.500.002.941.267.950.001800.0010.0068.000.00
24San Agustín Tlaxiaca, HGO2.402.000.000.002.541.400.000.00620.003964.000.000.00
25San Bartolo Tutotepec, HGO1.100.001.100.001.160.001.160.002215.000.001315.000.00
26San Salvador, HGO5.181.100.003.505.480.770.002.453250.0075.000.0055.00
27Santiago de Anaya, HGO4.931.100.003.505.220.770.002.452650.00105.000.0032.70
28Santiago Tulantepec, HGO2.052.700.000.002.171.890.000.002754.00308.000.000.00
29Singuilucan, HGO2.602.900.000.002.752.030.000.002397.0010809.000.000.00
30Tenango de Doria, HGO1.150.001.200.001.210.001.270.002759.000.00800.000.00
31Tepeapulco, HGO2.852.250.000.003.021.570.000.00761.007205.000.000.00
32Tianguistengo, HGO1.200.000.950.001.270.001.000.001220.000.00511.000.00
33Tizayuca, HGO3.502.300.000.003.711.610.000.001220.001068.200.000.00
34Tlanalapa, HGO1.852.150.000.001.961.500.000.00219.003340.000.000.00
35Tolcayuca, HGO2.430.900.000.002.570.630.000.00106.002905.000.000.00
36Tulancingo de Bravo, HGO2.501.800.000.002.651.260.000.005120.00210.000.000.00
37Villa de Tezontepec, HGO2.951.500.000.003.121.050.000.00480.002381.000.000.00
38Zacualtipán de Ángeles, HGO0.951.101.100.001.000.771.160.00612.0014.0088.000.00
39Zapotlán de Juárez, HGO2.341.000.000.002.480.700.000.00638.004357.000.000.00
40Zempoala, HGO2.001.000.000.002.120.700.000.002309.5013668.000.000.00
41Axapusco, MEX2.351.700.000.002.491.190.000.001320.009740.000.000.00
42Hueypoxtla, MEX2.931.700.000.003.101.190.000.006426.004200.000.000.00
43Nopaltepec, MEX1.301.800.000.001.371.260.000.00404.003381.000.000.00
44Otumba, MEX2.672.000.000.002.821.400.000.00990.004235.000.000.00
45San Martín de las Pirámides, MEX2.632.250.000.002.781.570.000.00618.3916.000.000.00
46Tecámac, MEX3.631.300.000.003.840.910.000.003971.002791.000.000.00
47Temascalapa, MEX1.281.850.000.001.351.290.000.001452.0010361.000.000.00
48Teotihuacán, MEX3.272.180.000.003.461.520.000.001995.0059.000.000.00
49Tepetlaoxtoc, MEX2.851.800.000.003.021.260.000.00969.001303.500.000.00
50Zumpango, MEX3.801.700.000.004.021.190.000.0010015.002382.000.000.00
51Ahuacatlán, PUE0.850.000.000.000.900.000.000.00976.000.000.000.00
52Ahuazotepec, PUE1.400.000.001.101.480.000.000.771240.000.000.00169.70
53Amixtlán, PUE0.870.001.080.000.910.001.140.00372.000.00223.000.00
54Aquixtla, PUE1.671.900.000.001.761.330.000.004336.4920.009.490.00
55Camocuautla, PUE0.970.002.100.001.030.002.220.00325.000.0075.000.00
56Chiconcuautla, PUE1.000.001.500.001.060.001.590.00857.000.00149.800.00
57Chignahuapan, PUE2.012.100.000.002.121.470.000.0012865.006800.000.000.00
58Coatepec, PUE0.880.001.060.000.930.001.120.00200.000.0068.000.00
59Cuautempan, PUE0.840.000.000.000.880.000.000.001197.000.000.000.00
60Hermenegildo Galeana, PUE1.000.001.700.001.060.001.800.00360.300.0080.000.00
61Honey, PUE1.900.001.700.002.010.001.800.002981.400.00535.000.00
62Huauchinango, PUE1.350.001.900.001.430.002.010.002136.500.00213.800.00
63Hueytlalpan, PUE0.700.001.150.000.740.001.210.00480.000.00435.000.00
64Huitzilan de Serdán, PUE0.700.001.000.000.740.001.060.00660.000.00310.000.00
65Ixtacamaxtitlán, PUE1.971.700.000.002.091.190.000.0011840.00565.000.000.00
66Jalpan, PUE1.400.001.800.001.480.001.900.00515.000.00348.000.00
67Jopala, PUE0.900.001.800.000.950.001.900.001411.000.00265.000.00
68Juan Galindo, PUE0.800.001.700.000.840.001.800.0035.000.0051.000.00
69Naupan, PUE0.800.001.700.000.840.001.800.00680.700.0067.300.00
70Olintla, PUE0.650.001.000.000.680.001.060.00750.000.00670.000.00
71Pahuatlán, PUE0.800.001.600.000.840.001.690.00341.000.0070.300.00
72Pantepec, PUE1.000.001.800.001.060.001.900.001215.000.00982.070.00
73San Felipe Tepatlán, PUE0.900.001.700.000.950.001.800.00258.000.0060.000.00
74Tepango de Rodríguez, PUE1.020.001.150.001.070.001.210.00194.000.0020.500.00
75Tepetzintla, PUE0.810.000.000.000.860.000.000.00960.000.000.000.00
76Tetela de Ocampo, PUE1.960.000.000.002.070.000.000.003288.000.000.000.00
77Tlacuilotepec, PUE0.800.001.700.000.840.001.800.00731.300.00312.000.00
78Tlaola, PUE0.800.001.500.000.840.001.590.00767.000.00380.200.00
79Tlapacoya, PUE0.900.001.800.000.950.001.900.00452.600.00204.500.00
80Tlaxco, PUE0.800.001.800.000.840.001.900.00446.000.00148.300.00
81Xicotepec, PUE0.900.001.900.000.950.002.010.001083.000.00279.300.00
82Xochitlán, PUE0.710.001.400.000.750.001.480.00720.000.00350.000.00
83Zacatlán, PUE1.551.800.000.001.631.260.000.0011244.500.000.500.00
84Zapotitlán de Méndez, PUE0.880.002.400.000.930.002.540.00500.000.0044.000.00
85Zihuateutla, PUE0.800.001.800.000.840.001.900.001106.700.00112.700.00
86Zongozotla, PUE0.750.001.000.000.790.001.060.00400.000.00130.000.00
87Atlangatepec, TLAX2.532.600.000.002.671.820.000.002025.002091.000.000.00
88Benito Juárez, TLAX2.482.100.000.002.621.470.000.00530.001601.000.000.00
89Calpulalpan, TLAX2.482.100.000.002.621.470.000.001335.009655.000.000.00
90Emiliano Zapata, TLAX2.902.300.000.003.071.610.000.00910.0030.000.000.00
91Españita, TLAX2.532.100.000.002.671.470.000.00666.004537.000.000.00
92Hueyotlipan, TLAX2.452.400.000.002.591.680.000.001235.004989.000.000.00
93Lázaro Cárdenas, TLAX4.502.300.000.004.771.610.000.00542.00119.000.000.00
94Muñoz de Domingo Arenas, TLAX2.762.500.000.002.921.750.000.00605.001110.000.000.00
95Nanacamilpa, TLAX2.652.100.000.002.801.470.000.00590.005059.000.000.00
96San Lucas Tecopilco, TLAX2.853.600.000.003.022.520.000.001436.00718.000.000.00
97Sanctórum, TLAX2.652.100.000.002.801.470.000.00400.002764.000.000.00
98Tetla de la Solidaridad, TLAX2.802.500.000.002.961.750.000.00460.006101.000.000.00
99Tlaxco, TLAX2.582.200.000.002.721.540.000.004396.0014264.000.000.00
100Xaltocan, TLAX2.953.600.000.003.122.520.000.003814.001120.000.000.00
101Benito Juárez, VER0.750.000.900.000.790.000.950.005200.000.004450.000.00
102Coahuitlán, VER1.820.001.600.001.920.001.690.001100.000.001070.000.00
103Coyutla, VER1.790.001.800.001.890.001.900.002750.000.002650.000.00
104Filomeno Mata, VER1.450.001.400.001.530.001.480.00350.000.00330.000.00
105Huayacocotla, VER1.400.951.201.101.480.661.270.774200.00255.0080.0088.00
106Ilamatlán, VER1.200.001.200.001.270.001.270.002200.000.00900.000.00
107Ixhuatlán de Madero, VER1.440.001.200.001.520.001.270.007050.000.005950.000.00
108Mecatlán, VER1.450.001.400.001.530.001.480.00800.000.00750.000.00
109Texcatepec, VER1.000.001.200.001.060.001.270.002200.000.00700.000.00
110Tlachichilco, VER1.360.001.000.001.440.001.060.002720.000.001075.000.00
111Zacualpan, VER1.300.001.200.001.370.001.270.001000.000.00215.000.00
112Zontecomatlán, VER1.200.001.200.001.270.001.270.004000.000.00990.000.00