{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["r","ABC"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"r","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Valor del inventario",250000000]
[]
[]
[null,"Cuánto cuesta tener inventario guardado?","Costo / gasto mensual",null,null,null,null,null,null,null,null,null,"Cuánto cuesta tener faltantes de inventario?"]
[null,"Personal",{"$f":"6*500000*1.4","v":4200000},null,null,null,null,null,null,null,null,null,"Costo unitario:",9000]
[null,"Espacio físico",{"$f":"5000*200","v":1000000},null,null,null,null,null,null,null,null,null,"Probabilidad de que falte:",0.5]
[null,"Sistemas de información",{"$f":"250000","v":250000},"WMS",null,null,null,null,null,null,null,null,"Unidades:",10000]
[null,"Equipo de cómputo",50000]
[null,"Servicios básicos: luz, agua, etc.",500000,null,null,null,null,null,null,null,null,null,null,{"$f":"N6*N7*N8","v":45000000}]
[null,"Limpieza",800000]
[null,"Vencimientos",{"$f":"0.03*$C$2/12","v":625000}]
[null,"Pierden",{"$f":"0.01*$C$2/12","v":208333.33333333334}]
[null,"Mermas o daños",{"$f":"0.02*$C$2/12","v":416666.66666666669}]
[null,"Seguros",{"$f":"1.5%*C2/12","v":312500}]
[null,"Papelería",100000]
[]
[null,"Costos y gastos operación:",{"$f":"SUM(C6:C16)","v":8462500},{"$f":"C18*12","v":101550000}]
[]
[null,"Costo de la plata (Costo de capital)",{"$f":"4%*C2/12","v":833333.33333333337},{"$f":"C20*12","v":10000000}]
[]
[null,"Total",null,{"$f":"SUM(D18:D20)","v":111550000}]
[null,"Total / Valor de Inventario",null,{"$f":"D22/C2","v":0.44619999999999999},"Tasa de tener inventario"]

{"sheet":"ABC","index":1,"n_rows":102,"n_cols":5,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["Skus","Consumo","Proporción","% Acumulado","ABC"]
[100,100000,{"$f":"B2/$B$102","v":0.11993801603331398},{"$f":"C2","v":0.11993801603331398},{"$f":"IF(D2<=80%, \"A\", IF(D2<=95%,\"B\",\"C\"))","v":"A"}]
[94,90000,{"$f":"B3/$B$102","v":0.10794421442998259},{"$f":"D2+C3","v":0.22788223046329659},{"$f":"IF(D3<=80%, \"A\", IF(D3<=95%,\"B\",\"C\"))","v":"A"}]
[6,80000,{"$f":"B4/$B$102","v":9.5950412826651191E-2},{"$f":"D3+C4","v":0.32383264328994776},"A"]
[9,60000,{"$f":"B5/$B$102","v":7.1962809619988397E-2},0.39579545290993617,"A"]
[8,60000,{"$f":"B6/$B$102","v":7.1962809619988397E-2},0.46775826252992458,"A"]
[7,60000,{"$f":"B7/$B$102","v":7.1962809619988397E-2},0.53972107214991294,"A"]
[66,60000,{"$f":"B8/$B$102","v":7.1962809619988397E-2},0.61168388176990129,"A"]
[93,60000,{"$f":"B9/$B$102","v":7.1962809619988397E-2},0.68364669138988965,"A"]
[38,60000,{"$f":"B10/$B$102","v":7.1962809619988397E-2},0.755609501009878,"A"]
[54,4933,{"$f":"B11/$B$102","v":5.9165423309233784E-3},0.76152604334080143,"A"]
[90,4864,{"$f":"B12/$B$102","v":5.8337850998603918E-3},0.76735982844066186,"A"]
[22,4700,{"$f":"B13/$B$102","v":5.637086753565757E-3},0.77299691519422764,"A"]
[18,4697,{"$f":"B14/$B$102","v":5.6334886130847582E-3},0.77863040380731241,"A"]
[80,4483,{"$f":"B15/$B$102","v":5.3768212587734657E-3},0.78400722506608589,"A"]
[97,4474,{"$f":"B16/$B$102","v":5.3660268373304674E-3},0.78937325190341634,"A"]
[55,4348,{"$f":"B17/$B$102","v":5.2149049371284922E-3},0.79458815684054485,"A"]
[33,4229,{"$f":"B18/$B$102","v":5.072178698048848E-3},0.79966033553859373,"A"]
[84,4197,{"$f":"B19/$B$102","v":5.0337985329181878E-3},0.80469413407151191,"B"]
[47,4196,{"$f":"B20/$B$102","v":5.0325991527578546E-3},0.8097267332242698,"B"]
[23,4183,{"$f":"B21/$B$102","v":5.0170072106735242E-3},0.81474374043494335,"B"]
[95,4148,{"$f":"B22/$B$102","v":4.9750289050618643E-3},0.8197187693400052,"B"]
[48,4141,{"$f":"B23/$B$102","v":4.9666332439395324E-3},0.82468540258394474,"B"]
[32,4138,{"$f":"B24/$B$102","v":4.9630351034585327E-3},0.82964843768740326,"B"]
[67,4130,{"$f":"B25/$B$102","v":4.9534400621758677E-3},0.83460187774957917,"B"]
[30,4034,{"$f":"B26/$B$102","v":4.8382995667838862E-3},0.839440177316363,"B"]
[73,4003,{"$f":"B27/$B$102","v":4.8011187818135584E-3},0.84424129609817655,"B"]
[46,3994,{"$f":"B28/$B$102","v":4.7903243603705601E-3},0.84903162045854708,"B"]
[16,3982,{"$f":"B29/$B$102","v":4.775931798446563E-3},0.85380755225699367,"B"]
[40,3971,{"$f":"B30/$B$102","v":4.7627386166828982E-3},0.85857029087367653,"B"]
[82,3904,{"$f":"B31/$B$102","v":4.6823801459405781E-3},0.86325267101961711,"B"]
[59,3828,{"$f":"B32/$B$102","v":4.5912272537552597E-3},0.86784389827337238,"B"]
[36,3594,{"$f":"B33/$B$102","v":4.3105722962373041E-3},0.87215447056960971,"B"]
[57,3470,{"$f":"B34/$B$102","v":4.1618491563559954E-3},0.87631631972596569,"B"]
[45,3441,{"$f":"B35/$B$102","v":4.1270671317063341E-3},0.88044338685767198,"B"]
[52,3377,{"$f":"B36/$B$102","v":4.0503068014450128E-3},0.88449369365911701,"B"]
[56,3348,{"$f":"B37/$B$102","v":4.0155247767953524E-3},0.88850921843591235,"B"]
[60,3280,{"$f":"B38/$B$102","v":3.933966925892699E-3},0.892443185361805,"B"]
[63,3260,{"$f":"B39/$B$102","v":3.9099793226860359E-3},0.896353164684491,"B"]
[86,3198,{"$f":"B40/$B$102","v":3.8356177527453812E-3},0.90018878243723643,"B"]
[51,3114,{"$f":"B41/$B$102","v":3.7348698192773973E-3},0.90392365225651383,"B"]
[35,3044,{"$f":"B42/$B$102","v":3.6509132080540779E-3},0.90757456546456794,"B"]
[13,3009,{"$f":"B43/$B$102","v":3.6089349024424179E-3},0.91118350036701035,"B"]
[77,2933,{"$f":"B44/$B$102","v":3.5177820102570991E-3},0.91470128237726744,"B"]
[11,2801,{"$f":"B45/$B$102","v":3.3594638290931245E-3},0.91806074620636058,"B"]
[72,2681,{"$f":"B46/$B$102","v":3.2155382098531479E-3},0.92127628441621368,"B"]
[91,2679,{"$f":"B47/$B$102","v":3.2131394495324818E-3},0.92448942386574617,"B"]
[31,2648,{"$f":"B48/$B$102","v":3.1759586645621544E-3},0.92766538253030828,"B"]
[61,2556,{"$f":"B49/$B$102","v":3.0656156898115055E-3},0.93073099822011973,"B"]
[28,2547,{"$f":"B50/$B$102","v":3.0548212683685072E-3},0.93378581948848827,"B"]
[98,2516,{"$f":"B51/$B$102","v":3.0176404833981798E-3},0.93680345997188641,"B"]
[78,2419,{"$f":"B52/$B$102","v":2.9013006078458651E-3},0.93970476057973229,"B"]
[42,2405,{"$f":"B53/$B$102","v":2.8845092856012015E-3},0.94258926986533353,"B"]
[26,2399,{"$f":"B54/$B$102","v":2.8773130046392025E-3},0.94546658286997276,"B"]
[29,2356,{"$f":"B55/$B$102","v":2.8257396577448775E-3},0.94829232252771767,"B"]
[49,2282,{"$f":"B56/$B$102","v":2.7369855258802252E-3},0.95102930805359787,"C"]
[14,2231,{"$f":"B57/$B$102","v":2.6758171377032351E-3},0.95370512519130113,"C"]
[53,2189,{"$f":"B58/$B$102","v":2.625443170969243E-3},0.95633056836227037,"C"]
[27,2187,{"$f":"B59/$B$102","v":2.6230444106485769E-3},0.95895361277291891,"C"]
[5,2000,{"$f":"B60/$B$102","v":2.3987603206662798E-3},0.96135237309358523,"C"]
[64,1902,{"$f":"B61/$B$102","v":2.2812210649536318E-3},0.96363359415853889,"C"]
[41,1717,{"$f":"B62/$B$102","v":2.0593357352920011E-3},0.96569292989383093,"C"]
[62,1715,{"$f":"B63/$B$102","v":2.0569369749713347E-3},0.96774986686880227,"C"]
[43,1703,{"$f":"B64/$B$102","v":2.0425444130473371E-3},0.96979241128184956,"C"]
[79,1645,{"$f":"B65/$B$102","v":1.9729803637480148E-3},0.97176539164559761,"C"]
[34,1576,{"$f":"B66/$B$102","v":1.8902231326850284E-3},0.97365561477828266,"C"]
[92,1546,{"$f":"B67/$B$102","v":1.8542417278750341E-3},0.97550985650615774,{"$f":"IF(D67<=80%, \"A\", IF(D67<=95%,\"B\",\"C\"))","v":"C"}]
[65,1494,{"$f":"B68/$B$102","v":1.7918739595377108E-3},{"$f":"D67+C68","v":0.97730173046569546},"C"]
[12,1303,{"$f":"B69/$B$102","v":1.5627923489140811E-3},0.97886452281460956,"C"]
[75,1240,{"$f":"B70/$B$102","v":1.4872313988130933E-3},0.98035175421342269,"C"]
[39,1214,{"$f":"B71/$B$102","v":1.4560475146444317E-3},0.98180780172806714,"C"]
[70,1200,{"$f":"B72/$B$102","v":1.4392561923997679E-3},0.98324705792046696,"C"]
[19,1177,{"$f":"B73/$B$102","v":1.4116704487121055E-3},0.98465872836917911,"C"]
[68,1068,{"$f":"B74/$B$102","v":1.2809380112357932E-3},0.98593966638041486,"C"]
[20,1061,{"$f":"B75/$B$102","v":1.2725423501134614E-3},0.98721220873052828,"C"]
[4,1000,{"$f":"B76/$B$102","v":1.1993801603331399E-3},0.98841158889086145,"C"]
[15,992,{"$f":"B77/$B$102","v":1.1897851190504746E-3},0.98960137400991188,"C"]
[21,968,{"$f":"B78/$B$102","v":1.1609999952024793E-3},0.99076237400511435,"C"]
[71,747,{"$f":"B79/$B$102","v":8.9593697976885541E-4},0.99165831098488322,"C"]
[50,609,{"$f":"B80/$B$102","v":7.3042251764288211E-4},0.9923887335025261,"C"]
[58,609,{"$f":"B81/$B$102","v":7.3042251764288211E-4},0.99311915602016898,"C"]
[25,603,{"$f":"B82/$B$102","v":7.2322623668088332E-4},0.99384238225684984,"C"]
[44,532,{"$f":"B83/$B$102","v":6.3807024529723036E-4},0.99448045250214712,"C"]
[17,529,{"$f":"B84/$B$102","v":6.3447210481623096E-4},0.99511492460696338,"C"]
[24,509,{"$f":"B85/$B$102","v":6.1048450160956812E-4},0.99572540910857299,"C"]
[87,487,{"$f":"B86/$B$102","v":5.8409813808223913E-4},0.99630950724665523,"C"]
[83,482,{"$f":"B87/$B$102","v":5.7810123728057336E-4},0.99688760848393576,"C"]
[76,458,{"$f":"B88/$B$102","v":5.49316113432578E-4},0.99743692459736832,"C"]
[69,392,{"$f":"B89/$B$102","v":4.701570228505908E-4},0.99790708162021891,"C"]
[96,332,{"$f":"B90/$B$102","v":3.9819421323060244E-4},0.99830527583344952,"C"]
[10,300,{"$f":"B91/$B$102","v":3.5981404809994197E-4},0.99866508988154945,"C"]
[99,297,{"$f":"B92/$B$102","v":3.5621590761894252E-4},0.99902130578916837,"C"]
[37,274,{"$f":"B93/$B$102","v":3.2863016393128034E-4},0.99934993595309962,"C"]
[88,193,{"$f":"B94/$B$102","v":2.3148037094429598E-4},0.99958141632404396,"C"]
[81,121,{"$f":"B95/$B$102","v":1.4512499940030991E-4},0.9997265413234443,"C"]
[3,100,{"$f":"B96/$B$102","v":1.1993801603331399E-4},0.99984647933947757,"C"]
[74,87,{"$f":"B97/$B$102","v":1.0434607394898316E-4},0.9999508254134265,"C"]
[2,20,{"$f":"B98/$B$102","v":2.3987603206662797E-5},0.99997481301663316,"C"]
[89,10,{"$f":"B99/$B$102","v":1.1993801603331399E-5},0.99998680681823648,"C"]
[85,6,{"$f":"B100/$B$102","v":7.1962809619988389E-6},0.9999940030991985,"C"]
[1,5,{"$f":"B101/$B$102","v":5.9969008016656993E-6},1.0000000000000002,"C"]
[null,{"$f":"SUM(B2:B101)","v":833764},"TOTAL"]