{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["INICIO","ENC","INSTRU","ANT","DATOS","SIMULADOR","PI","PV","PP","PRC","PMO","PGIF","PGO","CUP","VIF","VII","PCV","ER","FNE","BG","RESULTADO","ACT"],"not_rendered":{"charts":0,"images":40,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INICIO","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,4,5,11],[6,4,7,11],[9,5,9,10]]}
[]
[]
[]
[]
[null,null,null,null,"INSTITUTO POLITÉCNICO NACIONAL"]
[]
[null,null,null,null,"ESCUELA SUPERIOR DE CÓMPUTO"]
[]
[]
[null,null,null,null,null,"Administración Financiera"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"                 "]
[null,null,null,null,null,null,"           "]
[]
[null,null,null,null,null,null,"Elaboro: EDUARDO RODRÍGUEZ FLORES "]
[null,null,null,null,null,null,null,"JOSEFINA HERNÁNDEZ JAIME "]
[null,null,null,null,null,null,null,"YASMÍN IVETTE JIMÉNEZ GALÁN "]

{"sheet":"ENC","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,7,7,10],[9,7,12,10],[13,7,13,10],[14,7,16,10],[9,0,15,5],[4,0,7,5]]}
[]
[]
[]
[]
["Bienvenido al prototipo financiero Presupuesto Maestro.",null,null,null,null,null,null,"Permite calculos los presupuestos que bajo el criterio de utilidad financiera existen: el presupuesto de operación y presupuestos financieros."]
[]
[]
[]
[]
["Este recurso didáctico digital esta desarrollado pensando en ti, para que tus clases sean más receptivas, participativas, proactivas y amenas. Te facilitaran las condiciones necesarias para que puedas llevar a cabo las actividades programadas para este tema con el maximo provecho ",null,null,null,null,null,null,"En la sección de RESULTADOS podrás ver todos los puntos importantes a destacar de los presupuestos que se mencionan y se calculan."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"¡Puedes ingresar los datos que tu quieras y ver los resultados!"]

{"sheet":"INSTRU","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[23,4,23,10],[18,4,21,10],[9,4,11,10],[12,4,16,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"En cada parte del simulador podrás encontrar diversas opciones para visualizar o editar."]
[]
[]
[null,null,null,null,"Si deseas modificar los datos, existe una unica sección destinada a ello. Todos los demás son para visualizar los resultados. Es necesario que se llenen todos los datos que se piden para que el simulador funcione de manera correcta."]
[]
[]
[]
[]
[]
[null,null,null,null,"En la sección de simulador  podrás seleccionar qué deseas ver, como presupuestos, estado de resultado, presupuesto de ventas, balance general entre otros."]

{"sheet":"ANT","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[6,1,6,4]]}

{"sheet":"DATOS","index":4,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,1,12,13],[31,1,31,3],[32,1,32,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[24,7,24,8],[24,9,25,9],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[40,7,40,9],[41,7,41,9],[40,1,40,3],[33,1,33,3],[38,1,38,3],[36,7,36,9],[37,7,37,9],[38,7,38,9],[39,7,39,9],[37,1,37,3],[36,1,36,3],[40,4,40,5],[41,1,41,3],[41,4,41,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ventas históricas de la empresa \"El Emperador, S.A. de C.V.\""]
[]
[null,"Trimestre",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Ventas Históricas (Unidades)",150000,125000,100000,170000,145000,118000,90000,135000,110000,150000,130000,180000]
[null,"Ingresos totales esperados",null,null,null,null,null,null,null,null,null,null,null,13000000]
[]
[null,"Ventas y Mercadotecnica",null,null,null,"Tasa de crecimiento",null,"Materias primas","Costo unitario","Estandar por producto","Tasa de crecimiento","Inventario inicial","Inventario Final","Compras esperadas"]
[null,"Precio propuesto para el producto",null,null,72.5,0.04,null,"A",2,1,0.03,5000,7000,275000]
[null,"Publicidad",null,null,10000,0.03,null,"B",2,2,0.03,12000,14000,590000]
[null,"Sueldo vendedores",null,null,30000,0.02,null,"C",4,1,0.03,6000,7000,580000]
[null,"Número de vendedores",null,null,50]
[null,"Gastos fijos de venta",null,null,50000]
[null,"Inventario inicial",null,null,15000,null,null,"Nivel de Utilidades",null,"Tasa de Impuesto"]
[null,"Inventario final",null,null,15500,null,null,"Limite Inferior","Limite Superior"]
[null,null,null,null,null,null,null,0,999,0.05]
[null,"Produccion",null,null,null,"Tasa de crecimiento",null,1000,9999,0.1]
[null,"Capacidad de produccion",null,null,140000,null,null,10000,49999,0.15]
[null,"Costo de produccion faltante",null,null,40,0.03,null,50000,99999,0.2]
[null,"Costo unitario de mano de obra",null,null,6,0.03,null,100000,499999,0.25]
[null,"Costo unitario de mantenimiento",null,null,5,0.03,null,500000,999999,0.3]
[null,"Costo unitario de produccion trimestre 12",null,null,20,0.03,null,1000000,null,0.35]
[null,"Estándar de mano de obra",null,null,1]
[]
[null,"Administracion",null,null,null,"Tasa de crecimiento",null,"Finanzas",null,null,null,"Tasa de crecimiento"]
[null,"Empleados de administracion",null,null,25,null,null,"Planta y maquinaria",null,null,500000]
[null,"Sueldo empleados administracion",null,null,50000,0.02,null,"Tiempo de vida estimado (años) ",null,null,5]
[null,"Gastos fijos de administracion",null,null,50000,null,null,"Valor de recuperacion",null,null,80000]
[null,null,null,null,null,null,null,"Efectivo",null,null,253500]
[null,"Depreciacion acumulada",null,null,0,null,null,"Préstamo a corto plazo",null,null,100000,3.5000000000000003E-2]
[null,"Utilidad o pérdida acumulada",null,null,0,null,null,"Capital Social",null,null,7800000]

{"sheet":"SIMULADOR","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PI","index":6,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Volumen estimado de ventas (Unidades)",{"$f":"IF(PV!$Q$22=1,PV!L11,PV!N11)","v":141924.24242424243},{"$f":"IF(PV!$Q$22=1,PV!L12,PV!N12)","v":143207.45920745921},{"$f":"IF(PV!$Q$22=1,PV!L13,PV!N13)","v":144490.67599067598},{"$f":"IF(PV!$Q$22=1,PV!L14,PV!N14)","v":145773.89277389276},{"$f":"IF(PV!$Q$22=1,PV!L15,PV!N15)","v":147057.10955710956},{"$f":"IF(PV!$Q$22=1,PV!L16,PV!N16)","v":148340.32634032634},{"$f":"IF(PV!$Q$22=1,PV!L17,PV!N17)","v":149623.54312354312},{"$f":"IF(PV!$Q$22=1,PV!L18,PV!N18)","v":150906.75990675989},{"$f":"IF(PV!$Q$22=1,PV!L19,PV!N19)","v":152189.9766899767},{"$f":"IF(PV!$Q$22=1,PV!L20,PV!N20)","v":153473.19347319347},{"$f":"IF(PV!$Q$22=1,PV!L21,PV!N21)","v":154756.41025641025},{"$f":"IF(PV!$Q$22=1,PV!L22,PV!N22)","v":156039.62703962703}]
[null,"*","Precio unitario",{"$f":"DATOS!E20","v":72.5},{"$f":"D12*(1+DATOS!$F20)","v":75.400000000000006},{"$f":"E12*(1+DATOS!$F20)","v":78.416000000000011},{"$f":"F12*(1+DATOS!$F20)","v":81.552640000000011},{"$f":"G12*(1+DATOS!$F20)","v":84.814745600000009},{"$f":"H12*(1+DATOS!$F20)","v":88.207335424000007},{"$f":"I12*(1+DATOS!$F20)","v":91.735628840960004},{"$f":"J12*(1+DATOS!$F20)","v":95.405053994598404},{"$f":"K12*(1+DATOS!$F20)","v":99.221256154382345},{"$f":"L12*(1+DATOS!$F20)","v":103.19010640055764},{"$f":"M12*(1+DATOS!$F20)","v":107.31771065657995},{"$f":"N12*(1+DATOS!$F20)","v":111.61041908284315}]
[null,"=","Ingresos Totales presupuestados",{"$f":"D11*D12","v":10289507.575757576},{"$f":"E11*E12","v":10797842.424242426},11330380.84848485,11888245.798787879,12472611.335757578,13084704.922406789,13725809.817850726,14397267.577054325,15100480.661285656,15836915.164132202,16608103.658148417,17415648.167423315]

{"sheet":"PV","index":7,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Trimestre n=12","Ventas 2015 - 2017","Ventas promedio","Indice Estacional","Periodo t","Ventas Y","tY","t*t",null,"Trimestre ","Pronósticos de Ventas 2018 - 2020","IE","Pronósticos de Ventas Ajustado 2018 - 2020",null,"Pronóstico","A + Bt"]
[null,1,{"$f":"DATOS!C16","v":150000},{"$f":"C11","v":150000},{"$f":"D11/D23","v":1.1228945726762321},1,{"$f":"D11","v":150000},{"$f":"F11*G11","v":150000},{"$f":"F11*F11","v":1},null,13,{"$f":"Q11+Q12*K11","v":141924.24242424243},{"$f":"E11","v":1.1228945726762321},{"$f":"L11*M11","v":159365.96154936767},null,"A",{"$f":"(G23-Q12*F23)/F22","v":125242.42424242424}]
[null,2,{"$f":"DATOS!D16","v":125000},{"$f":"C12","v":125000},{"$f":"D12/D23","v":0.9357454772301933},2,{"$f":"D12","v":125000},{"$f":"F12*G12","v":250000},{"$f":"F12*F12","v":4},null,14,{"$f":"Q11+Q12*K12","v":143207.45920745921},{"$f":"E12","v":0.9357454772301933},{"$f":"L12*M12","v":134005.73225900735},null,"B",{"$f":"(F22*H23-F23*G23)/(F22*I23-F23*F23)","v":1283.2167832167831}]
[null,3,{"$f":"DATOS!E16","v":100000},100000,{"$f":"D13/D23","v":0.74859638178415466},3,100000,{"$f":"F13*G13","v":300000},9,null,15,{"$f":"Q11+Q12*K13","v":144490.67599067598},0.74859638178415466,108165.19724816667]
[null,4,{"$f":"DATOS!F16","v":170000},170000,{"$f":"D14/D23","v":1.272613849033063},4,170000,680000,16,null,16,{"$f":"Q11+Q12*K14","v":145773.89277389276},1.272613849033063,185513.87477151665]
[null,5,{"$f":"DATOS!G16","v":145000},145000,{"$f":"D15/D23","v":1.0854647535870243},5,145000,725000,25,null,17,{"$f":"Q11+Q12*K15","v":147057.10955710956},1.0854647535870243,159625.30918862799]
[null,6,{"$f":"DATOS!H16","v":118000},118000,{"$f":"D16/D23","v":0.88334373050530246},6,118000,708000,36,null,18,{"$f":"Q11+Q12*K16","v":148340.32634032634},0.88334373050530246,131035.49725383785]
[null,7,{"$f":"DATOS!I16","v":90000},90000,{"$f":"D17/D23","v":0.67373674360573921},7,90000,630000,49,null,19,{"$f":"Q11+Q12*K17","v":149623.54312354312},0.67373674360573921,100806.87871080883]
[null,8,{"$f":"DATOS!J16","v":135000},135000,{"$f":"D18/D23","v":1.0106051154086089},8,135000,1080000,64,null,20,{"$f":"Q11+Q12*K18","v":150906.75990675989},1.0106051154086089,152507.14351151031]
[null,9,{"$f":"DATOS!K16","v":110000},110000,{"$f":"D19/D23","v":0.82345601996257012},9,110000,990000,81,null,21,{"$f":"Q11+Q12*K19","v":152189.9766899767},0.82345601996257012,125321.75248332453]
[null,10,{"$f":"DATOS!L16","v":150000},150000,{"$f":"D20/D23","v":1.1228945726762321},10,150000,1500000,100,null,22,{"$f":"Q11+Q12*K20","v":153473.19347319347},1.1228945726762321,172334.21600233827]
[null,11,{"$f":"DATOS!M16","v":130000},130000,{"$f":"D21/D23","v":0.97317529631940103},11,130000,1430000,121,null,23,{"$f":"Q11+Q12*K21","v":154756.41025641025},0.97317529631940103,150605.11540860884]
[null,12,{"$f":"DATOS!N16","v":180000},180000,{"$f":"D22/D23","v":1.3474734872114784},12,180000,{"$f":"F22*G22","v":2160000},144,null,24,{"$f":"Q11+Q12*K22","v":156039.62703962703},1.3474734872114784,210259.26039026474,null,"Lineal",1]
[null,"Total",null,{"$f":"SUM(D11:D22)/B22","v":133583.33333333334},null,{"$f":"SUM(F11:F22)","v":78},{"$f":"SUM(G11:G22)","v":1603000},{"$f":"SUM(H11:H22)","v":10603000},{"$f":"SUM(I11:I22)","v":650},null,null,null,null,null,null,"IE",0]

{"sheet":"PP","index":8,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Volumen Estimado de ventas",{"$f":"PI!D11","v":141924.24242424243},{"$f":"PI!E11","v":143207.45920745921},{"$f":"PI!F11","v":144490.67599067598},{"$f":"PI!G11","v":145773.89277389276},{"$f":"PI!H11","v":147057.10955710956},{"$f":"PI!I11","v":148340.32634032634},{"$f":"PI!J11","v":149623.54312354312},{"$f":"PI!K11","v":150906.75990675989},{"$f":"PI!L11","v":152189.9766899767},{"$f":"PI!M11","v":153473.19347319347},{"$f":"PI!N11","v":154756.41025641025},{"$f":"PI!O11","v":156039.62703962703}]
[null,"+","Inventario final deseado                                   10% ventas siguiente trimestre",{"$f":"E11*0.1","v":14320.745920745921},{"$f":"F11*0.1","v":14449.067599067599},{"$f":"G11*0.1","v":14577.389277389277},14705.710955710958,14834.032634032636,14962.354312354313,15090.675990675991,{"$f":"L11*0.1","v":15218.99766899767},15347.319347319348,15475.641025641025,{"$f":"O11*0.1","v":15603.962703962703},{"$f":"DATOS!E26","v":15500}]
[null,"=","Necesidades de producción",{"$f":"D11+D12","v":156244.98834498835},{"$f":"E11+E12","v":157656.52680652682},159068.06526806526,160479.60372960372,161891.14219114219,163302.68065268066,164714.2191142191,166125.75757575757,167537.29603729604,168948.83449883451,170360.37296037294,171539.62703962703]
[null,"-","Inventario Inicial",{"$f":"DATOS!E25","v":15000},{"$f":"D12","v":14320.745920745921},{"$f":"E12","v":14449.067599067599},{"$f":"F12","v":14577.389277389277},14705.710955710958,14834.032634032636,14962.354312354313,15090.675990675991,15218.99766899767,15347.319347319348,15475.641025641025,15603.962703962703]
[null,"=","Producción Requerida",{"$f":"D13-D14","v":141244.98834498835},{"$f":"E13-E14","v":143335.7808857809},{"$f":"F13-F14","v":144618.99766899765},145902.21445221445,147185.43123543123,148468.64801864803,149751.86480186478,151035.08158508159,152318.29836829836,153601.51515151517,154884.73193473191,155935.66433566433]
[null,"-","Producción programada",{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000},{"$f":"DATOS!E29","v":140000}]
[null,"=","Maquila",{"$f":"D15-D16","v":1244.9883449883491},{"$f":"E15-E16","v":3335.7808857808996},4618.9976689976465,5902.2144522144517,7185.4312354312278,8468.648018648033,9751.86480186478,11035.081585081585,12318.298368298361,13601.515151515167,14884.731934731913,{"$f":"O15-O16","v":15935.664335664333}]

{"sheet":"PRC","index":9,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"MATERIA PRIMA A "]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Produccion requerida",{"$f":"IF(PP!D17<0,PP!D15,PP!D16)","v":140000},{"$f":"IF(PP!E17<0,PP!E15,PP!E16)","v":140000},{"$f":"IF(PP!F17<0,PP!F15,PP!F16)","v":140000},{"$f":"IF(PP!G17<0,PP!G15,PP!G16)","v":140000},{"$f":"IF(PP!H17<0,PP!H15,PP!H16)","v":140000},{"$f":"IF(PP!I17<0,PP!I15,PP!I16)","v":140000},{"$f":"IF(PP!J17<0,PP!J15,PP!J16)","v":140000},{"$f":"IF(PP!K17<0,PP!K15,PP!K16)","v":140000},{"$f":"IF(PP!L17<0,PP!L15,PP!L16)","v":140000},{"$f":"IF(PP!M17<0,PP!M15,PP!M16)","v":140000},{"$f":"IF(PP!N17<0,PP!N15,PP!N16)","v":140000},{"$f":"IF(PP!O17<0,PP!O15,PP!O16)","v":140000}]
[null,"*","Estándar de materia prima A por producto",{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1},{"$f":"DATOS!J20","v":1}]
[null,"=","Materia prima A requerida para la producción",{"$f":"D11*D12","v":140000},140000,140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[null,"+","Inventario final deseado de materia prima A                             ",{"$f":"E13*0.05","v":7000},{"$f":"F13*0.05","v":7000},7000,7000,7000,7000,7000,7000,7000,7000,7000,{"$f":"DATOS!M20","v":7000}]
[null,"=","Unidades necesarias de materia prima A ",{"$f":"D13+D14","v":147000},{"$f":"E13+E14","v":147000},147000,147000,147000,147000,147000,147000,147000,147000,147000,147000]
[null,"-","Inventario inicial de materia prima A",{"$f":"DATOS!L20","v":5000},{"$f":"D14","v":7000},{"$f":"E14","v":7000},7000,7000,7000,7000,7000,7000,7000,7000,7000]
[null,"=","Total de unidades de materia prima A",{"$f":"D15-D16","v":142000},{"$f":"E15-E16","v":140000},140000,140000,{"$f":"H15-H16","v":140000},140000,140000,140000,140000,140000,140000,140000]
[null,"*","Costo por unidad de materia prima A",{"$f":"DATOS!I20","v":2},{"$f":"D18*(1+DATOS!K20)","v":2.06},{"$f":"E18*(1+DATOS!K20)","v":2.1217999999999999},{"$f":"F18*(1+DATOS!K20)","v":2.185454},{"$f":"G18*(1+DATOS!K20)","v":2.2510176200000003},{"$f":"H18*(1+DATOS!K20)","v":2.3185481486000001},{"$f":"I18*(1+DATOS!K20)","v":2.3881045930580003},{"$f":"J18*(1+DATOS!K20)","v":2.4597477308497404},{"$f":"K18*(1+DATOS!K20)","v":2.5335401627752328},{"$f":"L18*(1+DATOS!K20)","v":2.6095463676584898},{"$f":"M18*(1+DATOS!K20)","v":2.6878327586882444},{"$f":"N18*(1+DATOS!K20)","v":2.7684677414488919}]
[null,"=","Costo total de materia prima A",{"$f":"D17*D18","v":284000},{"$f":"E17*E18","v":288400},297052,305963.56,315142.46680000005,324596.740804,334334.64302812004,344364.68231896363,354695.62278853258,365336.49147218856,376296.58621635422,387585.48380284489]
[]
[null,null,"MATERIA PRIMA B"]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Producción requerida",{"$f":"IF(PP!D17<0,PP!D15,PP!D16)","v":140000},{"$f":"IF(PP!E17<0,PP!E15,PP!E16)","v":140000},{"$f":"IF(PP!F17<0,PP!F15,PP!F16)","v":140000},{"$f":"IF(PP!G17<0,PP!G15,PP!G16)","v":140000},{"$f":"IF(PP!H17<0,PP!H15,PP!H16)","v":140000},{"$f":"IF(PP!I17<0,PP!I15,PP!I16)","v":140000},{"$f":"IF(PP!J17<0,PP!J15,PP!J16)","v":140000},{"$f":"IF(PP!K17<0,PP!K15,PP!K16)","v":140000},{"$f":"IF(PP!L17<0,PP!L15,PP!L16)","v":140000},{"$f":"IF(PP!M17<0,PP!M15,PP!M16)","v":140000},{"$f":"IF(PP!N17<0,PP!N15,PP!N16)","v":140000},{"$f":"IF(PP!O17<0,PP!O15,PP!O16)","v":140000}]
[null,"*","Estándar de materia prima B por producto",{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2},{"$f":"DATOS!J21","v":2}]
[null,"=","Materia prima B requerida para la producción",{"$f":"D23*D24","v":280000},{"$f":"E23*E24","v":280000},280000,280000,280000,280000,280000,280000,280000,280000,280000,280000]
[null,"+","Inventario final deseado de materia prima B                        ",{"$f":"E25*0.05","v":14000},{"$f":"F25*0.05","v":14000},14000,14000,14000,14000,14000,14000,14000,14000,14000,{"$f":"DATOS!M21","v":14000}]
[null,"=","Unidades necesarias de materia prima B",{"$f":"D25+D26","v":294000},{"$f":"E25+E26","v":294000},294000,294000,294000,294000,294000,294000,294000,294000,294000,{"$f":"O25+O26","v":294000}]
[null,"-","Inventario inicial de materia prima B",{"$f":"DATOS!L21","v":12000},{"$f":"D26","v":14000},{"$f":"E26","v":14000},14000,14000,14000,14000,14000,14000,14000,14000,14000]
[null,"=","Total de unidades de materia prima B",{"$f":"D27-D28","v":282000},{"$f":"E27-E28","v":280000},280000,280000,280000,280000,280000,280000,280000,280000,280000,280000]
[null,"*","Costo por unidad de materia prima B",{"$f":"DATOS!I21","v":2},{"$f":"D30*(1+DATOS!K21)","v":2.06},{"$f":"E30*(1+DATOS!K21)","v":2.1217999999999999},{"$f":"F30*(1+DATOS!K21)","v":2.185454},{"$f":"G30*(1+DATOS!K21)","v":2.2510176200000003},{"$f":"H30*(1+DATOS!K21)","v":2.3185481486000001},{"$f":"I30*(1+DATOS!K21)","v":2.3881045930580003},{"$f":"J30*(1+DATOS!K21)","v":2.4597477308497404},{"$f":"K30*(1+DATOS!K21)","v":2.5335401627752328},{"$f":"L30*(1+DATOS!K21)","v":2.6095463676584898},{"$f":"M30*(1+DATOS!K21)","v":2.6878327586882444},{"$f":"N30*(1+DATOS!K21)","v":2.7684677414488919}]
[null,"=","Costo total de materia prima B",{"$f":"D29*D30","v":564000},{"$f":"E29*E30","v":576800},594104,611927.12,630284.93360000011,649193.481608,668669.28605624009,688729.36463792727,709391.24557706516,730672.98294437712,752593.17243270844,775170.96760568977]
[]
[null,null,"MATERIA PRIMA C"]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Producción requerida",{"$f":"IF(PP!D17<0,PP!D15,PP!D16)","v":140000},{"$f":"IF(PP!E17<0,PP!E15,PP!E16)","v":140000},{"$f":"IF(PP!F17<0,PP!F15,PP!F16)","v":140000},{"$f":"IF(PP!G17<0,PP!G15,PP!G16)","v":140000},{"$f":"IF(PP!H17<0,PP!H15,PP!H16)","v":140000},{"$f":"IF(PP!I17<0,PP!I15,PP!I16)","v":140000},{"$f":"IF(PP!J17<0,PP!J15,PP!J16)","v":140000},{"$f":"IF(PP!K17<0,PP!K15,PP!K16)","v":140000},{"$f":"IF(PP!L17<0,PP!L15,PP!L16)","v":140000},{"$f":"IF(PP!M17<0,PP!M15,PP!M16)","v":140000},{"$f":"IF(PP!N17<0,PP!N15,PP!N16)","v":140000},{"$f":"IF(PP!O17<0,PP!O15,PP!O16)","v":140000}]
[null,"*","Estándar de materia prima C por producto",{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1},{"$f":"DATOS!J22","v":1}]
[null,"=","Materia prima C requerida para la producción",{"$f":"D35*D36","v":140000},{"$f":"E35*E36","v":140000},140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[null,"+","Inventario final deseado de materia prima C                 ",{"$f":"E37*0.05","v":7000},{"$f":"F37*0.05","v":7000},7000,7000,7000,7000,7000,7000,7000,7000,{"$f":"O37*0.05","v":7000},{"$f":"DATOS!M22","v":7000}]
[null,"=","Unidades necesarias de materia prima C",{"$f":"D37+D38","v":147000},{"$f":"E37+E38","v":147000},147000,147000,147000,147000,147000,147000,147000,147000,147000,147000]
[null,"-","Inventario inicial de materia prima C",{"$f":"DATOS!L22","v":6000},{"$f":"D38","v":7000},{"$f":"E38","v":7000},7000,7000,7000,7000,7000,7000,7000,7000,7000]
[null,"=","Total de unidades de materia prima C",{"$f":"D39-D40","v":141000},{"$f":"E39-E40","v":140000},140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[null,"*","Costo por unidad de materia prima C",{"$f":"DATOS!I22","v":4},{"$f":"D42*(1+DATOS!K22)","v":4.12},{"$f":"E42*(1+DATOS!K22)","v":4.2435999999999998},{"$f":"F42*(1+DATOS!K22)","v":4.370908},{"$f":"G42*(1+DATOS!K22)","v":4.5020352400000005},{"$f":"H42*(1+DATOS!K22)","v":4.6370962972000003},{"$f":"I42*(1+DATOS!K22)","v":4.7762091861160005},{"$f":"J42*(1+DATOS!K22)","v":4.9194954616994808},{"$f":"K42*(1+DATOS!K22)","v":5.0670803255504655},{"$f":"L42*(1+DATOS!K22)","v":5.2190927353169796},{"$f":"M42*(1+DATOS!K22)","v":5.3756655173764889},{"$f":"N42*(1+DATOS!K22)","v":5.5369354828977837}]
[null,"=","Costo total de materia prima C",{"$f":"D41*D42","v":564000},{"$f":"E41*E42","v":576800},594104,611927.12,630284.93360000011,649193.481608,668669.28605624009,688729.36463792727,709391.24557706516,730672.98294437712,752593.17243270844,775170.96760568977]

{"sheet":"PMO","index":10,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Producción Requerida",{"$f":"IF(PP!D17<0,PP!D15,PP!D16)","v":140000},{"$f":"IF(PP!E17<0,PP!E15,PP!E16)","v":140000},{"$f":"IF(PP!F17<0,PP!F15,PP!F16)","v":140000},{"$f":"IF(PP!G17<0,PP!G15,PP!G16)","v":140000},{"$f":"IF(PP!H17<0,PP!H15,PP!H16)","v":140000},{"$f":"IF(PP!I17<0,PP!I15,PP!I16)","v":140000},{"$f":"IF(PP!J17<0,PP!J15,PP!J16)","v":140000},{"$f":"IF(PP!K17<0,PP!K15,PP!K16)","v":140000},{"$f":"IF(PP!L17<0,PP!L15,PP!L16)","v":140000},{"$f":"IF(PP!M17<0,PP!M15,PP!M16)","v":140000},{"$f":"IF(PP!N17<0,PP!N15,PP!N16)","v":140000},{"$f":"IF(PP!O17<0,PP!O15,PP!O16)","v":140000}]
[null,"*","Estándar de mano de obra directa",{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1},{"$f":"DATOS!E34","v":1}]
[null,"=","Horas totales requeridas de mano de obra directa",{"$f":"D11*D12","v":140000},{"$f":"E11*E12","v":140000},140000,140000,140000,140000,140000,140000,140000,140000,140000,140000]
[null,"*","Costo por hora de mano de obra directa",{"$f":"DATOS!E31","v":6},{"$f":"D14*(1+DATOS!F31)","v":6.18},{"$f":"E14*(1+DATOS!F31)","v":6.3654000000000002},{"$f":"F14*(1+DATOS!F31)","v":6.556362},{"$f":"G14*(1+DATOS!F31)","v":6.7530528600000004},{"$f":"H14*(1+DATOS!F31)","v":6.9556444458000009},{"$f":"I14*(1+DATOS!F31)","v":7.1643137791740008},{"$f":"J14*(1+DATOS!F31)","v":7.3792431925492208},{"$f":"K14*(1+DATOS!F31)","v":7.6006204883256974},{"$f":"L14*(1+DATOS!F31)","v":7.8286391029754681},{"$f":"M14*(1+DATOS!F31)","v":8.0634982760647329},{"$f":"N14*(1+DATOS!F31)","v":8.3054032243466747}]
[null,"=","Costo total de mano de obra directa",{"$f":"D13*D14","v":840000},{"$f":"E13*E14","v":865200},891156,917890.68,945427.40040000004,973790.22241200018,1003003.9290843601,1033094.046956891,1064086.8683655977,1096009.4744165656,1128889.7586490626,1162756.4514085345]

{"sheet":"PGIF","index":11,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Depreciación de la planta",{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500}]
[null,"+","Depreciación de la maquinaria",{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500},{"$f":"(DATOS!$K$37-DATOS!$K$39)/(DATOS!$K$38*8)","v":10500}]
[null,"+","Costo de electricidad de la planta",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+","Costo de agua de la planta",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+","Costo de teléfono de la planta",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+","Costo de mantenimiento del equipo",{"$f":"DATOS!E32*IF(PP!D17<0,PP!D15,PP!D16)","v":700000},{"$f":"POWER((1+DATOS!F32),1)*DATOS!E32*IF(PP!E17<0,PP!E15,PP!E16)","v":721000},{"$f":"POWER((1+DATOS!F32),2)*DATOS!E32*IF(PP!F17<0,PP!F15,PP!F16)","v":742630},{"$f":"POWER((1+DATOS!F32),3)*DATOS!E32*IF(PP!G17<0,PP!G15,PP!G16)","v":764908.9},{"$f":"POWER((1+DATOS!F32),4)*DATOS!E32*IF(PP!H17<0,PP!H15,PP!H16)","v":787856.1669999999},{"$f":"POWER((1+DATOS!F32),5)*DATOS!E32*IF(PP!I17<0,PP!I15,PP!I16)","v":811491.85200999992},{"$f":"POWER((1+DATOS!F32),6)*DATOS!E32*IF(PP!J17<0,PP!J15,PP!J16)","v":835836.60757029988},{"$f":"POWER((1+DATOS!F32),7)*DATOS!E32*IF(PP!K17<0,PP!K15,PP!K16)","v":860911.70579740894},{"$f":"POWER((1+DATOS!F32),8)*DATOS!E32*IF(PP!L17<0,PP!L15,PP!L16)","v":886739.05697133113},{"$f":"POWER((1+DATOS!F32),9)*DATOS!E32*IF(PP!M17<0,PP!M15,PP!M16)","v":913341.22868047107},{"$f":"POWER((1+DATOS!F32),10)*DATOS!E32*IF(PP!N17<0,PP!N15,PP!N16)","v":940741.46554088523},{"$f":"POWER((1+DATOS!F32),11)*DATOS!E32*IF(PP!O17<0,PP!O15,PP!O16)","v":968963.70950711181}]
[null,"+","Costo de supervisión de la planta",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+","Seguro de la planta",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"+","Costo de lubricantes y energéticos",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"=","Total de gastos indirectos de fabricación",{"$f":"SUM(D11:D19)","v":721000},{"$f":"SUM(E11:E19)","v":742000},763630,785908.9,808856.1669999999,832491.85200999992,856836.60757029988,881911.70579740894,907739.05697133113,934341.22868047107,{"$f":"SUM(N11:N19)","v":961741.46554088523},989963.70950711181]

{"sheet":"PGO","index":12,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Gastos de Publicidad",{"$f":"DATOS!E21","v":10000},{"$f":"D11*(1+DATOS!F21)","v":10300},{"$f":"E11*(1+DATOS!F21)","v":10609},{"$f":"F11*(1+DATOS!F21)","v":10927.27},{"$f":"G11*(1+DATOS!F21)","v":11255.088100000001},{"$f":"H11*(1+DATOS!F21)","v":11592.740743},{"$f":"I11*(1+DATOS!F21)","v":11940.52296529},{"$f":"J11*(1+DATOS!F21)","v":12298.7386542487},{"$f":"K11*(1+DATOS!F21)","v":12667.700813876161},{"$f":"L11*(1+DATOS!F21)","v":13047.731838292446},{"$f":"M11*(1+DATOS!F21)","v":13439.163793441219},{"$f":"N11*(1+DATOS!F21)","v":13842.338707244457}]
[null,"+","Sueldos de los vendedores",{"$f":"DATOS!E22*DATOS!E23","v":1500000},{"$f":"D12*(DATOS!F22+1)","v":1530000},{"$f":"E12*(DATOS!F22+1)","v":1560600},{"$f":"F12*(DATOS!F22+1)","v":1591812},{"$f":"G12*(DATOS!F22+1)","v":1623648.24},{"$f":"H12*(DATOS!F22+1)","v":1656121.2047999999},{"$f":"I12*(DATOS!F22+1)","v":1689243.6288959999},{"$f":"J12*(DATOS!F22+1)","v":1723028.50147392},{"$f":"K12*(DATOS!F22+1)","v":1757489.0715033985},{"$f":"L12*(DATOS!F22+1)","v":1792638.8529334664},{"$f":"M12*(DATOS!F22+1)","v":1828491.6299921358},{"$f":"N12*(DATOS!F22+1)","v":1865061.4625919785}]
[null,"+","Gastos Fijos de Ventas",{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000},{"$f":"DATOS!E24","v":50000}]
[null,"=","Total de gastos de ventas",{"$f":"D11+D12+D13","v":1560000},{"$f":"E11+E12+E13","v":1590300},1621209,1652739.27,1684903.3281,1717713.945543,1751184.1518612897,1785327.2401281686,1820156.7723172747,1855686.5847717589,1891930.7937855769,1928903.801299223]
[]
[null,"+","Sueldos de empleados",{"$f":"DATOS!E38*DATOS!E37","v":1250000},{"$f":"D16*(1+DATOS!F38)","v":1275000},{"$f":"E16*(1+DATOS!F38)","v":1300500},{"$f":"F16*(1+DATOS!F38)","v":1326510},{"$f":"G16*(1+DATOS!F38)","v":1353040.2},{"$f":"H16*(1+DATOS!F38)","v":1380101.004},{"$f":"I16*(1+DATOS!F38)","v":1407703.0240799999},{"$f":"J16*(1+DATOS!F38)","v":1435857.0845615999},{"$f":"K16*(1+DATOS!F38)","v":1464574.226252832},{"$f":"L16*(1+DATOS!F38)","v":1493865.7107778885},{"$f":"M16*(1+DATOS!F38)","v":1523743.0249934464},{"$f":"N16*(1+DATOS!F38)","v":1554217.8854933153}]
[null,"+","Gastos Fijos de Administracion",{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000},{"$f":"DATOS!E39","v":50000}]
[null,"=","Total de gastos de administracion",{"$f":"D16+D17","v":1300000},{"$f":"E16+E17","v":1325000},1350500,1376510,1403040.2,1430101.004,1457703.0240799999,1485857.0845615999,1514574.226252832,1543865.7107778885,1573743.0249934464,1604217.8854933153]
[]
[null,"=","Total de gastos de administración y venta",{"$f":"D14+D18","v":2860000},{"$f":"E14+E18","v":2915300},2971709,3029249.27,3087943.5280999998,3147814.9495430002,3208887.1759412894,3271184.3246897683,3334730.9985701069,3399552.2955496474,3465673.8187790234,3533121.6867925385]

{"sheet":"CUP","index":13,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Materia Prima \"A\"",{"$f":"PRC!D18*DATOS!J20","v":2},{"$f":"PRC!E18*DATOS!J20","v":2.06},{"$f":"PRC!F18*DATOS!J20","v":2.1217999999999999},{"$f":"PRC!G18*DATOS!J20","v":2.185454},{"$f":"PRC!H18*DATOS!J20","v":2.2510176200000003},{"$f":"PRC!I18*DATOS!J20","v":2.3185481486000001},{"$f":"PRC!J18*DATOS!J20","v":2.3881045930580003},{"$f":"PRC!K18*DATOS!J20","v":2.4597477308497404},{"$f":"PRC!L18*DATOS!J20","v":2.5335401627752328},{"$f":"PRC!M18*DATOS!J20","v":2.6095463676584898},{"$f":"PRC!N18*DATOS!J20","v":2.6878327586882444},{"$f":"PRC!O18*DATOS!J20","v":2.7684677414488919}]
[null,"+","Materia Prima \"B\"",{"$f":"PRC!D30*DATOS!J21","v":4},{"$f":"PRC!E30*DATOS!J21","v":4.12},{"$f":"PRC!F30*DATOS!J21","v":4.2435999999999998},{"$f":"PRC!G30*DATOS!J21","v":4.370908},{"$f":"PRC!H30*DATOS!J21","v":4.5020352400000005},{"$f":"PRC!I30*DATOS!J21","v":4.6370962972000003},{"$f":"PRC!J30*DATOS!J21","v":4.7762091861160005},{"$f":"PRC!K30*DATOS!J21","v":4.9194954616994808},{"$f":"PRC!L30*DATOS!J21","v":5.0670803255504655},{"$f":"PRC!M30*DATOS!J21","v":5.2190927353169796},{"$f":"PRC!N30*DATOS!J21","v":5.3756655173764889},{"$f":"PRC!O30*DATOS!J21","v":5.5369354828977837}]
[null,"+","Materia Prima \"C\"",{"$f":"PRC!D42*DATOS!J22","v":4},{"$f":"PRC!E42*DATOS!J22","v":4.12},{"$f":"PRC!F42*DATOS!J22","v":4.2435999999999998},{"$f":"PRC!G42*DATOS!J22","v":4.370908},{"$f":"PRC!H42*DATOS!J22","v":4.5020352400000005},{"$f":"PRC!I42*DATOS!J22","v":4.6370962972000003},{"$f":"PRC!J42*DATOS!J22","v":4.7762091861160005},{"$f":"PRC!K42*DATOS!J22","v":4.9194954616994808},{"$f":"PRC!L42*DATOS!J22","v":5.0670803255504655},{"$f":"PRC!M42*DATOS!J22","v":5.2190927353169796},{"$f":"PRC!N42*DATOS!J22","v":5.3756655173764889},{"$f":"PRC!O42*DATOS!J22","v":5.5369354828977837}]
[null,"+","Mano de obra",{"$f":"PMO!D14*DATOS!J20","v":6},{"$f":"PMO!E14*DATOS!J20","v":6.18},{"$f":"PMO!F14*DATOS!J20","v":6.3654000000000002},{"$f":"PMO!G14*DATOS!J20","v":6.556362},{"$f":"PMO!H14*DATOS!J20","v":6.7530528600000004},{"$f":"PMO!I14*DATOS!J20","v":6.9556444458000009},{"$f":"PMO!J14*DATOS!J20","v":7.1643137791740008},{"$f":"PMO!K14*DATOS!J20","v":7.3792431925492208},{"$f":"PMO!L14*DATOS!J20","v":7.6006204883256974},{"$f":"PMO!M14*DATOS!J20","v":7.8286391029754681},{"$f":"PMO!N14*DATOS!J20","v":8.0634982760647329},{"$f":"PMO!O14*DATOS!J20","v":8.3054032243466747}]
[null,"+","Gastos indirectos",{"$f":"PGIF!D20/PMO!D11","v":5.15},{"$f":"PGIF!E20/PMO!E11","v":5.3},{"$f":"PGIF!F20/PMO!F11","v":5.4545000000000003},{"$f":"PGIF!G20/PMO!G11","v":5.6136350000000004},{"$f":"PGIF!H20/PMO!H11","v":5.7775440499999995},{"$f":"PGIF!I20/PMO!I11","v":5.9463703714999996},{"$f":"PGIF!J20/PMO!J11","v":6.1202614826449988},{"$f":"PGIF!K20/PMO!K11","v":6.2993693271243494},{"$f":"PGIF!L20/PMO!L11","v":6.4838504069380791},{"$f":"PGIF!M20/PMO!M11","v":6.6738659191462224},{"$f":"PGIF!N20/PMO!N11","v":6.869581896720609},{"$f":"PGIF!O20/PMO!O11","v":7.0711693536222269}]
[null,"=","Gastos Unitarios",{"$f":"SUM(D11:D15)","v":21.15},{"$f":"SUM(E11:E15)","v":21.78},{"$f":"SUM(F11:F15)","v":22.428899999999999},23.097267000000002,23.785685010000002,24.4947555603,25.225098227109001,25.977351173922273,26.75217170913994,27.550236860414142,28.372243966226563,{"$f":"SUM(O11:O15)","v":29.218911285213363}]

{"sheet":"VIF","index":14,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Materia Prima \"A\"",{"$f":"PRC!D14*PRC!D18","v":14000},{"$f":"PRC!E14*PRC!E18","v":14420},{"$f":"PRC!F14*PRC!F18","v":14852.599999999999},{"$f":"PRC!G14*PRC!G18","v":15298.178},{"$f":"PRC!H14*PRC!H18","v":15757.123340000002},{"$f":"PRC!I14*PRC!I18","v":16229.8370402},{"$f":"PRC!J14*PRC!J18","v":16716.732151406002},{"$f":"PRC!K14*PRC!K18","v":17218.234115948184},{"$f":"PRC!L14*PRC!L18","v":17734.781139426628},{"$f":"PRC!M14*PRC!M18","v":18266.824573609429},{"$f":"PRC!N14*PRC!N18","v":18814.829310817709},{"$f":"PRC!O14*PRC!O18","v":19379.274190142241}]
[null,"+","Materia Prima \"B\"",{"$f":"PRC!D26*PRC!D30","v":28000},{"$f":"PRC!E26*PRC!E30","v":28840},{"$f":"PRC!F26*PRC!F30","v":29705.199999999997},{"$f":"PRC!G26*PRC!G30","v":30596.356},{"$f":"PRC!H26*PRC!H30","v":31514.246680000004},{"$f":"PRC!I26*PRC!I30","v":32459.6740804},{"$f":"PRC!J26*PRC!J30","v":33433.464302812004},{"$f":"PRC!K26*PRC!K30","v":34436.468231896368},{"$f":"PRC!L26*PRC!L30","v":35469.562278853256},{"$f":"PRC!M26*PRC!M30","v":36533.649147218857},{"$f":"PRC!N26*PRC!N30","v":37629.658621635419},{"$f":"PRC!O26*PRC!O30","v":38758.548380284483}]
[null,"+","Materia Prima \"C\"",{"$f":"PRC!D38*PRC!D42","v":28000},{"$f":"PRC!E38*PRC!E42","v":28840},{"$f":"PRC!F38*PRC!F42","v":29705.199999999997},{"$f":"PRC!G38*PRC!G42","v":30596.356},{"$f":"PRC!H38*PRC!H42","v":31514.246680000004},{"$f":"PRC!I38*PRC!I42","v":32459.6740804},{"$f":"PRC!J38*PRC!J42","v":33433.464302812004},{"$f":"PRC!K38*PRC!K42","v":34436.468231896368},{"$f":"PRC!L38*PRC!L42","v":35469.562278853256},{"$f":"PRC!M38*PRC!M42","v":36533.649147218857},{"$f":"PRC!N38*PRC!N42","v":37629.658621635419},{"$f":"PRC!O38*PRC!O42","v":38758.548380284483}]
[null,"+","Producto Terminado",{"$f":"PP!D12*CUP!D16","v":302883.77622377622},{"$f":"PP!E12*CUP!E16","v":314700.69230769231},{"$f":"PP!F12*CUP!F16","v":326954.80636363634},{"$f":"PP!G12*CUP!G16","v":339661.73236888117},{"$f":"PP!H12*CUP!H16","v":352837.62766116089},{"$f":"PP!I12*CUP!I16","v":366499.2114877195},{"$f":"PP!J12*CUP!J16","v":380663.7841782773},{"$f":"PP!K12*CUP!K16","v":395349.24696265697},{"$f":"PP!L12*CUP!L16","v":410574.12245449272},{"$f":"PP!M12*CUP!M16","v":426357.57582315267},{"$f":"PP!N12*CUP!N16","v":442719.43667673011},{"$f":"PP!O12*CUP!O16","v":452893.12492080714}]
[null,"=","Total de inventario Final",{"$f":"SUM(D11:D14)","v":372883.77622377622},{"$f":"SUM(E11:E14)","v":386800.69230769231},401217.80636363634,416152.62236888119,431623.24436116091,447648.39668871951,464247.44493530731,481440.41754239786,499248.02815162588,517691.69869119982,536793.58323081862,549789.49587151839]

{"sheet":"VII","index":15,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Materia Prima \"A\"",{"$f":"PRC!D16*PRC!D18","v":10000},{"$f":"VIF!D11","v":14000},{"$f":"VIF!E11","v":14420},{"$f":"VIF!F11","v":14852.599999999999},{"$f":"VIF!G11","v":15298.178},{"$f":"VIF!H11","v":15757.123340000002},{"$f":"VIF!I11","v":16229.8370402},{"$f":"VIF!J11","v":16716.732151406002},{"$f":"VIF!K11","v":17218.234115948184},{"$f":"VIF!L11","v":17734.781139426628},{"$f":"VIF!M11","v":18266.824573609429},{"$f":"VIF!N11","v":18814.829310817709}]
[null,"+","Materia Prima \"B\"",{"$f":"PRC!D28*PRC!D30","v":24000},{"$f":"VIF!D12","v":28000},{"$f":"VIF!E12","v":28840},{"$f":"VIF!F12","v":29705.199999999997},{"$f":"VIF!G12","v":30596.356},{"$f":"VIF!H12","v":31514.246680000004},{"$f":"VIF!I12","v":32459.6740804},{"$f":"VIF!J12","v":33433.464302812004},{"$f":"VIF!K12","v":34436.468231896368},{"$f":"VIF!L12","v":35469.562278853256},{"$f":"VIF!M12","v":36533.649147218857},{"$f":"VIF!N12","v":37629.658621635419}]
[null,"+","Materia Prima \"C\"",{"$f":"PRC!D40*PRC!D42","v":24000},{"$f":"VIF!D13","v":28000},{"$f":"VIF!E13","v":28840},{"$f":"VIF!F13","v":29705.199999999997},{"$f":"VIF!G13","v":30596.356},{"$f":"VIF!H13","v":31514.246680000004},{"$f":"VIF!I13","v":32459.6740804},{"$f":"VIF!J13","v":33433.464302812004},{"$f":"VIF!K13","v":34436.468231896368},{"$f":"VIF!L13","v":35469.562278853256},{"$f":"VIF!M13","v":36533.649147218857},{"$f":"VIF!N13","v":37629.658621635419}]
[null,"+","Producto Terminado",{"$f":"PP!D14*DATOS!E33","v":300000},{"$f":"VIF!D14","v":302883.77622377622},{"$f":"VIF!E14","v":314700.69230769231},{"$f":"VIF!F14","v":326954.80636363634},{"$f":"VIF!G14","v":339661.73236888117},{"$f":"VIF!H14","v":352837.62766116089},{"$f":"VIF!I14","v":366499.2114877195},{"$f":"VIF!J14","v":380663.7841782773},{"$f":"VIF!K14","v":395349.24696265697},{"$f":"VIF!L14","v":410574.12245449272},{"$f":"VIF!M14","v":426357.57582315267},{"$f":"VIF!N14","v":442719.43667673011}]
[null,"=","Total de inventario Inicial",{"$f":"D11+D12+D13+D14","v":358000},372883.77622377622,386800.69230769231,401217.80636363634,416152.62236888119,431623.24436116091,447648.39668871951,464247.44493530731,481440.41754239786,499248.02815162588,517691.69869119982,536793.58323081862]

{"sheet":"PCV","index":16,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Costos de compra Materia Prima A",{"$f":"PRC!D19","v":284000},{"$f":"PRC!E19","v":288400},{"$f":"PRC!F19","v":297052},{"$f":"PRC!G19","v":305963.56},{"$f":"PRC!H19","v":315142.46680000005},{"$f":"PRC!I19","v":324596.740804},{"$f":"PRC!J19","v":334334.64302812004},{"$f":"PRC!K19","v":344364.68231896363},{"$f":"PRC!L19","v":354695.62278853258},{"$f":"PRC!M19","v":365336.49147218856},{"$f":"PRC!N19","v":376296.58621635422},{"$f":"PRC!O19","v":387585.48380284489}]
[null,"+","Costos de compra Materia Prima B",{"$f":"PRC!D31","v":564000},{"$f":"PRC!E31","v":576800},{"$f":"PRC!F31","v":594104},{"$f":"PRC!G31","v":611927.12},{"$f":"PRC!H31","v":630284.93360000011},{"$f":"PRC!I31","v":649193.481608},{"$f":"PRC!J31","v":668669.28605624009},{"$f":"PRC!K31","v":688729.36463792727},{"$f":"PRC!L31","v":709391.24557706516},{"$f":"PRC!M31","v":730672.98294437712},{"$f":"PRC!N31","v":752593.17243270844},{"$f":"PRC!O31","v":775170.96760568977}]
[null,"+","Costos de compra Materia Prima C",{"$f":"PRC!D43","v":564000},{"$f":"PRC!E43","v":576800},{"$f":"PRC!F43","v":594104},{"$f":"PRC!G43","v":611927.12},{"$f":"PRC!H43","v":630284.93360000011},{"$f":"PRC!I43","v":649193.481608},{"$f":"PRC!J43","v":668669.28605624009},{"$f":"PRC!K43","v":688729.36463792727},{"$f":"PRC!L43","v":709391.24557706516},{"$f":"PRC!M43","v":730672.98294437712},{"$f":"PRC!N43","v":752593.17243270844},{"$f":"PRC!O43","v":775170.96760568977}]
[null,"+","Costo total de mano de obra",{"$f":"PMO!D15","v":840000},{"$f":"PMO!E15","v":865200},{"$f":"PMO!F15","v":891156},{"$f":"PMO!G15","v":917890.68},{"$f":"PMO!H15","v":945427.40040000004},{"$f":"PMO!I15","v":973790.22241200018},{"$f":"PMO!J15","v":1003003.9290843601},{"$f":"PMO!K15","v":1033094.046956891},{"$f":"PMO!L15","v":1064086.8683655977},{"$f":"PMO!M15","v":1096009.4744165656},{"$f":"PMO!N15","v":1128889.7586490626},{"$f":"PMO!O15","v":1162756.4514085345}]
[null,"+","Total de gastos indirectos",{"$f":"PGIF!D20","v":721000},{"$f":"PGIF!E20","v":742000},{"$f":"PGIF!F20","v":763630},{"$f":"PGIF!G20","v":785908.9},{"$f":"PGIF!H20","v":808856.1669999999},{"$f":"PGIF!I20","v":832491.85200999992},{"$f":"PGIF!J20","v":856836.60757029988},{"$f":"PGIF!K20","v":881911.70579740894},{"$f":"PGIF!L20","v":907739.05697133113},{"$f":"PGIF!M20","v":934341.22868047107},{"$f":"PGIF!N20","v":961741.46554088523},{"$f":"PGIF!O20","v":989963.70950711181}]
[null,null,"Precio de subcontratar",{"$f":"DATOS!E30","v":40},{"$f":"D16*(1+DATOS!F30)","v":41.2},{"$f":"E16*(1+DATOS!F30)","v":42.436000000000007},{"$f":"F16*(1+DATOS!F30)","v":43.709080000000007},{"$f":"G16*(1+DATOS!F30)","v":45.020352400000007},{"$f":"H16*(1+DATOS!F30)","v":46.370962972000008},{"$f":"I16*(1+DATOS!F30)","v":47.762091861160009},{"$f":"J16*(1+DATOS!F30)","v":49.194954616994814},{"$f":"K16*(1+DATOS!F30)","v":50.670803255504659},{"$f":"L16*(1+DATOS!F30)","v":52.190927353169798},{"$f":"M16*(1+DATOS!F30)","v":53.756655173764891},{"$f":"N16*(1+DATOS!F30)","v":55.369354828977841}]
[null,"+","Costo de subcontratación",{"$f":"PP!D17*PCV!D16","v":49799.533799533965},{"$f":"PP!E17*PCV!E16","v":137434.17249417308},{"$f":"PP!F17*PCV!F16","v":196011.78508158415},{"$f":"PP!G17*PCV!G16","v":257980.36366899768},{"$f":"PP!H17*PCV!H16","v":323490.64636508131},{"$f":"PP!I17*PCV!I16","v":392699.36369562917},{"$f":"PP!J17*PCV!J16","v":465769.4624842786},{"$f":"PP!K17*PCV!K16","v":542870.33777292375},{"$f":"PP!L17*PCV!L16","v":624178.07306265028},{"$f":"PP!M17*PCV!M16","v":709875.68916576635},{"$f":"PP!N17*PCV!N16","v":800153.40196930978},{"$f":"PP!O17*PCV!O16","v":882347.45303688582}]
[null,"=","Costo Total de Produccion",{"$f":"D11+D12+D13+D14+D15+D17","v":3022799.5337995337},{"$f":"E11+E12+E13+E14+E15+E17","v":3186634.172494173},3336057.785081584,3491597.7436689977,3653486.5477650817,3821965.1421376299,3997283.214279539,4179699.5021220418,4369482.1123422412,4566908.8496237453,4772267.5572410282,4972995.0329667572]

{"sheet":"ER","index":17,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Ingreso Total",{"$f":"PI!D13","v":10289507.575757576},{"$f":"PI!E13","v":10797842.424242426},{"$f":"PI!F13","v":11330380.84848485},{"$f":"PI!G13","v":11888245.798787879},{"$f":"PI!H13","v":12472611.335757578},{"$f":"PI!I13","v":13084704.922406789},{"$f":"PI!J13","v":13725809.817850726},{"$f":"PI!K13","v":14397267.577054325},{"$f":"PI!L13","v":15100480.661285656},{"$f":"PI!M13","v":15836915.164132202},{"$f":"PI!N13","v":16608103.658148417},{"$f":"PI!O13","v":17415648.167423315}]
[null,"-","IVA",{"$f":"D11-D13","v":1419242.4242424238},{"$f":"E11-E13","v":1489357.5757575762},1562811.1515151504,1639758.041212121,1720360.1842424236,1804786.8858492114,1893215.1472897548,1985830.0106281824,2082824.9187980201,2184402.0916044414,2290772.9183652978,2402158.3679204565]
[null,"=","Ingreso Neto",{"$f":"D11/1.16","v":8870265.1515151523},{"$f":"E11/1.16","v":9308484.8484848496},9767569.6969696991,10248487.757575758,10752251.151515154,11279918.036557578,11832594.670560971,12411437.566426143,13017655.742487635,13652513.072527761,14317330.739783119,15013489.799502859]
[null,"-","Costo de venta",{"$f":"VII!D15+PCV!D18-VIF!D15","v":3007915.7575757573},{"$f":"VII!E15+PCV!E18-VIF!E15","v":3172717.256410257},{"$f":"VII!F15+PCV!F18-VIF!F15","v":3321640.6710256403},{"$f":"VII!G15+PCV!G18-VIF!G15","v":3476662.9276637528},{"$f":"VII!H15+PCV!H18-VIF!H15","v":3638015.925772802},{"$f":"VII!I15+PCV!I18-VIF!I15","v":3805939.9898100719},{"$f":"VII!J15+PCV!J18-VIF!J15","v":3980684.1660329509},{"$f":"VII!K15+PCV!K18-VIF!K15","v":4162506.5295149507},{"$f":"VII!L15+PCV!L18-VIF!L15","v":4351674.5017330134},{"$f":"VII!M15+PCV!M18-VIF!M15","v":4548465.1790841715},{"$f":"VII!N15+PCV!N18-VIF!N15","v":4753165.6727014091},{"$f":"VII!O15+PCV!O18-VIF!O15","v":4959999.1203260571}]
[null,"=","Utilidad Bruta",{"$f":"D13-D14","v":5862349.3939393945},{"$f":"E13-E14","v":6135767.5920745926},6445929.0259440588,6771824.829912005,7114235.2257423522,7473978.0467475057,7851910.5045280196,8248931.0369111924,8665981.240754623,9104047.8934435882,9564165.0670817103,10053490.679176802]
[null,"-","Gastos de operación",{"$f":"PGO!D20","v":2860000},{"$f":"PGO!E20","v":2915300},{"$f":"PGO!F20","v":2971709},{"$f":"PGO!G20","v":3029249.27},{"$f":"PGO!H20","v":3087943.5280999998},{"$f":"PGO!I20","v":3147814.9495430002},{"$f":"PGO!J20","v":3208887.1759412894},{"$f":"PGO!K20","v":3271184.3246897683},{"$f":"PGO!L20","v":3334730.9985701069},{"$f":"PGO!M20","v":3399552.2955496474},{"$f":"PGO!N20","v":3465673.8187790234},{"$f":"PGO!O20","v":3533121.6867925385}]
[null,"-","Gastos financieros",{"$f":"DATOS!K41*DATOS!L41","v":3500.0000000000005},{"$f":"FNE!E56*DATOS!L41","v":0},{"$f":"FNE!F56*DATOS!L41","v":0},{"$f":"FNE!G56*DATOS!L41","v":0},{"$f":"FNE!H56*DATOS!L41","v":0},{"$f":"FNE!I56*DATOS!L41","v":0},{"$f":"FNE!J56*DATOS!L41","v":0},{"$f":"FNE!K56*DATOS!L41","v":0},{"$f":"FNE!L56*DATOS!L41","v":0},{"$f":"FNE!M56*DATOS!L41","v":0},{"$f":"FNE!N56*DATOS!L41","v":0},{"$f":"FNE!O56*DATOS!L41","v":0}]
[null,"=","Utilidad antes de impuestos",{"$f":"D15-D16-D17","v":2998849.3939393945},{"$f":"E15-E16-E17","v":3220467.5920745926},{"$f":"F15-F16-F17","v":3474220.0259440588},3742575.559912005,4026291.6976423524,4326163.0972045055,4643023.3285867302,4977746.7122214241,5331250.242184516,5704495.5978939403,6098491.248302687,6520368.9923842633]
[null,"-","Impuestos",0,{"$f":"IF(AND(E18>DATOS!H27,E18<DATOS!I27),E18*0.1,IF(AND(E18>DATOS!H28,E18<DATOS!I28),E18*0.15,IF(AND(E18>DATOS!H29,E18<DATOS!I29),E18*0.2,IF(AND(E18>DATOS!H30,E18<DATOS!I30),E18*0.25,IF(AND(E18>DATOS!H31,E18<DATOS!I31),E18*0.3,IF(E18>DATOS!H32,E18*0.35,0))))))","v":1127163.6572261073},{"$f":"IF(AND(F18>DATOS!H27,F18<DATOS!I27),F18*0.1,IF(AND(F18>DATOS!H28,F18<DATOS!I28),F18*0.15,IF(AND(F18>DATOS!H29,F18<DATOS!I29),F18*0.2,IF(AND(F18>DATOS!H30,F18<DATOS!I30),F18*0.25,IF(AND(F18>DATOS!H31,F18<DATOS!I31),F18*0.3,IF(F18>DATOS!H32,F18*0.35,0))))))","v":1215977.0090804205},{"$f":"IF(AND(G18>DATOS!H27,G18<DATOS!I27),G18*0.1,IF(AND(G18>DATOS!H28,G18<DATOS!I28),G18*0.15,IF(AND(G18>DATOS!H29,G18<DATOS!I29),G18*0.2,IF(AND(G18>DATOS!H30,G18<DATOS!I30),G18*0.25,IF(AND(G18>DATOS!H31,G18<DATOS!I31),G18*0.3,IF(G18>DATOS!H32,G18*0.35,0))))))","v":1309901.4459692016},{"$f":"IF(AND(H18>DATOS!H27,H18<DATOS!I27),H18*0.1,IF(AND(H18>DATOS!H28,H18<DATOS!I28),H18*0.15,IF(AND(H18>DATOS!H29,H18<DATOS!I29),H18*0.2,IF(AND(H18>DATOS!H30,H18<DATOS!I30),H18*0.25,IF(AND(H18>DATOS!H31,H18<DATOS!I31),H18*0.3,IF(H18>DATOS!H32,H18*0.35,0))))))","v":1409202.0941748233},{"$f":"IF(AND(I18>DATOS!H27,I18<DATOS!I27),I18*0.1,IF(AND(I18>DATOS!H28,I18<DATOS!I28),I18*0.15,IF(AND(I18>DATOS!H29,I18<DATOS!I29),I18*0.2,IF(AND(I18>DATOS!H30,I18<DATOS!I30),I18*0.25,IF(AND(I18>DATOS!H31,I18<DATOS!I31),I18*0.3,IF(I18>DATOS!H32,I18*0.35,0))))))","v":1514157.0840215769},{"$f":"IF(AND(J18>DATOS!H27,J18<DATOS!I27),J18*0.1,IF(AND(J18>DATOS!H28,J18<DATOS!I28),J18*0.15,IF(AND(J18>DATOS!H29,J18<DATOS!I29),J18*0.2,IF(AND(J18>DATOS!H30,J18<DATOS!I30),J18*0.25,IF(AND(J18>DATOS!H31,J18<DATOS!I31),J18*0.3,IF(J18>DATOS!H32,J18*0.35,0))))))","v":1625058.1650053554},{"$f":"IF(AND(K18>DATOS!H27,K18<DATOS!I27),K18*0.1,IF(AND(K18>DATOS!H28,K18<DATOS!I28),K18*0.15,IF(AND(K18>DATOS!H29,K18<DATOS!I29),K18*0.2,IF(AND(K18>DATOS!H30,K18<DATOS!I30),K18*0.25,IF(AND(K18>DATOS!H31,K18<DATOS!I31),K18*0.3,IF(K18>DATOS!H32,K18*0.35,0))))))","v":1742211.3492774984},{"$f":"IF(AND(L18>DATOS!H27,L18<DATOS!I27),L18*0.1,IF(AND(L18>DATOS!H28,L18<DATOS!I28),L18*0.15,IF(AND(L18>DATOS!H29,L18<DATOS!I29),L18*0.2,IF(AND(L18>DATOS!H30,L18<DATOS!I30),L18*0.25,IF(AND(L18>DATOS!H31,L18<DATOS!I31),L18*0.3,IF(L18>DATOS!H32,L18*0.35,0))))))","v":1865937.5847645805},{"$f":"IF(AND(M18>DATOS!H27,M18<DATOS!I27),M18*0.1,IF(AND(M18>DATOS!H28,M18<DATOS!I28),M18*0.15,IF(AND(M18>DATOS!H29,M18<DATOS!I29),M18*0.2,IF(AND(M18>DATOS!H30,M18<DATOS!I30),M18*0.25,IF(AND(M18>DATOS!H31,M18<DATOS!I31),M18*0.3,IF(M18>DATOS!H32,M18*0.35,0))))))","v":1996573.4592628789},{"$f":"IF(AND(N18>DATOS!H27,N18<DATOS!I27),N18*0.1,IF(AND(N18>DATOS!H28,N18<DATOS!I28),N18*0.15,IF(AND(N18>DATOS!H29,N18<DATOS!I29),N18*0.2,IF(AND(N18>DATOS!H30,N18<DATOS!I30),N18*0.25,IF(AND(N18>DATOS!H31,N18<DATOS!I31),N18*0.3,IF(N18>DATOS!H32,N18*0.35,0))))))","v":2134471.9369059405},{"$f":"IF(AND(O18>DATOS!H27,O18<DATOS!I27),O18*0.1,IF(AND(O18>DATOS!H28,O18<DATOS!I28),O18*0.15,IF(AND(O18>DATOS!H29,O18<DATOS!I29),O18*0.2,IF(AND(O18>DATOS!H30,O18<DATOS!I30),O18*0.25,IF(AND(O18>DATOS!H31,O18<DATOS!I31),O18*0.3,IF(O18>DATOS!H32,O18*0.35,0))))))","v":2282129.1473344918}]
[null,"=","Utilidad o Perdida Neta",{"$f":"D18-D19","v":2998849.3939393945},{"$f":"E18-E19","v":2093303.9348484853},{"$f":"F18-F19","v":2258243.0168636385},2432674.1139428033,2617089.6034675292,2812006.0131829288,3017965.163581375,3235535.3629439259,3465312.6574199358,3707922.1386310617,3964019.3113967464,{"$f":"O18-O19","v":4238239.8450497715}]

{"sheet":"FNE","index":18,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[26,2,26,3],[28,2,28,3],[29,2,29,3],[35,2,35,3],[36,2,36,3],[30,2,30,3],[32,2,32,3],[33,2,33,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[25,2,25,3],[45,4,45,15],[52,4,52,15],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[34,2,34,3],[37,2,37,3],[60,2,60,3],[55,2,55,3],[42,2,42,3],[45,2,45,3],[51,2,51,3],[52,2,52,3],[58,2,58,3],[59,2,59,3],[57,2,57,3],[56,2,56,3],[54,2,54,3],[9,4,9,16],[17,4,17,16],[18,2,18,3],[19,2,19,3],[9,2,9,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PASO 1",null,"Presupuesto de ingreso"]
[]
[null,null,"Trimestre",null,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,null,"Ventas",null,{"$f":"PI!D13","v":10289507.575757576},{"$f":"PI!E13","v":10797842.424242426},{"$f":"PI!F13","v":11330380.84848485},{"$f":"PI!G13","v":11888245.798787879},{"$f":"PI!H13","v":12472611.335757578},{"$f":"PI!I13","v":13084704.922406789},{"$f":"PI!J13","v":13725809.817850726},{"$f":"PI!K13","v":14397267.577054325},{"$f":"PI!L13","v":15100480.661285656},{"$f":"PI!M13","v":15836915.164132202},{"$f":"PI!N13","v":16608103.658148417},{"$f":"PI!O13","v":17415648.167423315}]
[null,"+","Cobranza 40% Contado",null,{"$f":"E13*0.4","v":4115803.0303030307},{"$f":"F13*0.4","v":4319136.9696969707},4532152.3393939398,4755298.3195151519,4989044.5343030309,5233881.9689627159,5490323.9271402908,5758907.0308217304,6040192.2645142628,6334766.0656528808,6643241.4632593673,{"$f":"P13*0.4","v":6966259.2669693269}]
[null,"+","Cobranza 1 trimestre después 60%",null,{"$f":"DATOS!N17*0.6","v":7800000},{"$f":"E13*0.6","v":6173704.5454545459},{"$f":"F13*0.6","v":6478705.4545454551},6798228.5090909097,7132947.4792727269,7483566.8014545469,7850822.953444073,8235485.8907104349,8638360.5462325942,9060288.3967713937,9502149.0984793212,{"$f":"O13*0.6","v":9964862.19488905},{"$f":"P13*0.6","v":10449388.900453988}]
[null,"=","Total de ingreso",null,{"$f":"E14+E15","v":11915803.030303031},{"$f":"F14+F15","v":10492841.515151516},{"$f":"G14+G15","v":11010857.793939395},{"$f":"H14+H15","v":11553526.828606062},{"$f":"I14+I15","v":12121992.013575759},12717448.770417262,13341146.880584363,13994392.921532165,14678552.810746856,15395054.462424275,16145390.561738688,16931121.461858377]
[]
[null,null,"PASO 2",null,"Presupuesto de egreso"]
[]
[null,null,"Trimestre",null,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,null,"Compras materia prima A",null,{"$f":"PRC!D19","v":284000},{"$f":"PRC!E19","v":288400},{"$f":"PRC!F19","v":297052},{"$f":"PRC!G19","v":305963.56},{"$f":"PRC!H19","v":315142.46680000005},{"$f":"PRC!I19","v":324596.740804},{"$f":"PRC!J19","v":334334.64302812004},{"$f":"PRC!K19","v":344364.68231896363},{"$f":"PRC!L19","v":354695.62278853258},{"$f":"PRC!M19","v":365336.49147218856},{"$f":"PRC!N19","v":376296.58621635422},{"$f":"PRC!O19","v":387585.48380284489}]
[null,"+","Pago materia prima A      30% Contado",null,{"$f":"E21*0.3","v":85200},{"$f":"F21*0.3","v":86520},89115.599999999991,91789.067999999999,94542.740040000019,97379.0222412,100300.39290843601,103309.40469568908,106408.68683655978,109600.94744165656,112888.97586490626,116275.64514085346]
[null,"+","Pago materia prima A                    1 trimestre después 70%",null,{"$f":"DATOS!N20*0.7","v":192500},{"$f":"E21*0.7","v":198800},{"$f":"F21*0.7","v":201880},207936.4,214174.492,220599.72676000002,227217.7185628,234034.250119684,241055.27762327454,248286.93595197279,255735.54403053198,263407.61035144795,271309.83866199141]
[]
[null,null,"Compras materia prima B",null,{"$f":"PRC!D31","v":564000},{"$f":"PRC!E31","v":576800},{"$f":"PRC!F31","v":594104},{"$f":"PRC!G31","v":611927.12},{"$f":"PRC!H31","v":630284.93360000011},{"$f":"PRC!I31","v":649193.481608},{"$f":"PRC!J31","v":668669.28605624009},{"$f":"PRC!K31","v":688729.36463792727},{"$f":"PRC!L31","v":709391.24557706516},{"$f":"PRC!M31","v":730672.98294437712},{"$f":"PRC!N31","v":752593.17243270844},{"$f":"PRC!O31","v":775170.96760568977}]
[null,"+","Pago materia prima B      30% Contado",null,{"$f":"E25*0.3","v":169200},{"$f":"F25*0.3","v":173040},178231.19999999998,183578.136,189085.48008000004,194758.0444824,200600.78581687203,206618.80939137816,212817.37367311955,219201.89488331313,225777.95172981251,232551.29028170693]
[null,"+","Pago materia prima B                    1 trimestre después 70%",null,{"$f":"DATOS!N21*0.7","v":413000},{"$f":"E25*0.7","v":394800},{"$f":"F25*0.7","v":403760},415872.8,428348.984,441199.45352000004,454435.4371256,468068.500239368,482110.55524654908,496573.87190394558,511471.08806106396,526815.22070289589,542619.67732398282]
[]
[null,null,"Compras materia prima C",null,{"$f":"PRC!D43","v":564000},{"$f":"PRC!E43","v":576800},{"$f":"PRC!F43","v":594104},{"$f":"PRC!G43","v":611927.12},{"$f":"PRC!H43","v":630284.93360000011},{"$f":"PRC!I43","v":649193.481608},{"$f":"PRC!J43","v":668669.28605624009},{"$f":"PRC!K43","v":688729.36463792727},{"$f":"PRC!L43","v":709391.24557706516},{"$f":"PRC!M43","v":730672.98294437712},{"$f":"PRC!N43","v":752593.17243270844},{"$f":"PRC!O43","v":775170.96760568977}]
[null,"+","Pago materia prima C      30% Contado",null,{"$f":"E29*0.3","v":169200},{"$f":"F29*0.3","v":173040},178231.19999999998,183578.136,189085.48008000004,194758.0444824,200600.78581687203,206618.80939137816,212817.37367311955,219201.89488331313,225777.95172981251,232551.29028170693]
[null,"+","Pago materia prima C                    1 trimestre después 70%",null,{"$f":"DATOS!N22*0.7","v":406000},{"$f":"E29*0.7","v":394800},{"$f":"F29*0.7","v":403760},415872.8,428348.984,441199.45352000004,454435.4371256,468068.500239368,482110.55524654908,496573.87190394558,511471.08806106396,526815.22070289589,542619.67732398282]
[]
[null,null,"Pago total materia prima A",null,{"$f":"E22+E23","v":277700},285320,290995.59999999998,299725.46799999999,308717.23204000003,317978.74900120002,327518.11147123598,337343.65481537307,347463.96445983433,357887.88339362934,368624.51989543822,379683.25549230142]
[null,"+","Pago total materia prima B",null,{"$f":"E26+E27","v":582200},567840,581991.19999999995,599450.93599999999,617434.46408000006,635957.49800240004,655036.22294247197,674687.30963074614,694927.92891966866,715775.76678725868,737249.03979087644,759366.51098460285]
[null,"+","Pago total materia prima C",null,{"$f":"E30+E31","v":575200},567840,581991.19999999995,599450.93599999999,617434.46408000006,635957.49800240004,655036.22294247197,674687.30963074614,694927.92891966866,715775.76678725868,737249.03979087644,759366.51098460285]
[null,"+","Costo de mano de obra",null,{"$f":"PMO!D15","v":840000},{"$f":"PMO!E15","v":865200},{"$f":"PMO!F15","v":891156},{"$f":"PMO!G15","v":917890.68},{"$f":"PMO!H15","v":945427.40040000004},{"$f":"PMO!I15","v":973790.22241200018},{"$f":"PMO!J15","v":1003003.9290843601},{"$f":"PMO!K15","v":1033094.046956891},{"$f":"PMO!L15","v":1064086.8683655977},{"$f":"PMO!M15","v":1096009.4744165656},{"$f":"PMO!N15","v":1128889.7586490626},{"$f":"PMO!O15","v":1162756.4514085345},{"$f":"ER!P14","v":0}]
[null,"+","Costo de mantenimiento",null,{"$f":"PGIF!D16","v":700000},{"$f":"PGIF!E16","v":721000},{"$f":"PGIF!F16","v":742630},{"$f":"PGIF!G16","v":764908.9},{"$f":"PGIF!H16","v":787856.1669999999},{"$f":"PGIF!I16","v":811491.85200999992},{"$f":"PGIF!J16","v":835836.60757029988},{"$f":"PGIF!K16","v":860911.70579740894},{"$f":"PGIF!L16","v":886739.05697133113},{"$f":"PGIF!M16","v":913341.22868047107},{"$f":"PGIF!N16","v":940741.46554088523},{"$f":"PGIF!O16","v":968963.70950711181},{"$f":"ER!P16","v":0}]
[null,"+","Costo de subcontratacion",null,{"$f":"PCV!D17","v":49799.533799533965},{"$f":"PCV!E17","v":137434.17249417308},{"$f":"PCV!F17","v":196011.78508158415},{"$f":"PCV!G17","v":257980.36366899768},{"$f":"PCV!H17","v":323490.64636508131},{"$f":"PCV!I17","v":392699.36369562917},{"$f":"PCV!J17","v":465769.4624842786},{"$f":"PCV!K17","v":542870.33777292375},{"$f":"PCV!L17","v":624178.07306265028},{"$f":"PCV!M17","v":709875.68916576635},{"$f":"PCV!N17","v":800153.40196930978},{"$f":"PCV!O17","v":882347.45303688582},{"$f":"ER!P17","v":0}]
[null,null,"Gastos financieros",null,{"$f":"ER!D17","v":3500.0000000000005},{"$f":"ER!E17","v":0},{"$f":"ER!F17","v":0},{"$f":"ER!G17","v":0},{"$f":"ER!H17","v":0},{"$f":"ER!I17","v":0},{"$f":"ER!J17","v":0},{"$f":"ER!K17","v":0},{"$f":"ER!L17","v":0},{"$f":"ER!M17","v":0},{"$f":"ER!N17","v":0},{"$f":"ER!O17","v":0}]
[null,null,"Gastos de operación",null,{"$f":"PGO!D20","v":2860000},{"$f":"PGO!E20","v":2915300},{"$f":"PGO!F20","v":2971709},{"$f":"PGO!G20","v":3029249.27},{"$f":"PGO!H20","v":3087943.5280999998},{"$f":"PGO!I20","v":3147814.9495430002},{"$f":"PGO!J20","v":3208887.1759412894},{"$f":"PGO!K20","v":3271184.3246897683},{"$f":"PGO!L20","v":3334730.9985701069},{"$f":"PGO!M20","v":3399552.2955496474},{"$f":"PGO!N20","v":3465673.8187790234},{"$f":"PGO!O20","v":3533121.6867925385}]
[null,"+","IVA",null,{"$f":"ER!D12","v":1419242.4242424238},{"$f":"ER!E12","v":1489357.5757575762},{"$f":"ER!F12","v":1562811.1515151504},{"$f":"ER!G12","v":1639758.041212121},{"$f":"ER!H12","v":1720360.1842424236},{"$f":"ER!I12","v":1804786.8858492114},{"$f":"ER!J12","v":1893215.1472897548},{"$f":"ER!K12","v":1985830.0106281824},{"$f":"ER!L12","v":2082824.9187980201},{"$f":"ER!M12","v":2184402.0916044414},{"$f":"ER!N12","v":2290772.9183652978},{"$f":"ER!O12","v":2402158.3679204565},{"$f":"ER!P12","v":0}]
[null,"+","Impuestos",null,{"$f":"ER!D19","v":0},{"$f":"ER!E19","v":1127163.6572261073},{"$f":"ER!F19","v":1215977.0090804205},{"$f":"ER!G19","v":1309901.4459692016},{"$f":"ER!H19","v":1409202.0941748233},{"$f":"ER!I19","v":1514157.0840215769},{"$f":"ER!J19","v":1625058.1650053554},{"$f":"ER!K19","v":1742211.3492774984},{"$f":"ER!L19","v":1865937.5847645805},{"$f":"ER!M19","v":1996573.4592628789},{"$f":"ER!N19","v":2134471.9369059405},{"$f":"ER!O19","v":2282129.1473344918},{"$f":"ER!P19","v":0}]
[null,"=","Total de egreso",null,{"$f":"SUM(E33:E42)","v":7307641.9580419576},{"$f":"SUM(F33:F42)","v":8676455.4054778572},9035272.9456771556,9418316.0408503208,9817866.1804823279,10234634.102537418,10669361.04473152,11122820.049199538,11595817.322831459,12089193.655647919,12603825.899686711,13129893.093461527,{"$f":"Q36+Q37+Q38+Q42+Q41","v":0}]
[]
[]
[null,null,"PASO 3",null,"Flujo neto de Operación"]
[]
[null,null,"Trimestre",null,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Total de ingresos",null,{"$f":"E16","v":11915803.030303031},10492841.515151516,11010857.793939395,11553526.828606062,12121992.013575759,12717448.770417262,13341146.880584363,13994392.921532165,14678552.810746856,15395054.462424275,16145390.561738688,16931121.461858377]
[null,"-","Total de egresos",null,{"$f":"E43","v":7307641.9580419576},{"$f":"F43","v":8676455.4054778572},9035272.9456771556,9418316.0408503208,9817866.1804823279,10234634.102537418,10669361.04473152,11122820.049199538,11595817.322831459,12089193.655647919,12603825.899686711,13129893.093461527]
[null,"=","Flujo de operación",null,{"$f":"E49-E50","v":4608161.0722610736},{"$f":"F49-F50","v":1816386.1096736584},1975584.8482622392,2135210.7877557408,2304125.8330934308,2482814.6678798441,2671785.8358528428,2871572.872332627,3082735.4879153967,3305860.806776356,3541564.6620519776,3801228.3683968503]
[]
[null,null,"PASO 4",null,"Flujo Neto de Efectivo (FNE)"]
[]
[null,null,"Trimestre",null,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Prestamo requerido",null,{"$f":"IF(E51+DATOS!K40-E57>0,0,(E51+DATOS!K40-E57)*-1)","v":0},{"$f":"IF(E59+F51-F57>0, 0, (E59+F51-F57)*-1)","v":0},{"$f":"IF(F59+G51-G57>0, 0, (F59+G51-G57)*-1)","v":0},0,0,0,0,0,0,0,0,0]
[null,"-","Pago del prestamo anterior",null,{"$f":"DATOS!K41","v":100000},{"$f":"E56","v":0},{"$f":"F56","v":0},0,0,0,0,0,0,0,0,0]
[null,"=","Flujo Financiero",null,{"$f":"E56-E57","v":-100000},{"$f":"F56-F57","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"=","Flujo Neto de Efectivo",null,{"$f":"IF(E51+DATOS!K40-E57<0,0,E51+DATOS!K40-E57)","v":4761661.0722610736},{"$f":"IF(E59+F51-F57<0, 0, E59+F51-F57)","v":6578047.181934732},{"$f":"IF(F59+G51-G57<0, 0, F59+G51-G57)","v":8553632.0301969722},10688842.817952713,12992968.651046144,15475783.318925988,18147569.154778831,21019142.027111456,24101877.515026852,27407738.321803208,30949302.983855188,34750531.352252036]

{"sheet":"BG","index":19,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"ACTIVOS"]
[null,null,"Efectivo",{"$f":"FNE!E59","v":4761661.0722610736},{"$f":"FNE!F59","v":6578047.181934732},{"$f":"FNE!G59","v":8553632.0301969722},{"$f":"FNE!H59","v":10688842.817952713},{"$f":"FNE!I59","v":12992968.651046144},{"$f":"FNE!J59","v":15475783.318925988},{"$f":"FNE!K59","v":18147569.154778831},{"$f":"FNE!L59","v":21019142.027111456},{"$f":"FNE!M59","v":24101877.515026852},{"$f":"FNE!N59","v":27407738.321803208},{"$f":"FNE!O59","v":30949302.983855188},{"$f":"FNE!P59","v":34750531.352252036}]
[null,null,"Inventario de producto terminado",{"$f":"VIF!D14","v":302883.77622377622},{"$f":"VIF!E14","v":314700.69230769231},{"$f":"VIF!F14","v":326954.80636363634},{"$f":"VIF!G14","v":339661.73236888117},{"$f":"VIF!H14","v":352837.62766116089},{"$f":"VIF!I14","v":366499.2114877195},{"$f":"VIF!J14","v":380663.7841782773},{"$f":"VIF!K14","v":395349.24696265697},{"$f":"VIF!L14","v":410574.12245449272},{"$f":"VIF!M14","v":426357.57582315267},{"$f":"VIF!N14","v":442719.43667673011},{"$f":"VIF!O14","v":452893.12492080714}]
[null,null,"Inventario de materia prima A",{"$f":"VIF!D11","v":14000},{"$f":"VIF!E11","v":14420},{"$f":"VIF!F11","v":14852.599999999999},{"$f":"VIF!G11","v":15298.178},{"$f":"VIF!H11","v":15757.123340000002},{"$f":"VIF!I11","v":16229.8370402},{"$f":"VIF!J11","v":16716.732151406002},{"$f":"VIF!K11","v":17218.234115948184},{"$f":"VIF!L11","v":17734.781139426628},{"$f":"VIF!M11","v":18266.824573609429},{"$f":"VIF!N11","v":18814.829310817709},{"$f":"VIF!O11","v":19379.274190142241}]
[null,null,"Inventario de materia prima B",{"$f":"VIF!D12","v":28000},{"$f":"VIF!E12","v":28840},{"$f":"VIF!F12","v":29705.199999999997},{"$f":"VIF!G12","v":30596.356},{"$f":"VIF!H12","v":31514.246680000004},{"$f":"VIF!I12","v":32459.6740804},{"$f":"VIF!J12","v":33433.464302812004},{"$f":"VIF!K12","v":34436.468231896368},{"$f":"VIF!L12","v":35469.562278853256},{"$f":"VIF!M12","v":36533.649147218857},{"$f":"VIF!N12","v":37629.658621635419},{"$f":"VIF!O12","v":38758.548380284483}]
[null,null,"Inventario de materia prima C",{"$f":"VIF!D13","v":28000},{"$f":"VIF!E13","v":28840},{"$f":"VIF!F13","v":29705.199999999997},{"$f":"VIF!G13","v":30596.356},{"$f":"VIF!H13","v":31514.246680000004},{"$f":"VIF!I13","v":32459.6740804},{"$f":"VIF!J13","v":33433.464302812004},{"$f":"VIF!K13","v":34436.468231896368},{"$f":"VIF!L13","v":35469.562278853256},{"$f":"VIF!M13","v":36533.649147218857},{"$f":"VIF!N13","v":37629.658621635419},{"$f":"VIF!O13","v":38758.548380284483}]
[null,null,"Cuentas por Cobrar",{"$f":"FNE!F15","v":6173704.5454545459},{"$f":"FNE!G15","v":6478705.4545454551},{"$f":"FNE!H15","v":6798228.5090909097},{"$f":"FNE!I15","v":7132947.4792727269},{"$f":"FNE!J15","v":7483566.8014545469},{"$f":"FNE!K15","v":7850822.953444073},{"$f":"FNE!L15","v":8235485.8907104349},{"$f":"FNE!M15","v":8638360.5462325942},{"$f":"FNE!N15","v":9060288.3967713937},{"$f":"FNE!O15","v":9502149.0984793212},{"$f":"FNE!P15","v":9964862.19488905},{"$f":"FNE!Q15","v":10449388.900453988}]
[null,null,"Total Activo circulante",{"$f":"SUM(D12:D17)","v":11308249.393939395},{"$f":"SUM(E12:E17)","v":13443553.328787878},15753078.345651517,18237942.919594321,20908158.696861852,23774254.669058781,26847302.490424573,30138942.99088645,33661413.93994987,37427579.118973732,41450958.761975057,{"$f":"SUM(O12:O17)","v":45749709.74857755}]
[]
[null,null,"Equipo",{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000},{"$f":"DATOS!K37","v":500000}]
[null,null,"Depreciación Acumulada",{"$f":"PGIF!D11+PGIF!D12","v":21000},{"$f":"PGIF!E11+PGIF!E12+BG!D21","v":42000},{"$f":"PGIF!F11+PGIF!F12+BG!E21","v":63000},{"$f":"PGIF!G11+PGIF!G12+BG!F21","v":84000},{"$f":"PGIF!H11+PGIF!H12+BG!G21","v":105000},{"$f":"PGIF!I11+PGIF!I12+BG!H21","v":126000},{"$f":"PGIF!J11+PGIF!J12+BG!I21","v":147000},{"$f":"PGIF!K11+PGIF!K12+BG!J21","v":168000},{"$f":"PGIF!L11+PGIF!L12+BG!K21","v":189000},{"$f":"PGIF!M11+PGIF!M12+BG!L21","v":210000},{"$f":"PGIF!N11+PGIF!N12+BG!M21","v":231000},{"$f":"PGIF!O11+PGIF!O12+BG!N21","v":252000}]
[null,null,"Total Activo fijo",{"$f":"D20-D21","v":479000},{"$f":"E20-E21","v":458000},{"$f":"F20-F21","v":437000},416000,395000,374000,353000,332000,311000,290000,269000,248000]
[]
[null,null,"Total de Activos",{"$f":"D18+D22","v":11787249.393939395},{"$f":"E18+E22","v":13901553.328787878},16190078.345651517,18653942.919594321,21303158.696861852,24148254.669058781,27200302.490424573,30470942.99088645,33972413.93994987,37717579.118973732,41719958.761975057,{"$f":"O18+O22","v":45997709.74857755}]
[]
[null,null,"PASIVOS"]
[null,null,"Prestamo ",{"$f":"FNE!E56","v":0},{"$f":"FNE!F56","v":0},{"$f":"FNE!G56","v":0},{"$f":"FNE!H56","v":0},{"$f":"FNE!I56","v":0},{"$f":"FNE!J56","v":0},{"$f":"FNE!K56","v":0},{"$f":"FNE!L56","v":0},{"$f":"FNE!M56","v":0},{"$f":"FNE!N56","v":0},{"$f":"FNE!O56","v":0},{"$f":"FNE!P56","v":0}]
[null,null,"Cuentas por Pagar",{"$f":"FNE!F23+FNE!F27+FNE!F31","v":988400},{"$f":"FNE!G23+FNE!G27+FNE!G31","v":1009400},{"$f":"FNE!H23+FNE!H27+FNE!H31","v":1039682},{"$f":"FNE!I23+FNE!I27+FNE!I31","v":1070872.46},{"$f":"FNE!J23+FNE!J27+FNE!J31","v":1102998.6338000002},{"$f":"FNE!K23+FNE!K27+FNE!K31","v":1136088.5928140001},{"$f":"FNE!L23+FNE!L27+FNE!L31","v":1170171.2505984199},{"$f":"FNE!M23+FNE!M27+FNE!M31","v":1205276.3881163727},{"$f":"FNE!N23+FNE!N27+FNE!N31","v":1241434.6797598638},{"$f":"FNE!O23+FNE!O27+FNE!O31","v":1278677.7201526598},{"$f":"FNE!P23+FNE!P27+FNE!P31","v":1317038.0517572397},{"$f":"FNE!Q23+FNE!Q27+FNE!Q31","v":1356549.1933099572}]
[null,null,"Total de pasivos",{"$f":"SUM(D27:D28)","v":988400},{"$f":"SUM(E27:E28)","v":1009400},1039682,1070872.46,1102998.6338000002,1136088.5928140001,1170171.2505984199,1205276.3881163727,1241434.6797598638,1278677.7201526598,1317038.0517572397,1356549.1933099572]
[]
[null,null,"CAPITAL CONTABLE"]
[null,null,"Capital Social",{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000},{"$f":"DATOS!K42","v":7800000}]
[null,null,"Utilidad Acumulada",{"$f":"ER!D20+DATOS!E42","v":2998849.3939393945},{"$f":"ER!E20+BG!D33","v":5092153.32878788},{"$f":"ER!F20+BG!E33","v":7350396.3456515186},{"$f":"ER!G20+BG!F33","v":9783070.4595943224},{"$f":"ER!H20+BG!G33","v":12400160.063061852},{"$f":"ER!I20+BG!H33","v":15212166.076244781},{"$f":"ER!J20+BG!I33","v":18230131.239826158},{"$f":"ER!K20+BG!J33","v":21465666.602770083},{"$f":"ER!L20+BG!K33","v":24930979.260190018},{"$f":"ER!M20+BG!L33","v":28638901.398821078},{"$f":"ER!N20+BG!M33","v":32602920.710217826},{"$f":"ER!O20+BG!N33","v":36841160.555267595}]
[null,null,"Total capital contable",{"$f":"SUM(D32:D33)","v":10798849.393939395},{"$f":"SUM(E32:E33)","v":12892153.32878788},15150396.345651519,17583070.459594324,20200160.063061852,23012166.076244779,26030131.239826158,29265666.602770083,32730979.260190018,36438901.398821078,40402920.710217826,{"$f":"SUM(O32:O33)","v":44641160.555267595}]
[]
[null,null,"Total capital + pasivos",{"$f":"D29+D34","v":11787249.393939395},{"$f":"E29+E34","v":13901553.32878788},16190078.345651519,18653942.919594325,21303158.696861852,24148254.669058777,27200302.490424577,30470942.990886457,33972413.939949885,37717579.118973739,41719958.761975065,45997709.74857755]
[null,null,null,{"$f":"D24-D36","v":0},{"$f":"E24-E36","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"RESULTADO","index":20,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[14,2,14,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trimestre",null,13,14,15,16,17,18,19,20,21,22,23,24]
[null,null,"Utilidad o pérdida neta",null,{"$f":"ER!D20","v":2998849.3939393945},{"$f":"ER!E20","v":2093303.9348484853},{"$f":"ER!F20","v":2258243.0168636385},{"$f":"ER!G20","v":2432674.1139428033},{"$f":"ER!H20","v":2617089.6034675292},{"$f":"ER!I20","v":2812006.0131829288},{"$f":"ER!J20","v":3017965.163581375},{"$f":"ER!K20","v":3235535.3629439259},{"$f":"ER!L20","v":3465312.6574199358},{"$f":"ER!M20","v":3707922.1386310617},{"$f":"ER!N20","v":3964019.3113967464},{"$f":"ER!O20","v":4238239.8450497715}]
[null,null,"Total de ingreso",null,{"$f":"FNE!E16","v":11915803.030303031},{"$f":"FNE!F16","v":10492841.515151516},{"$f":"FNE!G16","v":11010857.793939395},{"$f":"FNE!H16","v":11553526.828606062},{"$f":"FNE!I16","v":12121992.013575759},{"$f":"FNE!J16","v":12717448.770417262},{"$f":"FNE!K16","v":13341146.880584363},{"$f":"FNE!L16","v":13994392.921532165},{"$f":"FNE!M16","v":14678552.810746856},{"$f":"FNE!N16","v":15395054.462424275},{"$f":"FNE!O16","v":16145390.561738688},{"$f":"FNE!P16","v":16931121.461858377}]
[null,null,"Total de egreso",null,{"$f":"FNE!E43","v":7307641.9580419576},{"$f":"FNE!F43","v":8676455.4054778572},{"$f":"FNE!G43","v":9035272.9456771556},{"$f":"FNE!H43","v":9418316.0408503208},{"$f":"FNE!I43","v":9817866.1804823279},{"$f":"FNE!J43","v":10234634.102537418},{"$f":"FNE!K43","v":10669361.04473152},{"$f":"FNE!L43","v":11122820.049199538},{"$f":"FNE!M43","v":11595817.322831459},{"$f":"FNE!N43","v":12089193.655647919},{"$f":"FNE!O43","v":12603825.899686711},{"$f":"FNE!P43","v":13129893.093461527}]
[null,null,"Flujo de operación",null,{"$f":"FNE!E51","v":4608161.0722610736},{"$f":"FNE!F51","v":1816386.1096736584},{"$f":"FNE!G51","v":1975584.8482622392},{"$f":"FNE!H51","v":2135210.7877557408},{"$f":"FNE!I51","v":2304125.8330934308},{"$f":"FNE!J51","v":2482814.6678798441},{"$f":"FNE!K51","v":2671785.8358528428},{"$f":"FNE!L51","v":2871572.872332627},{"$f":"FNE!M51","v":3082735.4879153967},{"$f":"FNE!N51","v":3305860.806776356},{"$f":"FNE!O51","v":3541564.6620519776},{"$f":"FNE!P51","v":3801228.3683968503}]
[null,null,"Prestamo requerido",null,{"$f":"FNE!E56","v":0},{"$f":"FNE!F56","v":0},{"$f":"FNE!G56","v":0},{"$f":"FNE!H56","v":0},{"$f":"FNE!I56","v":0},{"$f":"FNE!J56","v":0},{"$f":"FNE!K56","v":0},{"$f":"FNE!L56","v":0},{"$f":"FNE!M56","v":0},{"$f":"FNE!N56","v":0},{"$f":"FNE!O56","v":0},{"$f":"FNE!P56","v":0}]
[null,null,"Flujo financiero",null,{"$f":"FNE!E58","v":-100000},{"$f":"FNE!F58","v":0},{"$f":"FNE!G58","v":0},{"$f":"FNE!H58","v":0},{"$f":"FNE!I58","v":0},{"$f":"FNE!J58","v":0},{"$f":"FNE!K58","v":0},{"$f":"FNE!L58","v":0},{"$f":"FNE!M58","v":0},{"$f":"FNE!N58","v":0},{"$f":"FNE!O58","v":0},{"$f":"FNE!P58","v":0}]
[null,null,"Flujo neto de fectivo (FNE)",null,{"$f":"FNE!E59","v":4761661.0722610736},{"$f":"FNE!F59","v":6578047.181934732},{"$f":"FNE!G59","v":8553632.0301969722},{"$f":"FNE!H59","v":10688842.817952713},{"$f":"FNE!I59","v":12992968.651046144},{"$f":"FNE!J59","v":15475783.318925988},{"$f":"FNE!K59","v":18147569.154778831},{"$f":"FNE!L59","v":21019142.027111456},{"$f":"FNE!M59","v":24101877.515026852},{"$f":"FNE!N59","v":27407738.321803208},{"$f":"FNE!O59","v":30949302.983855188},{"$f":"FNE!P59","v":34750531.352252036}]
[null,null,"Total de activos",null,{"$f":"BG!D24","v":11787249.393939395},{"$f":"BG!E24","v":13901553.328787878},{"$f":"BG!F24","v":16190078.345651517},{"$f":"BG!G24","v":18653942.919594321},{"$f":"BG!H24","v":21303158.696861852},{"$f":"BG!I24","v":24148254.669058781},{"$f":"BG!J24","v":27200302.490424573},{"$f":"BG!K24","v":30470942.99088645},{"$f":"BG!L24","v":33972413.93994987},{"$f":"BG!M24","v":37717579.118973732},{"$f":"BG!N24","v":41719958.761975057},{"$f":"BG!O24","v":45997709.74857755}]
[null,null,"Total pasivo",null,{"$f":"BG!D29","v":988400},{"$f":"BG!E29","v":1009400},{"$f":"BG!F29","v":1039682},{"$f":"BG!G29","v":1070872.46},{"$f":"BG!H29","v":1102998.6338000002},{"$f":"BG!I29","v":1136088.5928140001},{"$f":"BG!J29","v":1170171.2505984199},{"$f":"BG!K29","v":1205276.3881163727},{"$f":"BG!L29","v":1241434.6797598638},{"$f":"BG!M29","v":1278677.7201526598},{"$f":"BG!N29","v":1317038.0517572397},{"$f":"BG!O29","v":1356549.1933099572}]
[null,null,"Total capital contable",null,{"$f":"BG!D34","v":10798849.393939395},{"$f":"BG!E34","v":12892153.32878788},{"$f":"BG!F34","v":15150396.345651519},{"$f":"BG!G34","v":17583070.459594324},{"$f":"BG!H34","v":20200160.063061852},{"$f":"BG!I34","v":23012166.076244779},{"$f":"BG!J34","v":26030131.239826158},{"$f":"BG!K34","v":29265666.602770083},{"$f":"BG!L34","v":32730979.260190018},{"$f":"BG!M34","v":36438901.398821078},{"$f":"BG!N34","v":40402920.710217826},{"$f":"BG!O34","v":44641160.555267595}]

{"sheet":"ACT","index":21,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[6,1,6,6]]}
[]
[null,"ACTIVIDADES DE APRENDIZAJE"]
[]
[]
[null,"1.- PRÁCTICA 5: PRESUPUESTO MAESTRO \"EL EMPERADOR S.A. de C.V.\""]