{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["r","EOQ","Descuento","EOQ Bal","ss","Cobertura"],"not_rendered":{"charts":0,"images":15,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"r","index":0,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Cuánto cuesta tener inventario????"]
[null,null,null,"C&G",null,"WACC","TOTAL %"]
["Inventario promedio:",2000000,null,{"$f":"SUM(D6:D24)","v":543460},{"$f":"D3/B3","v":0.27173000000000003},0.115,{"$f":"F3+E3","v":0.38673000000000002}]
[null,null,null,null,null,null,{"$f":"G3*B3","v":773460}]
["Costos y Gastos:",null,"Mensual","Anual"]
["Alquiler de bodega (m2)",2000,{"$f":"7.5*B6","v":15000},{"$f":"C6*12","v":180000}]
["Racks",2500,{"$f":"D7/12","v":1458.3333333333333},{"$f":"70*B7/10","v":17500}]
["Equipo de manejo de materiales",null,{"$f":"D8/12","v":1596.6666666666667},{"$f":"(25000+70000+800)/5","v":19160}]
["Electricidad",null,1000,{"$f":"C9*12","v":12000}]
["Plagas",null,400,4800]
["Vigilancia",null,5000,60000]
["Salarios (incluye cargas)",10,{"$f":"B12*900","v":9000},108000]
["Back office",null,1500,18000]
["Servicios públicos",null,300,3600]
["Software",null,{"$f":"D15/12","v":666.66666666666663},{"$f":"40000/5","v":8000}]
["Equipo móvil",6,{"$f":"D16/12","v":133.33333333333334},{"$f":"B16*800/3","v":1600}]
["Materiales",null,2000,{"$f":"C17*12","v":24000}]
["Seguros del inventario",2.0000000000000001E-4,{"$f":"B18*B3","v":400},{"$f":"C18*12","v":4800}]
["Obsolescencia",0.01,{"$f":"D19/12","v":1666.6666666666667},{"$f":"B19*B3","v":20000}]
["Mermas",5.0000000000000001E-3,{"$f":"D20/12","v":833.33333333333337},{"$f":"B3*B20","v":10000}]
["Faltantes",0.02,3333.3333333333335,{"$f":"B3*B21","v":40000}]
["Mantenimientos",null,500,{"$f":"C22*12","v":6000}]
["Uniformes",null,200,{"$f":"C23*12","v":2400}]
["Subsidio",null,300,{"$f":"C24*12","v":3600}]

{"sheet":"EOQ","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Demanda anual",10000,null,"Cantidad de compra","Costo anual de pedir","Costo anual de tener","Costo total"]
["Costo unitario",10,null,1000,{"$f":"$B$1/D2*$B$3","v":5000},{"$f":"D2/2*$B$2*$B$4","v":2000},{"$f":"E2+F2","v":7000}]
["Costo de pedido",500,null,{"$f":"B6","v":1581.1388300841897},{"$f":"$B$1/D3*$B$3","v":3162.277660168379},{"$f":"D3/2*$B$2*$B$4","v":3162.27766016838},{"$f":"E3+F3","v":6324.555320336759}]
["Tasa anual por tener inventario",0.4,null,2000,{"$f":"$B$1/D4*$B$3","v":2500},{"$f":"D4/2*$B$2*$B$4","v":4000},{"$f":"E4+F4","v":6500}]
[null,null,null,3000,1666.6666666666667,6000,7666.666666666667]
["EOQ",{"$f":"SQRT((2*B3*B1)/(B2*B4))","v":1581.1388300841897},null,4000,1250,8000,9250]
[null,null,null,5000,1000,10000,11000]

{"sheet":"Descuento","index":2,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Demanda (Consumo) anual",75000]
["Costo pedido",20,null,"Paso 1","EOQ con descuento",{"$f":"SQRT((2*B2*B1)/(B7*B3))","v":6666.6666666666661},"No sirve"]
["Costo tenencia",0.15]
[]
["Límite",10000,null,null,null,null,"CA_Pedir","CA_tener","CA_Compra","CA_total"]
["Precio 1",0.5,null,"Paso 2","EOQ sin descuento",{"$f":"SQRT((2*B2*B1)/(B6*B3))","v":6324.555320336759},{"$f":"$B$1/F6*$B$2","v":237.17082451262843},{"$f":"F6/2*$B$6*$B$3","v":237.17082451262846},{"$f":"$B$1*B6","v":37500},{"$f":"SUM(G6:I6)","v":37974.341649025257}]
["Precio 2",0.45,null,null,"Límite",10000,{"$f":"$B$1/F7*$B$2","v":150},{"$f":"F7/2*$B$6*$B$3","v":375},{"$f":"$B$1*B7","v":33750},{"$f":"SUM(G7:I7)","v":34275}]

{"sheet":"EOQ Bal","index":3,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Mes",1,2,3,4,5,6,7,8,9,10,11,12,"Total anual"]
["Pronósticos de demanda",335,264,294,304,426,136,310,362,447,208,285,485,{"$f":"SUM(B2:M2)","v":3856}]
[]
["Costo de Pedido",290]
["Tasa de tenencia de inventario (mensual)",0.02,{"$f":"B5*12","v":0.24}]
["Costo unitario",10]
[]
["EOQ",{"$f":"SQRT((2*B4*N2)/(B6*B5*12))","v":965.33241252258097}]
["Cobertura EOQ",{"$f":"B8/N2*12","v":3.0041465119997333}]
[]
["Ejemplo con opción B:",1,2,3,4,5,6,7,8,9,10,11,12,"Total anual"]
["Inventario Inicial",0,{"$f":"B15","v":558},{"$f":"C15","v":294},0,562,136,0,809,447,0,770,485]
["Pronóstico",{"$f":"B2","v":335},{"$f":"C2","v":264},294,304,426,136,310,362,447,208,285,485,{"$f":"SUM(B13:M13)","v":3856}]
["Pedido",{"$f":"SUM(B13:D13)","v":893},null,null,{"$f":"SUM(E13:G13)","v":866},null,null,{"$f":"SUM(H13:J13)","v":1119},null,null,{"$f":"SUM(K13:M13)","v":978},null,null,{"$f":"SUM(B14:M14)","v":3856}]
["Inventario Final",{"$f":"B12+B14-B13","v":558},{"$f":"C12+C14-C13","v":294},0,562,136,0,809,447,0,770,485,0,{"$f":"SUM(B15:M15)","v":4061}]
[]
["Costo pedido",{"$f":"COUNTIF(B14:M14,\">0\")*B4","v":1160}]
["Costo de Inv",{"$f":"N15*B6*B5","v":812.2}]
["Total",{"$f":"B17+B18","v":1972.2}]

{"sheet":"ss","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
["Pronóstico",209,138,135,146,96,208,164,125,97,193,157,178]
[]
["Nivel de servicio",0.9,null,null,"MAD",25]
["Factor de seguridad",{"$f":"_xlfn.NORM.S.INV(B4)","v":1.2815515655446006}]
["Error de pronóstico",{"$f":"1.25*F4","v":31.25}]
["Tiempo L",3,null,null,"Q",{"$f":"SUM(B2:D2)","v":482},"comprar para 3 meses"]
["Desv basada en L",{"$f":"SQRT(B7)*B6","v":54.126587736527412}]
["Stock de seguridad",{"$f":"B5*B8","v":69.366013251333882},{"$f":"B9*B13","v":69366.013251333876}]
[]
["Punto de reorden",{"$f":"AVERAGE(B2:M2)*B7+B9","v":530.86601325133392}]
[]
["Costo unitario",1000]

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