0% found this document useful (0 votes)
26 views8 pages

Formulacion Minimo Costo Solver

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
26 views8 pages

Formulacion Minimo Costo Solver

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

DIETA EN BASE SECA: 125 PD - 2800 Kcal/kg

MATERIAS PRIMAS MEZCLA MIN MAX HUMED ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
(%) (%) (%) (%) Kcal/kg (%, MS) (%, MS (%) (%) (%) (%) (%) (%) (%) (%) (%) (%) (%)

MAÍZ AMARILLO 20.00 20 100 11.5 3600 8.7 5.6 0.19 0.32 0.27 0.07 0.33 14.01 1.58 0.34 5.45 66.7 2.3
HARINA DE CEBADA 10.00 10 15 11.5 3253 10.0 6.1 0.43 0.45 0.40 0.14 0.53 20.45 6.21 1.24 8.09 59.3 1.9
AFRECHO DE TRIGO 20.00 15 20 10.7 2774 20.2 14.6 0.77 0.69 0.62 0.24 1.32 43.10 13.65 3.81 39.74 22.1 3.9
TORTA DE SOYA 46 11.27 0 100 10.1 3900 53.4 47.0 2.75 1.01 1.72 0.67 3.15 12.57 6.01 0.44 9.79 1.6 0.8
FREJOL DE PALO 0 0 0 10.6 2908 24.2 14.0 1.36 0.49 0.73 0.34 1.19 29.52 7.90 0.45 42.73 31.1 0.8
HARINA DE LEUCAENA 0.00 0 0 9.9 2836 30.4 20.3 1.15 0.56 0.82 0.33 1.01 33.73 18.96 7.36 28.09 0.4 2.7
HARINA DE ALFALFA 11.22 0 100 8.9 2406 19.4 12.9 0.73 0.31 0.63 0.25 0.60 35.01 24.81 4.99 31.17 2.2 0.1
AFRECHO DE CEBADA 0.00 0 0 10.6 1993 7.3 4.7 0.12 0.13 0.11 0.06 0.16 77.28 35.79 3.24 36.79 11.5 1.6
CÁSCARA DE CACAO 0 0 0 9.4 1962 13.7 0.1 0.06 0.20 0.12 0.00 0.06 53.72 37.84 16.33 28.79 0.2 1.9
CHALA DE MAÍZ 9.56 0 15 10.8 1680 6.3 4.3 0.08 0.00 0.09 0.00 0.07 64.24 30.94 0.78 37.44 6.4 0.0
RASTROJO DE KIWICHA 0.00 0 0 8.1 1698 10.2 4.9 0.16 0.11 0.14 0.00 0.15 59.53 37.77 5.44 40.05 5.0 0.3
MARLO 11.79 0 15 10.4 1767 5.3 1.4 0.12 0.07 0.11 0.00 0.10 79.11 37.83 1.45 40.39 3.7 0.0
AC. SOJA 1.000 1 2 0.0 8600 0 0 0 0 0 0 0 0 0 0 0 0 100.0
MELAZA DE CAÑA 0.000 0 0 27.4 2230 4.3 4.3 0.0 0.1 0 0 0 0 0 0 0 0 0.1
L-LISINA HCL 0.300 0 0.3 0.5 4800 94.4 94.4 78.00 0.0 0 0 0 0 0 0 0 0 0
DL METIONINA 0.300 0 0.3 0.5 5640 58.4 58.4 0 99.00 0 0 0 0 0 0 0 0 0
L-TREONINA 0.100 0 0.1 0.5 4100 72.5 72.5 0 0.00 98.00 0 0 0 0 0 0 0 0
L-ARGININA 0.000 0 0 0.5 0 196.9 196.9 0 0 0 0 98.00 0 0 0 0 0 0
L-TRIPTOFANO 0.000 0 0 0.6 6500 84.5 84.5 0 0 0 98.00 0 0 0 0 0 0 0
CARBONATO CALCICO 1.200 0 1.2 2.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FOSFATO BICALCICO ANH. 0.000 0 0 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CLORURO SODICO 0.300 0 0.3 0.70 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BICARBONATO SODICO 0.200 0 0.2 0.20 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CORRECTOR 0.500 0 0.5 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
97.75 10.0 2800.0 16.7 12.5 0.88 0.70 0.60 0.18 0.82 34.3 14.5 1.8 8.0 25.2 2.5

MIN 2800.0 17.0 12.5 0.780 0.700 0.560 0.170 1.200 20.0 14.0 0.0 8.0 16.0
MAX 2800.0 18.0 12.5 0.83 0.74 0.59 0.18 1.25 15.0 22.0

MATERIAS PRIMAS CANTIDADES


MAÍZ AMARILLO 15.16 22.74 30.32 45.49
HARINA DE CEBADA 15.00 22.50 30.00 45.00
AFRECHO DE TRIGO 25.00 37.50 50.00 75.00
TORTA DE SOYA 46 21.49 32.23 42.97 64.46
HARINA DE ALFALFA 6.19 9.28 12.37 18.56
CHALA DE MAÍZ 5.00 7.50 10.00 15.00
RASTROJO DE KIWICHA 6.67 10.00 13.33 20.00
AC. SOJA 3.000 4.50 6.00 9.00
DL METIONINA 0.300 0.45 0.60 0.90
CARBONATO CALCICO 1.200 1.80 2.40 3.60
CLORURO SODICO 0.300 0.45 0.60 0.90
BICARBONATO SODICO 0.200 0.30 0.40 0.60
CORRECTOR 0.500 0.75 1.00 1.50
TOTAL 100.00 ### ### ###

MAÍZ AMARILLO 28.70 43.05 57.40 86.10


AFRECHO DE TRIGO 25.00 37.50 50.00 75.00
TORTA DE SOYA 46 22.00 33.00 44.00 66.00
HARINA DE ALFALFA 6.18 9.27 12.37 18.55
CHALA DE MAÍZ 5.81 8.71 11.62 17.43
RASTROJO DE KIWICHA 6.81 10.21 13.61 20.42
AC. SOJA 3.000 4.50 6.00 9.00
DL METIONINA 0.300 0.45 0.60 0.90
CARBONATO CALCICO 1.200 1.80 2.40 3.60
CLORURO SODICO 0.300 0.45 0.60 0.90
BICARBONATO SODICO 0.200 0.30 0.40 0.60
CORRECTOR 0.500 0.75 1.00 1.50
TOTAL 100.00 ### ### ###
Ca P Na Cl PRECIO
(%) (%) (%) (%) S/kg

0.02 0.25 0.01 0.06 10 0 61.5


0.07 0.40 0.02 0.03 10 0
0.15 1.09 0.03 0.07 10 0
0.36 0.73 0.02 0.04 10 0
0.09 0.38 0.02 0.04 10 0
1.81 0.27 0.02 0.04 10 0
1.93 0.21 0.09 0.03 10 0
0.08 0.10 0.06 0.11 10 0
0.36404 0.22 0.00 0.00 10 0
0.35874 0.19 0.00 0.00 10 0
1.6108 0.11 0.00 0.00 10 0
0.04463 0.16 0.00 0.00 10 0
0 0 0 0 10 0
0.77 0.07 0.38 1.40 10 0
0 0 0 0.10 5000 0
0 0 0 0.00 5000 0
0 0 0.15 0.20 5000
0 0 0 0 5000
0 0 0 0.05 5000
38.60 0.01 0.55 0.10 5000
27.00 17.70 0.08 0.30 10
0 0 38.40 57.60 10
0 0 43.00 0.15 10
0 0 0 0 1000
Ca P Na Cl
0.80 0.45 0.23 0.21 109.53

0.80 0.40 0.10 0.20


0.80 0.4 0.20 0.24
DIETA EN BASE SECA: 125 PD - 2800 Kcal/kg
MATERIAS PRIMAS MEZCLA MIN MAX HUMED ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
(%) (%) (%) (%) Kcal/kg (%, MS) (%, MS (%) (%) (%) (%) (%) (%) (%) (%) (%) (%) (%)

MAÍZ AMARILLO 21.43 20 100 11.5 3600 8.7 5.6 0.19 0.32 0.27 0.07 0.33 14.01 1.58 0.34 5.45 66.7 2.3
HARINA DE CEBADA 10.00 10 15 11.5 3253 10.0 6.1 0.43 0.45 0.40 0.14 0.53 20.45 6.21 1.24 8.09 59.3 1.9
AFRECHO DE TRIGO 20.00 15 20 10.7 2774 20.2 14.6 0.77 0.69 0.62 0.24 1.32 43.10 13.65 3.81 39.74 22.1 3.9
TORTA DE SOYA 46 10.79 0 100 10.1 3900 53.4 47.0 2.75 1.01 1.72 0.67 3.15 12.57 6.01 0.44 9.79 1.6 0.8
FREJOL DE PALO 0 0 0 10.6 2908 24.2 14.0 1.36 0.49 0.73 0.34 1.19 29.52 7.90 0.45 42.73 31.1 0.8
HARINA DE LEUCAENA 0.00 0 0 9.9 2836 30.4 20.3 1.15 0.56 0.82 0.33 1.01 33.73 18.96 7.36 28.09 0.4 2.7
HARINA DE ALFALFA 12.14 0 100 8.9 2406 19.4 12.9 0.73 0.31 0.63 0.25 0.60 35.01 24.81 4.99 31.17 2.2 0.1
AFRECHO DE CEBADA 0.00 0 0 10.6 1993 7.3 4.7 0.12 0.13 0.11 0.06 0.16 77.28 35.79 3.24 36.79 11.5 1.6
CÁSCARA DE CACAO 0 0 0 9.4 1962 13.7 0.1 0.06 0.20 0.12 0.00 0.06 53.72 37.84 16.33 28.79 0.2 1.9
CHALA DE MAÍZ 4.59 0 15 10.8 1680 6.3 4.3 0.08 0.00 0.09 0.00 0.07 64.24 30.94 0.78 37.44 6.4 0.0
RASTROJO DE KIWICHA 0.00 0 0 8.1 1698 10.2 4.9 0.16 0.11 0.14 0.00 0.15 59.53 37.77 5.44 40.05 5.0 0.3
MARLO 15.00 0 15 10.4 1767 5.3 1.4 0.12 0.07 0.11 0.00 0.10 79.11 37.83 1.45 40.39 3.7 0.0
AC. SOJA 3.000 2 3 0.0 8600 0 0 0 0 0 0 0 0 0 0 0 0 100.0
MELAZA DE CAÑA 0.000 0 0 27.4 2230 4.3 4.3 0.0 0.1 0 0 0 0 0 0 0 0 0.1
L-LISINA HCL 0.300 0 0.3 0.5 4800 94.4 94.4 78.00 0.0 0 0 0 0 0 0 0 0 0
DL METIONINA 0.300 0 0.3 0.5 5640 58.4 58.4 0 99.00 0 0 0 0 0 0 0 0 0
L-TREONINA 0.100 0 0.1 0.5 4100 72.5 72.5 0 0.00 98.00 0 0 0 0 0 0 0 0
L-ARGININA 0.100 0 0.1 0.5 0 196.9 196.9 0 0 0 0 98.00 0 0 0 0 0 0
L-TRIPTOFANO 0.000 0 0 0.6 6500 84.5 84.5 0 0 0 98.00 0 0 0 0 0 0 0
CARBONATO CALCICO 1.200 0 1.2 2.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FOSFATO BICALCICO ANH. 0.000 0 0 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CLORURO SODICO 0.300 0 0.3 0.70 0 0 0 0 0 0 0 0 0 0 0 0 0 0
BICARBONATO SODICO 0.250 0 0.25 0.20 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CORRECTOR 0.500 0 0.5 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
100.00 10.0 3000.0 16.8 12.5 0.88 0.70 0.60 0.18 0.92 34.1 14.4 1.9 22.5 25.9 4.6

MIN 3000.0 17.0 12.5 0.780 0.700 0.560 0.170 1.200 20.0 14.0 0.0 8.0 16.0
MAX 3000.0 18.0 12.5 0.83 0.74 0.59 0.18 1.25 15.0 22.0

MATERIAS PRIMAS CANTIDADES


MAÍZ AMARILLO 15.16 22.74 30.32 45.49
HARINA DE CEBADA 15.00 22.50 30.00 45.00
AFRECHO DE TRIGO 25.00 37.50 50.00 75.00
TORTA DE SOYA 46 21.49 32.23 42.97 64.46
HARINA DE ALFALFA 6.19 9.28 12.37 18.56
CHALA DE MAÍZ 5.00 7.50 10.00 15.00
RASTROJO DE KIWICHA 6.67 10.00 13.33 20.00
AC. SOJA 3.000 4.50 6.00 9.00
DL METIONINA 0.300 0.45 0.60 0.90
CARBONATO CALCICO 1.200 1.80 2.40 3.60
CLORURO SODICO 0.300 0.45 0.60 0.90
BICARBONATO SODICO 0.200 0.30 0.40 0.60
CORRECTOR 0.500 0.75 1.00 1.50
TOTAL 100.00 ### ### ###

MAÍZ AMARILLO 28.70 43.05 57.40 86.10


AFRECHO DE TRIGO 25.00 37.50 50.00 75.00
TORTA DE SOYA 46 22.00 33.00 44.00 66.00
HARINA DE ALFALFA 6.18 9.27 12.37 18.55
CHALA DE MAÍZ 5.81 8.71 11.62 17.43
RASTROJO DE KIWICHA 6.81 10.21 13.61 20.42
AC. SOJA 3.000 4.50 6.00 9.00
DL METIONINA 0.300 0.45 0.60 0.90
CARBONATO CALCICO 1.200 1.80 2.40 3.60
CLORURO SODICO 0.300 0.45 0.60 0.90
BICARBONATO SODICO 0.200 0.30 0.40 0.60
CORRECTOR 0.500 0.75 1.00 1.50
TOTAL 100.00 ### ### ###
Ca P Na Cl PRECIO
(%) (%) (%) (%) S/kg

0.02 0.25 0.01 0.06 10 57.430 MAÍZ AMARILLO 20.00 MAÍZ AMARILLO 16.00
0.07 0.40 0.02 0.03 10 30.000 HARINA DE CEB 10.00 HARINA DE CEB 10.00
0.15 1.09 0.03 0.07 10 48.000 AFRECHO DE TRI 15.00 AFRECHO DE TRI 13.00
0.36 0.73 0.02 0.04 10 35.735 TORTA DE SOYA 12.03 TORTA DE SOYA 12.92
0.09 0.38 0.02 0.04 10 0.000 FREJOL DE PALO 0 FREJOL DE PALO 0
1.81 0.27 0.02 0.04 10 0.000 HARINA DE LEU 0.00 HARINA DE LEU 0.00
1.93 0.21 0.09 0.03 10 32.771 HARINA DE ALFA 11.17 HARINA DE ALFA 9.46
0.08 0.10 0.06 0.11 10 0.000 AFRECHO DE CE 0.00 AFRECHO DE CE 0.00
0.36404 0.22 0.00 0.00 10 0.000 CÁSCARA DE CA 0 CÁSCARA DE CA 0
0.35874 0.19 0.00 0.00 10 37.344 CHALA DE MAÍZ 12.75 CHALA DE MAÍZ 20.00
1.6108 0.11 0.00 0.00 10 0.000 RASTROJO DE KI 0.00 RASTROJO DE KI 0.00
0.04463 0.16 0.00 0.00 10 45.570 MARLO 15.00 MARLO 15.57
0 0 0 0 10 4.000 AC. SOJA 1.000 AC. SOJA 0.000
0.77 0.07 0.38 1.40 10 0.000 MELAZA DE CAÑ 0.000 MELAZA DE CAÑ 0.000
0 0 0 0.10 5000 0.900 L-LISINA HCL 0.300 L-LISINA HCL 0.300
0 0 0 0.00 5000 0.900 DL METIONINA 0.300 DL METIONINA 0.300
0 0 0.15 0.20 5000 0.300 L-TREONINA 0.100 L-TREONINA 0.100
0 0 0 0 5000 0.300 L-ARGININA 0.100 L-ARGININA 0.100
0 0 0 0.05 5000 0.000 L-TRIPTOFANO 0.000 L-TRIPTOFANO 0.000
38.60 0.01 0.55 0.10 5000 3.600 CARBONATO CAL 1.200 CARBONATO CAL 1.200
27.00 17.70 0.08 0.30 10 0.000 FOSFATO BICALC 0.000 FOSFATO BICALC 0.000
0 0 38.40 57.60 10 0.900 CLORURO SODIC 0.300 CLORURO SODIC 0.300
0 0 43.00 0.15 10 0.750 BICARBONATO S 0.250 BICARBONATO S 0.250
0 0 0 0 1000 1.500 CORRECTOR 0.500 CORRECTOR 0.500
Ca P Na Cl
0.80 0.45 0.25 0.21 114.75

0.80 0.40 0.10 0.20


0.80 0.4 0.20 0.24
DIETA EN BASE SECA: 125 PD - 2800 Kcal/kg
MATERIAS PRIMAS MEZCLA MIN MAX HUMED ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
(%) (%) (%) (%) Kcal/kg (%, MS) (%, MS (%) (%) (%) (%) (%) (%) (%) (%) (%) (%) (%)

MAÍZ AMARILLO 22.05 10 25 11.5 3730 8.68 5.61 0.19 0.32 0.27 0.07 0.33 14.01 1.58 0.34 5.45 66.7 2.3
HARINA DE CEBADA 20.00 7 20 11.5 3263 9.96 6.13 0.43 0.45 0.40 0.14 0.53 20.45 6.21 1.24 8.09 59.3 1.9
AFRECHO DE TRIGO 5.00 5 5 10.7 2787 20.17 14.60 0.77 0.69 0.62 0.24 1.32 43.10 13.65 3.81 39.74 22.1 3.9
TORTA DE SOYA 46 14.00 8 14 10.1 4173 53.39 49.44 2.75 1.01 1.72 0.67 3.15 12.57 6.01 0.44 9.79 1.6 0.8
HARINA DE ALFALFA 12.00 8 12 8.9 2446 19.38 12.87 0.73 0.31 0.63 0.25 0.60 35.01 24.81 4.99 31.17 2.2 0.1
CHALA DE MAÍZ 1.00 1 1 10.8 1548 6.28 1.38 0.08 0.00 0.09 0.00 0.07 64.24 30.94 0.78 37.44 6.4 0.0
MARLO 1.00 1 1 10.4 1915 5.26 0.96 0.12 0.07 0.11 0.00 0.10 79.11 37.83 1.45 40.39 3.7 0.0
AC. SOJA 0.500 0.5 3 0.0 8600 0 0 0 0 0 0 0 0 0 0 0 0 100.0
L-LISINA HCL 0.178 0 0 0.5 4800 94.4 94.4 78.00 0.0 0 0 0 0 0 0 0 0 0
DL METIONINA 0.330 0 0 0.5 5640 58.4 58.4 0 99.00 0 0 0 0 0 0 0 0 0
L-TREONINA 0.073 0 0 0.5 4100 72.5 72.5 0 0.00 98.00 0 0 0 0 0 0 0 0
L-ARGININA 0.204 0 0 0.5 0 196.9 196.9 0 0 0 0 98.00 0 0 0 0 0 0
CARBONATO CÁLCICO 0.880 0 0 2.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FOSFATO BICÁLCICO ANH. 0.737 0 0 0.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CLORURO SÓDICO 0.318 0 0 0.70 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CORRECTOR 0.500 0.5 0.5 0.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
ED CUY PB PD LYS M+C THR TRP ARG FND FAD LAD FB ALMIDON EE
78.77 8.1 2600.0 15.6 12.5 0.78 0.70 0.56 0.18 0.96 16.7 6.8 1.2 10.7 28.3 1.7

MIN 2600.0 0.0 12.5 0.780 0.700 0.560 0.170 1.000 20.0 14.0 0.0 8.0 16.0 0.0
MAX 2600.0 0.0 12.5 0.00 0.00 0.00 0.00 0.00 0.0 0.0 0.0 0.0 0.0 0.0
E SECA: 125 PD - 2800 Kcal/kg
Ca P Na Cl PRECIO
(%) (%) (%) (%) S/kg

0.02 0.25 0.01 0.06 2


0.07 0.40 0.02 0.03 2.6
0.15 1.09 0.03 0.07 1.8
0.36 0.73 0.02 0.04 3
1.93 0.21 0.09 0.03 2
0.36 0.19 0.00 0.00 1.5
0.04 0.16 0.00 0.00 1.5
0 0 0 0 5
0 0 0 0.10 10.2
0 0 0 0.00 17.2
0 0 0.15 0.20 9.2
0 0 0 0 20.8
38.60 0.01 0.55 0.10 3.5
27.00 17.70 0.08 0.30 3.7
0 0 38.40 57.60 1.5
0 0 0 0 1
Ca P Na Cl
0.85 0.45 0.15 0.22 1.96

0.80 0.40 0.10 0.20


0.85 0.45 0.15 0.25

You might also like