{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AE"],"not_rendered":{"charts":0,"images":0,"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":"AE","index":0,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["COSTO DE PRODUCCIÓN TOTAL Y UNITARIO",null,null,null,null,null,null,null,"GASTO TOTAL Y UNITARIO"]
[]
[null,"Descripción",null,"Cantidad","Costo Unitario","Total","%",null,null,"Descripción",null,"Cantidad","Costo Unitario","Total","%"]
["1.-","COSTOS QUE VARIAN SEGÚN LA CANTIDAD A PRODUCIR",null,null,null,{"$f":"F5+F12","v":20.649404761904758},{"$f":"F4/F33","v":0.83843290796597059},null,"3.-","GASTOS QUE VARIAN SEGÚN LA CANTIDAD A VENDER",null,null,null,{"$f":"N5+N12","v":0},{"$f":"N4/N33","v":0}]
[null,1.1000000000000001,"Materiales",null,null,{"$f":"SUM(F6:F11)","v":16.378571428571426},{"$f":"F5/F33","v":0.66502320185614849},null,null,3.1,"Insumos",null,null,{"$f":"SUM(N6:N11)","v":0},{"$f":"N5/N33","v":0}]
[null,null,"Fresas - Kilo",1,6,{"$f":"D6*E6","v":6},null,null,null,null,null,null,null,{"$f":"L6*M6","v":0}]
[null,null,"Yogurt - Litro",1,7.2,{"$f":"D7*E7","v":7.2},null,null,null,null,null,null,null,{"$f":"L7*M7","v":0}]
[null,null,"Azucar - Kilo",0.5,5.5,2.75,null,null,null,null,null,null,null,0]
[null,null,"Bolsitas - Paquete de 70 unidades",20,{"$f":"1.5/70","v":2.1428571428571429E-2},0.4285714285714286,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,1.2,"Personal",null,null,{"$f":"SUM(F13:F17)","v":4.270833333333333},{"$f":"F12/F33","v":0.17340970610982212},null,null,3.2,"Personal",null,null,{"$f":"SUM(N13:N17)","v":0},{"$f":"N12/N33","v":0}]
[null,null,"Fabricante - Horas",1,{"$f":"1025/240","v":4.270833333333333},4.270833333333333,null,null,null,null,null,null,null,{"$f":"L13*M13","v":0}]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[]
["2.-","COSTOS FIJOS QUE NO VARIAN SEGÚN LA CANTIDAD A PRODUCIR",null,null,null,{"$f":"F20+F26","v":3.979166666666667},{"$f":"F19/F33","v":0.16156709203402941},null,"4.-","GASTOS FIJOS QUE NO VARIAN SEGÚN LA CANTIDAD A VENDER",null,null,null,{"$f":"N20+N26","v":2},{"$f":"N19/N33","v":1}]
[null,2.1,"Personal",null,null,{"$f":"SUM(F21:F25)","v":0},{"$f":"F20/F33","v":0},null,null,4.0999999999999996,"Personal",null,null,{"$f":"SUM(N21:N25)","v":0},{"$f":"N20/N33","v":0}]
[null,null,null,null,null,{"$f":"D21*E21","v":0},null,null,null,null,null,null,null,{"$f":"L21*M21","v":0}]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,2.2000000000000002,"Otros",null,null,{"$f":"SUM(F27:F31)","v":3.979166666666667},{"$f":"F26/F33","v":0.16156709203402941},null,null,4.2,"Otros",null,null,{"$f":"SUM(N27:N31)","v":2},{"$f":"N26/N33","v":1}]
[null,null,"Electricidad - Mes",1,1,1,null,null,null,null,"Electricidad - Mes",1,1,{"$f":"L27*M27","v":1}]
[null,null,"Agua - Mes",1,1,1,null,null,null,null,"Agua - Mes",1,1,1]
[null,null,"Desgaste licuadora - Mes",1,{"$f":"((150/4)*0.1)/12","v":0.3125},0.3125,null,null,null,null,null,null,null,0]
[null,null,"Desgaste refrigeradora - Mes",1,{"$f":"((800/4)*0.1)/12","v":1.6666666666666667},1.6666666666666667,null,null,null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[]
[null,null,"COSTO TOTAL DE PRODUCCIÓN",null,null,{"$f":"F19+F4","v":24.628571428571426},1,null,null,null,"GASTO TOTAL",null,null,{"$f":"N19+N4","v":2},1]
[null,null,"UNIDADES PRODUCIDAS",null,null,20,null,null,null,null,"UNIDADES VENDIDAS",null,null,{"$f":"F34","v":20}]
[null,null,"COSTO POR UNIDAD",null,null,{"$f":"IFERROR(F33/F34,0)","v":1.2314285714285713},null,null,null,null,"GASTO POR UNIDAD",null,null,{"$f":"IFERROR(N33/N34,0)","v":0.1}]
[]
[]
[null,null,null,null,null,null,null,null,"RESUMEN"]
["ELABORADO POR"]
["WWW.ARCHIVOEXCEL.COM",null,null,null,null,null,null,null,null,null,"COSTO POR UNIDAD",null,null,{"$f":"F35","v":1.2314285714285713},{"$f":"N40/N44","v":0.61527480371163457}]
["Lima - Perú",null,null,null,null,null,null,null,null,null,"GASTO POR UNIDAD",null,null,{"$f":"N35","v":0.1},{"$f":"N41/N44","v":4.9964311206281233E-2}]
["Copyright©  2023",null,null,null,null,null,null,null,null,null,"TOTAL COSTO Y GASTO POR UNIDAD",null,null,{"$f":"SUM(N40:N41)","v":1.3314285714285714},{"$f":"N42/N44","v":0.66523911491791576}]
["ARCHIVO EXCEL E.I.R.L.",null,null,null,null,null,null,null,null,null,"GANANCIA",null,null,0.67,{"$f":"N43/N44","v":0.33476088508208424}]
[null,null,null,null,null,null,null,null,null,null,"PRECIO VENTA PÚBLICO",null,null,{"$f":"SUM(N42:N43)","v":2.0014285714285713},1]
[]
[null,null,null,null,null,null,null,null,null,null,"TOTAL VENTAS",null,null,{"$f":"F34*N44","v":40.028571428571425},1]
[null,null,null,null,null,null,null,null,null,null,"TOTAL COSTOS Y GASTOS",null,null,{"$f":"F34*N42","v":26.628571428571426},{"$f":"N47/N46","v":0.66523911491791576}]
[null,null,null,null,null,null,null,null,null,null,"TOTAL GANACIA",null,null,{"$f":"N46-N47","v":13.399999999999999},{"$f":"N48/N46","v":0.33476088508208424}]