logística plantilla abc multicriterio

13
artículo impacto anual costo unita itai 1 2 126 16 2 3 130 47 3 2 116 9 4 2 64 49 5 1 94 40 6 3 86 43 7 1 24 66 8 2 50 69 9 3 47 5 10 2 119 61 11 1 94 71 12 3 36 56 13 0 94 22 14 0 59 45 15 0 28 80 16 3 23 7 17 2 63 56 18 3 76 80 19 1 127 6 20 2 71 12 21 0 113 31 22 0 49 8 23 1 129 33 24 0 92 34 25 2 127 37 26 1 92 79 27 3 125 20 28 2 94 9 29 3 125 67 30 1 80 78 31 2 62 28 32 3 34 8 33 2 81 39 34 2 92 12 35 0 78 19 36 3 30 50 37 1 109 52 38 0 51 26 39 1 32 66 40 3 101 59 41 2 73 4 42 0 76 31

Upload: omarandrecastillogarcia

Post on 05-Jan-2016

220 views

Category:

Documents


0 download

DESCRIPTION

una plantilla muy útil para la aplicación del método ABC multicriterio

TRANSCRIPT

Page 1: Logística Plantilla ABC Multicriterio

artículo impacto anual costo unitari itai itai%1 1 96 192 3 47 723 3 120 44 3 91 505 3 64 796 3 102 247 0 66 578 3 30 119 2 74 72

10 0 98 4111 1 86 7912 1 92 6313 1 86 6714 2 113 6215 1 22 2116 3 42 6617 0 22 3618 2 108 1719 1 75 3920 0 59 1921 0 89 6322 3 106 5923 2 117 2424 3 86 325 2 111 3126 0 117 6327 2 42 1728 1 126 1329 1 51 1430 2 60 6731 1 114 7632 3 127 3033 3 16 1334 2 17 3935 2 27 6136 3 95 2737 0 38 4338 3 43 1639 3 48 6340 2 76 5541 3 87 7442 2 99 5243 1 39 7844 2 30 2845 2 46 55

Page 2: Logística Plantilla ABC Multicriterio

46 3 15 2147 0 124 248 2 79 3349 3 82 4250 3 104 2051 2 113 2552 3 112 4153 2 48 4954 3 97 1555 0 87 1056 1 123 6557 1 40 8058 1 77 1159 0 82 260 1 118 3861 1 44 3862 3 48 4463 2 89 3064 0 42 1065 1 27 2766 1 103 3267 2 89 468 3 31 5969 1 95 4870 1 129 3771 2 92 5272 3 105 7173 1 40 2474 0 35 675 3 39 6476 2 19 1277 1 104 3378 2 115 3879 1 127 6880 3 52 6781 2 61 1982 2 84 4183 2 47 2784 0 127 1985 3 121 3186 1 23 3087 2 31 1788 0 91 3989 1 86 390 3 29 2891 0 16 3292 3 122 1093 0 71 41

Page 3: Logística Plantilla ABC Multicriterio

94 2 57 2795 1 118 1496 0 24 3697 3 127 7998 2 87 6399 2 55 52

100 3 116 73

Page 4: Logística Plantilla ABC Multicriterio

tabla 1artículo impacto anual costo unitari itai itai%

1 0 39 57 2223 0.780687552 2 73 64 4672 1.640743253 0 33 53 1749 0.614225164 3 81 28 2268 0.796490945 2 87 40 3480 1.222128966 2 91 62 5642 1.981394147 1 92 35 3220 1.130820488 1 102 78 7956 2.794039669 1 129 73 9417 3.30712312

10 3 36 36 1296 0.4551376811 1 126 26 3276 1.1504869212 3 62 40 2480 0.8709424813 0 62 39 2418 0.8491689214 3 120 68 8160 2.8656817115 3 35 28 980 0.3441627516 2 116 25 2900 1.018440817 3 16 60 960 0.3371390218 2 54 68 3672 1.2895567719 2 106 47 4982 1.7496110620 2 26 4 104 0.0365233921 0 116 6 696 0.2444257922 2 24 64 1536 0.5394224423 3 77 53 4081 1.4331920424 3 34 74 2516 0.8835851925 1 71 20 1420 0.4986848126 1 128 24 3072 1.0788448827 3 41 66 2706 0.9503106228 2 77 34 2618 0.9194062129 2 54 69 3726 1.3085208430 1 59 17 1003 0.3522400431 1 47 65 3055 1.0728747132 3 101 3 303 0.106409533 3 24 9 216 0.0758562834 2 64 38 2432 0.8540855335 0 45 60 2700 0.9482035136 1 99 79 7821 2.7466294937 3 110 25 2750 0.9657628338 0 14 10 140 0.0491661139 1 64 63 4032 1.415983940 3 35 4 140 0.0491661141 0 96 23 2208 0.7754197642 3 28 30 840 0.2949966543 3 94 41 3854 1.3534727144 1 17 48 816 0.2865681745 2 83 19 1577 0.5538210846 1 114 26 2964 1.04091674

Page 5: Logística Plantilla ABC Multicriterio

47 0 29 63 1827 0.6416177148 0 40 47 1880 0.6602305949 1 121 48 5808 2.039691150 1 117 70 8190 2.876217351 2 125 28 3500 1.2291526952 3 23 7 161 0.0565410253 3 24 37 888 0.311853654 1 83 16 1328 0.4663756555 1 115 20 2300 0.8077289156 2 18 55 990 0.3476746257 2 24 68 1632 0.5731363458 0 115 5 575 0.2019322359 0 44 51 2244 0.7880624760 2 29 65 1885 0.6619865261 3 125 45 5625 1.9754239762 3 61 75 4575 1.6066781663 3 34 46 1564 0.5492556664 1 103 38 3914 1.374543965 3 110 49 5390 1.8928951566 3 89 25 2225 0.7813899367 2 40 77 3080 1.0816543768 0 107 34 3638 1.2776164369 0 101 23 2323 0.815806270 1 84 63 5292 1.8584788771 1 102 63 6426 2.2567243472 1 107 34 3638 1.2776164373 0 74 4 296 0.103951274 2 80 20 1600 0.5618983775 2 108 51 5508 1.9343351576 3 59 35 2065 0.7252000977 0 44 31 1364 0.4790183678 3 46 5 230 0.0807728979 2 42 44 1848 0.6489926280 2 37 54 1998 0.7016705981 2 115 44 5060 1.7770036182 1 107 68 7276 2.5552328583 0 24 8 192 0.067427884 0 77 26 2002 0.7030753485 1 117 15 1755 0.6163322886 1 124 17 2108 0.7403011187 1 64 72 4608 1.6182673288 0 67 4 268 0.0941179889 2 60 33 1980 0.6953492490 0 85 56 4760 1.6716476691 2 80 9 720 0.2528542792 2 111 7 777 0.272871993 3 68 54 3672 1.2895567794 3 67 67 4489 1.57647612

Page 6: Logística Plantilla ABC Multicriterio

95 2 112 48 5376 1.8879785496 2 34 23 782 0.2746278397 3 27 31 837 0.2939430998 1 53 60 3180 1.1167730299 2 103 37 3811 1.33837169

100 0 78 54 4212 1.47919747284749

Page 7: Logística Plantilla ABC Multicriterio

tabla2 11,12artículo impacto itai% itai%acum criterio

9 1 3.30712312 3.30712312 1 1 si50 1 2.8762173 6.18334042 1 1 si14 3 2.86568171 9.04902212 1 3 FALSE

8 1 2.79403966 11.8430618 1 1 si36 1 2.74662949 14.5896913 1 1 si82 1 2.55523285 17.1449241 1 1 si71 1 2.25672434 19.4016485 1 1 si49 1 2.0396911 21.4413396 1 1 si

6 2 1.98139414 23.4227337 1 2 si61 3 1.97542397 25.3981577 1 3 FALSE75 2 1.93433515 27.3324928 1 2 si65 3 1.89289515 29.225388 1 3 FALSE95 2 1.88797854 31.1133665 1 2 si70 1 1.85847887 32.9718454 1 1 si81 2 1.77700361 34.748849 1 2 si19 2 1.74961106 36.49846 1 2 si90 0 1.67164766 38.1701077 1 0 FALSE

2 2 1.64074325 39.810851 1 2 si87 1 1.61826732 41.4291183 1 1 si62 3 1.60667816 43.0357964 1 3 FALSE94 3 1.57647612 44.6122726 1 3 FALSE

100 0 1.47919747 46.09147 1 0 FALSE23 3 1.43319204 47.5246621 1 3 FALSE39 1 1.4159839 48.940646 1 1 si64 1 1.3745439 50.3151899 1 1 si43 3 1.35347271 51.6686626 1 3 FALSE99 2 1.33837169 53.0070343 1 2 si29 2 1.30852084 54.3155551 1 2 si18 2 1.28955677 55.6051119 1 2 si93 3 1.28955677 56.8946686 1 3 FALSE68 0 1.27761643 58.1722851 1 0 FALSE72 1 1.27761643 59.4499015 1 1 si51 2 1.22915269 60.6790542 1 2 si

5 2 1.22212896 61.9011831 1 2 si11 1 1.15048692 63.0516701 1 1 si

7 1 1.13082048 64.1824905 1 1 si98 1 1.11677302 65.2992636 1 1 si67 2 1.08165437 66.3809179 1 2 si26 1 1.07884488 67.4597628 1 1 si31 1 1.07287471 68.5326375 1 1 si46 1 1.04091674 69.5735543 1 1 si16 2 1.0184408 70.5919951 1 2 si37 3 0.96576283 71.5577579 1 3 FALSE27 3 0.95031062 72.5080685 1 3 FALSE35 0 0.94820351 73.456272 1 0 FALSE28 2 0.91940621 74.3756782 1 2 si

Page 8: Logística Plantilla ABC Multicriterio

24 3 0.88358519 75.2592634 1 3 FALSE12 3 0.87094248 76.1302059 1 3 FALSE34 2 0.85408553 76.9842914 1 2 si13 0 0.84916892 77.8334603 1 0 FALSE69 0 0.8158062 78.6492665 1 0 FALSE55 1 0.80772891 79.4569955 1 1 si

4 3 0.79649094 80.2534864 2 3 FALSE59 0 0.78806247 81.0415489 2 0 FALSE66 3 0.78138993 81.8229388 2 3 FALSE

1 0 0.78068755 82.6036264 2 0 FALSE41 0 0.77541976 83.3790461 2 0 FALSE86 1 0.74030111 84.1193472 2 1 si76 3 0.72520009 84.8445473 2 3 084 0 0.70307534 85.5476226 2 0 FALSE80 2 0.70167059 86.2492932 2 2 FALSE89 2 0.69534924 86.9446425 2 2 060 2 0.66198652 87.606629 2 2 FALSE48 0 0.66023059 88.2668596 2 0 FALSE79 2 0.64899262 88.9158522 2 2 FALSE47 0 0.64161771 89.5574699 2 0 FALSE85 1 0.61633228 90.1738022 2 1 si

3 0 0.61422516 90.7880274 2 0 FALSE57 2 0.57313634 91.3611637 2 2 FALSE74 2 0.56189837 91.9230621 2 2 FALSE45 2 0.55382108 92.4768831 2 2 FALSE63 3 0.54925566 93.0261388 2 3 FALSE22 2 0.53942244 93.5655612 2 2 FALSE25 1 0.49868481 94.0642461 2 1 si77 0 0.47901836 94.5432644 2 0 FALSE54 1 0.46637565 95.0096401 3 1 FALSE10 3 0.45513768 95.4647778 3 3 FALSE30 1 0.35224004 95.8170178 3 1 FALSE56 2 0.34767462 96.1646924 3 2 FALSE15 3 0.34416275 96.5088552 3 3 FALSE17 3 0.33713902 96.8459942 3 3 FALSE53 3 0.3118536 97.1578478 3 3 FALSE42 3 0.29499665 97.4528444 3 3 FALSE97 3 0.29394309 97.7467875 3 3 FALSE44 1 0.28656817 98.0333557 3 1 FALSE96 2 0.27462783 98.3079835 3 2 FALSE92 2 0.2728719 98.5808554 3 2 FALSE91 2 0.25285427 98.8337097 3 2 FALSE21 0 0.24442579 99.0781355 3 0 FALSE58 0 0.20193223 99.2800677 3 0 FALSE32 3 0.1064095 99.3864772 3 3 FALSE73 0 0.1039512 99.4904284 3 0 FALSE88 0 0.09411798 99.5845464 3 0 FALSE78 3 0.08077289 99.6653193 3 3 FALSE

Page 9: Logística Plantilla ABC Multicriterio

33 3 0.07585628 99.7411756 3 3 FALSE83 0 0.0674278 99.8086034 3 0 FALSE52 3 0.05654102 99.8651444 3 3 FALSE38 0 0.04916611 99.9143105 3 0 FALSE40 3 0.04916611 99.9634766 3 3 FALSE20 2 0.03652339 100 3 2 FALSE

37

Page 10: Logística Plantilla ABC Multicriterio

13,21,22,23,31 32,33 1 2 3

0 FALSEFALSE FALSE

si FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSE

si FALSEFALSE FALSE

si FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSE

si FALSEFALSE FALSEFALSE FALSE

si FALSEsi FALSEsi FALSEsi FALSE

FALSE FALSEFALSE FALSE

si FALSEFALSE FALSEFALSE FALSEFALSE FALSE

si FALSEsi FALSE

FALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSEFALSE FALSE

si FALSEsi FALSEsi FALSE

FALSE FALSE

Page 11: Logística Plantilla ABC Multicriterio

si FALSEsi FALSE

FALSE FALSEsi FALSEsi FALSE

FALSE FALSEFALSE si

si FALSEFALSE si

si FALSEsi FALSE

FALSE FALSEFALSE si

si FALSEsi FALSEsi FALSEsi FALSEsi FALSEsi FALSEsi FALSE

FALSE FALSEsi FALSEsi FALSEsi FALSEsi FALSE

FALSE sisi FALSE

FALSE FALSEsi FALSEsi FALSE

FALSE sisi FALSE

FALSE siFALSE siFALSE siFALSE siFALSE siFALSE si

si FALSEFALSE siFALSE siFALSE si

si FALSEsi FALSE

FALSE sisi FALSEsi FALSE

FALSE si

Page 12: Logística Plantilla ABC Multicriterio

FALSE sisi FALSE

FALSE sisi FALSE

FALSE siFALSE si

43 20