Fertilizacion Excel

Instrucciones www.tripoliven.com www.agro-marketing.com Fertilización N Cultivo CULTIVO AJUSTADO Nutrientes secundar

Views 314 Downloads 5 File size 65KB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

Instrucciones www.tripoliven.com www.agro-marketing.com

Fertilización N

Cultivo

CULTIVO AJUSTADO

Nutrientes secundarios (aportados/necesarios) Fertilizante sólido (kg/Ha) Fertilizante en solución (al 31%) (Kg/Ha) Agua para disolver el NPK (hasta una conc. de 69%) (Kg) Costo Total

MgO

150

30

150

0

0

0

121

41

101

2

25

30

Cesta de productos disponible

NPK sólido equivalente requerido: 23-5-23 (5:1:5) Fórmula NPK en solución : 7-1-7 (5:1:5) Nutrientes aportados (kg/Ha)

P2O5 K2O S CaO Requerimiento de nutrientes (kg/Ha)

Contenido de nutrientes del fertilizante 45.5%

0.0%

0.0%

0.0%

0.0%

0.0%

10.0%

30.0%

0.0%

5.0%

8.0%

0.0%

0.0%

0.0%

60.0%

0.0%

0.0%

0.0%

0.0%

0.0%

22.0%

22.0%

0.0%

18.0%

22.8% 7.0% 150

4.6% 1.4% 30

22.8% 7.0% 150

0.8% 0.2% 5

1.2% 0.4% 8

0.0% 0.0% 0

S NA

CaO NA

MgO NA

(NA=No Aplica)

658 2,147 1,489 kg 132,538 Bs/TM

Kg/Ha

Solubilidad (g/100 g H2O)

Costos/Precios

308

100.0

200,000 Bs/TM

83,378 Bs/TM

100

100.0

160,000 Bs/TM

400,000 Bs/TM

250

30.0

220,000 Bs/TM

208,250 Bs/TM

0

1.0 53.0 g/100 g H2O

180,000 Bs/TM 132,538 Bs/TM

242,450 Bs/TM 117,717 Bs/TM

Instrucciones

Tipo de fertilizante 1 UREA (SUPERNITROGENO) 2 SULFATO DE AMONIO (SUPER SAM) 3 FOSFATO DIAMONICO (FOSFACTIVO) 4 NPK 10-26-26 CP (EL RENDIDOR) 5 NPK 12-24-12/3 CP (EL LLANERO) 6 NPK 14-14-14/11 CP (EL VIGORIZADOR) 7 NPK 12-12-17/2/10 SP (EL HORTICULTOR) 8 RPA 0-25-0/4/20 (FOSFOPODER) 9 SULFATO DE CALCIO GRANULAR (EL MEJORADOR) 10 DAP II 16-42-0 (FOSFATO ESPECIAL) 11 NH3 (AMONIACO ANHIDRO) 12 SULFATO DE POTASIO 13 CLORURO DE POTASIO 14 NITRATO DE POTASIO 15 SOLUCION UAN (N-SOL O UAN) 28% UAN 16 RPA 0-33-0/2/22 (SUPERPHOSFERTIL) 17 URFOS 44 18 URFOSe 30 19 SUPERFOSFATO SIMPLE 20 ROCA RIECITO 21 SULPOMAG 22 SULFATO DE ZINC (ZnSO4.7H2O) 23 NITRATO DE CALCIO 24 FOSFATO DICALCICO (CaHPO4(H2O)2) 25 FOSFATO MONOCALCICO (Ca(H2PO4)2(H2O)) 26 SUPERFOS TECNICO (Ca(H2PO4)2(H2O)CaSO4(H2O)2) 27 SOLUCION DE LIGNATO DE ZINC 28 LODO FOSFATO AMONICO 29 SULFATO DE MAGNESIO HEPTAHIDRATADO 30 SUPERFOSFATO TRIPLE

N 45.5% 21.0% 18.0% 10.0% 12.0% 14.0% 12.0% 0.0% 0.0% 16.0% 82.0% 0.0% 0.0% 13.0% 28.0% 0.0% 17.0% 10.0% 0.0% 0.0% 0.0% 0.0% 15.0% 0.0% 0.0% 0.0% 0.0% 12.0% 0% 0%

P2O5 0.0% 0.0% 46.0% 26.0% 24.0% 14.0% 12.0% 25.0% 0.0% 42.0% 0.0% 0.0% 0.0% 0.0% 0.0% 33.0% 44.0% 30.0% 20.0% 27.0% 0.0% 0.0% 0.0% 41.2% 56.3% 33.5% 0.0% 48.0% 0% 46%

ANALISIS K2O 0.0% 0.0% 0.0% 26.0% 12.0% 14.0% 17.0% 0.0% 0.0% 0.0% 0.0% 50.0% 60.0% 44.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 22.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0% 0%

Tipo de Nutriente 1 N 2 P2O5 3 K2O 4 S 5 CaO 6 MgO 7 Zn 8 9

Tipo de Costo/Precio 1 COSTOS VARIABLES 2 COSTOS FIJOS 3 COSTOS DIRECTOS 4 COSTOS ADMINISTRACION 5 COSTOS INDIRECTOS 6 PRECIO GRANEL DISTRIBUIDOR 7 PRECIO ENSACADO DISTRIBUIDOR 8 9 Cultivo 1 MAIZ 2 ARROZ 3 SORGO 4 TRIGO

3 4 5 6 7 8 9

10 11 12 13 14 15 16

N 180 150 100 180

P2O5 80 50 40 50

K2O 220 100 80 70

5 SOYA 6 AJONJOLI 7 ALGODÓN 8 PALMA ACEITERA 9 MANI 10 COCO 11 GIRASOL 12 ZANAHORIA 13 FRIJOL 14 CARAOTA 15 ARVEJA 16 REMOLACHA 17 PLATANO 18 CAMBUR 19 NARANJA 20 PASTOS 21 LECHOSA 22 GUAYABA 23 PARCHITA 24 GUANABANA 25 MANGO 26 PIÑA 27 MANZANA 28 DURAZNO 29 FRESAS 30 UVAS DE MESA Altagracia 31 MELON 32 AGUACATE 33 PATILLA 34 CACAO

120 120 120 180 180 180 180 100 130 130 130 100 300 300 200 80 160 160 120 120 140 200 110 100 130 120 170 170 140 150

40 40 40 50 40 40 40 80 30 30 30 80 70 70 100 20 80 80 220 40 70 60 40 30 70 40 60 60 40 30

100 100 90 250 90 90 90 180 70 70 70 180 1100 1100 230 10 160 160 220 120 210 400 170 150 180 80 250 250 180 150

35 CAFÉ 36 CAÑA DE AZUCAR 37 TABACO 38 PAPA 39 YUCA 40 APIO 41 BERENJENA 42 ÑAME 43 AJO 44 BATATA 45 REPOLLO 46 COLIFLOR 47 LECHUGA 48 AJI DULCE/PICANTE 49 PEPINO 50 CEBOLLA 51 TOMATE 52 PIMENTON 53 54 55 56 57 58 59 60 61 62 63 64

150 220 70 150 150 150 400 150 100 150 150 170 110 250 130 100 220 200

30 120 30 80 80 80 200 80 80 80 40 60 30 120 120 50 150 180

150 320 140 250 250 250 350 250 180 250 140 200 180 350 180 140 380 330

65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 1

2

3

4

5

ANALISIS S 0.0% 24.0% 2.0% 1.0% 1.0% 11.0% 10.0% 4.0% 11.0% 2.0% 0.0% 17.0% 0.0% 0.0% 0.0% 1.0% 0.0% 5.0% 20.0% 0.0% 22.0% 11.0% 0.0% 0.0% 0.0% 7.6% 0.0% 0.0% 20% 0%

CaO 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 20.0% 22.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 22.0% 0.0% 8.0% 20.0% 36.0% 0.0% 0.0% 15.0% 32.6% 22.2% 13.2% 0.0% 0.0% 0% 15%

MgO 0.0% 0.0% 0.0% 0.0% 3.0% 0.0% 2.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 18.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 20% 0%

Zn 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 21.0% 0.0% 0.0% 0.0% 0.0% 10.5% 0.0% 0% 0%

VARIABLES 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 200,000

FIJOS 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 185,000 165,000 160,000 210,000 220,000 180,000 200,000 200,000

Costo DIRECTOS ADMINISTRACION INDIRECTOS 200,000 200,000 200,000 185,000 185,000 185,000 165,000 165,000 165,000 160,000 160,000 160,000 210,000 210,000 210,000 220,000 220,000 220,000 180,000 180,000 180,000 200,000 200,000 200,000 185,000 185,000 185,000 165,000 165,000 165,000 160,000 160,000 160,000 210,000 210,000 210,000 220,000 220,000 220,000 180,000 180,000 180,000 200,000 200,000 200,000 185,000 185,000 185,000 165,000 165,000 165,000 160,000 160,000 160,000 210,000 210,000 210,000 220,000 220,000 220,000 180,000 180,000 180,000 200,000 200,000 200,000 185,000 185,000 185,000 165,000 165,000 165,000 160,000 160,000 160,000 210,000 210,000 210,000 220,000 220,000 220,000 180,000 180,000 180,000 200,000 150,000 150,000 200,000 150,000 150,000

S 20 10 0 0

CaO 10 0 0 0

MgO 2 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0.3855049 0.5944951 0.99 0 0 0 0 0 0 0.03 0 0 0 0 0 0 0 0 0 0 1 2 3 0 0 0 0 0 0 0.2 0.2 0 0 0.36 0 0.22 0 0.18 0.109 0 0 0 0.15 0 0 0 0 0 0 0 0.076 0.132 0 0 0.473 0 0 0 0 0.1300981 0 0.1635229 0 0 0 0 0 0 0.165 0 0 0 0.03 0 0 0 0

0 0.17 0.113 0.015 0.006 0.015 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

6

7

8

PRECIO PRECIO (G.D.) PRECIO (E.D.) 83,378 94,850 69,050 82,394 154,656 168,000 179,751 193,095 164,211 177,555 137,401 150,745 173,556 186,900 49,545 57,020 33,125 40,600 154,656 168,000 10,000 10,000 359,580 374,580 208,250 223,250 10,000 10,000 10,000 10,000 58,425 65,900 1,175,000 1,175,000 400,000 400,000 40,000 40,000 10,000 10,000 242,450 257,450 1,092,500 1,092,500 10,000 10,000 200,000 200,000 300,000 300,000 150,000 150,000 200,000 200,000 30,000 30,000 1,100,000 1,100,000 1,100,000 1,100,000

Solubilidad (25°C) g/100cc H2O PRECIO (E.D.) 100 40 40 35 35 35 35 1 0.2 45 100 10 30 40 100 1 75 100 1 0.2 1 30 50 0.1 1.5 1 25 25 30 2

Llave normal de chorro (ag Abertura (mm) Abertura (%) 0.4 3.2% 1.0 8.3% 2.0 16.7% 6.0 50.0% 9.0 75.0% 12.0 100.0%

normal de chorro (agua a 2 kg de presión) Litros/dia Litros/dia m3h 46 46 0.002 2,086 1,800 0.075 4,512 4,661 0.194 16,400 16,104 0.671 23,536 24,687 1.029 33,984 33,269 1.386

litros/h 2 75 194 671 1,029 1,386