Using this model The CFLP min fuxx + Exex 2,0/XjCu; KEK Subject to Vj E) (10) Exek tej = 1 Ej, Dikki S YRAK Vk EK (11) xkj 20 Vk EK, VEJ (12) (13) Y E{0,1} Vk EK Resolve this using EXCEL A Russian company produces cattle forage. In the province of Domedovsky, there are seven farms which have an average daily forage demand (in quintals) equal to 36, 42, 34, 50, 27, 30, and 43 respectively. The company intends to purchase some silos to supply the seven farms. Six different potential sites in the area have been identified, with a maximum daily forage capacity (expressed in quintals) equal to, respectively, 80, 90, 110, 120, 100, and 120. For the next four years, the company estimates the following fixed costs (in ): 321 420, 350 640, 379 860, 401 775, 350 640, and 336 030, respectively. The daily average marginal facility cost (in ) per quintal of forage, for each potential site is equal to 0.15,0.18, 0.20, 0.18, 0.15, and 0.17, respectively. The transport cost per quintal of forage and per kilometer travelled is equal to 0.06. The kilometric distances for each origin destination pair are shown in the table shown in next slide. Find the optimal strategy for purchasing silos to satisfy daily demand Farm 1 2 3 4 5 6 7 Potential Silo 1 18 23 19 21 24 17 9 2 21 18 17 23 11 18 20 3 27 18 17 20 23 9 18 4 16 23 9 31 21 23 10 5 31 18 19 10 17 18 20 17 6 18 29 21 22 18 8 Using this model The CFLP min fuxx + Exex 2,0/XjCu; KEK Subject to Vj E) (10) Exek tej = 1 Ej, Dikki S YRAK Vk EK (11) xkj 20 Vk EK, VEJ (12) (13) Y E{0,1} Vk EK Resolve this using EXCEL A Russian company produces cattle forage. In the province of Domedovsky, there are seven farms which have an average daily forage demand (in quintals) equal to 36, 42, 34, 50, 27, 30, and 43 respectively. The company intends to purchase some silos to supply the seven farms. Six different potential sites in the area have been identified, with a maximum daily forage capacity (expressed in quintals) equal to, respectively, 80, 90, 110, 120, 100, and 120. For the next four years, the company estimates the following fixed costs (in ): 321 420, 350 640, 379 860, 401 775, 350 640, and 336 030, respectively. The daily average marginal facility cost (in ) per quintal of forage, for each potential site is equal to 0.15,0.18, 0.20, 0.18, 0.15, and 0.17, respectively. The transport cost per quintal of forage and per kilometer travelled is equal to 0.06. The kilometric distances for each origin destination pair are shown in the table shown in next slide. Find the optimal strategy for purchasing silos to satisfy daily demand Farm 1 2 3 4 5 6 7 Potential Silo 1 18 23 19 21 24 17 9 2 21 18 17 23 11 18 20 3 27 18 17 20 23 9 18 4 16 23 9 31 21 23 10 5 31 18 19 10 17 18 20 17 6 18 29 21 22 18 8
