practica 4 metodos 2
DESCRIPTION
IM2 UNSATRANSCRIPT
Hoja1Planta TamaoCosto unitarioCosto fijoCosto variableA2,50063.8619.15844.702Capacidad 2,5006,0009,500B6,000481236Inversin120,000231,387326,602C9,500469.236.8AoProduccinIngresosCosto fijoC. variableFlujo anual11,400119,0004789562582.88,522110477.8Ao1234522,500212,5004789511175552,850159650OpcionAABCC32,500212,5004789511175552,85015965042,500212,5004789511175552,85015965052,500212,5004789511175552,850159650Ao123450OpcionAAAAAFlujo99,9220C.T110477.81596501596501596501596500AoProduccinIngresosCosto fijoC. variableFlujo anualERROR:#VALUE!11,400119,00072,00050,400-3,40012240022,500212,50072,00090,00050,50016200035,500467,50072,000198,000197,50027000046,000510,00072,000216,000222,00028800056,000510,00072,000216,000222,0002880000Flujo457,21300AoProduccinIngresosCosto fijoC. variableFlujo anualERROR:#VALUE!11,400119,00087,40051,520-19,92013892022,500212,50087,40092,00033,10017940035,500467,50087,400202,400177,70028980047,500637,50087,400276,000274,10036340059,500807,50087,400349,600370,500437000Flujo508,878