proyecto cuyes

37
Proyecto con gradiente en la inversiòn Egresos Costos fijos unitarios (3 meses) 796 Costos variables unitarios (3 meses) 807 Costo fijo unitario/mes (comunidad + fundacion) 265 costo variable unitario/mes (comunidad + fundacion) 269 aporte comunitario al costo variable (forraje) 80% aporte fundacion al costo variable (alimento balancea 20% costo total/mes inversiòn unitaria 4,909 tamaño de la inversiòn 1 cuyes machos 1 cuyes hembras 7 cuyes/parto 5 numero de lotes 6 total cuyes para reproducción 48 total cuyes para reproducción 2do. Lote 96 total cuyes para reproducción 3er. Lote 144 total cuyes para vta sin 2do. Lote 210 total cuyes para ventas con 2do. lote 114 total cuyes para ventas con 3er. Lote 66 precio/cuy 15 Egresos totales Monto de la Inversiòn 184,731 Capital de instalaciòn solo cuyes 4,909 Otros gastos de instalaciòn 6,110 Egresos capital de operación/mes solo cuyes sin 2do. 319 Egresos capital de operación/mes solo cuyes 2do. lote Egresos capital de operación/mes solo cuyes 3er. lote Otros egresos por capital de operaciòn/mes Total (cuyes + otros) egresos cronograma de inversiones monto unitario de la inversiòn No. Hijos totales por parto (1ra.camada) No. Hijos totales por parto (2da.camada) No. Hijos totales por parto (3ra.camada) No. Hijos totales por parto (4ta.camada) No. De hijos totales/mes lote unitario sin lotes No. De hijos totales/mes lote unitario con 2do. Lote

Upload: juan-perez-sanchez

Post on 17-Dec-2015

31 views

Category:

Documents


2 download

DESCRIPTION

Modelo matemàtico para la evaluaciòn econòmica de una granja productora de cuyes de 2,000 cuyes/mes escalable segùn paràmetros hasta la producciòn deseada, se dan los indicadores econòmicos de rentabilidad a partir de montos de inversiòn y costos de operaciòn del proyecto

TRANSCRIPT

Hoja1Proyecto con gradiente en la inversinEgresos 1457816Costos fijos unitarios (3 meses)7967963,1843,9805,5726,36812,736Costos variables unitarios (3 meses)8078073,2284,0355,6496,45612,912Costo fijo unitario/mes (comunidad + fundacion)2652651,0611,3271,8572,1234,245costo variable unitario/mes (comunidad + fundacion)2692691,0761,3451,8832,1524,304aporte comunitario al costo variable (forraje)80%2158611,0761,5061,7223,443aporte fundacion al costo variable (alimento balanceado)20%54215269377430861costo total/mes3191,2771,5962,2342,5535,106inversin unitaria4,9094,90919,63624,54534,36339,27278,544

tamao de la inversin11457816machoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrasmachoshembrascuyes machos11111111ra. Camada1717171717171717171717171717171717171717171717171717171717171717171717cuyes hembras77777772da camada1717171717171717171717171717171717171717171717171717171717171717171717cuyes/parto55565553ra. Camada1717171717171717171717171717171717171717171717171717171717171717171717numero de lotes66666664ta. Camada1717171717171717171717171717171717171717171717171717171717171717171717total cuyes para reproduccin48481922403363847685ta. Camada1717171717171717171717171717171717171717171717171717171717171717171717total cuyes para reproduccin 2do. Lote96963844806727681,5366ta. Camada1717171717171717171717171717171717171717171717171717171717171717171717total cuyes para reproduccin 3er. Lote1441445767201,0081,1522,304total cuyes/sexo642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642642total cuyes para vta sin 2do. Lote2102108401,0501,4701,6803,360Unidades/48 cuyes4848484848484848484848484848484848484848484848484848484848484848484848total cuyes para ventas con 2do. lote1141144565707989121,824total cuyes para ventas con 3er. Lote66662643304625281,056precio/cuy15151515151515Lotes cuyes1234567891011121314151617181920212223242526272829303132333435acumulado tamao 7ERROR:#REF!Egresos totalesacumulado tamao 8ERROR:#REF!Monto de la Inversin184,7311457816acumulado tamao 16Capital de instalacin solo cuyes4,9094,90919,63624,54534,36339,27278,544Otros gastos de instalacin6,110Egresos capital de operacin/mes solo cuyes sin 2do. Lote3193191,2771,5962,2342,5535,106Egresos capital de operacin/mes solo cuyes 2do. lote 6382,5533,1914,4685,10610,212Egresos capital de operacin/mes solo cuyes 3er. lote 9573,8304,7876,7027,65915,318Otros egresos por capital de operacin/mes3,577Total (cuyes + otros) egresos3191,2771,5962,2342,5535,106

cronograma de inversiones0123456789101112131415161718192021222324monto unitario de la inversin4,9094,9094,9094,909No. Hijos totales por parto (1ra.camada)210210210210210210No. Hijos totales por parto (2da.camada)210210210210210No. Hijos totales por parto (3ra.camada)210210210210210No. Hijos totales por parto (4ta.camada)210210210210210

No. De hijos totales/mes lote unitario sin lotes210210210210210210210210210210210210210210210210210210210210210No. De hijos totales/mes lote unitario con 2do. Lote162162162162420420420420420420420420420420420420420420420420420No de Hijos totales/mes lote unitario con 3er. Lote144144144144630630630630630630630630630630630630630630630630630

No. De hijos/ tamao 1 sin 2do. Lote1210210210210210210210210210210210210210210210210210210210210210No. De hijos/ tamao 4 sin 2do. Lote4840840840840840840840840840840840840840840840840840840840840840No. De hijos/ tamao 5 sin 2do. Lote51,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,0501,050No. De hijos/ tamao 7 sin 2do. Lote71,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,4701,470No. De hijos/ tamao 8 sin 2do. Lote81,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,680No. De Hijos/ tamao 16 sin 2do. Lote163,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,360

No. De hijos/ tamao 1 con 2do. Lote1162162162162420420420420420420420420420420420420420420420420420No. De hijos/ tamao 4 con 2do. Lote46486486486481,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,6801,680No. De hijos/ tamao 5 con 2do. Lote58108108108102,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,1002,100No. De hijos/ tamao 7 con 2do. Lote71,1341,1341,1341,1342,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,9402,940No. De hijos/ tamao 8 con 2do. Lote81,2961,2961,2961,2963,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,3603,360No. de hijos/ tamao 16 con 2do. Lote162,5922,5922,5922,5926,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,7206,720

No. De hijos/ tamao 1 con 3er. Lote1144144144144630630630630630630630630630630630630630630630630630No De hijos/ tamao 4 con 3er. Lote45765765765762,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,5202,520No. De hijos/ tamao 5 con 3er. Lote57207207207203,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,150No. De hijos/ tamao 7 con 3er. Lote71,0081,0081,0081,0084,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,4104,410No. De hijos/ tamao 8 con 3er. Lote81,1521,1521,1521,1525,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,0405,040No. De hijos/ tamao 16 con 3er. Lote162,3042,3042,3042,30410,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,08010,080

0123456789101112131415161718192021222324precio unitario/cuy15151515151515151515151515151515151515151515ingresos brutos/ tamao 1 sin 2do. Lote13,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,1503,150Ingresos brutos/ tamao 4 sin 2do. Lote412,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,60012,600Ingresos brutos/ tamao 5 sin 2do. Lote515,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,75015,750ingresos brutos/ tamao 7 sin 2do. Lote722,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,05022,050ingresos brutos/ tamao 8 sin 2do. Lote825,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,200ingresos brutos/ tamao 16 sin 2do. Lote1650,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,400

ingresos brutos/ tamao 1 con 2do. Lote12,4302,4302,4302,4306,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,3006,300ingresos brutos/ tamao 4 con 2do. Lote49,7209,7209,7209,72025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,20025,200Ingresos brutos/ tamao 5 con 2do. Lote512,15012,15012,15012,15031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,50031,500ingresos brutos/ tamao 7 con 2do. Lote717,01017,01017,01017,01044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,10044,100ingresos brutos/ tamao 8 con 2do. Lote819,44019,44019,44019,44050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,40050,400ingresos brutos/ tamao 16 con 2do. Lote1638,88038,88038,88038,880100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800100,800

Ingresos brutos/ tamao 1 con 3er. Lote12,1602,1602,1602,1609,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,4509,450Ingresos brutos/ tamao 4 con 3er. Lote48,6408,6408,6408,64037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,80037,800Ingresos brutos/ tamao 5 con 3er. Lote510,80010,80010,80010,80047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,25047,250Ingresos brutos/ tamao 7 con 3er. Lote715,12015,12015,12015,12066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,15066,150Ingresos brutos/ tamao 8 con 3er. Lote817,28017,28017,28017,28075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,60075,600Ingresos brutos/ tamao 16 con 3er. Lote1634,56034,56034,56034,560151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200151,200

Otros egresos (otros proyectos)6,1103,5773,5773,5777,24222,89329,61222,53322,53322,53322,53322,53322,53318,95718,95718,95718,95718,95718,95718,95718,95718,95718,95718,95718,957Otras inversiones iniciales0.0

0123456789101112131415161718192021222324Monto de la inversin. Tamao 119,6364,9094,9094,9094,909Monto de la inversin. Tamao 478,54419,63619,63619,63619,636Monto de la inversin. Tamao 598,18024,54524,54524,54524,545Monto de la inversin. Tamao 7137,45234,36334,36334,36334,363Monto de la inversin. Tamao 8157,08839,27239,27239,27239,272Monto de la inversin. Tamao 16314,17678,54478,54478,54478,5440123456789101112131415161718192021222324Egresos cuyes tamao 1 sin 2do. Lote11,0198,8058,8058,8057,56123,21229,93122,85222,85222,85222,85222,85222,85219,27619,27619,27619,27619,27619,27619,27619,27619,27619,27619,27619,276Egresos cuyes tamao 4 sin 2do. Lote25,74624,48924,48924,4898,51824,17030,88923,81023,81023,81023,81023,81023,81020,23320,23320,23320,23320,23320,23320,23320,23320,23320,23320,23320,233Egresos cuyes tamao 5 sin 2do. Lote30,65529,71729,71729,7178,83724,48931,20824,12924,12924,12924,12924,12924,12920,55220,55220,55220,55220,55220,55220,55220,55220,55220,55220,55220,552Egresos cuyes tamao 7 sin 2do. Lote40,47340,17440,17440,1749,47625,12731,84624,76724,76724,76724,76724,76724,76721,19121,19121,19121,19121,19121,19121,19121,19121,19121,19121,19121,191Egresos cuyes tamao 8 sin 2do. Lote45,38245,40245,40245,4029,79525,44632,16525,08625,08625,08625,08625,08625,08621,51021,51021,51021,51021,51021,51021,51021,51021,51021,51021,51021,510Egresos cuyes tamao 16 sin 2do. Lote84,65487,22787,22787,22712,34827,99934,71827,63927,63927,63927,63927,63927,63924,06324,06324,06324,06324,06324,06324,06324,06324,06324,06324,06324,0630123456789101112131415161718192021222324Egresos cuyes tamao 1 con 2do. Lote11,0199,1249,1249,1247,88023,53230,25123,17223,17223,17223,17223,17223,17219,59519,59519,59519,59519,59519,59519,59519,59519,59519,59519,59519,595Egresos cuyes tamao 4 con 2do. Lote25,74625,76625,76625,7669,79525,44632,16525,08625,08625,08625,08625,08625,08621,51021,51021,51021,51021,51021,51021,51021,51021,51021,51021,51021,510Egresos cuyes tamao 5 con 2do. Lote30,65531,31331,31331,31310,43326,08532,80425,72525,72525,72525,72525,72525,72522,14822,14822,14822,14822,14822,14822,14822,14822,14822,14822,14822,148Egresos cuyes tamao 7 con 2do. Lote40,47342,40842,40842,40811,71027,36134,08027,00127,00127,00127,00127,00127,00123,42523,42523,42523,42523,42523,42523,42523,42523,42523,42523,42523,425Egresos cuyes tamao 8 con 2do. Lote45,38247,95547,95547,95512,34827,99934,71827,63927,63927,63927,63927,63927,63924,06324,06324,06324,06324,06324,06324,06324,06324,06324,06324,06324,063Egresos cuyes tamao 16 con 2do. Lote84,65492,33392,33392,33317,45433,10639,82532,74632,74632,74632,74632,74632,74629,16929,16929,16929,16929,16929,16929,16929,16929,16929,16929,16929,169

Egresos cuyes tamao 1 con 3er. Lote11,0199,4439,4439,4438,19923,85130,57023,49123,49123,49123,49123,49123,49119,91419,91419,91419,91419,91419,91419,91419,91419,91419,91419,91419,914Egresos cuyes tamao 4 con 3er. Lote25,74627,04227,04227,04211,07126,72333,44226,36326,36326,36326,36326,36326,36322,78622,78622,78622,78622,78622,78622,78622,78622,78622,78622,78622,786Egresos cuyes tamao 5 con 3er. Lote30,65532,90932,90932,90912,02927,68034,39927,32027,32027,32027,32027,32027,32023,74423,74423,74423,74423,74423,74423,74423,74423,74423,74423,74423,744Egresos cuyes tamao 7 con 3er. Lote40,47344,64144,64144,64113,94329,59536,31429,23529,23529,23529,23529,23529,23525,65825,65825,65825,65825,65825,65825,65825,65825,65825,65825,65825,658Egresos cuyes tamao 8 con 3er. Lote45,38250,50850,50850,50814,90130,55337,27230,19330,19330,19330,19330,19330,19326,61626,61626,61626,61626,61626,61626,61626,61626,61626,61626,61626,616Egresos cuyes tamao 16 con 3er. Lote84,65497,43997,43997,43922,56038,21244,93137,85237,85237,85237,85237,85237,85234,27534,27534,27534,27534,27534,27534,27534,27534,27534,27534,27534,275

0.00.00.0123456789101112131415161718192021222324ingresos netos tamao 1 sin 2do. Lote-11,019-8,805-8,805-8,805-4,411-20,062-26,781-19,702-19,702-19,702-19,702-19,702-19,702-16,126-16,126-16,126-16,126-16,126-16,126-16,126-16,126-16,126-16,126-16,126-16,126Ingresos netos tamao 4 sin 2do. Lote-25,746-24,489-24,489-24,4894,082-11,570-18,289-11,210-11,210-11,210-11,210-11,210-11,210-7,633-7,633-7,633-7,633-7,633-7,633-7,633-7,633-7,633-7,633-7,633-7,633ingresos netos tamao 5 sin 2do. Lote-30,655-29,717-29,717-29,7176,913-8,739-15,458-8,379-8,379-8,379-8,379-8,379-8,379-4,802-4,802-4,802-4,802-4,802-4,802-4,802-4,802-4,802-4,802-4,802-4,802ingresos netos tamao 7 sin 2do lote-40,473-40,174-40,174-40,17412,574-3,077-9,796-2,717-2,717-2,717-2,717-2,717-2,717859859859859859859859859859859859859ingresos netos tamao 8 sin 2do. Lote-45,382-45,402-45,402-45,40215,405-246-6,9651141141141141141143,6903,6903,6903,6903,6903,6903,6903,6903,6903,6903,6903,690ingresos netos tamao 16 sin 2do. Lote-84,654-87,227-87,227-87,22738,05222,40115,68222,76122,76122,76122,76122,76122,76126,33726,33726,33726,33726,33726,33726,33726,33726,33726,33726,33726,3370.00.00.0123456789101112131415161718192021222324ingresos netos tamao 1 con 2do. Lote-11,019-9,124-9,124-9,124-5,450-21,102-27,821-20,742-16,872-16,872-16,872-16,872-16,872-13,295-13,295-13,295-13,295-13,295-13,295-13,295-13,295-13,295-13,295-13,295-13,295Ingresos netos tamao 4 con 2do. Lote-25,746-25,766-25,766-25,766-75-15,726-22,445-15,3661141141141141143,6903,6903,6903,6903,6903,6903,6903,6903,6903,6903,6903,690Ingresos netos tamao 5 con 2do. Lote-30,655-31,313-31,313-31,3131,717-13,935-20,654-13,5755,7755,7755,7755,7755,7759,3529,3529,3529,3529,3529,3529,3529,3529,3529,3529,3529,352ingresos netos tamao 7 con 2do lote-40,473-42,408-42,408-42,4085,300-10,351-17,070-9,99117,09917,09917,09917,09917,09920,67520,67520,67520,67520,67520,67520,67520,67520,67520,67520,67520,675ingresos netos tamao 8 con 2do. Lote-45,382-47,955-47,955-47,9557,092-8,559-15,278-8,19922,76122,76122,76122,76122,76126,33726,33726,33726,33726,33726,33726,33726,33726,33726,33726,33726,337ingresos brutos tamao 16 con 2do. Lote-84,654-92,333-92,333-92,33321,4265,774-9456,13468,05468,05468,05468,05468,05471,63171,63171,63171,63171,63171,63171,63171,63171,63171,63171,63171,631

ingresos netos tamao 1 con 3er. Lote-11,019-9,443-9,443-9,443-6,039-21,691-28,410-21,331-14,041-14,041-14,041-14,041-14,041-10,464-10,464-10,464-10,464-10,464-10,464-10,464-10,464-10,464-10,464-10,464-10,464Ingresos netos tamao 4 con 3er. Lote-25,746-27,042-27,042-27,042-2,431-18,083-24,802-17,72311,43711,43711,43711,43711,43715,01415,01415,01415,01415,01415,01415,01415,01415,01415,01415,01415,014Ingresos netos tamao 5 con 3er. Lote-30,655-32,909-32,909-32,909-1,229-16,880-23,599-16,52019,93019,93019,93019,93019,93023,50623,50623,50623,50623,50623,50623,50623,50623,50623,50623,50623,506ingresos netos tamao 7 con 3er. lote-40,473-44,641-44,641-44,6411,177-14,475-21,194-14,11536,91536,91536,91536,91536,91540,49240,49240,49240,49240,49240,49240,49240,49240,49240,49240,49240,492ingresos netos tamao 8 con 3er. Lote-45,382-50,508-50,508-50,5082,379-13,273-19,992-12,91345,40745,40745,40745,40745,40748,98448,98448,98448,98448,98448,98448,98448,98448,98448,98448,98448,984ingresos brutos tamao 16 con 3er. Lote-84,654-97,439-97,439-97,43912,000-3,652-10,371-3,292113,348113,348113,348113,348113,348116,925116,925116,925116,925116,925116,925116,925116,925116,925116,925116,925116,9250.00.00.0123456789101112131415161718192021222324ingresos netos + inversin tamao 1 sin 2do. Lote184,731173,712164,907156,102147,298142,887122,82496,04376,34056,63836,93517,233-2,469-22,172-38,298-54,424-70,549-86,675-102,801-118,927-135,053-151,178-167,304-183,430-199,556-215,682ingresos netos + inversion tamao 4 sin 2do. Lote184,731158,985134,496110,00785,51789,59978,02959,74048,53137,32126,11114,9013,691-7,519-15,152-22,785-30,418-38,052-45,685-53,318-60,951-68,584-76,218-83,851-91,484-99,117ingresos netos + inversin tamao 5 sin 2do. Lote184,731154,076124,35994,64164,92471,83763,09847,64039,26130,88222,50314,1245,745-2,634-7,437-12,239-17,041-21,844-26,646-31,448-36,251-41,053-45,855-50,658-55,460-60,262ingresos netos + inversin tamao 7 sin 2do. Lote184,731144,258104,08463,91123,73736,31233,23423,43820,72118,00415,28612,5699,8527,1347,9948,8539,71310,57211,43112,29113,15014,01014,86915,72816,58817,447ingresos netos + inversin tamao 8 sin 2do. Lote184,731139,34993,94748,5463,14418,54918,30311,33711,45111,56411,67811,79211,90512,01915,70919,39923,09026,78030,47034,16037,85141,54145,23148,92252,61256,302ingresos netos + inversin tamao 16 sin 2do. Lote184,731100,07712,850-74,377-161,603-123,551-101,151-85,469-62,709-39,948-17,1885,57328,33451,09477,431103,768130,106156,443182,780209,117235,454261,792288,129314,466340,803367,1400.00.00.0123456789101112131415161718192021222324ingresos netos + inversin tamao 1 con Lote 2184,731173,712164,588155,464146,340140,890119,78991,96871,22654,35537,48320,6123,740-13,132-26,426-39,721-53,016-66,311-79,606-92,901-106,196-119,491-132,786-146,081-159,376-172,671ingresos netos + inversin tamao 4 con Lote 2184,731158,985133,219107,45481,68881,61365,88743,44128,07528,18828,30228,41628,52928,64332,33336,02339,71443,40447,09450,78454,47558,16561,85565,54669,23672,926ingresos netos + inversin tamao 5 con Lote 2184,731154,076122,76391,45060,13761,85447,91927,26613,69119,46625,24231,01736,79242,56851,92061,27270,62479,97689,32898,680108,032117,384126,736136,088145,440154,792ingresos netos + inversin tamao 7 con Lote 2184,731144,258101,85059,44317,03522,33611,985-5,086-15,0772,02219,12136,22053,31870,41791,093111,768132,444153,119173,795194,470215,146235,821256,496277,172297,847318,523ingresos netos + inversin tamao 8 con Lote 2184,731139,34991,39443,439-4,5152,577-5,983-21,261-29,461-6,70016,06038,82161,58284,342110,679137,016163,354189,691216,028242,365268,702295,040321,377347,714374,051400,388Ingresos netos + inversin tamao 16 con Lote 2184,731100,0777,744-84,589-176,922-155,496-149,721-150,666-144,532-76,477-8,42359,632127,686195,740267,372339,003410,634482,265553,896625,527697,158768,789840,420912,051983,6821,055,313

ingresos netos + inversin tamao 1 con 3er. Lote184,731173,712164,269154,826145,383139,344117,65389,24367,91353,87239,83125,79011,750-2,291-12,755-23,219-33,683-44,147-54,611-65,076-75,540-86,004-96,468-106,932-117,396-127,860ingresos netos + inversin tamao 4 con 3er. Lote 184,731158,985131,943104,90077,85875,42757,34432,54214,81926,25637,69349,13060,56772,00487,018102,032117,046132,059147,073162,087177,101192,114207,128222,142237,156252,169ingresos netos + inversin tamao 5 con 3er. Lote 184,731154,076121,16788,25955,35054,12137,24113,642-2,87917,05136,98156,91076,84096,770120,276143,782167,289190,795214,301237,808261,314284,820308,327331,833355,339378,846ingresos netos + inversin tamao 7 con 3er. Lote 184,731144,25899,61754,97510,33411,510-2,965-24,159-38,274-1,35935,55572,470109,385146,300186,792227,283267,775308,266348,758389,249429,741470,232510,724551,215591,707632,198ingresos netos + inversin tamao 8 con 3er. Lote 184,731139,34988,84138,333-12,175-9,795-23,068-43,060-55,972-10,56534,84380,250125,658171,065220,049269,034318,018367,002415,986464,970513,954562,938611,922660,907709,891758,875Ingresos netos + inversin tamao 16 con 3er. Lote 184,731100,0772,638-94,801-192,240-180,240-183,892-194,263-197,554-84,20629,142142,490255,839369,187486,112603,037719,962836,887953,8121,070,7361,187,6611,304,5861,421,5111,538,4361,655,3611,772,286

Egresos por capital de instalacin de otros proyectosposta mdica: equipamiento1,426proyecto abejas33,600proyecto biohuertos33,420crianza de gallinas31,6060123456789101112131415161718192021222324Total Costo de instalacin (otros proyectos)100,052100,052ingresos netos - tamao 4 con lote 2158,985134,496110,00785,51789,59978,02959,74048,53137,32126,11114,9013,691-7,519-15,152-22,785-30,418-38,052-45,685-53,318-60,951-68,584-76,218-83,851-91,484-99,117Ingresos netos - tamao 4 lote 2134,496110,00785,51789,59978,02959,74048,53137,321-73,94114,9013,691-7,519-15,152-22,785-30,418-38,052-45,685-53,318-60,951-68,584-76,218-83,851-91,484-99,117

otros gastos0123456789101112131415161718192021222324equipos agricolas3,6650.03,665equipos para capacitacion5,7505,750personal local en campo4,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,1574,157equipo tecnico del proyecto3,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,1003,100personal de coordinacin3,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,7003,700personal tcnico de apoyo2,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,000capacitacion, personal para6,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,0006,000operacin centros produccion15,8401,3201,3201,3201,3201,3201,3201,3201,3201,3201,3201,3201,320refrigerios 360360360materiales en la capacitacin16,0801,3401,3401,3401,3401,3401,3401,3401,3401,3401,3401,3401,340evaluador externo7,0797079contingencias e imprevistos11,000916.67916.67916.67916.67916.67916.67916.67916.67916.67916.67916.67916.67total egresos otros proyectos (costo operativo)6,1103,5773,5773,5777,24222,89329,61222,53322,53322,53322,53322,53322,53318,95718,95718,95718,95718,95718,95718,95718,95718,95718,95718,95718,957

0123456789101112131415161718192021222324flujo economico para el VAN/TIR tamao 1 sin 2do. Lote-184,731173,712164,907156,102147,298142,887122,82496,04376,34056,63836,93517,233-2,469-22,172-38,298-54,424-70,549-86,675-102,801-118,927-135,053-151,178-167,304-183,430-199,556-215,682flujo economico para el VAN/TIR tamao 4 sin 2do. Lote-184,731158,985134,496110,00785,51789,59978,02959,74048,53137,32126,11114,9013,691-7,519-15,152-22,785-30,418-38,052-45,685-53,318-60,951-68,584-76,218-83,851-91,484-99,117flujo economico para el VAN/TIR tamao 5 sin 2do. Lote-184,731154,076124,35994,64164,92471,83763,09847,64039,26130,88222,50314,1245,745-2,634-7,437-12,239-17,041-21,844-26,646-31,448-36,251-41,053-45,855-50,658-55,460-60,262flujo economico para el VAN/TIR tamao 7 sin 2do. Lote-184,731144,258104,08463,91123,73736,31233,23423,43820,72118,00415,28612,5699,8527,1347,9948,8539,71310,57211,43112,29113,15014,01014,86915,72816,58817,447flujo economico para el VAN/TIR tamao 8 sin 2do. Lote-184,731139,34993,94748,5463,14418,54918,30311,33711,45111,56411,67811,79211,90512,01915,70919,39923,09026,78030,47034,16037,85141,54145,23148,92252,61256,302flujo economico para el VAN/TIR tamao 16 sin 2do. Lote-184,731100,07712,850-74,377-161,603-123,551-101,151-85,469-62,709-39,948-17,1885,57328,33451,09477,431103,768130,106156,443182,780209,117235,454261,792288,129314,466340,803367,1400123456789101112131415161718192021222324flujo economico para el VAN/TIR tamao 1 con 2do. Lote-184,731173,712164,588155,464146,340140,890119,78991,96871,22654,35537,48320,6123,740-13,132-26,426-39,721-53,016-66,311-79,606-92,901-106,196-119,491-132,786-146,081-159,376-172,671flujo economico para el VAN/TIR tamao 4 con 2do. Lote-184,731158,985133,219107,45481,68881,61365,88743,44128,07528,18828,30228,41628,52928,64332,33336,02339,71443,40447,09450,78454,47558,16561,85565,54669,23672,926flujo economico para el VAN/TIR tamao 5 con 2do. Lote-184,731154,076122,76391,45060,13761,85447,91927,26613,69119,46625,24231,01736,79242,56851,92061,27270,62479,97689,32898,680108,032117,384126,736136,088145,440154,792flujo economico para el VAN/TIR tamao 7 con 2do. Lote-184,731144,258101,85059,44317,03522,33611,985-5,086-15,0772,02219,12136,22053,31870,41791,093111,768132,444153,119173,795194,470215,146235,821256,496277,172297,847318,523flujo economico para el VAN/TIR tamao 8 con 2do. Lote-184,731139,34991,39443,439-4,5152,577-5,983-21,261-29,461-6,70016,06038,82161,58284,342110,679137,016163,354189,691216,028242,365268,702295,040321,377347,714374,051400,388flujo economico para el VAN/TIR tamao 16 con 2do. Lote-184,731100,0777,744-84,589-176,922-155,496-149,721-150,666-144,532-76,477-8,42359,632127,686195,740267,372339,003410,634482,265553,896625,527697,158768,789840,420912,051983,6821,055,3130123456789101112131415161718192021222324flujo economico para el VAN/TIR tamao 1 con 3ero. Lote-184,731173,712164,269154,826145,383139,344117,65389,24367,91353,87239,83125,79011,750-2,291-12,755-23,219-33,683-44,147-54,611-65,076-75,540-86,004-96,468-106,932-117,396-127,860flujo economico para el VAN/TIR tamao 4 con 3er. Lote-184,731158,985131,943104,90077,85875,42757,34432,54214,81926,25637,69349,13060,56772,00487,018102,032117,046132,059147,073162,087177,101192,114207,128222,142237,156252,169flujo economico para el VAN/TIR tamao 5 con 3er. Lote-184,731154,076121,16788,25955,35054,12137,24113,642-2,87917,05136,98156,91076,84096,770120,276143,782167,289190,795214,301237,808261,314284,820308,327331,833355,339378,846flujo economico para el VAN/TIR tamao 7 con 3er. Lote-184,731144,25899,61754,97510,33411,510-2,965-24,159-38,274-1,35935,55572,470109,385146,300186,792227,283267,775308,266348,758389,249429,741470,232510,724551,215591,707632,198flujo economico para el VAN/TIR tamao 8 con 3er. Lote-184,731139,34988,84138,333-12,175-9,795-23,068-43,060-55,972-10,56534,84380,250125,658171,065220,049269,034318,018367,002415,986464,970513,954562,938611,922660,907709,891758,875flujo economico para el VAN/TIR tamao 16 con 3er. Lote-184,731100,0772,638-94,801-192,240-180,240-183,892-194,263-197,554-84,20629,142142,490255,839369,187486,112603,037719,962836,887953,8121,070,7361,187,6611,304,5861,421,5111,538,4361,655,3611,772,286

tasa 1tasa 2anualanual24%12%van para tamao 1 sin 2do. Lote254,640361,976van para tamao 4 sin 2do. Lote160,608261,205van para tamao 5 sin 2do. Lote129,263227,614van para tamao 7 sin 2do. Lote66,575160,433van para tamao 8 sin 2do. Lote35,231126,843van para tamao 16 sin 2do. Lote-215,522-141,881

van para tamao 1 con 2do. Lote256,011388,568van para tamao 4 con 2do. Lote166,090367,571van para tamao 5 con 2do. Lote136,116360,572van para tamao 7 con 2do. Lote76,169346,574van para tamao 8 con 2do. Lote46,196339,575van para tamao 16 con 2do. Lote-193,593283,583

van para tamao 1 con 3er. Lote259,260421,610van para tamao 4 con 3er. Lote179,088499,740van para tamao 5 con 3er. Lote152,363525,784van para tamao 7 con 3er. Lote98,915577,870van para tamao 8 scon 3er. Lote72,191603,914