{"text_format":"2","workbook":"xls","n_sheets":12,"sheets":["1.1","1.2","1.3","1.4","1.5","1.6","1.7","1.8","1.9","1.10","1.11","1.12"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":1,"defined_names":304,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"1.1","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"A","B","unidades"]
["a producir",0,0,"u/semana"]
["estampado",6,16,"seg/u"]
["soldado",12,6,"seg/u"]
["pintado",9,9,"seg/u"]
["beneficio",4,3,"$/u"]
[]
[]
[]
["Beneficio",0,"$/semana"]
[]
[null,"tiempo insumido","Disponibilidad","unidades"]
["Estampado",0,48000,"seg/semana"]
["Soldado",0,42000,"seg/semana"]
["Pintado",0,36000,"seg/semana"]

{"sheet":"1.2","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"A","B","unidades"]
["a armar",0,0,"cajas"]
["licor",300,400,"g"]
["nuez",500,200,"g"]
["fruta",200,400,"g"]
["beneficio",120,90,"$/caja"]
[]
[]
[]
["Beneficio",0]
[]
[]
["Restricciones A"]
[null,"gr. Consumidos","Disponibilidad","unidades"]
["licor",0,100000,"gr"]
["nuez",0,120000,"gr"]
["fruta",0,100000,"gr"]
[]
[]
["Restricciones B"]
["Mínimo A",50]
["r",3]
[]
[]
[]
["B-r*A",0]
["A",0,50]

{"sheet":"1.3","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"A","B","unidades"]
["a comprar",2.4,0.8,"kg/saco"]
["arena fina",4,3,"u/kg"]
["arrena gruesa",3,6,"u/kg"]
["piedrecilla",5,2,"u/kg"]
["beneficio",60,100,"$/u"]
[]
[]
[]
["Costo",224,"$/saco"]
[]
[null,"contenido","req minimo","unidades"]
["arena fina",12,12,"u/saco"]
["arrena gruesa",12,12,"u/saco"]
["piedrecilla",13.6,10,"u/saco"]

{"sheet":"1.4","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"M","N","unidades"]
["a suministrar",4,9,"kg/día"]
["contenido A",0.1,0,"kg/kg"]
["contenido B",0,0.1,"kg/kg"]
["contenido C",0.1,0.2,"kg/kg"]
["contenido D",0.2,0.1,"kg/kg"]
["costo",10,4,"$/día"]
[]
[]
[]
["Costo",76,"$/día"]
[]
[null,"consumido","requerido","unidades"]
["A",0.4,0.4,"kg/día"]
["B",0.9,0.6,"kg/día"]
["C",2.2,2,"kg/día"]
["D",1.7000000000000002,1.7,"kg/día"]

{"sheet":"1.5","index":4,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"P1","P2","P3","P4","P5","P6","P7","unidades"]
["a suministrar",9,0.9999999999999925,16,1.000000051420249,1,0,10,"u"]
["V1",5,0,2,0,3,1,2,"u/u"]
["V2",3,1,5,0,2,0,1,"u/u"]
["V3",1,0,3,1,2,0,6,"u/u"]
["costo",4,1,5,0.6,3.5,0.7,4,"$/u"]
[]
[]
[]
["Costo",161.10000003085213]
[]
[null,"consumido","requerido","unidades"]
["A",100,100,"u"]
["B",120,120,"u"]
["C",120.00000005142024,120,"u"]
["D",120.00000005142024,160,"u"]

{"sheet":"1.6","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"X12","X23","X34","X45","X56","X61","unidades"]
["a contratar",10,10,10,10,3,2,"personas"]
[]
[]
[]
["Personal total",45,"personas"]
[]
["turno","personal","requerido","unidades"]
[1,12,7,"personas"]
[2,20,20,"personas"]
[3,20,14,"personas"]
[4,20,20,"personas"]
[5,13,10,"personas"]
[6,5,5,"personas"]

{"sheet":"1.7","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"A","BI","BII","C","unidades"]
["a fabricar",0,13,4,16,"u/sem"]
["HMI",5,6,null,null,"h/u"]
["HMII",null,null,4,4,"h/u"]
["MP M",1.6,null,null,1.2,"kg/u"]
["MP N",null,1.8,1.8,null,"kg/u"]
["beneficio",50,70,70,80,"$/u"]
[]
[]
[]
["Beneficio",2470,"$/sem"]
[]
[null,"utilizado","Disponible","unidades"]
["HMI",78,80,"h/sem"]
["HMII",80,80,"h/sem"]
["MP M",19.2,20,"kg/sem"]
["MP N",30.6,36,"kg/sem"]
[]
[null,"producción B","mínimo","unidades"]
["distribuidor",17,10,"u/sem"]

{"sheet":"1.8","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Whisky","E","K","T"]
["Licor",null,2544.4444445318964,3155.5555552057504,2.623537034540486e-07,"costo licor","disponibilidad"]
["A",2000,1526.6666667191375,473.3333332808625,0,7,2000]
[" B ",2500,1017.7777778127588,1482.2222220544252,1.328163406503699e-07,5,2500]
["C",1199.9999999999998,0,1199.9999998704625,1.295373628036787e-07,4,1200]
[null,"precio Wkisky",6.8,5.7,4.5]
[]
[]
[]
["Beneficio",null,3988.8888886702625]
[]
[null,"%","límite"]
["EA",0.5999999999999999,0.6,"mínimo"]
["EC",0,0.2,"máximo"]
["KA",0.15,0.15,"mínimo"]
["KC",0.3802816901419501,0.6,"máximo"]
["TC",0.4937508451309788,0.5,"máximo"]

{"sheet":"1.9","index":8,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8]],"flags":["formulas_cached_only"]}
[null,"a producir",null,null,null,"a comprar"]
[null,"A","B","C","D","A","B","C","D","unidades"]
["total",3999.9999995000003,3000,8000,0,4.999999418942025e-07,0,0,5000,"u"]
["estampado",3,3,3,3,{"$nulls":4},"m/u"]
["armado",6,7,8,11,{"$nulls":4},"m/u"]
["cableado",12,15,18,15,{"$nulls":4},"m/u"]
["ajuste",5,6,3,6,{"$nulls":4},"m/u"]
["calidad",1,2,2,2,1.8,3,"2.5","2.5","m/u"]
["costo",500,600,1200,1000,800,750,1800,800,"$/u"]
[]
[]
[]
["Costo",17400000.00015]
[]
[null,"Insumido","Disponible","unidades"]
["estampado",749.999999975,1200,"h "]
["armado",1816.6666666166668,3600,"h "]
["cableado",3949.9999999,5000,"h "]
["ajuste",1148.148148101852,3000,"h "]
["calidad",481.4814814909722,3000,"h "]
[]
[null,"producido","Requerido","unidades"]
["A",4000,4000,"u"]
["B",3000,3000,"u"]
["C",8000,8000,"u"]
["D",5000,5000,"u"]

{"sheet":"1.10","index":9,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"I","II","III","IV","Total","Disponible"]
[null,0,10.000000000000057,990,0,1000,1000]
["R50",2,0,1,1]
["R30",0,3,1,0]
["R20",0,0,1,2]
["beneficio",4,4.5,4.5,4]
[]
[]
[]
["Beneficio",4500]
[]
[null,"Obtenidos","Mìnimo","Beneficio"]
["R50",990,950,2]
["R30",1020.0000000000002,1000,1.5]
["R20",990,960,1]

{"sheet":"1.11","index":10,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Fábrica","Capacidad (u)","Costo",1,2,3,4,"A producir"]
[1,140,60,0,0,0,140,140]
[2,260,72,0,160,100,0,260]
[3,360,48,180,120,0,60,360]
[4,220,60,0,0,50,0,50]
[null,null,null,180,280,150,200]
[]
["Costo",78880]
[]
["Costos"]
["Fábrica",1,2,3,4]
[1,28,40,36,38]
[2,18,28,24,30]
[3,42,54,52,54]
[4,36,48,40,46]
["Requrimientos",180,280,150,200]

{"sheet":"1.12","index":11,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,1]],"flags":["formulas_cached_only"]}
["Compañía","Contrato?","Pago $","M2"]
["A",0,100,17]
["B",1,75,15]
["C ",0,115,20]
["D",1,50,15]
["E",1,135,20]
["Total",null,260,50]
[null,null,"Max",50]