{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Inicio_Merc_Comp","Merc_Comp_y3","Merc_Comp_y3_Equilibrio","Merc_Comp_y3_Fn_Oferta","Oculto_Merc_Comp","Merc_Comp_y2","Merc_Comp_y2_Equilibrio"],"not_rendered":{"charts":10,"images":6,"macros":1,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Inicio_Merc_Comp","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[24,0,24,2],[32,10,32,11],[33,10,33,11]]}
{"$rows_empty":24}
["    Descargue la versión Kindle"]
{"$rows_empty":8}
[{"$nulls":10},"Miguel Cervantes Jiménez"]

{"sheet":"Merc_Comp_y3","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[4,2,4,3],[10,1,10,4],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[21,1,21,4],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,2],[31,1,31,2],[33,1,33,2]]}
["MERCADOS COMPETITIVOS"]
[]
[]
[]
[null,null,"Parámetros función costos"]
[null,null,"a (y3)",{"v":1,"d":"1.0"}]
[null,null,"b (y2)",-2.3]
[null,null,"c (y)",{"v":40,"d":"40.0"}]
[null,null,"d",{"v":3000,"d":"3,000.0"}]
[null,null,"Inserte los datos correspondientes"]
[null,"Resultados del equilibrio"]
[null,"Precio",null,{"v":500,"d":"500.0"},{"$f":"D12","v":{"v":500,"d":"500.0"}}]
[null,"Cantidad de equilibrio",null,{"$f":"Oculto_Merc_Comp!C16","v":{"v":13.173161381577527,"d":"13.2"}},{"$f":"Oculto_Merc_Comp!B16","v":{"v":13.038087846700288,"d":"13.0"}}]
[null,"Cantidad y (minimiza CMe)",null,{"$f":"J15","v":{"v":11.843594233512825,"d":"11.84"}}]
[null,"Costo unitario",null,{"$f":"Oculto_Merc_Comp!C17","v":{"v":410.9696757687567,"d":"410.97"}},{"$f":"Oculto_Merc_Comp!B17","v":{"v":420.09922291820226,"d":"420.10"}},{"$nulls":3},"pegar",11.843594233512825]
[null,"Costo medio (mínimo)",null,{"$f":"Oculto_Merc_Comp!B31","v":{"v":416.33194203270074,"d":"416.33"}},{"$nulls":4},"min=0",{"$f":"2*D6*(J15)+D7-D9*(J15^(-2))","v":-2.5533006208888764E-5}]
[null,"Ingreso total",null,{"$f":"Oculto_Merc_Comp!C19","v":{"v":6586.580690788764,"d":"6,586.6"}},{"$f":"Oculto_Merc_Comp!B19","v":{"v":6519.043923350144,"d":"6,519.0"}}]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!C20","v":{"v":5413.769861836423,"d":"5,413.8"}},{"$f":"Oculto_Merc_Comp!B20","v":{"v":5477.290572738048,"d":"5,477.3"}}]
[null,"Beneficio",null,{"$f":"Oculto_Merc_Comp!C21","v":{"v":1172.8108289523407,"d":"1,172.8"}},{"$f":"Oculto_Merc_Comp!B21","v":{"v":1041.7533506120963,"d":"1,041.8"}}]
[null,"Impuesto unitario",null,null,{"v":10,"d":"10.0"}]
[]
[null,"Cuantificación de costos"]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!C23","v":{"v":5413.769861836423,"d":"5,413.77"}},{"$f":"Oculto_Merc_Comp!B23","v":{"v":5477.290572738048,"d":"5,477.29"}}]
[null,"Costo fijo",null,{"$f":"Oculto_Merc_Comp!C24","v":{"v":3000,"d":"3,000.00"}},{"$f":"Oculto_Merc_Comp!B24","v":{"v":3000,"d":"3,000.00"}}]
[null,"Costo variable",null,{"$f":"Oculto_Merc_Comp!C25","v":{"v":2413.769861836423,"d":"2,413.77"}},{"$f":"Oculto_Merc_Comp!B25","v":{"v":2477.2905727380476,"d":"2,477.29"}}]
[null,"Costo medio",null,{"$f":"Oculto_Merc_Comp!C26","v":{"v":410.96967576875664,"d":"410.97"}},{"$f":"Oculto_Merc_Comp!B26","v":{"v":420.09922291820226,"d":"420.10"}}]
[null,"Costo marginal",null,{"$f":"Oculto_Merc_Comp!C27","v":{"v":500.00000000000006,"d":"500.00"}},{"$f":"Oculto_Merc_Comp!B27","v":{"v":499.99999999999994,"d":"500.00"}}]
[null,"Costo fijo medio",null,{"$f":"Oculto_Merc_Comp!C28","v":{"v":227.73576616129944,"d":"227.74"}},{"$f":"Oculto_Merc_Comp!B28","v":{"v":230.09509026733915,"d":"230.10"}}]
[null,"Costo variable medio",null,{"$f":"Oculto_Merc_Comp!C29","v":{"v":183.23390960745724,"d":"183.23"}},{"$f":"Oculto_Merc_Comp!B29","v":{"v":190.0041326508631,"d":"190.00"}}]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]

{"sheet":"Merc_Comp_y3_Equilibrio","index":2,"n_rows":34,"n_cols":9,"rows_kept":34,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[4,2,4,3],[10,1,10,3],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[21,1,21,3],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
["MERCADO COMPETITIVO"]
[]
[]
[]
[null,null,"Parámetros función costos"]
[null,null,"a (y3)",{"v":3,"d":"3.0"}]
[null,null,"b (y2)",{"v":-6,"d":"-6.0"}]
[null,null,"c (y)",{"v":20,"d":"20.0"}]
[null,null,"d",{"v":120,"d":"120.0"}]
[null,null,"Inserte los datos correspondientes"]
[null,"Resultados del equilibrio"]
[null,"Precio",null,{"v":100,"d":"100.0"}]
[null,"Cantidad de equilibrio",null,{"$f":"Oculto_Merc_Comp!B58","v":{"v":3.534108422347542,"d":"3.5"}}]
[null,"Cantidad y (minimiza CMe)",null,{"$f":"I15","v":{"v":3.091977842933671,"d":"3.09"}}]
[null,"Costo unitario",null,{"$f":"Oculto_Merc_Comp!B59","v":{"v":80.21993214771462,"d":"80.22"}},{"$nulls":3},"pegar",3.091977842933671]
[null,"Costo medio (mínimo)",null,{"$f":"Oculto_Merc_Comp!B73","v":{"v":78.93922382070458,"d":"78.94"}},{"$nulls":3},"min=0",{"$f":"2*D6*(I15)+D7-D9*(I15^(-2))","v":-4.8852788143705084E-6}]
[null,"Ingreso total",null,{"$f":"Oculto_Merc_Comp!B61","v":{"v":353.4108422347542,"d":"353.4"}}]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!B62","v":{"v":283.50593784338656,"d":"283.5"}}]
[null,"Beneficio",null,{"$f":"Oculto_Merc_Comp!B63","v":{"v":69.90490439136767,"d":"69.9"}}]
[null,"Impuesto por unidad",null,{"v":10,"d":"10.0"}]
[{"$nulls":3},"Inserte el impuesto"]
[null,"Cuantificación de costos"]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!B65","v":{"v":283.50593784338656,"d":"283.51"}}]
[null,"Costo fijo",null,{"$f":"Oculto_Merc_Comp!B66","v":{"v":120,"d":"120.00"}}]
[null,"Costo variable",null,{"$f":"Oculto_Merc_Comp!B67","v":{"v":163.50593784338656,"d":"163.51"}}]
[null,"Costo medio",null,{"$f":"Oculto_Merc_Comp!B68","v":{"v":80.21993214771462,"d":"80.22"}}]
[null,"Costo marginal",null,{"$f":"Oculto_Merc_Comp!B69","v":{"v":100,"d":"100.00"}}]
[null,"Costo fijo medio",null,{"$f":"Oculto_Merc_Comp!B70","v":{"v":33.95481565907637,"d":"33.95"}}]
[null,"Costo variable medio",null,{"$f":"Oculto_Merc_Comp!B71","v":{"v":46.26511648863824,"d":"46.27"}}]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]

{"sheet":"Merc_Comp_y3_Fn_Oferta","index":3,"n_rows":35,"n_cols":9,"rows_kept":35,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[4,2,4,3],[10,1,10,3],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[22,1,22,3],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2]]}
["MERCADO COMPETITIVO"]
[]
[]
[]
[null,null,"Parámetros función costos"]
[null,null,"a (y3)",{"v":0.06,"d":"0.06000"}]
[null,null,"b (y2)",{"v":1E-4,"d":"0.00010"}]
[null,null,"c (y)",{"v":0.4,"d":"0.40"}]
[null,null,"d",{"v":45000,"d":"45,000.0"}]
[null,null,"Inserte los datos correspondientes"]
[null,"Resultados del equilibrio"]
[null,"Precio",null,{"v":1500,"d":"1,500.0"}]
[null,"Cantidad de equilibrio",null,{"$f":"Oculto_Merc_Comp!B99","v":{"v":91.27436493972483,"d":"91.3"}}]
[null,"Cantidad y (minimiza CMe)",null,{"$f":"I15","v":{"v":72.10980938545543,"d":"72.11"}}]
[null,"Costo unitario",null,{"$f":"Oculto_Merc_Comp!B100","v":{"v":993.2887515646571,"d":"993.29"}},{"$nulls":3},"pegar",72.10980938545543]
[null,"Costo medio (mínimo)",null,{"$f":"Oculto_Merc_Comp!B116","v":{"v":936.4449326366928,"d":"936.44"}},{"$nulls":3},"min=0",{"$f":"2*D6*(I15)+D7-D9*(I15^(-2))","v":-8.6092233686052566E-4}]
[null,"Costo variable medio (mínimo)",null,{"$f":"Oculto_Merc_Comp!B102","v":{"v":-8.3333333333333339E-4,"d":"-0.00"}}]
[null,"Cantidad y (minimiza CVMe)",null,{"$f":"Oculto_Merc_Comp!B103","v":{"v":2.5828223652835294,"d":"2.58"}}]
[null,"Ingreso total",null,{"$f":"Oculto_Merc_Comp!B104","v":{"v":136911.54740958725,"d":"136,911.5"}}]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!B105","v":{"v":90661.8000008362,"d":"90,661.8"}}]
[null,"Beneficio",null,{"$f":"Oculto_Merc_Comp!B106","v":{"v":46249.74740875105,"d":"46,249.7"}}]
[]
[null,"Cuantificación de costos"]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!B108","v":{"v":90661.8000008362,"d":"90,661.80"}}]
[null,"Costo fijo",null,{"$f":"Oculto_Merc_Comp!B109","v":{"v":45000,"d":"45,000.00"}}]
[null,"Costo variable",null,{"$f":"Oculto_Merc_Comp!B110","v":{"v":45661.8000008362,"d":"45,661.80"}}]
[null,"Costo medio",null,{"$f":"Oculto_Merc_Comp!B111","v":{"v":993.2887515646572,"d":"993.29"}}]
[null,"Costo marginal",null,{"$f":"Oculto_Merc_Comp!B112","v":{"v":1500.0000000000005,"d":"1,500.00"}}]
[null,"Costo fijo medio",null,{"$f":"Oculto_Merc_Comp!B113","v":{"v":493.01904241915906,"d":"493.02"}}]
[null,"Costo variable medio",null,{"$f":"Oculto_Merc_Comp!B114","v":{"v":500.2697091454982,"d":"500.27"}}]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]

{"sheet":"Oculto_Merc_Comp","index":4,"n_rows":123,"n_cols":52,"rows_kept":123,"hidden":true,"merged":[[0,0,0,25],[0,28,0,51],[37,28,37,51],[42,0,42,25],[83,0,83,25]]}
["FUNCIÒN DE COSTOS POLINOMIO DE TERCER GRADO     COMPLETO",{"$nulls":27},"FUNCIÓN DE COSTOS DE SEGUNDO GRADO       COMPLETO"]
[{"$nulls":3},"Ponderador","Producto Total","COSTO TOTAL","COSTO MEDIO","COSTO FIJO MEDIO","COSTO VARIABLE MEDIO","COSTO MARGINAL","PRECIO=Ingreso Marginal","COSTO UNITARIO","LineY","LineP","LineCU","P","IT","Line Xprod","Line Yprod","Line X","Line CT","Line IT","Max P","Max P","OFERTA","Q"]
[null,"con impuesto","sin impuesto",0,{"$f":"D3*$B$11","v":0},{"$f":"$B$7+($B$6*E3)+($B$5*(E3^2))+($B$4*(E3^3))+($B$9*(E3^4))","v":{"v":3000,"d":"3,000.00"}},0,0,{"$f":"G3-H3","v":0},{"$f":"(4*$B$9*(E3^3))+(3*$B$4*(E3^2))+(2*$B$5*(E3^1))+($B$6)","v":50},{"$f":"$B$15","v":{"v":500,"d":"500.0"}},{"$f":"$B$17","v":{"v":420.09922291820226,"d":"420.1"}},{"$f":"$B$16","v":{"v":13.038087846700288,"d":"13.0"}},{"$f":"(MAX(K3,L3))*D3","v":0},{"$f":"$B$16*D3","v":{"v":0,"d":"0.0"}},{"$f":"Q3-F3","v":{"v":-3000,"d":"(3,000.00)"}},{"$f":"$B$15*E3","v":0},{"$f":"$E$17","v":{"v":12.77732608976628,"d":"12.78"}},{"$f":"D3*$N$26","v":0},{"$f":"$E$17*D3","v":0},{"$f":"$F$17","v":{"v":5349.395211542011,"d":"5,349.40"}},{"$f":"$Q$17","v":{"v":6388.66304488314,"d":"6,388.66"}},{"$f":"$P$26","v":{"v":1039.2678333411295,"d":"1,039.27"}},{"$f":"D3*$P$26","v":0},{"$nulls":4},"FUNCIÒN DE COSTOS",null,null,"Ponderador","Producto Total","COSTO TOTAL","COSTO MEDIO","COSTO FIJO MEDIO","COSTO VARIABLE MEDIO","COSTO MARGINAL","PRECIO=Ingreso Marginal","COSTO UNITARIO","LineY","LineP","LineCU","P","IT","Line Xprod","Line Yprod","Line X","Line CT","Line IT","Max P","Max P"]
["a",{"$f":"Merc_Comp_y3!D6","v":{"v":1,"d":"1.0"}},{"$f":"B4","v":{"v":1,"d":"1.0"}},0.05,{"$f":"D4*$B$11","v":{"v":0.91266614926902,"d":"0.91"}},{"v":3044.477714552783,"d":"3,044.48"},{"$f":"(F4/E4)","v":{"v":3335.8065454615476,"d":"3,335.81"}},{"$f":"$B$7/E4","v":{"v":3287.072718104845,"d":"3,287.07"}},{"$f":"G4-H4","v":{"v":48.73382735670248,"d":"48.73"}},48.30061421342713,{"$f":"$B$15","v":{"v":500,"d":"500.0"}},{"$f":"$B$17","v":{"v":420.09922291820226,"d":"420.1"}},{"$f":"$B$16","v":{"v":13.038087846700288,"d":"13.0"}},{"v":25,"d":"25.00"},{"$f":"$B$16*D4","v":{"v":0.6519043923350144,"d":"0.7"}},{"v":-2588.144639918273,"d":"(2,588.14)"},{"$f":"$B$15*E4","v":{"v":456.33307463451,"d":"456.33"}},{"$f":"$E$17","v":{"v":12.77732608976628,"d":"12.78"}},{"$f":"D4*$N$26","v":{"v":319.43315224415704,"d":"319.43"}},{"$f":"$E$17*D4","v":{"v":0.638866304488314,"d":"0.64"}},{"$f":"$F$17","v":{"v":5349.395211542011,"d":"5,349.40"}},{"$f":"$Q$17","v":{"v":6388.66304488314,"d":"6,388.66"}},{"$f":"$P$26","v":1039.2678333411295},{"$f":"D4*$P$26","v":51.96339166705648},{"$f":"IF($J4>$I4,J4,($B$37*1.01))","v":49.164275},{"$f":"IF(E4<$B$38,$B$38,E4)","v":1.15},{"$nulls":5},0,{"$f":"AF4*$AD$11","v":0},{"$f":"$AD$7+($AD$6*AG4)+($AD$5*(AG4^2))","v":{"v":3000,"d":"3,000.00"}},0,0,{"$f":"AI4-AJ4","v":0},{"$f":"(2*$AD$5*(AG4^1))+($AD$6)","v":-20},{"$f":"$AD$15","v":{"v":400,"d":"400.0"}},{"$f":"$AD$17","v":{"v":247.14285714285714,"d":"247.1"}},{"$f":"$AD$16","v":52.5},{"$f":"(MAX(AM4,AN4))*AF4","v":0},{"$f":"$AD$16*AF4","v":{"v":0,"d":"0.0"}},{"$f":"AS4-AH4","v":{"v":-3000,"d":"(3,000.00)"}},{"$f":"$AD$15*AG4","v":0},{"$f":"$AD$13","v":{"v":52.5,"d":"52.50"}},{"$f":"AF4*$AP$27","v":0},{"$f":"$AD$16*AF4","v":0},{"$f":"$AH$18","v":{"v":12559.409999999998,"d":"12,559.41"}},{"$f":"$AS$18","v":{"v":20580,"d":"20,580.00"}},{"$f":"$AR$27","v":{"v":8020.590000000002,"d":"8,020.59"}},{"$f":"AF4*$AR$27","v":0}]
["b",{"$f":"Merc_Comp_y3!D7","v":-2.3},{"$f":"B5","v":-2.3},{"v":0.1,"d":"0.10"},{"v":1.82533229853804,"d":"1.83"},{"v":3089.6850990417574,"d":"3,089.69"},{"v":1692.6699327658712,"d":"1,692.67"},{"v":1643.5363590524225,"d":"1,643.54"},{"v":49.13357371344864,"d":"49.13"},51.59898542698351,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":50,"d":"50.00"},{"v":1.3038087846700288,"d":"1.3"},{"v":-2177.0189497727374,"d":"(2,177.02)"},{"v":912.66614926902,"d":"912.67"},{"v":12.77732608976628,"d":"12.78"},{"v":638.8663044883141,"d":"638.87"},{"v":1.277732608976628,"d":"1.28"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,103.92678333411295,{"$f":"IF($J5>$I5,J5,($B$37*1.01))","v":51.59898542698351},{"$f":"IF(E5<$B$38,$B$38,E5)","v":1.82533229853804},null,null,"b",{"$f":"Merc_Comp_y2!D6","v":{"v":4,"d":"4.0"}},"Y2",0.05,{"v":3.6750000000000003,"d":"3.68"},{"$f":"$AD$7+($AD$6*AG5)+($AD$5*(AG5^2))","v":{"v":2980.5225,"d":"2,980.52"}},{"$f":"(AH5/AG5)","v":{"v":811.0265306122449,"d":"811.03"}},{"$f":"$AD$7/AG5","v":{"v":816.3265306122448,"d":"816.33"}},{"$f":"AI5-AJ5","v":{"v":-5.2999999999999545,"d":"-5.30"}},{"$f":"(2*$AD$5*(AG5^1))+($AD$6)","v":9.400000000000002},{"$f":"$AD$15","v":{"v":400,"d":"400.0"}},{"$f":"$AD$17","v":{"v":247.14285714285714,"d":"247.1"}},{"$f":"$AD$16","v":52.5},{"$f":"(MAX(AM5,AN5))*AF5","v":{"v":20,"d":"20.00"}},{"$f":"$AD$16*AF5","v":{"v":2.625,"d":"2.6"}},{"$f":"AS5-AH5","v":{"v":-1510.5225,"d":"(1,510.52)"}},{"$f":"$AD$15*AG5","v":{"v":1470,"d":"1,470.00"}},{"$f":"$AD$13","v":{"v":52.5,"d":"52.50"}},{"$f":"AF5*$AP$27","v":{"v":1029,"d":"1,029.00"}},{"$f":"$AD$16*AF5","v":{"v":2.625,"d":"2.63"}},{"$f":"$AH$18","v":{"v":12559.409999999998,"d":"12,559.41"}},{"$f":"$AS$18","v":{"v":20580,"d":"20,580.00"}},{"$f":"$AR$27","v":8020.590000000002},{"$f":"AF5*$AR$27","v":401.0295000000001}]
["c",{"$f":"Merc_Comp_y3!D8+Merc_Comp_y3!E20","v":{"v":50,"d":"50.0"}},{"$f":"Merc_Comp_y3!D8","v":{"v":40,"d":"40.0"}},0.15,{"v":2.73799844780706,"d":"2.74"},{"v":3140.1834371032132,"d":"3,140.18"},{"v":1146.890145105186,"d":"1,146.89"},{"v":1095.6909060349485,"d":"1,095.69"},{"v":51.19923907023758,"d":"51.20"},59.89511364066914,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":75,"d":"75.00"},{"v":1.955713177005043,"d":"2.0"},{"v":-1771.1842131996832,"d":"(1,771.18)"},{"v":1368.99922390353,"d":"1,369.00"},{"v":12.77732608976628,"d":"12.78"},{"v":958.299456732471,"d":"958.30"},{"v":1.916598913464942,"d":"1.92"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,155.8901750011694,59.89511364066914,2.73799844780706,null,null,"c",{"$f":"Merc_Comp_y2!D7","v":{"v":-20,"d":"-20.0"}},"Y",{"v":0.1,"d":"0.10"},{"v":7.3500000000000005,"d":"7.35"},{"v":3069.09,"d":"3,069.09"},{"v":417.56326530612245,"d":"417.56"},{"$f":"$AD$7/AG6","v":{"v":408.1632653061224,"d":"408.16"}},{"v":9.400000000000034,"d":"9.40"},38.800000000000004,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":40,"d":"40.00"},{"v":5.25,"d":"5.3"},{"v":-129.09000000000015,"d":"(129.09)"},{"v":2940,"d":"2,940.00"},{"v":52.5,"d":"52.50"},{"v":2058,"d":"2,058.00"},5.25,{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,802.0590000000002]
["d",{"$f":"Merc_Comp_y3!D9","v":{"v":3000,"d":"3000.0"}},{"$f":"B7","v":{"v":3000,"d":"3000.0"}},{"v":0.2,"d":"0.20"},{"v":3.65066459707608,"d":"3.65"},{"v":3200.534012373441,"d":"3,200.53"},{"v":876.699002953281,"d":"876.70"},{"v":821.7681795262113,"d":"821.77"},{"v":54.930823427069754,"d":"54.93"},73.188998854484,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":100,"d":"100.00"},{"v":2.6076175693400576,"d":"2.6"},{"v":-1375.2017138354008,"d":"(1,375.20)"},{"v":1825.33229853804,"d":"1,825.33"},{"v":12.77732608976628,"d":"12.78"},{"v":1277.7326089766282,"d":"1,277.73"},{"v":2.555465217953256,"d":"2.56"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,207.8535666682259,73.188998854484,3.65066459707608,null,null,"d",{"$f":"Merc_Comp_y2!D8","v":{"v":3000,"d":"3000.0"}},0,0.15,{"v":11.025,"d":"11.03"},{"v":3265.7025,"d":"3,265.70"},{"v":296.20884353741496,"d":"296.21"},{"v":272.10884353741494,"d":"272.11"},{"v":24.100000000000023,"d":"24.10"},68.2,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":60,"d":"60.00"},{"v":7.875,"d":"7.9"},{"v":1144.2975000000001,"d":"1,144.30"},{"v":4410,"d":"4,410.00"},{"v":52.5,"d":"52.50"},{"v":3087,"d":"3,087.00"},{"v":7.875,"d":"7.88"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,1203.0885000000003]
["p",null,null,0.25,{"v":4.5633307463451,"d":"4.56"},{"v":3275.29810848873,"d":"3,275.30"},{"v":717.7428704049139,"d":"717.74"},{"v":657.4145436209691,"d":"657.41"},{"v":60.32832678394482,"d":"60.33"},91.48064106842813,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":125,"d":"125.00"},{"v":3.259521961675072,"d":"3.3"},{"v":-993.6327353161801,"d":"(993.63)"},{"v":2281.66537317255,"d":"2,281.67"},{"v":12.77732608976628,"d":"12.78"},{"v":1597.165761220785,"d":"1,597.17"},{"v":3.19433152244157,"d":"3.19"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,259.8169583352824,91.48064106842813,4.5633307463451,null,null,"p",null,null,{"v":0.2,"d":"0.20"},{"v":14.700000000000001,"d":"14.70"},{"v":3570.36,"d":"3,570.36"},{"v":242.88163265306122,"d":"242.88"},{"v":204.0816326530612,"d":"204.08"},{"v":38.80000000000001,"d":"38.80"},97.60000000000001,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":80,"d":"80.00"},10.5,{"v":2309.64,"d":"2,309.64"},{"v":5880,"d":"5,880.00"},{"v":52.5,"d":"52.50"},{"v":4116,"d":"4,116.00"},{"v":10.5,"d":"10.50"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,1604.1180000000004]
[null,{"v":0,"d":"0.0"},{"$f":"B9","v":{"v":0,"d":"0.0"}},{"v":0.3,"d":"0.30"},{"v":5.47599689561412,"d":"5.48"},{"v":3369.037009085371,"d":"3,369.04"},{"v":615.2372021583371,"d":"615.24"},{"v":547.8454530174743,"d":"547.85"},{"v":67.39174914086288,"d":"67.39"},114.7700402825015,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":150,"d":"150.00"},{"v":3.911426354010086,"d":"3.9"},{"v":-631.0385612783111,"d":"(631.04)"},{"v":2737.99844780706,"d":"2,738.00"},{"v":12.77732608976628,"d":"12.78"},{"v":1916.598913464942,"d":"1,916.60"},{"v":3.833197826929884,"d":"3.83"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,311.7803500023388,114.7700402825015,5.47599689561412,{"$nulls":3},{"v":0,"d":"0.0"},null,0.25,{"v":18.375,"d":"18.38"},{"v":3983.0625,"d":"3,983.06"},{"v":216.76530612244898,"d":"216.77"},{"v":163.26530612244898,"d":"163.27"},{"v":53.5,"d":"53.50"},127,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":100,"d":"100.00"},{"v":13.125,"d":"13.1"},{"v":3366.9375,"d":"3,366.94"},{"v":7350,"d":"7,350.00"},{"v":52.5,"d":"52.50"},{"v":5145,"d":"5,145.00"},{"v":13.125,"d":"13.13"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,2005.1475000000005]
[{"$nulls":3},0.35,{"v":6.38866304488314,"d":"6.39"},{"v":3486.3119977996553,"d":"3,486.31"},{"v":545.702907369945,"d":"545.70"},{"v":469.5818168721207,"d":"469.58"},{"v":76.1210904978243,"d":"76.12"},143.05719649670408,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":175,"d":"175.00"},{"v":4.5633307463451,"d":"4.6"},{"v":-291.9804753580852,"d":"(291.98)"},{"v":3194.33152244157,"d":"3,194.33"},{"v":12.77732608976628,"d":"12.78"},{"v":2236.032065709099,"d":"2,236.03"},{"v":4.472064131418198,"d":"4.47"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,363.7437416693953,143.05719649670408,6.38866304488314,{"$nulls":5},{"v":0.3,"d":"0.30"},22.05,{"v":4503.81,"d":"4,503.81"},{"v":204.2544217687075,"d":"204.25"},{"v":136.05442176870747,"d":"136.05"},{"v":68.20000000000002,"d":"68.20"},156.4,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":120,"d":"120.00"},{"v":15.75,"d":"15.8"},{"v":4316.19,"d":"4,316.19"},{"v":8820,"d":"8,820.00"},{"v":52.5,"d":"52.50"},{"v":6174,"d":"6,174.00"},15.75,{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,2406.1770000000006]
["Máxima cantidad de y",{"$f":"B35*1.4","v":{"v":18.2533229853804,"d":"18.3"}},{"$f":"B11","v":{"v":18.2533229853804,"d":"18.3"}},{"v":0.4,"d":"0.40"},{"v":7.30132919415216,"d":"7.30"},{"v":3631.6843582678716,"d":"3,631.68"},{"v":497.4004406179343,"d":"497.40"},{"v":410.88408976310564,"d":"410.88"},{"v":86.51635085482866,"d":"86.52"},176.34210971103593,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":200,"d":"200.00"},{"v":5.215235138680115,"d":"5.2"},{"v":18.98023880820847,"d":"18.98"},{"v":3650.66459707608,"d":"3,650.66"},{"v":12.77732608976628,"d":"12.78"},{"v":2555.4652179532563,"d":"2,555.47"},{"v":5.110930435906512,"d":"5.11"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,415.7071333364518,176.34210971103593,7.30132919415216,null,null,"Máxima cantidad de y",{"$f":"AD31*1.4","v":73.5},null,0.35,{"v":25.724999999999998,"d":"25.73"},{"v":5132.602499999999,"d":"5,132.60"},{"v":199.51807580174926,"d":"199.52"},{"v":116.61807580174928,"d":"116.62"},{"v":82.89999999999998,"d":"82.90"},185.79999999999998,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":140,"d":"140.00"},{"v":18.375,"d":"18.4"},{"v":5157.397500000001,"d":"5,157.40"},{"v":10290,"d":"10,290.00"},{"v":52.5,"d":"52.50"},{"v":7202.999999999999,"d":"7,203.00"},{"v":18.375,"d":"18.38"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,2807.2065000000007]
["Cantidad y (minimiza CMe)",{"v":32.72564681209457,"d":"32.726"},{"$f":"B12","v":{"v":32.72564681209457,"d":"32.726"}},0.45,{"v":8.21399534342118,"d":"8.21"},{"v":3809.715374126311,"d":"3,809.72"},{"v":463.80783222352557,"d":"463.81"},{"v":365.2303020116495,"d":"365.23"},{"v":98.57753021187608,"d":"98.58"},214.62477992549708,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":225,"d":"225.00"},{"v":5.8671395310151295,"d":"5.9"},{"v":297.28229758427915,"d":"297.28"},{"v":4106.99767171059,"d":"4,107.00"},{"v":12.77732608976628,"d":"12.78"},{"v":2874.898370197413,"d":"2,874.90"},{"v":5.749796740394826,"d":"5.75"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,467.6705250035083,214.62477992549708,8.21399534342118,null,null,"Cantidad y (minimiza CMe)",{"$f":"SQRT(AD7/AD5)","v":{"v":27.386127875258307,"d":"27.39"}},null,{"v":0.4,"d":"0.40"},{"v":29.400000000000002,"d":"29.40"},{"v":5869.4400000000005,"d":"5,869.44"},{"v":199.64081632653063,"d":"199.64"},{"v":102.0408163265306,"d":"102.04"},{"v":97.60000000000002,"d":"97.60"},215.20000000000002,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":160,"d":"160.00"},{"v":21,"d":"21.0"},{"v":5890.5599999999995,"d":"5,890.56"},{"v":11760,"d":"11,760.00"},{"v":52.5,"d":"52.50"},{"v":8232,"d":"8,232.00"},{"v":21,"d":"21.00"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,3208.236000000001]
["Inserte un valor y particular",{"$f":"B35","v":{"v":13.038087846700288,"d":"13.0"}},{"$f":"C35","v":{"v":13.173161381577527,"d":"13.2"}},{"v":0.5,"d":"0.50"},{"v":9.1266614926902,"d":"9.13"},{"v":4024.966329011264,"d":"4,024.97"},{"v":441.0119003794512,"d":"441.01"},{"v":328.70727181048454,"d":"328.71"},{"v":112.30462856896668,"d":"112.30"},257.90520714008744,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":250,"d":"250.00"},{"v":6.519043923350144,"d":"6.5"},{"v":538.3644173338362,"d":"538.36"},{"v":4563.3307463451,"d":"4,563.33"},{"v":12.77732608976628,"d":"12.78"},{"v":3194.33152244157,"d":"3,194.33"},{"v":6.38866304488314,"d":"6.39"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,519.6339166705648,257.90520714008744,9.1266614926902,null,null,"Inserte un valor y particular",{"$f":"AD31","v":52.5},null,0.45,{"v":33.075,"d":"33.08"},{"v":6714.322500000001,"d":"6,714.32"},{"v":203.002947845805,"d":"203.00"},{"v":90.70294784580499,"d":"90.70"},{"v":112.30000000000003,"d":"112.30"},244.60000000000002,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":180,"d":"180.00"},{"v":23.625,"d":"23.6"},{"v":6515.677500000001,"d":"6,515.68"},{"v":13230.000000000002,"d":"13,230.00"},{"v":52.5,"d":"52.50"},{"v":9261,"d":"9,261.00"},{"v":23.625,"d":"23.63"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,3609.265500000001]
[{"$nulls":3},0.55,{"v":10.03932764195922,"d":"10.04"},{"v":4281.99850655902,"d":"4,282.00"},{"v":426.5224384810862,"d":"426.52"},{"v":298.82479255498595,"d":"298.82"},{"v":127.69764592610028,"d":"127.70"},306.183391354807,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":275,"d":"275.00"},{"v":7.170948315685159,"d":"7.2"},{"v":737.6653144205902,"d":"737.67"},{"v":5019.66382097961,"d":"5,019.66"},{"v":12.77732608976628,"d":"12.78"},{"v":3513.764674685727,"d":"3,513.76"},{"v":7.027529349371455,"d":"7.03"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,571.5973083376213,306.183391354807,10.03932764195922,{"$nulls":5},{"v":0.5,"d":"0.50"},36.75,{"v":7667.25,"d":"7,667.25"},{"v":208.6326530612245,"d":"208.63"},{"v":81.63265306122449,"d":"81.63"},{"v":127,"d":"127.00"},274,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":200,"d":"200.00"},{"v":26.25,"d":"26.3"},{"v":7032.75,"d":"7,032.75"},{"v":14700,"d":"14,700.00"},{"v":52.5,"d":"52.50"},{"v":10290,"d":"10,290.00"},26.25,{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,4010.295000000001]
["Precio",{"$f":"Merc_Comp_y3!$D$12","v":{"v":500,"d":"500.0"}},{"$f":"B15","v":{"v":500,"d":"500.0"}},{"v":0.6,"d":"0.60"},{"v":10.95199379122824,"d":"10.95"},{"v":4585.3731904058695,"d":"4,585.37"},{"v":418.6793087920141,"d":"418.68"},{"v":273.9227265087371,"d":"273.92"},{"v":144.756582283277,"d":"144.76"},359.4593325696559,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":300,"d":"300.00"},{"v":7.822852708020172,"d":"7.8"},{"v":890.6237052082506,"d":"890.62"},{"v":5475.99689561412,"d":"5,476.00"},{"v":12.77732608976628,"d":"12.78"},{"v":3833.197826929884,"d":"3,833.20"},{"v":7.666395653859768,"d":"7.67"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,623.5607000046776,359.4593325696559,10.95199379122824,null,null,"Precio",{"$f":"Merc_Comp_y2!D11","v":{"v":400,"d":"400.0"}},null,0.55,{"v":40.425000000000004,"d":"40.43"},{"v":8728.222500000002,"d":"8,728.22"},{"v":215.91150278293136,"d":"215.91"},{"v":74.21150278293135,"d":"74.21"},{"v":141.70000000000002,"d":"141.70"},303.40000000000003,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":220.00000000000003,"d":"220.00"},{"v":28.875000000000004,"d":"28.9"},{"v":7441.7775,"d":"7,441.78"},{"v":16170.000000000002,"d":"16,170.00"},{"v":52.5,"d":"52.50"},{"v":11319.000000000002,"d":"11,319.00"},{"v":28.875000000000004,"d":"28.88"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,4411.3245000000015]
["Cantidad de Equilibrio",{"$f":"B35","v":{"v":13.038087846700288,"d":"13.0"}},{"$f":"C35","v":{"v":13.173161381577527,"d":"13.2"}},0.65,{"v":11.86465994049726,"d":"11.86"},{"v":4939.651664188103,"d":"4,939.65"},{"v":416.3331851870233,"d":"416.33"},{"v":252.85174754652655,"d":"252.85"},{"v":163.48143764049672,"d":"163.48"},417.7330307846339,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":325,"d":"325.00"},{"v":8.474757100355188,"d":"8.5"},{"v":992.6783060605276,"d":"992.68"},{"v":5932.32997024863,"d":"5,932.33"},{"v":12.77732608976628,"d":"12.78"},{"v":4152.630979174041,"d":"4,152.63"},{"v":8.305261958348082,"d":"8.31"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,675.5240916717343,417.7330307846339,11.86465994049726,null,null,"Cantidad de Equilibrio",{"$f":"AD31","v":52.5},null,{"v":0.6,"d":"0.60"},{"v":44.1,"d":"44.10"},{"v":9897.240000000002,"d":"9,897.24"},{"v":224.42721088435377,"d":"224.43"},{"v":68.02721088435374,"d":"68.03"},{"v":156.40000000000003,"d":"156.40"},332.8,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":240,"d":"240.00"},31.5,{"v":7742.759999999998,"d":"7,742.76"},{"v":17640,"d":"17,640.00"},{"v":52.5,"d":"52.50"},{"v":12348,"d":"12,348.00"},{"v":31.5,"d":"31.50"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,4812.354000000001]
["Costo Unitario",{"$f":"(B4*(B16^2))+(B5*B16)+B6+(B7/B16)","v":{"v":420.09922291820226,"d":"420.1"}},{"$f":"(C4*(C16^2))+(C5*C16)+C6+(C7/C16)","v":{"v":410.9696757687567,"d":"411.0"}},{"v":0.7,"d":"0.70"},{"v":12.77732608976628,"d":"12.78"},{"v":5349.395211542011,"d":"5,349.40"},{"v":418.66312043382,"d":"418.66"},{"v":234.79090843606036,"d":"234.79"},{"v":183.87221199775962,"d":"183.87"},481.0044859997413,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":350,"d":"350.00"},{"v":9.1266614926902,"d":"9.1"},{"v":1039.2678333411295,"d":"1,039.27"},{"v":6388.66304488314,"d":"6,388.66"},{"v":12.77732608976628,"d":"12.78"},{"v":4472.064131418198,"d":"4,472.06"},{"v":8.944128262836395,"d":"8.94"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,727.4874833387906,481.0044859997413,12.77732608976628,null,null,"Costo Unitario",{"$f":"(AD5*AD16)+AD6+(AD7/AD16)","v":{"v":247.14285714285714,"d":"247.1"}},null,0.65,{"v":47.775,"d":"47.78"},{"v":11174.3025,"d":"11,174.30"},{"v":233.89434850863424,"d":"233.89"},{"v":62.79434850863422,"d":"62.79"},{"v":171.10000000000002,"d":"171.10"},362.2,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":260,"d":"260.00"},{"v":34.125,"d":"34.1"},{"v":7935.6975,"d":"7,935.70"},{"v":19110,"d":"19,110.00"},{"v":52.5,"d":"52.50"},{"v":13377,"d":"13,377.00"},{"v":34.125,"d":"34.13"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,5213.383500000002]
["Cantidad y (minimiza CMe)",{"$f":"G17","v":{"v":418.66312043382,"d":"418.663"}},{"$f":"B18","v":{"v":418.66312043382,"d":"418.663"}},0.75,{"v":13.6899922390353,"d":"13.69"},{"v":5819.165116103883,"d":"5,819.17"},{"v":425.06708656205524,"d":"425.07"},{"v":219.13818120698969,"d":"219.14"},{"v":205.92890535506555,"d":"205.93"},549.2736982149779,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":375,"d":"375.00"},{"v":9.778565885025216,"d":"9.8"},{"v":1025.8310034137676,"d":"1,025.83"},{"v":6844.99611951765,"d":"6,845.00"},{"v":12.77732608976628,"d":"12.78"},{"v":4791.497283662355,"d":"4,791.50"},{"v":9.582994567324711,"d":"9.58"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,779.4508750058471,549.2736982149779,13.6899922390353,null,null,"Cantidad y (minimiza CMe)",{"$f":"AD12","v":{"v":27.386127875258307,"d":"27.386"}},null,{"v":0.7,"d":"0.70"},{"v":51.449999999999996,"d":"51.45"},{"v":12559.409999999998,"d":"12,559.41"},{"v":244.10903790087463,"d":"244.11"},{"v":58.30903790087464,"d":"58.31"},{"v":185.79999999999998,"d":"185.80"},391.59999999999997,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":280,"d":"280.00"},{"v":36.75,"d":"36.8"},{"v":8020.590000000002,"d":"8,020.59"},{"v":20580,"d":"20,580.00"},{"v":52.5,"d":"52.50"},{"v":14405.999999999998,"d":"14,406.00"},36.75,{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,5614.413000000001]
["Ingreso Total",{"$f":"B15*B16","v":6519.043923350144},{"$f":"C15*C16","v":6586.580690788764},{"v":0.8,"d":"0.80"},{"v":14.60265838830432,"d":"14.60"},{"v":6353.522661510009,"d":"6,353.52"},{"v":435.0935625939674,"d":"435.09"},{"v":205.44204488155282,"d":"205.44"},{"v":229.6515177124146,"d":"229.65"},622.5406674303437,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":400,"d":"400.00"},{"v":10.43047027736023,"d":"10.4"},{"v":947.8065326421511,"d":"947.81"},{"v":7301.32919415216,"d":"7,301.33"},{"v":12.77732608976628,"d":"12.78"},{"v":5110.930435906513,"d":"5,110.93"},{"v":10.221860871813025,"d":"10.22"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,831.4142666729036,622.5406674303437,14.60265838830432,null,null,"Ingreso Total",{"$f":"AD15*AD16","v":{"v":21000,"d":"21000.000"}},null,0.75,{"v":55.125,"d":"55.13"},{"v":14052.5625,"d":"14,052.56"},{"v":254.92176870748298,"d":"254.92"},{"v":54.42176870748299,"d":"54.42"},{"v":200.5,"d":"200.50"},421,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":300,"d":"300.00"},{"v":39.375,"d":"39.4"},{"v":7997.4375,"d":"7,997.44"},{"v":22050,"d":"22,050.00"},{"v":52.5,"d":"52.50"},{"v":15435,"d":"15,435.00"},{"v":39.375,"d":"39.38"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,6015.442500000001]
["Costo Total",{"$f":"B23","v":{"v":5477.290572738048,"d":"5477.291"}},{"$f":"C23","v":{"v":5413.769861836423,"d":"5413.770"}},0.85,{"v":15.51532453757334,"d":"15.52"},{"v":6957.029131396681,"d":"6,957.03"},{"v":448.39726778185644,"d":"448.40"},{"v":193.35721871204973,"d":"193.36"},{"v":255.0400490698067,"d":"255.04"},700.8053936458389,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":425,"d":"425.00"},{"v":11.082374669695245,"d":"11.1"},{"v":800.6331373899893,"d":"800.63"},{"v":7757.66226878667,"d":"7,757.66"},{"v":12.77732608976628,"d":"12.78"},{"v":5430.363588150669,"d":"5,430.36"},{"v":10.860727176301339,"d":"10.86"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,883.37765833996,700.8053936458389,15.51532453757334,null,null,"Costo Total",{"$f":"AD23","v":{"v":12975,"d":"12975.000"}},null,{"v":0.8,"d":"0.80"},{"v":58.800000000000004,"d":"58.80"},{"v":15653.760000000002,"d":"15,653.76"},{"v":266.22040816326535,"d":"266.22"},{"v":51.0204081632653,"d":"51.02"},{"v":215.20000000000005,"d":"215.20"},450.40000000000003,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":320,"d":"320.00"},{"v":42,"d":"42.0"},{"v":7866.239999999998,"d":"7,866.24"},{"v":23520,"d":"23,520.00"},{"v":52.5,"d":"52.50"},{"v":16464,"d":"16,464.00"},{"v":42,"d":"42.00"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,6416.472000000002]
["Beneficio",{"$f":"B19-B20","v":{"v":1041.7533506120963,"d":"1,041.8"}},{"$f":"C19-C20","v":{"v":1172.8108289523407,"d":"1,172.8"}},{"v":0.9,"d":"0.90"},{"v":16.42799068684236,"d":"16.43"},{"v":7634.245809400187,"d":"7,634.25"},{"v":464.7096504330666,"d":"464.71"},{"v":182.61515100582474,"d":"182.62"},{"v":282.0944994272419,"d":"282.09"},784.0678768614631,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":450,"d":"450.00"},{"v":11.734279062030259,"d":"11.7"},{"v":579.7495340209935,"d":"579.75"},{"v":8213.99534342118,"d":"8,214.00"},{"v":12.77732608976628,"d":"12.78"},{"v":5749.796740394826,"d":"5,749.80"},{"v":11.499593480789652,"d":"11.50"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,935.3410500070166,784.0678768614631,16.42799068684236,null,null,"Beneficio",{"$f":"AD19-AD20","v":{"v":8025,"d":"8,025.0"}},null,0.85,{"v":62.475,"d":"62.48"},{"v":17363.002500000002,"d":"17,363.00"},{"v":277.91920768307324,"d":"277.92"},{"v":48.019207683073226,"d":"48.02"},{"v":229.9,"d":"229.90"},479.8,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":340,"d":"340.00"},{"v":44.625,"d":"44.6"},{"v":7626.997499999998,"d":"7,627.00"},{"v":24990,"d":"24,990.00"},{"v":52.5,"d":"52.50"},{"v":17493,"d":"17,493.00"},{"v":44.625,"d":"44.63"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,6817.501500000001]
[{"$nulls":3},0.95,{"v":17.34065683611138,"d":"17.34"},{"v":8389.733979156817,"d":"8,389.73"},{"v":483.8186960533962,"d":"483.82"},{"v":173.00382726867608,"d":"173.00"},{"v":310.81486878472015,"d":"310.81"},872.3281170772165,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":475,"d":"475.00"},{"v":12.386183454365273,"d":"12.4"},{"v":280.5944388988719,"d":"280.59"},{"v":8670.32841805569,"d":"8,670.33"},{"v":12.77732608976628,"d":"12.78"},{"v":6069.229892638983,"d":"6,069.23"},{"v":12.138459785277966,"d":"12.14"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,987.304441674073,872.3281170772165,17.34065683611138,{"$nulls":5},{"v":0.9,"d":"0.90"},66.15,{"v":19180.290000000005,"d":"19,180.29"},{"v":289.95147392290255,"d":"289.95"},{"v":45.35147392290249,"d":"45.35"},{"v":244.60000000000005,"d":"244.60"},509.20000000000005,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":360,"d":"360.00"},{"v":47.25,"d":"47.3"},{"v":7279.709999999999,"d":"7,279.71"},{"v":26460.000000000004,"d":"26,460.00"},{"v":52.5,"d":"52.50"},{"v":18522,"d":"18,522.00"},47.25,{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,7218.531000000002]
["Costo Total",{"$f":"B4*(B13^(3))+B5*(B13^(2))+B6*B13+B7","v":{"v":5477.290572738048,"d":"5477.3"}},{"$f":"C4*(C13^(3))+C5*(C13^(2))+C6*C13+C7","v":{"v":5413.769861836423,"d":"5413.8"}},{"v":1,"d":"1.00"},{"v":18.2533229853804,"d":"18.25"},{"v":9228.054924302867,"d":"9,228.05"},{"v":505.55479304748377,"d":"505.55"},{"v":164.35363590524227,"d":"164.35"},{"v":341.2011571422415,"d":"341.20"},965.5861142930995,{"v":500,"d":"500.0"},{"v":420.09922291820226,"d":"420.1"},{"v":13.038087846700288,"d":"13.0"},{"v":500,"d":"500.00"},{"v":13.038087846700288,"d":"13.0"},{"v":-101.39343161266697,"d":"(101.39)"},{"v":9126.6614926902,"d":"9,126.66"},{"v":12.77732608976628,"d":"12.78"},{"v":6388.66304488314,"d":"6,388.66"},{"v":12.77732608976628,"d":"12.78"},{"v":5349.395211542011,"d":"5,349.40"},{"v":6388.66304488314,"d":"6,388.66"},1039.2678333411295,1039.2678333411295,965.5861142930995,18.2533229853804,null,null,"Costo Total",{"$f":"AD5*(AD13^(2))+AD6*AD13+AD7","v":{"v":12975,"d":"12975.0"}},null,0.95,{"v":69.825,"d":"69.83"},{"v":21105.6225,"d":"21,105.62"},{"v":302.26455424274974,"d":"302.26"},{"v":42.96455424274973,"d":"42.96"},{"v":259.3,"d":"259.30"},538.6,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":380,"d":"380.00"},{"v":49.875,"d":"49.9"},{"v":6824.377499999999,"d":"6,824.38"},{"v":27930,"d":"27,930.00"},{"v":52.5,"d":"52.50"},{"v":19551,"d":"19,551.00"},{"v":49.875,"d":"49.88"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,7619.560500000001]
["Costo Fijo",{"$f":"B7","v":{"v":3000,"d":"3000.0"}},{"$f":"C7","v":{"v":3000,"d":"3000.0"}},{"v":1,"d":"1.00"},{"$f":"B13","v":{"v":13.038087846700288,"d":"13.04"}},{"v":5477.290572738048,"d":"5,477.29"},{"$f":"(F24/E24)","v":{"v":420.09922291820226,"d":"420.10"}},{"v":230.09509026733915,"d":"230.10"},{"$f":"G24-H24","v":{"v":190.0041326508631,"d":"190.00"}},499.99999999999994,{"$nulls":5},{"v":1041.7533506120963,"d":"1,041.75"},{"$f":"$B$15*E24","v":{"v":6519.043923350144,"d":"6,519.04"}},{"$nulls":11},"Costo Fijo",{"$f":"AD7","v":{"v":3000,"d":"3000.0"}},null,{"v":1,"d":"1.00"},{"$f":"AF24*$AD$11","v":{"v":73.5,"d":"73.50"}},{"v":23139,"d":"23,139.00"},{"v":314.81632653061223,"d":"314.82"},{"v":40.816326530612244,"d":"40.82"},{"v":274,"d":"274.00"},568,{"v":400,"d":"400.0"},{"v":247.14285714285714,"d":"247.1"},52.5,{"v":400,"d":"400.00"},52.5,{"v":6261,"d":"6,261.00"},{"v":29400,"d":"29,400.00"},{"v":52.5,"d":"52.50"},{"v":20580,"d":"20,580.00"},{"v":52.5,"d":"52.50"},{"v":12559.409999999998,"d":"12,559.41"},{"v":20580,"d":"20,580.00"},8020.590000000002,8020.590000000002]
["Costo Variable",{"$f":"B23-B24","v":{"v":2477.2905727380476,"d":"2477.3"}},{"$f":"C23-C24","v":{"v":2413.769861836423,"d":"2413.8"}},{"$nulls":25},"Costo Variable",{"$f":"AD23-AD24","v":{"v":9975,"d":"9975.0"}},null,{"v":1,"d":"1.00"},{"$f":"$AD$31","v":{"v":52.5,"d":"52.50"}},{"v":12975,"d":"12,975.00"},{"$f":"(AH25/AG25)","v":{"v":247.14285714285714,"d":"247.14"}},{"v":57.142857142857146,"d":"57.14"},{"$f":"AI25-AJ25","v":{"v":190,"d":"190.00"}},400]
["Costo Medio",{"$f":"B23/B13","v":{"v":420.09922291820226,"d":"420.1"}},{"$f":"C23/C13","v":{"v":410.96967576875664,"d":"411.0"}},null,null,{"$f":"G23*1.1","v":{"v":556.1102723522322,"d":"556.11"}},{"$nulls":6},"MAX CT, IT",{"$f":"MAX(F17,Q17)","v":{"v":6388.66304488314,"d":"6,388.66"}},"Max P",{"$f":"MAX(P3:P23)","v":{"v":1039.2678333411295,"d":"1,039.27"}},{"$nulls":12},"Costo Medio",{"$f":"AD23/AD13","v":{"v":247.14285714285714,"d":"247.1"}}]
["Costo Marginal",{"$f":"(3*B4*(B13^(2)))+(2*B5*B13)+B6","v":{"v":499.99999999999994,"d":"500.0"}},{"$f":"(3*C4*(C13^(2)))+(2*C5*C13)+C6","v":{"v":500.00000000000006,"d":"500.0"}},null,null,102.025,{"$nulls":22},"Costo Marginal",{"$f":"(2*AD5*AD13)+AD6","v":{"v":400,"d":"400.0"}},null,{"v":100,"d":"100.00"},null,{"$f":"AI24*1.1","v":{"v":346.29795918367347,"d":"346.30"}},{"$nulls":6},"MAX CT, IT",{"$f":"MAX(AH18,AS18)","v":{"v":20580,"d":"20,580.00"}},"Max P",{"$f":"MAX(AR4:AR24)","v":{"v":8020.590000000002,"d":"8,020.59"}}]
["Costo Fijo Medio",{"$f":"B24/B13","v":{"v":230.09509026733915,"d":"230.1"}},{"$f":"C24/C13","v":{"v":227.73576616129944,"d":"227.7"}},{"$nulls":25},"Costo Fijo Medio",{"$f":"AD24/AD13","v":{"v":57.142857142857146,"d":"57.1"}},null,{"$f":"AD5-(AD7*(POWER(AF27,-2)))","v":{"v":3.7,"d":"3.70"}},null,102.025]
["Costo Variable Medio",{"$f":"B25/B13","v":{"v":190.0041326508631,"d":"190.0"}},{"$f":"C25/C13","v":{"v":183.23390960745724,"d":"183.2"}},{"$nulls":25},"Costo Variable Medio",{"$f":"AD25/AD13","v":{"v":190,"d":"190.0"}}]
["min",{"$f":"(B4*(B12^(3))+B5*(B12^(2))+B6*B12+B7)/B12","v":{"v":1137.370192563041,"d":"1137.4"}},{"$f":"(C4*(C12^(3))+C5*(C12^(2))+C6*C12+C7)/C12","v":{"v":1127.3701925630412,"d":"1127.4"}}]
["costo mínimo",{"$f":"(B4*(Merc_Comp_y3!D14^(3))+B5*(Merc_Comp_y3!D14^(2))+B6*Merc_Comp_y3!D14+B7)/Merc_Comp_y3!D14","v":416.33194203270074},{"$f":"(C4*(Merc_Comp_y3!F14^(3))+C5*(Merc_Comp_y3!F14^(2))+C6*Merc_Comp_y3!F14+C7)/Merc_Comp_y3!F14","v":{"$error":"#DIV/0!"}},{"$nulls":25},"y2 equilibrio",{"$f":"(AD15-AD6)/(2*AD5)","v":52.5}]
[null,{"$f":"2*B4*(B12)+B5-B7*(B12^(-2))","v":{"v":60.35008937336822,"d":"60.350089"}},{"$f":"2*C4*(C12)+C5-C7*(C12^(-2))","v":{"v":60.35008937336822,"d":"60.350089"}}]
[]
["y1 equilibrio",{"$f":"((-1*(2*B5*-1))+((((2*-1*B5)^(2))-((4*(3*-1*B4))*((B6*-1)+B15)))^(1/2)))/((2*(3*-1)*B4))","v":{"v":-11.504754513366956,"d":"-11.5"}},{"$f":"((-1*(2*C5*-1))+((((2*-1*C5)^(2))-((4*(3*-1*C4))*((C6*-1)+C15)))^(1/2)))/((2*(3*-1)*C4))","v":{"v":-11.639828048244196,"d":"-11.6"}}]
["y2 equilibrio",{"$f":"((-1*(2*B5*-1))-((((2*-1*B5)^(2))-((4*(3*-1*B4))*((B6*-1)+B15)))^(1/2)))/((2*(3*-1)*B4))","v":{"v":13.038087846700288,"d":"13.0"}},{"$f":"((-1*(2*C5*-1))-((((2*-1*C5)^(2))-((4*(3*-1*C4))*((C6*-1)+C15)))^(1/2)))/((2*(3*-1)*C4))","v":{"v":13.173161381577527,"d":"13.2"}}]
[]
["Min CMg",{"$f":"(3*B4*(B38^2))+(2*B5*B38)+B6","v":{"v":48.6775,"d":"48.7"}},{"$f":"(3*C4*(C38^2))+(2*C5*C38)+C6","v":{"v":38.6775,"d":"38.7"}}]
[null,{"$f":"(B5/(2*B4))*-1","v":{"v":1.15,"d":"1.2"}},{"$f":"(C5/(2*C4))*-1","v":{"v":1.15,"d":"1.2"}},{"$nulls":25},"FUNCIÓN DE COSTOS DE SEGUNDO GRADO       ÚNICAMENTE EQUILIBRIO"]
[]
[{"$nulls":31},"Ponderador","Producto Total","COSTO TOTAL","COSTO MEDIO","COSTO FIJO MEDIO","COSTO VARIABLE MEDIO","COSTO MARGINAL","PRECIO=Ingreso Marginal","COSTO UNITARIO","LineY","LineP","LineCU","P","IT","Line Xprod","Line Yprod","Line X","Line CT","Line IT","Max P","Max P"]
[{"$nulls":31},0,{"$f":"AF41*$AD$48","v":0},{"$f":"$AD$44+($AD$43*AG41)+($AD$42*(AG41^2))","v":{"v":2000,"d":"2,000.00"}},0,0,{"$f":"AI41-AJ41","v":0},{"$f":"(2*$AD$42*(AG41^1))+($AD$43)","v":-20},{"$f":"$AD$52","v":{"v":158,"d":"158.0"}},{"$f":"$AD$54","v":{"v":158.8876404494382,"d":"158.9"}},{"$f":"$AD$53","v":{"v":22.25,"d":"22.3"}},{"$f":"(MAX(AM41,AN41))*AF41","v":0},{"$f":"$AD$53*AF41","v":{"v":0,"d":"0.0"}},{"$f":"AS41-AH41","v":{"v":-2000,"d":"(2,000.00)"}},{"$f":"$AD$52*AG41","v":0},{"$f":"$AD$55","v":{"v":158.94208209126347,"d":"158.94"}},{"$f":"AF41*$AD$64","v":0},{"$f":"$AG$55*AF41","v":0},{"$f":"$AH$55","v":{"v":3465.7320999999993,"d":"3,465.73"}},{"$f":"$AS$55","v":{"v":3445.1899999999996,"d":"3,445.19"}},{"$f":"$AR$64","v":{"v":-20.542099999999664,"d":"(20.54)"}},{"$f":"AF41*$AR$64","v":0}]
[{"$nulls":28},"b",{"$f":"Merc_Comp_y2_Equilibrio!D6","v":{"v":4,"d":"4.0"}},"Y2",0.05,{"$f":"AF42*$AD$48","v":{"v":1.5575,"d":"1.56"}},{"$f":"$AD$44+($AD$43*AG42)+($AD$42*(AG42^2))","v":{"v":1978.5532249999999,"d":"1,978.55"}},{"$f":"(AH42/AG42)","v":{"v":1270.3391492776884,"d":"1,270.34"}},{"$f":"$AD$44/AG42","v":{"v":1284.1091492776884,"d":"1,284.11"}},{"$f":"AI42-AJ42","v":{"v":-13.769999999999982,"d":"-13.77"}},{"$f":"(2*$AD$42*(AG42^1))+($AD$43)","v":-7.539999999999999},{"$f":"$AD$52","v":{"v":158,"d":"158.0"}},{"$f":"$AD$54","v":{"v":158.8876404494382,"d":"158.9"}},{"$f":"$AD$53","v":{"v":22.25,"d":"22.3"}},{"$f":"(MAX(AM42,AN42))*AF42","v":{"v":7.944382022471911,"d":"7.94"}},{"$f":"$AD$53*AF42","v":{"v":1.1125,"d":"1.1"}},{"$f":"AS42-AH42","v":{"v":-1732.4682249999998,"d":"(1,732.47)"}},{"$f":"$AD$52*AG42","v":{"v":246.085,"d":"246.09"}},{"$f":"$AD$55","v":{"v":158.94208209126347,"d":"158.94"}},{"$f":"AF42*$AD$64","v":{"v":7.9,"d":"7.90"}},{"$f":"$AG$55*AF42","v":{"v":1.09025,"d":"1.09"}},{"$f":"$AH$55","v":{"v":3465.7320999999993,"d":"3,465.73"}},{"$f":"$AS$55","v":{"v":3445.1899999999996,"d":"3,445.19"}},{"$f":"$AR$64","v":{"v":-20.542099999999664,"d":"(20.54)"}},{"$f":"AF42*$AR$64","v":{"v":-1.0271049999999833,"d":"(1.03)"}}]
["FUNCIÒN DE COSTOS POLINOMIO DE TERCER GRADO     UNICAMENTE EQUILIBRIO",{"$nulls":27},"c",{"$f":"Merc_Comp_y2_Equilibrio!D7","v":{"v":-20,"d":"-20.0"}},"Y",{"v":0.1,"d":"0.10"},{"v":3.115,"d":"3.12"},{"v":1976.5129,"d":"1,976.51"},{"v":634.5145746388442,"d":"634.51"},{"$f":"$AD$44/AG43","v":{"v":642.0545746388442,"d":"642.05"}},{"v":-7.539999999999964,"d":"-7.54"},4.920000000000002,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":15.888764044943821,"d":"15.89"},{"v":2.225,"d":"2.2"},{"v":-1484.3428999999999,"d":"(1,484.34)"},492.17,{"v":158.94208209126347,"d":"158.94"},{"v":15.8,"d":"15.80"},{"v":2.1805,"d":"2.18"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-2.0542099999999666,"d":"(2.05)"}]
[{"$nulls":3},"Ponderador","Producto Total","COSTO TOTAL","COSTO MEDIO","COSTO FIJO MEDIO","COSTO VARIABLE MEDIO","COSTO MARGINAL","PRECIO=Ingreso Marginal","COSTO UNITARIO","LineY","LineP","LineCU","P","IT","Line Xprod","Line Yprod","Line X","Line CT","Line IT","Max P","Max P","OFERTA","Q",null,null,"d",{"$f":"Merc_Comp_y2_Equilibrio!D8","v":{"v":2000,"d":"2000.0"}},0,0.15,{"v":4.672499999999999,"d":"4.67"},{"v":1993.879025,"d":"1,993.88"},{"v":426.7263830925629,"d":"426.73"},{"v":428.0363830925629,"d":"428.04"},{"v":-1.3100000000000023,"d":"-1.31"},17.379999999999995,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":23.83314606741573,"d":"23.83"},{"v":3.3375,"d":"3.3"},{"v":-1255.624025,"d":"(1,255.62)"},{"v":738.2549999999999,"d":"738.26"},{"v":158.94208209126347,"d":"158.94"},{"v":23.7,"d":"23.70"},{"v":3.270749999999999,"d":"3.27"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-3.0813149999999494,"d":"(3.08)"}]
[{"$nulls":3},0,{"$f":"D45*$B$53","v":0},{"$f":"$B$49+($B$48*E45)+($B$47*(E45^2))+($B$46*(E45^3))+($B$51*(E45^4))","v":{"v":120,"d":"120.00"}},0,0,{"$f":"G45-H45","v":0},{"$f":"(4*$B$9*(E45^3))+(3*$B$4*(E45^2))+(2*$B$5*(E45^1))+($B$6)","v":50},{"$f":"$B$57","v":{"v":100,"d":"100.0"}},{"$f":"$B$59","v":{"v":80.21993214771462,"d":"80.2"}},{"$f":"$B$58","v":{"v":3.534108422347542,"d":"3.5"}},{"$f":"(MAX(K45,L45))*D45","v":0},{"$f":"$B$58*D45","v":{"v":0,"d":"0.0"}},{"$f":"Q45-F45","v":{"v":-120,"d":"(120.00)"}},{"$f":"$B$57*E45","v":0},{"$f":"$E$59","v":{"v":3.4634262539005904,"d":"3.46"}},{"$f":"D45*$N$68","v":0},{"$f":"$E$59*D45","v":0},{"$f":"$F$59","v":{"v":276.5655924703816,"d":"276.57"}},{"$f":"$Q$59","v":{"v":346.342625390059,"d":"346.34"}},{"$f":"$P$68","v":{"v":69.77703291967742,"d":"69.78"}},{"$f":"D45*$P$68","v":0},{"$nulls":4},"p",null,null,{"v":0.2,"d":"0.20"},6.23,{"v":2030.6516000000001,"d":"2,030.65"},{"v":325.9472873194222,"d":"325.95"},{"v":321.0272873194221,"d":"321.03"},{"v":4.920000000000073,"d":"4.92"},29.840000000000003,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":31.777528089887642,"d":"31.78"},{"v":4.45,"d":"4.5"},{"v":-1046.3116,"d":"(1,046.31)"},984.34,{"v":158.94208209126347,"d":"158.94"},{"v":31.6,"d":"31.60"},{"v":4.361,"d":"4.36"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-4.108419999999933,"d":"(4.11)"}]
["a",{"$f":"Merc_Comp_y3_Equilibrio!D6","v":{"v":3,"d":"3.0"}},null,0.05,{"$f":"D46*$B$53","v":{"v":0.24738758956432794,"d":"0.25"}},{"$f":"$B$49+($B$48*E46)+($B$47*(E46^2))+($B$46*(E46^3))+($B$51*(E46^4))","v":{"v":127.09984479129906,"d":"127.10"}},{"$f":"(F46/E46)","v":{"v":513.7680714506878,"d":"513.77"}},{"$f":"$B$49/E46","v":{"v":485.0687951296624,"d":"485.07"}},{"$f":"G46-H46","v":{"v":28.699276321025366,"d":"28.70"}},{"$f":"(4*$B$51*(E46^3))+(3*$B$46*(E46^2))+(2*$B$47*(E46^1))+($B$48)","v":27.5821545004621},{"$f":"$B$57","v":{"v":100,"d":"100.0"}},{"$f":"$B$59","v":{"v":80.21993214771462,"d":"80.2"}},{"$f":"$B$58","v":{"v":3.534108422347542,"d":"3.5"}},{"v":5,"d":"5.00"},{"$f":"$B$58*D46","v":{"v":0.1767054211173771,"d":"0.2"}},{"v":-102.36108583486627,"d":"(102.36)"},{"$f":"$B$57*E46","v":{"v":24.738758956432793,"d":"24.74"}},{"$f":"$E$59","v":{"v":3.4634262539005904,"d":"3.46"}},{"$f":"D46*$N$68","v":{"v":17.31713126950295,"d":"17.32"}},{"$f":"$E$59*D46","v":{"v":0.17317131269502953,"d":"0.17"}},{"$f":"$F$59","v":{"v":276.5655924703816,"d":"276.57"}},{"$f":"$Q$59","v":{"v":346.342625390059,"d":"346.34"}},{"$f":"$P$68","v":{"v":69.77703291967742,"d":"69.78"}},{"$f":"D46*$P$68","v":3.488851645983871},{"$f":"IF($J46>$I46,J46,($B$79*1.01))","v":27.27},{"$f":"IF(E46<$B$80,$B$80,E46)","v":1},{"$nulls":3},{"v":0,"d":"0.0"},null,0.25,{"v":7.7875,"d":"7.79"},{"v":2086.830625,"d":"2,086.83"},{"v":267.97182985553775,"d":"267.97"},{"v":256.8218298555377,"d":"256.82"},{"v":11.150000000000034,"d":"11.15"},42.3,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":39.72191011235955,"d":"39.72"},{"v":5.5625,"d":"5.6"},{"v":-856.4056250000001,"d":"(856.41)"},{"v":1230.425,"d":"1,230.43"},{"v":158.94208209126347,"d":"158.94"},{"v":39.5,"d":"39.50"},{"v":5.451249999999999,"d":"5.45"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-5.135524999999916,"d":"(5.14)"}]
["b",{"$f":"Merc_Comp_y3_Equilibrio!D7","v":{"v":-6,"d":"-6.0"}},null,{"v":0.1,"d":"0.10"},{"v":0.4947751791286559,"d":"0.49"},{"v":133.73780707610422,"d":"133.74"},{"v":270.3001539237046,"d":"270.30"},{"$f":"$B$49/E47","v":{"v":242.5343975648312,"d":"242.53"}},{"v":27.765756358873404,"d":"27.77"},{"$f":"(4*$B$51*(E47^3))+(3*$B$46*(E47^2))+(2*$B$47*(E47^1))+($B$48)","v":26.265920151392272},{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":10,"d":"10.00"},{"v":0.3534108422347542,"d":"0.4"},{"v":-84.26028916323864,"d":"(84.26)"},{"v":49.477517912865586,"d":"49.48"},{"v":3.4634262539005904,"d":"3.46"},{"v":34.6342625390059,"d":"34.63"},{"v":0.34634262539005906,"d":"0.35"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},6.977703291967742,{"$f":"IF($J47>$I47,J47,($B$79*1.01))","v":27.27},{"$f":"IF(E47<$B$80,$B$80,E47)","v":1},{"$nulls":5},{"v":0.3,"d":"0.30"},{"v":9.344999999999999,"d":"9.35"},{"v":2162.4161,"d":"2,162.42"},{"v":231.39819154628145,"d":"231.40"},{"v":214.01819154628146,"d":"214.02"},{"v":17.379999999999995,"d":"17.38"},54.75999999999999,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":47.66629213483146,"d":"47.67"},{"v":6.675,"d":"6.7"},{"v":-685.9061000000002,"d":"(685.91)"},{"v":1476.5099999999998,"d":"1,476.51"},{"v":158.94208209126347,"d":"158.94"},{"v":47.4,"d":"47.40"},{"v":6.541499999999998,"d":"6.54"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-6.162629999999899,"d":"(6.16)"}]
["c",{"$f":"Merc_Comp_y3_Equilibrio!D8+B64","v":{"v":30,"d":"30.0"}},null,0.15,{"v":0.7421627686929837,"d":"0.74"},{"v":140.18641178156696,"d":"140.19"},{"v":188.88903849009836,"d":"188.89"},{"v":161.68959837655416,"d":"161.69"},{"v":27.1994401135442,"d":"27.20"},26.051296952790512,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":15,"d":"15.00"},{"v":0.5301162633521312,"d":"0.5"},{"v":-65.97013491226859,"d":"(65.97)"},{"v":74.21627686929837,"d":"74.22"},{"v":3.4634262539005904,"d":"3.46"},{"v":51.951393808508854,"d":"51.95"},{"v":0.5195139380850885,"d":"0.52"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},10.466554937951614,27.27,1,null,null,"Máxima cantidad de y",{"$f":"AD68*1.4","v":{"v":31.15,"d":"31.2"}},null,0.35,{"v":10.902499999999998,"d":"10.90"},{"v":2257.4080249999997,"d":"2,257.41"},{"v":207.05416418252696,"d":"207.05"},{"v":183.44416418252698,"d":"183.44"},{"v":23.609999999999985,"d":"23.61"},67.21999999999998,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":55.61067415730337,"d":"55.61"},{"v":7.7875,"d":"7.8"},{"v":-534.8130249999999,"d":"(534.81)"},{"v":1722.5949999999998,"d":"1,722.60"},{"v":158.94208209126347,"d":"158.94"},{"v":55.3,"d":"55.30"},{"v":7.6317499999999985,"d":"7.63"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-7.189734999999882,"d":"(7.19)"}]
["d",{"$f":"Merc_Comp_y3_Equilibrio!D9","v":{"v":120,"d":"120.0"}},null,{"v":0.2,"d":"0.20"},{"v":0.9895503582573117,"d":"0.99"},{"v":146.71818383483878,"d":"146.72"},{"v":148.26752636745326,"d":"148.27"},{"v":121.2671987824156,"d":"121.27"},{"v":27.000327585037653,"d":"27.00"},26.938284904656825,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":20,"d":"20.00"},{"v":0.7068216844695084,"d":"0.7"},{"v":-47.76314800910761,"d":"(47.76)"},{"v":98.95503582573117,"d":"98.96"},{"v":3.4634262539005904,"d":"3.46"},{"v":69.2685250780118,"d":"69.27"},{"v":0.6926852507801181,"d":"0.69"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},13.955406583935485,27.27,1,null,null,"Cantidad y (minimiza CMe)",{"$f":"SQRT(AD44/AD42)","v":{"v":22.360679774997898,"d":"22.36"}},null,{"v":0.4,"d":"0.40"},12.46,{"v":2371.8064,"d":"2,371.81"},{"v":190.35364365971105,"d":"190.35"},{"v":160.51364365971105,"d":"160.51"},{"v":29.840000000000003,"d":"29.84"},79.68,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":63.555056179775285,"d":"63.56"},8.9,{"v":-403.1263999999999,"d":"(403.13)"},{"v":1968.68,"d":"1,968.68"},{"v":158.94208209126347,"d":"158.94"},{"v":63.2,"d":"63.20"},{"v":8.722,"d":"8.72"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-8.216839999999866,"d":"(8.22)"}]
["p",null,null,0.25,{"v":1.2369379478216396,"d":"1.24"},{"v":153.60564816307115,"d":"153.61"},{"v":124.1821777992863,"d":"124.18"},{"v":97.01375902593249,"d":"97.01"},{"v":27.168418773353807,"d":"27.17"},28.92688400699121,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":25,"d":"25.00"},{"v":0.8835271055868855,"d":"0.9"},{"v":-29.91185338090719,"d":"(29.91)"},{"v":123.69379478216396,"d":"123.69"},{"v":3.4634262539005904,"d":"3.46"},{"v":86.58565634751476,"d":"86.59"},{"v":0.8658565634751476,"d":"0.87"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},17.444258229919356,28.92688400699121,1.2369379478216396,null,null,"Inserte un valor y particular",{"$f":"AD68","v":{"v":22.25,"d":"22.3"}},null,0.45,{"v":14.0175,"d":"14.02"},{"v":2505.611225,"d":"2,505.61"},{"v":178.74879436418763,"d":"178.75"},{"v":142.6787943641876,"d":"142.68"},{"v":36.07000000000002,"d":"36.07"},92.14,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":71.49943820224719,"d":"71.50"},{"v":10.012500000000001,"d":"10.0"},{"v":-290.84622500000023,"d":"(290.85)"},{"v":2214.765,"d":"2,214.77"},{"v":158.94208209126347,"d":"158.94"},{"v":71.10000000000001,"d":"71.10"},{"v":9.812249999999999,"d":"9.81"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-9.243944999999849,"d":"(9.24)"}]
[null,{"v":0,"d":"0.0"},null,{"v":0.3,"d":"0.30"},{"v":1.4843255373859674,"d":"1.48"},{"v":161.12132969341553,"d":"161.12"},{"v":108.5485128667697,"d":"108.55"},{"v":80.84479918827708,"d":"80.84"},{"v":27.70371367849262,"d":"27.70"},32.01709425979365,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":30,"d":"30.00"},{"v":1.0602325267042625,"d":"1.1"},{"v":-12.688775954818794,"d":"(12.69)"},{"v":148.43255373859674,"d":"148.43"},{"v":3.4634262539005904,"d":"3.46"},{"v":103.90278761701771,"d":"103.90"},{"v":1.039027876170177,"d":"1.04"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},20.933109875903227,32.01709425979365,1.4843255373859674,{"$nulls":5},{"v":0.5,"d":"0.50"},{"v":15.575,"d":"15.58"},{"v":2658.8224999999998,"d":"2,658.82"},{"v":170.71091492776884,"d":"170.71"},{"v":128.41091492776886,"d":"128.41"},{"v":42.29999999999998,"d":"42.30"},104.6,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":79.4438202247191,"d":"79.44"},{"v":11.125,"d":"11.1"},{"v":-197.97249999999985,"d":"(197.97)"},{"v":2460.85,"d":"2,460.85"},{"v":158.94208209126347,"d":"158.94"},{"v":79,"d":"79.00"},{"v":10.902499999999998,"d":"10.90"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-10.271049999999832,"d":"(10.27)"}]
[{"$nulls":3},0.35,{"v":1.7317131269502952,"d":"1.73"},{"v":169.53775335302342,"d":"169.54"},{"v":97.90175446183449,"d":"97.90"},{"v":69.29554216138035,"d":"69.30"},{"v":28.606212300454132,"d":"28.61"},36.208915663064175,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":35,"d":"35.00"},{"v":1.2369379478216396,"d":"1.2"},{"v":3.6335593420060945,"d":"3.63"},{"v":173.1713126950295,"d":"173.17"},{"v":3.4634262539005904,"d":"3.46"},{"v":121.21991888652065,"d":"121.22"},{"v":1.2121991888652066,"d":"1.21"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},24.4219615218871,36.208915663064175,1.7317131269502952,null,null,"Precio",{"$f":"Merc_Comp_y2_Equilibrio!D11","v":{"v":158,"d":"158.0"}},null,0.55,{"v":17.1325,"d":"17.13"},{"v":2831.4402250000003,"d":"2,831.44"},{"v":165.2671953888808,"d":"165.27"},{"v":116.73719538888078,"d":"116.74"},{"v":48.530000000000015,"d":"48.53"},117.06,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":87.38820224719102,"d":"87.39"},{"v":12.2375,"d":"12.2"},{"v":-124.50522500000034,"d":"(124.51)"},{"v":2706.935,"d":"2,706.94"},{"v":158.94208209126347,"d":"158.94"},{"v":86.9,"d":"86.90"},{"v":11.99275,"d":"11.99"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-11.298154999999817,"d":"(11.30)"}]
["Máxima cantidad de y",{"$f":"B77*1.4","v":{"v":4.947751791286558,"d":"4.9"}},null,{"v":0.4,"d":"0.40"},{"v":1.9791007165146235,"d":"1.98"},{"v":179.12744406904636,"d":"179.13"},{"v":90.50951403044616,"d":"90.51"},{"v":60.6335993912078,"d":"60.63"},{"v":29.875914639238353,"d":"29.88"},41.50234821680279,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":40,"d":"40.00"},{"v":1.4136433689390169,"d":"1.4"},{"v":18.782627582415984,"d":"18.78"},{"v":197.91007165146235,"d":"197.91"},{"v":3.4634262539005904,"d":"3.46"},{"v":138.5370501560236,"d":"138.54"},{"v":1.3853705015602362,"d":"1.39"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},27.91081316787097,41.50234821680279,1.9791007165146235,null,null,"Cantidad de Equilibrio",{"$f":"AD68","v":{"v":22.25,"d":"22.3"}},null,{"v":0.6,"d":"0.60"},{"v":18.689999999999998,"d":"18.69"},{"v":3023.4644,"d":"3,023.46"},{"v":161.76909577314072,"d":"161.77"},{"v":107.00909577314073,"d":"107.01"},{"v":54.75999999999999,"d":"54.76"},129.51999999999998,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":95.33258426966292,"d":"95.33"},{"v":13.35,"d":"13.4"},{"v":-70.44440000000031,"d":"(70.44)"},{"v":2953.0199999999995,"d":"2,953.02"},{"v":158.94208209126347,"d":"158.94"},{"v":94.8,"d":"94.80"},{"v":13.082999999999997,"d":"13.08"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-12.325259999999798,"d":"(12.33)"}]
["Cantidad y (minimiza CMe)",{"v":32.72564681209457,"d":"32.726"},null,0.45,{"v":2.2264883060789513,"d":"2.23"},{"v":190.1629267686357,"d":"190.16"},{"v":85.40935348702996,"d":"85.41"},{"v":53.896532792184715,"d":"53.90"},{"v":31.512820694845246,"d":"31.51"},47.897391921009444,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":45,"d":"45.00"},{"v":1.590348790056394,"d":"1.6"},{"v":32.48590383925941,"d":"32.49"},{"v":222.64883060789512,"d":"222.65"},{"v":3.4634262539005904,"d":"3.46"},{"v":155.85418142552658,"d":"155.85"},{"v":1.5585418142552658,"d":"1.56"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},31.39966481385484,47.897391921009444,2.2264883060789513,null,null,"Costo Unitario",{"$f":"(AD42*AD53)+AD43+(AD44/AD53)","v":{"v":158.8876404494382,"d":"158.9"}},null,0.65,{"v":20.2475,"d":"20.25"},{"v":3234.895025,"d":"3,234.90"},{"v":159.7676268675145,"d":"159.77"},{"v":98.77762686751451,"d":"98.78"},{"v":60.989999999999995,"d":"60.99"},141.98,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":103.27696629213484,"d":"103.28"},{"v":14.4625,"d":"14.5"},{"v":-35.79002499999979,"d":"(35.79)"},{"v":3199.105,"d":"3,199.11"},{"v":158.94208209126347,"d":"158.94"},{"v":102.7,"d":"102.70"},{"v":14.173249999999998,"d":"14.17"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-13.352364999999782,"d":"(13.35)"}]
["Inserte un valor y particular",{"$f":"B77","v":{"v":3.534108422347542,"d":"3.5"}},null,{"v":0.5,"d":"0.50"},{"v":2.473875895643279,"d":"2.47"},{"v":202.91672637894305,"d":"202.92"},{"v":82.02380998024108,"d":"82.02"},{"v":48.50687951296624,"d":"48.51"},{"v":33.51693046727484,"d":"33.52"},55.39404677568419,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":50,"d":"50.00"},{"v":1.767054211173771,"d":"1.8"},{"v":44.47086318538487,"d":"44.47"},{"v":247.38758956432793,"d":"247.39"},{"v":3.4634262539005904,"d":"3.46"},{"v":173.1713126950295,"d":"173.17"},{"v":1.7317131269502952,"d":"1.73"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},34.88851645983871,55.39404677568419,2.473875895643279,null,null,"Cantidad y (minimiza CMe)",{"$f":"AI55","v":{"v":158.94208209126347,"d":"158.942"}},null,{"v":0.7,"d":"0.70"},{"v":21.804999999999996,"d":"21.81"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":158.94208209126347,"d":"158.94"},{"v":91.72208209126349,"d":"91.72"},{"v":67.21999999999998,"d":"67.22"},154.43999999999997,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":111.22134831460674,"d":"111.22"},{"v":15.575,"d":"15.6"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":158.94208209126347,"d":"158.94"},{"v":110.6,"d":"110.60"},{"v":15.263499999999997,"d":"15.26"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-14.379469999999763,"d":"(14.38)"}]
[{"$nulls":3},0.55,{"v":2.7212634852076074,"d":"2.72"},{"v":217.66136782711985,"d":"217.66"},{"v":79.98540715013279,"d":"79.99"},{"v":44.097163193605674,"d":"44.10"},{"v":35.88824395652711,"d":"35.89"},63.992312780827,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":55.00000000000001,"d":"55.00"},{"v":1.9437596322911483,"d":"1.9"},{"v":54.46498069364091,"d":"54.46"},{"v":272.12634852076076,"d":"272.13"},{"v":3.4634262539005904,"d":"3.46"},{"v":190.48844396453248,"d":"190.49"},{"v":1.9048844396453248,"d":"1.90"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},38.37736810582258,63.992312780827,2.7212634852076074,null,null,"Ingreso Total",{"$f":"AD52*AD53","v":{"v":3515.5,"d":"3515.500"}},null,0.75,{"v":23.362499999999997,"d":"23.36"},{"v":3715.9756249999996,"d":"3,715.98"},{"v":159.0572766185126,"d":"159.06"},{"v":85.60727661851259,"d":"85.61"},73.45,166.89999999999998,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":119.16573033707866,"d":"119.17"},{"v":16.6875,"d":"16.7"},{"v":-24.700624999999945,"d":"(24.70)"},{"v":3691.2749999999996,"d":"3,691.28"},{"v":158.94208209126347,"d":"158.94"},{"v":118.5,"d":"118.50"},{"v":16.353749999999998,"d":"16.35"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-15.406574999999748,"d":"(15.41)"}]
["Precio",{"$f":"Merc_Comp_y3_Equilibrio!D12","v":{"v":100,"d":"100.0"}},null,{"v":0.6,"d":"0.60"},{"v":2.968651074771935,"d":"2.97"},{"v":234.66937604031753,"d":"234.67"},{"v":79.04916075674063,"d":"79.05"},{"v":40.42239959413854,"d":"40.42"},{"v":38.626761162602094,"d":"38.63"},73.69218993643784,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":60,"d":"60.00"},{"v":2.120465053408525,"d":"2.1"},{"v":62.195731436875946,"d":"62.20"},{"v":296.8651074771935,"d":"296.87"},{"v":3.4634262539005904,"d":"3.46"},{"v":207.80557523403542,"d":"207.81"},{"v":2.078055752340354,"d":"2.08"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},41.866219751806454,73.69218993643784,2.968651074771935,null,null,"Costo Total",{"$f":"AD60","v":{"v":3535.25,"d":"3535.250"}},null,{"v":0.8,"d":"0.80"},24.92,{"v":3985.6256000000003,"d":"3,985.63"},{"v":159.93682182985555,"d":"159.94"},{"v":80.25682182985553,"d":"80.26"},{"v":79.68000000000002,"d":"79.68"},179.36,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":127.11011235955057,"d":"127.11"},17.8,{"v":-48.26560000000018,"d":"(48.27)"},{"v":3937.36,"d":"3,937.36"},{"v":158.94208209126347,"d":"158.94"},{"v":126.4,"d":"126.40"},{"v":17.444,"d":"17.44"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-16.433679999999733,"d":"(16.43)"}]
["Cantidad de Equilibrio",{"$f":"B77","v":{"v":3.534108422347542,"d":"3.5"}},null,0.65,{"v":3.216038664336263,"d":"3.22"},{"v":254.21327594568766,"d":"254.21"},{"v":79.04546632624302,"d":"79.05"},{"v":37.31298424074326,"d":"37.31"},{"v":41.732482085499754,"d":"41.73"},84.49367824251681,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":65,"d":"65.00"},{"v":2.2971704745259025,"d":"2.3"},{"v":67.39059048793865,"d":"67.39"},{"v":321.6038664336263,"d":"321.60"},{"v":3.4634262539005904,"d":"3.46"},{"v":225.12270650353838,"d":"225.12"},{"v":2.251227065035384,"d":"2.25"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},45.355071397790326,84.49367824251681,3.216038664336263,null,null,"Beneficio",{"$f":"AD56-AD57","v":{"v":-19.75,"d":"-19.8"}},null,0.85,{"v":26.4775,"d":"26.48"},{"v":4274.682025,"d":"4,274.68"},{"v":161.4458323104523,"d":"161.45"},{"v":75.53583231045228,"d":"75.54"},{"v":85.91000000000001,"d":"85.91"},191.82,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":135.05449438202248,"d":"135.05"},{"v":18.912499999999998,"d":"18.9"},{"v":-91.23702500000036,"d":"(91.24)"},{"v":4183.445,"d":"4,183.45"},{"v":158.94208209126347,"d":"158.94"},{"v":134.29999999999998,"d":"134.30"},{"v":18.534249999999997,"d":"18.53"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-17.460784999999714,"d":"(17.46)"}]
["Costo Unitario",{"$f":"(B46*(B58^2))+(B47*B58)+B48+(B49/B58)","v":{"v":80.21993214771462,"d":"80.2"}},null,{"v":0.7,"d":"0.70"},{"v":3.4634262539005904,"d":"3.46"},{"v":276.5655924703816,"d":"276.57"},{"v":79.85317780591028,"d":"79.85"},{"v":34.64777108069018,"d":"34.65"},{"v":45.2054067252201,"d":"45.21"},96.3967776990638,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":70,"d":"70.00"},{"v":2.473875895643279,"d":"2.5"},{"v":69.77703291967742,"d":"69.78"},{"v":346.342625390059,"d":"346.34"},{"v":3.4634262539005904,"d":"3.46"},{"v":242.4398377730413,"d":"242.44"},{"v":2.4243983777304132,"d":"2.42"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},48.8439230437742,96.3967776990638,3.4634262539005904,{"$nulls":5},{"v":0.9,"d":"0.90"},{"v":28.035,"d":"28.04"},{"v":4583.1449,"d":"4,583.14"},{"v":163.4793971820938,"d":"163.48"},{"v":71.3393971820938,"d":"71.34"},92.14,204.28,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":142.99887640449438,"d":"143.00"},{"v":20.025000000000002,"d":"20.0"},{"v":-153.6149000000005,"d":"(153.61)"},{"v":4429.53,"d":"4,429.53"},{"v":158.94208209126347,"d":"158.94"},{"v":142.20000000000002,"d":"142.20"},{"v":19.624499999999998,"d":"19.62"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-18.487889999999698,"d":"(18.49)"}]
["Cantidad y (minimiza CMe)",{"$f":"G59","v":{"v":79.85317780591028,"d":"79.853"}},null,0.75,{"v":3.7108138434649187,"d":"3.71"},{"v":301.99885054155095,"d":"302.00"},{"v":81.38345475707396,"d":"81.38"},{"v":32.33791967531083,"d":"32.34"},{"v":49.045535081763134,"d":"49.05"},109.4014883060789,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":75,"d":"75.00"},{"v":2.6505813167606567,"d":"2.7"},{"v":69.08253380494091,"d":"69.08"},{"v":371.08138434649186,"d":"371.08"},{"v":3.4634262539005904,"d":"3.46"},{"v":259.75696904254426,"d":"259.76"},{"v":2.597569690425443,"d":"2.60"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},52.33277468975807,109.4014883060789,3.7108138434649187,null,null,"Costo Total",{"$f":"AD42*(AD50^(2))+AD43*AD50+AD44","v":{"v":3535.25,"d":"3535.3"}},null,0.95,{"v":29.592499999999998,"d":"29.59"},{"v":4911.014224999999,"d":"4,911.01"},{"v":165.95469206724675,"d":"165.95"},{"v":67.58469206724678,"d":"67.58"},{"v":98.36999999999998,"d":"98.37"},216.73999999999998,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":150.94325842696628,"d":"150.94"},{"v":21.1375,"d":"21.1"},{"v":-235.3992249999992,"d":"(235.40)"},{"v":4675.615,"d":"4,675.62"},{"v":158.94208209126347,"d":"158.94"},{"v":150.1,"d":"150.10"},{"v":20.714749999999995,"d":"20.71"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-19.51499499999968,"d":"(19.51)"}]
["Ingreso Total",{"$f":"B57*B58","v":353.4108422347542},null,{"v":0.8,"d":"0.80"},{"v":3.958201433029247,"d":"3.96"},{"v":330.7855750863472,"d":"330.79"},{"v":83.56966685073277,"d":"83.57"},{"v":30.3167996956039,"d":"30.32"},{"v":53.25286715512887,"d":"53.25"},123.50781006356209,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":80,"d":"80.00"},{"v":2.8272867378780338,"d":"2.8"},{"v":65.0345682165775,"d":"65.03"},{"v":395.8201433029247,"d":"395.82"},{"v":3.4634262539005904,"d":"3.46"},{"v":277.0741003120472,"d":"277.07"},{"v":2.7707410031204724,"d":"2.77"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},55.82162633574194,123.50781006356209,3.958201433029247,null,null,"Costo Fijo",{"$f":"AD44","v":{"v":2000,"d":"2000.0"}},null,{"v":1,"d":"1.00"},31.15,{"v":5258.289999999999,"d":"5,258.29"},{"v":168.8054574638844,"d":"168.81"},{"v":64.20545746388443,"d":"64.21"},{"v":104.59999999999998,"d":"104.60"},229.2,{"v":158,"d":"158.0"},{"v":158.8876404494382,"d":"158.9"},{"v":22.25,"d":"22.3"},{"v":158.8876404494382,"d":"158.89"},{"v":22.25,"d":"22.3"},{"v":-336.58999999999924,"d":"(336.59)"},{"v":4921.7,"d":"4,921.70"},{"v":158.94208209126347,"d":"158.94"},{"v":158,"d":"158.00"},{"v":21.804999999999996,"d":"21.81"},{"v":3465.7320999999993,"d":"3,465.73"},{"v":3445.1899999999996,"d":"3,445.19"},{"v":-20.542099999999664,"d":"(20.54)"},{"v":-20.542099999999664,"d":"(20.54)"}]
["Costo Total",{"$f":"B65","v":{"v":283.50593784338656,"d":"283.506"}},null,0.85,{"v":4.205589022593575,"d":"4.21"},{"v":363.19829103192177,"d":"363.20"},{"v":86.36086148235626,"d":"86.36"},{"v":28.533458537038968,"d":"28.53"},{"v":57.82740294531729,"d":"57.83"},138.71574297151335,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":85,"d":"85.00"},{"v":3.003992158995411,"d":"3.0"},{"v":57.3606112274357,"d":"57.36"},{"v":420.55890225935747,"d":"420.56"},{"v":3.4634262539005904,"d":"3.46"},{"v":294.3912315815502,"d":"294.39"},{"v":2.943912315815502,"d":"2.94"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},59.31047798172581,138.71574297151335,4.205589022593575,null,null,"Costo Variable",{"$f":"AD60-AD61","v":{"v":1535.25,"d":"1535.3"}},null,{"v":1,"d":"1.00"},31.15,{"v":5258.289999999999,"d":"5,258.29"},{"$f":"(AH62/AG62)","v":{"v":168.8054574638844,"d":"168.81"}},{"v":64.20545746388443,"d":"64.21"},{"$f":"AI62-AJ62","v":{"v":104.59999999999998,"d":"104.60"}},229.2]
["Beneficio",{"$f":"B61-B62","v":{"v":69.90490439136767,"d":"69.9"}},null,{"v":0.9,"d":"0.90"},{"v":4.452976612157903,"d":"4.45"},{"v":399.5095233054261,"d":"399.51"},{"v":89.71740884842076,"d":"89.72"},{"v":26.948266396092357,"d":"26.95"},{"v":62.7691424523284,"d":"62.77"},155.02528702993263,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":90,"d":"90.00"},{"v":3.180697580112788,"d":"3.2"},{"v":45.78813791036413,"d":"45.79"},{"v":445.29766121579024,"d":"445.30"},{"v":3.4634262539005904,"d":"3.46"},{"v":311.70836285105315,"d":"311.71"},{"v":3.1170836285105317,"d":"3.12"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},62.79932962770968,155.02528702993263,4.452976612157903,null,null,"Costo Medio",{"$f":"AD60/AD50","v":{"v":158.8876404494382,"d":"158.9"}}]
["impuesto por unidad",{"$f":"Merc_Comp_y3_Equilibrio!D20","v":{"v":10,"d":"10.000"}},null,0.95,{"v":4.7003642017222305,"d":"4.70"},{"v":439.9917968340118,"d":"439.99"},{"v":93.60802226193391,"d":"93.61"},{"v":25.529936585771708,"d":"25.53"},{"v":68.0780856761622,"d":"68.08"},172.43644223881998,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":95,"d":"95.00"},{"v":3.357403001230165,"d":"3.4"},{"v":30.044623338211295,"d":"30.04"},{"v":470.0364201722231,"d":"470.04"},{"v":3.4634262539005904,"d":"3.46"},{"v":329.02549412055606,"d":"329.03"},{"v":3.2902549412055606,"d":"3.29"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},66.28818127369355,172.43644223881998,4.7003642017222305,null,null,"Costo Marginal",{"$f":"(2*AD42*AD50)+AD43","v":{"v":158,"d":"158.0"}},null,{"v":100,"d":"100.00"},null,{"$f":"AI61*1.1","v":{"v":185.68600321027287,"d":"185.69"}},{"$nulls":6},"MAX CT, IT",{"$f":"MAX(AH55,AS55)","v":{"v":3465.7320999999993,"d":"3,465.73"}},"Max P",{"$f":"MAX(AR41:AR61)","v":{"v":-20.542099999999664,"d":"(20.54)"}}]
["Costo Total",{"$f":"B46*(B55^(3))+B47*(B55^(2))+B48*B55+B49","v":{"v":283.50593784338656,"d":"283.5"}},null,{"v":1,"d":"1.00"},{"v":4.947751791286558,"d":"4.95"},{"v":484.9176365448302,"d":"484.92"},{"v":98.00767237330182,"d":"98.01"},{"v":24.25343975648312,"d":"24.25"},{"v":73.7542326168187,"d":"73.75"},190.94920859817543,{"v":100,"d":"100.0"},{"v":80.21993214771462,"d":"80.2"},{"v":3.534108422347542,"d":"3.5"},{"v":100,"d":"100.00"},{"v":3.534108422347542,"d":"3.5"},{"v":9.857542583825648,"d":"9.86"},{"v":494.77517912865585,"d":"494.78"},{"v":3.4634262539005904,"d":"3.46"},{"v":346.342625390059,"d":"346.34"},{"v":3.4634262539005904,"d":"3.46"},{"v":276.5655924703816,"d":"276.57"},{"v":346.342625390059,"d":"346.34"},{"v":69.77703291967742,"d":"69.78"},69.77703291967742,190.94920859817543,4.947751791286558,null,null,"Costo Fijo Medio",{"$f":"AD61/AD50","v":{"v":89.88764044943821,"d":"89.9"}},null,{"$f":"AD42-(AD44*(POWER(AF64,-2)))","v":{"v":3.8,"d":"3.80"}},null,102.025]
["Costo Fijo",{"$f":"B49","v":{"v":120,"d":"120.0"}},null,{"v":1,"d":"1.00"},{"v":4.947751791286558,"d":"4.95"},{"v":484.9176365448302,"d":"484.92"},{"$f":"(F66/E66)","v":{"v":98.00767237330182,"d":"98.01"}},{"v":24.25343975648312,"d":"24.25"},{"$f":"G66-H66","v":{"v":73.7542326168187,"d":"73.75"}},190.94920859817543,{"$nulls":5},{"v":9.857542583825648,"d":"9.86"},{"v":494.77517912865585,"d":"494.78"},{"$nulls":11},"Costo Variable Medio",{"$f":"AD62/AD50","v":{"v":69,"d":"69.0"}}]
["Costo Variable",{"$f":"B65-B66","v":{"v":163.50593784338656,"d":"163.5"}}]
["Costo Medio",{"$f":"B65/B55","v":{"v":80.21993214771462,"d":"80.2"}},{"$nulls":3},{"$f":"G65*1.1","v":{"v":107.808439610632,"d":"107.81"}},{"$nulls":6},"MAX CT, IT",{"$f":"MAX(F59,Q59)","v":{"v":346.342625390059,"d":"346.34"}},"Max P",{"$f":"MAX(P45:P65)","v":{"v":69.77703291967742,"d":"69.78"}},{"$nulls":12},"y2 equilibrio",{"$f":"(AD52-AD43)/(2*AD42)","v":{"v":22.25,"d":"22.3"}}]
["Costo Marginal",{"$f":"(3*B46*(B55^(2)))+(2*B47*B55)+B48","v":{"v":100,"d":"100.0"}},{"$nulls":3},102.025]
["Costo Fijo Medio",{"$f":"B66/B55","v":{"v":33.95481565907637,"d":"34.0"}}]
["Costo Variable Medio",{"$f":"B67/B55","v":{"v":46.26511648863824,"d":"46.3"}}]
["min",{"$f":"(B46*(B54^(3))+B47*(B54^(2))+B48*B54+B49)/B54","v":{"v":3050.216845775735,"d":"3050.2"}}]
["costo mínimo",{"$f":"(B46*(Merc_Comp_y3_Equilibrio!D14^(3))+B47*(Merc_Comp_y3_Equilibrio!D14^(2))+B48*Merc_Comp_y3_Equilibrio!D14+B49)/Merc_Comp_y3_Equilibrio!D14","v":78.93922382070458}]
[null,{"$f":"2*B46*(B54)+B47-B49*(B54^(-2))","v":{"v":190.24183270253457,"d":"190.241833"}}]
[]
["y1 equilibrio",{"$f":"((-1*(2*B47*-1))+((((2*-1*B47)^(2))-((4*(3*-1*B46))*((B48*-1)+B57)))^(1/2)))/((2*(3*-1)*B46))","v":{"v":-2.200775089014209,"d":"-2.2"}}]
["y2 equilibrio",{"$f":"((-1*(2*B47*-1))-((((2*-1*B47)^(2))-((4*(3*-1*B46))*((B48*-1)+B57)))^(1/2)))/((2*(3*-1)*B46))","v":{"v":3.534108422347542,"d":"3.5"}}]
[]
["Min CMg",{"$f":"(3*B46*(B80^2))+(2*B47*B80)+B48","v":{"v":27,"d":"27.0"}}]
[null,{"$f":"(B47/(2*B46))*-1","v":{"v":1,"d":"1.0"}}]
[]
[]
[]
["FUNCIÒN DE COSTOS POLINOMIO DE TERCER GRADO     OFERTA"]
[{"$nulls":3},"Ponderador","Producto Total","COSTO TOTAL","COSTO MEDIO","COSTO FIJO MEDIO","COSTO VARIABLE MEDIO","COSTO MARGINAL","PRECIO=Ingreso Marginal","COSTO UNITARIO","LineY","LineP","LineCU","P","IT","Line Xprod","Line Yprod","Line X","Line CT","Line IT","Max P","Max P","OFERTA","Q"]
[{"$nulls":3},0,{"$f":"D86*$B$94","v":0},{"$f":"$B$90+($B$89*E86)+($B$88*(E86^2))+($B$87*(E86^3))+($B$92*(E86^4))","v":{"v":45000,"d":"45,000.00"}},0,0,{"$f":"G86-H86","v":0},{"$f":"(4*$B$9*(E86^3))+(3*$B$4*(E86^2))+(2*$B$5*(E86^1))+($B$6)","v":50},{"$f":"$B$98","v":{"v":1500,"d":"1500.0"}},{"$f":"$B$100","v":{"v":993.2887515646571,"d":"993.3"}},{"$f":"$B$99","v":{"v":91.27436493972483,"d":"91.3"}},{"$f":"(MAX(K86,L86))*D86","v":0},{"$f":"$B$99*D86","v":{"v":0,"d":"0.0"}},{"$f":"Q86-F86","v":{"v":-45000,"d":"(45,000.00)"}},{"$f":"$B$98*E86","v":0},{"$f":"$E$100","v":{"v":89.44887764093033,"d":"89.45"}},{"$f":"D86*$N$109","v":0},{"$f":"$E$100*D86","v":0},{"$f":"$F$100","v":{"v":87977.95373881227,"d":"87,977.95"}},{"$f":"$Q$100","v":{"v":134173.3164613955,"d":"134,173.32"}},{"$f":"$P$109","v":{"v":46195.36272258323,"d":"46,195.36"}},{"$f":"D86*$P$109","v":0}]
["a",{"$f":"Merc_Comp_y3_Fn_Oferta!D6","v":{"v":0.06,"d":"0.0600"}},"Y3",0.05,{"$f":"D87*$B$94","v":{"v":6.389205545780738,"d":"6.39"}},{"$f":"$B$90+($B$89*E87)+($B$88*(E87^2))+($B$87*(E87^3))+($B$92*(E87^4))","v":{"v":45018.20895321685,"d":"45,018.21"}},{"$f":"(F87/E87)","v":{"v":7045.979133187486,"d":"7,045.98"}},{"$f":"$B$90/E87","v":{"v":7043.1291774165575,"d":"7,043.13"}},{"$f":"G87-H87","v":{"v":2.849955770928318,"d":"2.85"}},{"$f":"(4*$B$92*(E87^3))+(3*$B$87*(E87^2))+(2*$B$88*(E87^1))+($B$89)","v":7.749228392231519},{"$f":"$B$98","v":{"v":1500,"d":"1500.0"}},{"$f":"$B$100","v":{"v":993.2887515646571,"d":"993.3"}},{"$f":"$B$99","v":{"v":91.27436493972483,"d":"91.3"}},{"v":75,"d":"75.00"},{"$f":"$B$99*D87","v":{"v":4.563718246986242,"d":"4.6"}},{"v":-35434.40063454574,"d":"(35,434.40)"},{"$f":"$B$98*E87","v":{"v":9583.808318671108,"d":"9,583.81"}},{"$f":"$E$100","v":{"v":89.44887764093033,"d":"89.45"}},{"$f":"D87*$N$109","v":{"v":6708.665823069776,"d":"6,708.67"}},{"$f":"$E$100*D87","v":{"v":4.472443882046517,"d":"4.47"}},{"$f":"$F$100","v":{"v":87977.95373881227,"d":"87,977.95"}},{"$f":"$Q$100","v":{"v":134173.3164613955,"d":"134,173.32"}},{"$f":"$P$109","v":{"v":46195.36272258323,"d":"46,195.36"}},{"$f":"D87*$P$109","v":2309.7681361291616},{"$f":"IF($J87>$I87,J87,($B$102*1.01))","v":7.749228392231519},{"$f":"IF(E87<$B$123,$B$123,E87)","v":6.389205545780738}]
["b",{"$f":"Merc_Comp_y3_Fn_Oferta!D7","v":{"v":1E-4,"d":"0.0001"}},"Y2",{"v":0.1,"d":"0.10"},{"v":12.778411091561477,"d":"12.78"},{"$f":"$B$90+($B$89*E88)+($B$88*(E88^2))+($B$87*(E88^3))+($B$92*(E88^4))","v":{"v":45130.32120364591,"d":"45,130.32"}},{"v":3531.763133950885,"d":"3,531.76"},{"$f":"$B$90/E88","v":{"v":3521.5645887082787,"d":"3,521.56"}},{"v":10.198545242606087,"d":"10.20"},{"$f":"(4*$B$92*(E88^3))+(3*$B$87*(E88^2))+(2*$B$88*(E88^1))+($B$89)","v":29.794357886707758},{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":150,"d":"150.00"},{"v":9.127436493972484,"d":"9.1"},{"v":-25962.70456630369,"d":"(25,962.70)"},{"v":19167.616637342217,"d":"19,167.62"},{"v":89.44887764093033,"d":"89.45"},{"v":13417.331646139552,"d":"13,417.33"},{"v":8.944887764093034,"d":"8.94"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},4619.536272258323,{"$f":"IF($J88>$I88,J88,($B$102*1.01))","v":29.794357886707758},{"$f":"IF(E88<$B$123,$B$123,E88)","v":12.778411091561477}]
["c",{"$f":"Merc_Comp_y3_Fn_Oferta!D8","v":{"v":0.4,"d":"0.4000"}},"Y",0.15,{"v":19.167616637342213,"d":"19.17"},{"v":45430.23188410988,"d":"45,430.23"},{"v":2370.1554942205507,"d":"2,370.16"},{"v":2347.7097258055196,"d":"2,347.71"},{"v":22.445768415031125,"d":"22.45"},66.53538848342872,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":225,"d":"225.00"},{"v":13.691154740958725,"d":"13.7"},{"v":-16678.80692809656,"d":"(16,678.81)"},{"v":28751.42495601332,"d":"28,751.42"},{"v":89.44887764093033,"d":"89.45"},{"v":20125.997469209324,"d":"20,126.00"},{"v":13.41733164613955,"d":"13.42"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},6929.304408387485,66.53538848342872,19.167616637342213]
["d",{"$f":"Merc_Comp_y3_Fn_Oferta!D9","v":{"v":45000,"d":"45000.0"}},0,{"v":0.2,"d":"0.20"},{"v":25.556822183122954,"d":"25.56"},{"v":46011.83612743147,"d":"46,011.84"},{"v":1800.3739196423435,"d":"1,800.37"},{"v":1760.7822943541394,"d":"1,760.78"},{"v":39.59162528820411,"d":"39.59"},117.97232018239443,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":300,"d":"300.00"},{"v":18.254872987944967,"d":"18.3"},{"v":-7676.6028527470335,"d":"(7,676.60)"},{"v":38335.23327468443,"d":"38,335.23"},{"v":89.44887764093033,"d":"89.45"},{"v":26834.663292279103,"d":"26,834.66"},{"v":17.889775528186068,"d":"17.89"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},9239.072544516646,117.97232018239443,25.556822183122954]
["p",null,null,0.25,{"v":31.94602772890369,"d":"31.95"},{"v":46969.029066433395,"d":"46,969.03"},{"v":1470.2619513454374,"d":"1,470.26"},{"v":1408.6258354833117,"d":"1,408.63"},{"v":61.636115862125735,"d":"61.64"},184.1051529836048,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":375,"d":"375.00"},{"v":22.81859123493121,"d":"22.8"},{"v":950.0125269221389,"d":"950.01"},{"v":47919.041593355534,"d":"47,919.04"},{"v":89.44887764093033,"d":"89.45"},{"v":33543.329115348875,"d":"33,543.33"},{"v":22.362219410232584,"d":"22.36"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},11548.840680645808,184.1051529836048,31.94602772890369]
[null,{"v":0,"d":"0.0"},null,{"v":0.3,"d":"0.30"},{"v":38.33523327468443,"d":"38.34"},{"v":48395.70583393835,"d":"48,395.71"},{"v":1262.4341030395553,"d":"1,262.43"},{"v":1173.8548629027598,"d":"1,173.85"},{"v":88.57924013679553,"d":"88.58"},264.9338868870599,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":450,"d":"450.00"},{"v":27.38230948191745,"d":"27.4"},{"v":9107.144078088291,"d":"9,107.14"},{"v":57502.84991202664,"d":"57,502.85"},{"v":89.44887764093033,"d":"89.45"},{"v":40251.99493841865,"d":"40,251.99"},{"v":26.8346632922791,"d":"26.83"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},13858.60881677497,264.9338868870599,38.33523327468443]
[{"$nulls":3},0.35,{"v":44.72443882046517,"d":"44.72"},{"v":50385.76156276906,"d":"50,385.76"},{"v":1126.582309171722,"d":"1,126.58"},{"v":1006.1613110595083,"d":"1,006.16"},{"v":120.42099811221374,"d":"120.42"},360.45852189275973,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":525,"d":"525.00"},{"v":31.94602772890369,"d":"31.9"},{"v":16700.89666792869,"d":"16,700.90"},{"v":67086.65823069775,"d":"67,086.66"},{"v":89.44887764093033,"d":"89.45"},{"v":46960.66076148842,"d":"46,960.66"},{"v":31.307107174325616,"d":"31.31"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},16168.37695290413,360.45852189275973,44.72443882046517]
["Máxima cantidad de y",{"$f":"B120*1.4","v":{"v":127.78411091561476,"d":"127.8"}},null,{"v":0.4,"d":"0.40"},{"v":51.11364436624591,"d":"51.11"},{"v":53033.09138574822,"d":"53,033.09"},{"v":1037.55253696545,"d":"1,037.55"},{"v":880.3911471770697,"d":"880.39"},{"v":157.16138978838023,"d":"157.16"},470.6790580007044,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":600,"d":"600.00"},{"v":36.509745975889935,"d":"36.5"},{"v":23637.375163620643,"d":"23,637.38"},{"v":76670.46654936887,"d":"76,670.47"},{"v":89.44887764093033,"d":"89.45"},{"v":53669.32658455821,"d":"53,669.33"},{"v":35.779551056372135,"d":"35.78"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},18478.145089033293,470.6790580007044,51.11364436624591]
["Cantidad y (minimiza CMe)",{"v":32.72564681209457,"d":"32.726"},null,0.45,{"v":57.50284991202664,"d":"57.50"},{"v":56431.59043569854,"d":"56,431.59"},{"v":981.3703237671348,"d":"981.37"},{"v":782.5699086018398,"d":"782.57"},{"v":198.80041516529502,"d":"198.80"},595.5954952108937,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":675,"d":"675.00"},{"v":41.073464222876176,"d":"41.1"},{"v":29822.684432341426,"d":"29,822.68"},{"v":86254.27486803997,"d":"86,254.27"},{"v":89.44887764093033,"d":"89.45"},{"v":60377.99240762798,"d":"60,377.99"},{"v":40.251994938418655,"d":"40.25"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},20787.913225162454,595.5954952108937,57.50284991202664]
["Inserte un valor y particular",{"$f":"B120","v":{"v":91.27436493972483,"d":"91.3"}},null,{"v":0.5,"d":"0.50"},{"v":63.89205545780738,"d":"63.89"},{"v":60675.15384544272,"d":"60,675.15"},{"v":949.6509919846136,"d":"949.65"},{"v":704.3129177416558,"d":"704.31"},{"v":245.33807424295776,"d":"245.34"},735.2078335233275,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":750,"d":"750.00"},{"v":45.63718246986242,"d":"45.6"},{"v":35162.92934126835,"d":"35,162.93"},{"v":95838.08318671107,"d":"95,838.08"},{"v":89.44887764093033,"d":"89.45"},{"v":67086.65823069775,"d":"67,086.66"},{"v":44.72443882046517,"d":"44.72"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},23097.681361291616,735.2078335233275,63.89205545780738]
[{"$nulls":3},0.55,{"v":70.28126100358813,"d":"70.28"},{"v":65857.67674780349,"d":"65,857.68"},{"v":937.0588376956014,"d":"937.06"},{"v":640.2844706742325,"d":"640.28"},{"v":296.7743670213689,"d":"296.77"},889.5160729380066,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":825.0000000000001,"d":"825.00"},{"v":50.200900716848665,"d":"50.2"},{"v":39564.21475757871,"d":"39,564.21"},{"v":105421.8915053822,"d":"105,421.89"},{"v":89.44887764093033,"d":"89.45"},{"v":73795.32405376753,"d":"73,795.32"},{"v":49.19688270251169,"d":"49.20"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},25407.44949742078,889.5160729380066,70.28126100358813]
["Precio",{"$f":"Merc_Comp_y3_Fn_Oferta!D12","v":{"v":1500,"d":"1500.0"}},null,{"v":0.6,"d":"0.60"},{"v":76.67046654936885,"d":"76.67"},{"v":72073.05427560351,"d":"72,073.05"},{"v":940.036724951908,"d":"940.04"},{"v":586.9274314513799,"d":"586.93"},{"v":353.1092935005281,"d":"353.11"},1058.5202134549297,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":900,"d":"900.00"},{"v":54.7646189638349,"d":"54.8"},{"v":42932.64554844977,"d":"42,932.65"},{"v":115005.69982405328,"d":"115,005.70"},{"v":89.44887764093033,"d":"89.45"},{"v":80503.9898768373,"d":"80,503.99"},{"v":53.6693265845582,"d":"53.67"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},27717.21763354994,1058.5202134549297,76.67046654936885]
["Cantidad de Equilibrio",{"$f":"B120","v":{"v":91.27436493972483,"d":"91.3"}},null,0.65,{"v":83.0596720951496,"d":"83.06"},{"v":79415.18156166555,"d":"79,415.18"},{"v":956.1220211740173,"d":"956.12"},{"v":541.7791674935814,"d":"541.78"},{"v":414.34285368043584,"d":"414.34"},1242.220255074098,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":975,"d":"975.00"},{"v":59.32833721082115,"d":"59.3"},{"v":45174.326581058835,"d":"45,174.33"},{"v":124589.50814272439,"d":"124,589.51"},{"v":89.44887764093033,"d":"89.45"},{"v":87212.65569990707,"d":"87,212.66"},{"v":58.14177046660472,"d":"58.14"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},30026.9857696791,1242.220255074098,83.0596720951496]
["Costo Unitario",{"$f":"(B87*(B99^2))+(B88*B99)+B89+(B90/B99)","v":{"v":993.2887515646571,"d":"993.3"}},null,{"v":0.7,"d":"0.70"},{"v":89.44887764093033,"d":"89.45"},{"v":87977.95373881227,"d":"87,977.95"},{"v":983.5557030908458,"d":"983.56"},{"v":503.08065552975415,"d":"503.08"},{"v":480.4750475610916,"d":"480.48"},1440.616197795511,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1050,"d":"1,050.00"},{"v":63.89205545780738,"d":"63.9"},{"v":46195.36272258323,"d":"46,195.36"},{"v":134173.3164613955,"d":"134,173.32"},{"v":89.44887764093033,"d":"89.45"},{"v":93921.32152297684,"d":"93,921.32"},{"v":62.61421434865123,"d":"62.61"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},32336.75390580826,1440.616197795511,89.44887764093033]
["Cantidad y (minimiza CMe)",{"$f":"G100","v":{"v":983.5557030908458,"d":"983.556"}},null,0.75,{"v":95.83808318671107,"d":"95.84"},{"v":97855.2659398664,"d":"97,855.27"},{"v":1021.0478203035996,"d":"1,021.05"},{"v":469.54194516110385,"d":"469.54"},{"v":551.5058751424957,"d":"551.51"},1653.7080416191686,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1125,"d":"1,125.00"},{"v":68.45577370479363,"d":"68.5"},{"v":45901.858840200206,"d":"45,901.86"},{"v":143757.1247800666,"d":"143,757.12"},{"v":89.44887764093033,"d":"89.45"},{"v":100629.98734604663,"d":"100,629.99"},{"v":67.08665823069775,"d":"67.09"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},34646.52204193742,1653.7080416191686,95.83808318671107]
["Costo Varianle Medio Mínimo",{"$f":"-B88/(2*B87)","v":{"v":-8.3333333333333339E-4,"d":"-0.001"}},null,{"v":0.8,"d":"0.80"},{"v":102.22728873249181,"d":"102.23"},{"v":109141.01329765064,"d":"109,141.01"},{"v":1067.630910013183,"d":"1,067.63"},{"v":440.19557358853484,"d":"440.20"},{"v":627.4353364246481,"d":"627.44"},1881.4957865450713,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1200,"d":"1,200.00"},{"v":73.01949195177987,"d":"73.0"},{"v":44199.91980108709,"d":"44,199.92"},{"v":153340.93309873773,"d":"153,340.93"},{"v":89.44887764093033,"d":"89.45"},{"v":107338.65316911641,"d":"107,338.65"},{"v":71.55910211274427,"d":"71.56"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},36956.290178066585,1881.4957865450713,102.22728873249181]
["Cantidad y (minimiza CVMe)",{"$f":"MAX(D110:D111)","v":{"v":2.5828223652835294,"d":"2.583"}},null,0.85,{"v":108.61649427827254,"d":"108.62"},{"v":121929.09094498766,"d":"121,929.09"},{"v":1122.5651477261695,"d":"1,122.57"},{"v":414.30171631862106,"d":"414.30"},{"v":708.2634314075484,"d":"708.26"},2123.9794325732178,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1275,"d":"1,275.00"},{"v":77.58321019876611,"d":"77.6"},{"v":40995.65047242114,"d":"40,995.65"},{"v":162924.7414174088,"d":"162,924.74"},{"v":89.44887764093033,"d":"89.45"},{"v":114047.31899218618,"d":"114,047.32"},{"v":76.03154599479078,"d":"76.03"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},39266.05831419575,2123.9794325732178,108.61649427827254]
["Ingreso Total",{"$f":"B98*B99","v":136911.54740958725},null,{"v":0.9,"d":"0.90"},{"v":115.00569982405328,"d":"115.01"},{"v":136313.39401470026,"d":"136,313.39"},{"v":1185.2751143921173,"d":"1,185.28"},{"v":391.2849543009199,"d":"391.28"},{"v":793.9901600911974,"d":"793.99"},2381.15897970361,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1350,"d":"1,350.00"},{"v":82.14692844575235,"d":"82.1"},{"v":36195.15572137968,"d":"36,195.16"},{"v":172508.54973607993,"d":"172,508.55"},{"v":89.44887764093033,"d":"89.45"},{"v":120755.98481525596,"d":"120,755.98"},{"v":80.50398987683731,"d":"80.50"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},41575.82645032491,2381.15897970361,115.00569982405328]
["Costo Total",{"$f":"B108","v":{"v":90661.8000008362,"d":"90661.800"}},null,0.95,{"v":121.39490536983402,"d":"121.39"},{"v":152387.81763961105,"d":"152,387.82"},{"v":1255.3065318133079,"d":"1,255.31"},{"v":370.6910093377136,"d":"370.69"},{"v":884.6155224755943,"d":"884.62"},2653.034427936246,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1425,"d":"1,425.00"},{"v":86.71064669273859,"d":"86.7"},{"v":29704.540415139985,"d":"29,704.54"},{"v":182092.35805475104,"d":"182,092.36"},{"v":89.44887764093033,"d":"89.45"},{"v":127464.65063832572,"d":"127,464.65"},{"v":84.97643375888381,"d":"84.98"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},43885.59458645407,2653.034427936246,121.39490536983402]
["Beneficio",{"$f":"B104-B105","v":{"v":46249.74740875105,"d":"46,249.7"}},null,{"v":1,"d":"1.00"},{"v":127.78411091561476,"d":"127.78"},{"v":170246.2569525428,"d":"170,246.26"},{"v":1332.2959774315675,"d":"1,332.30"},{"v":352.1564588708279,"d":"352.16"},{"v":980.1395185607396,"d":"980.14"},2939.6057772711274,{"v":1500,"d":"1500.0"},{"v":993.2887515646571,"d":"993.3"},{"v":91.27436493972483,"d":"91.3"},{"v":1500,"d":"1,500.00"},{"v":91.27436493972483,"d":"91.3"},{"v":21429.909420879325,"d":"21,429.91"},{"v":191676.16637342214,"d":"191,676.17"},{"v":89.44887764093033,"d":"89.45"},{"v":134173.3164613955,"d":"134,173.32"},{"v":89.44887764093033,"d":"89.45"},{"v":87977.95373881227,"d":"87,977.95"},{"v":134173.3164613955,"d":"134,173.32"},{"v":46195.36272258323,"d":"46,195.36"},46195.36272258323,2939.6057772711274,127.78411091561476]
[{"$nulls":3},{"v":1,"d":"1.00"},{"v":127.78411091561476,"d":"127.78"},{"v":170246.2569525428,"d":"170,246.26"},{"$f":"(F107/E107)","v":{"v":1332.2959774315675,"d":"1,332.30"}},{"v":352.1564588708279,"d":"352.16"},{"$f":"G107-H107","v":{"v":980.1395185607396,"d":"980.14"}},2939.6057772711274]
["Costo Total",{"$f":"B87*(B96^(3))+B88*(B96^(2))+B89*B96+B90","v":{"v":90661.8000008362,"d":"90661.8"}}]
["Costo Fijo",{"$f":"B90","v":{"v":45000,"d":"45000.0"}},{"$nulls":3},{"$f":"G106*1.1","v":{"v":1465.5255751747243,"d":"1,465.53"}},{"$nulls":6},"MAX CT, IT",{"$f":"MAX(F100,Q100)","v":{"v":134173.3164613955,"d":"134,173.32"}},"Max P",{"$f":"MAX(P86:P106)","v":{"v":46195.36272258323,"d":"46,195.36"}}]
["Costo Variable",{"$f":"B108-B109","v":{"v":45661.8000008362,"d":"45661.8"}},null,{"$f":"(B88+((B88^(2)+(4*B87*B89))^(0.5)))/(2*B87)","v":2.5828223652835294},null,102.025]
["Costo Medio",{"$f":"B108/B96","v":{"v":993.2887515646572,"d":"993.3"}},null,{"$f":"(B88-((B88^(2)+(4*B87*B89))^(0.5)))/(2*B87)","v":-2.581155698616863}]
["Costo Marginal",{"$f":"(3*B87*(B96^(2)))+(2*B88*B96)+B89","v":{"v":1500.0000000000005,"d":"1500.0"}}]
["Costo Fijo Medio",{"$f":"B109/B96","v":{"v":493.01904241915906,"d":"493.0"}}]
["Costo Variable Medio",{"$f":"B110/B96","v":{"v":500.2697091454982,"d":"500.3"}}]
["min",{"$f":"(B87*(B95^(3))+B88*(B95^(2))+B89*B95+B90)/B95","v":{"v":1439.7296645344272,"d":"1439.7"}}]
["costo mínimo",{"$f":"(B87*(Merc_Comp_y3_Fn_Oferta!D14^(3))+B88*(Merc_Comp_y3_Fn_Oferta!D14^(2))+B89*Merc_Comp_y3_Fn_Oferta!D14+B90)/Merc_Comp_y3_Fn_Oferta!D14","v":936.4449326366928}]
[null,{"$f":"2*B87*(B95)+B88-B90*(B95^(-2))","v":{"v":-38.09088614486238,"d":"-38.090886"}}]
[]
["y1 equilibrio",{"$f":"((-1*(2*B88*-1))+((((2*-1*B88)^(2))-((4*(3*-1*B87))*((B89*-1)+B98)))^(1/2)))/((2*(3*-1)*B87))","v":{"v":-91.27547605083593,"d":"-91.3"}}]
["y2 equilibrio",{"$f":"((-1*(2*B88*-1))-((((2*-1*B88)^(2))-((4*(3*-1*B87))*((B89*-1)+B98)))^(1/2)))/((2*(3*-1)*B87))","v":{"v":91.27436493972483,"d":"91.3"}}]
[]
["Min CMg",{"$f":"(3*B87*(B123^2))+(2*B88*B123)+B89","v":{"v":0.39999995833333335,"d":"0.4"}}]
[null,{"$f":"(B88/(2*B87))*-1","v":{"v":-8.3333333333333339E-4,"d":"-0.0"}}]

{"sheet":"Merc_Comp_y2","index":5,"n_rows":33,"n_cols":4,"rows_kept":33,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[4,2,4,3],[9,1,9,3],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,1,19,3],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[32,1,32,2]]}
["MERCADO COMPETITIVO"]
[]
[]
[]
[null,null,"Parámetros función costos"]
[null,null,"b (y2)",{"v":4,"d":"4.0"}]
[null,null,"c (y)",{"v":-20,"d":"-20.0"}]
[null,null,"d",{"v":3000,"d":"3,000.0"}]
[null,null,"Inserte los datos correspondientes"]
[null,"Resultados del equilibrio"]
[null,"Precio",null,{"v":400,"d":"400.0"}]
[null,"Cantidad de equilibrio",null,{"$f":"Oculto_Merc_Comp!AD16","v":52.5}]
[null,"Cantidad y (minimiza CMe)",null,{"$f":"SQRT(D8/D6)","v":{"v":27.386127875258307,"d":"27.39"}}]
[null,"Costo unitario",null,{"$f":"Oculto_Merc_Comp!AD17","v":{"v":247.14285714285714,"d":"247.14"}}]
[null,"Costo medio (mínimo)",null,{"$f":"(D6*D13)+D7+(D8/D13)","v":{"v":199.08902300206643,"d":"199.09"}}]
[null,"Ingreso total",null,{"$f":"Oculto_Merc_Comp!AD19","v":{"v":21000,"d":"21,000.0"}}]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!AD20","v":{"v":12975,"d":"12,975.0"}}]
[null,"Beneficio",null,{"$f":"Oculto_Merc_Comp!AD21","v":{"v":8025,"d":"8,025.0"}}]
[]
[null,"Cuantificación de costos"]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!AD23","v":{"v":12975,"d":"12,975.00"}}]
[null,"Costo fijo",null,{"$f":"Oculto_Merc_Comp!AD24","v":{"v":3000,"d":"3,000.00"}}]
[null,"Costo variable",null,{"$f":"Oculto_Merc_Comp!AD25","v":{"v":9975,"d":"9,975.00"}}]
[null,"Costo medio",null,{"$f":"Oculto_Merc_Comp!AD26","v":{"v":247.14285714285714,"d":"247.14"}}]
[null,"Costo marginal",null,{"$f":"Oculto_Merc_Comp!AD27","v":{"v":400,"d":"400.00"}}]
[null,"Costo fijo medio",null,{"$f":"Oculto_Merc_Comp!AD28","v":{"v":57.142857142857146,"d":"57.14"}}]
[null,"Costo variable medio",null,{"$f":"Oculto_Merc_Comp!AD29","v":{"v":190,"d":"190.00"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]

{"sheet":"Merc_Comp_y2_Equilibrio","index":6,"n_rows":33,"n_cols":4,"rows_kept":33,"hidden":true,"merged":[[0,0,0,4],[1,0,1,4],[4,2,4,3],[9,1,9,3],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,1,19,3],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[32,1,32,2]]}
["MERCADO COMPETITIVO"]
[]
[]
[]
[null,null,"Parámetros función costos"]
[null,null,"b (y2)",{"v":4,"d":"4.0"}]
[null,null,"c (y)",{"v":-20,"d":"-20.0"}]
[null,null,"d",{"v":2000,"d":"2,000.0"}]
[null,null,"Inserte los datos correspondientes"]
[null,"Resultados del equilibrio"]
[null,"Precio",null,{"v":158,"d":"158.0"}]
[null,"Cantidad de equilibrio",null,{"$f":"Oculto_Merc_Comp!AD53","v":{"v":22.25,"d":"22.3"}}]
[null,"Cantidad y (minimiza CMe)",null,{"$f":"Oculto_Merc_Comp!AD49","v":{"v":22.360679774997898,"d":"22.36"}}]
[null,"Costo unitario",null,{"$f":"Oculto_Merc_Comp!AD54","v":{"v":158.8876404494382,"d":"158.89"}}]
[null,"Costo medio (mínimo)",null,{"$f":"(D6*D13)+D7+(D8/D13)","v":{"v":158.88543819998318,"d":"158.89"}}]
[null,"Ingreso total",null,{"$f":"Oculto_Merc_Comp!AD56","v":{"v":3515.5,"d":"3,515.5"}}]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!AD57","v":{"v":3535.25,"d":"3,535.3"}}]
[null,"Beneficio",null,{"$f":"Oculto_Merc_Comp!AD58","v":{"v":-19.75,"d":"-19.8"}}]
[]
[null,"Cuantificación de costos"]
[null,"Costo total",null,{"$f":"Oculto_Merc_Comp!AD60","v":{"v":3535.25,"d":"3,535.25"}}]
[null,"Costo fijo",null,{"$f":"Oculto_Merc_Comp!AD61","v":{"v":2000,"d":"2,000.00"}}]
[null,"Costo variable",null,{"$f":"Oculto_Merc_Comp!AD62","v":{"v":1535.25,"d":"1,535.25"}}]
[null,"Costo medio",null,{"$f":"Oculto_Merc_Comp!AD63","v":{"v":158.8876404494382,"d":"158.89"}}]
[null,"Costo marginal",null,{"$f":"Oculto_Merc_Comp!AD64","v":{"v":158,"d":"158.00"}}]
[null,"Costo fijo medio",null,{"$f":"Oculto_Merc_Comp!AD65","v":{"v":89.88764044943821,"d":"89.89"}}]
[null,"Costo variable medio",null,{"$f":"Oculto_Merc_Comp!AD66","v":{"v":69,"d":"69.00"}}]
[]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]
[null,"Valores de equilibrio"]