0% encontró este documento útil (0 votos)
53 vistas66 páginas

Análisis de Costos y Demanda de Inventario

Este documento presenta datos de demanda, probabilidades de demanda y un modelo de inventario de revisión periódica con múltiples períodos. Incluye tablas con inventario inicial, demanda, ventas e inventario final para cada período, así como costos de inventario, faltantes y pedidos acumulados.
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
53 vistas66 páginas

Análisis de Costos y Demanda de Inventario

Este documento presenta datos de demanda, probabilidades de demanda y un modelo de inventario de revisión periódica con múltiples períodos. Incluye tablas con inventario inicial, demanda, ventas e inventario final para cada período, así como costos de inventario, faltantes y pedidos acumulados.
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

Datos

Demanda Probabilidad P. Acumulada Límite Inferior Límite Superior


125 0.25 0.25 0 0.25
110 0.45 0.7 0.25 0.7
130 0.22 0.92 0.7 0.92
105 0.08 1 0.92 1
1

Costo de Pedido: S 500 Dolares/pedido


Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 6 días
Capacidad del Almacen 600 kg
Costo de Inventario Unif(3;5) Dólares
0.84394257682 130

Día Inventario Demanda Venta Inventario


Inicial Real Final

1 600 105 105 495


2 495 105 105 390
3 390 110 110 280
4 280 105 105 175
5 175 125 125 50
6 50 130 50 0
7 600 110 110 490
8 490 105 105 385
9 385 130 130 255
10 255 110 110 145
11 145 125 125 20
12 20 110 20 0
13 600 130 130 470
14 470 110 110 360
15 360 130 130 230
16 230 110 110 120
17 120 125 120 0
18 0 110 0 0
19 600 130 130 470
20 470 110 110 360
21 360 110 110 250
22 250 130 130 120
23 120 105 105 15
24 15 110 15 0
25 600 110 110 490
26 490 130 130 360
27 360 130 130 230
28 230 110 110 120
29 120 105 105 15
30 15 110 15 0
31 600 125 125 475
32 475 125 125 350
33 350 110 110 240
34 240 125 125 115
35 115 110 110 5
36 5 105 5 0
37 600 105 105 495
38 495 110 110 385
39 385 110 110 275
40 275 125 125 150
41 150 110 110 40
42 40 110 40 0
43 600 110 110 490
44 490 110 110 380
45 380 110 110 270
46 270 130 130 140
47 140 125 125 15
48 15 130 15 0
49 600 105 105 495
50 495 125 125 370
51 370 110 110 260
52 260 125 125 135
53 135 125 125 10
54 10 110 10 0
55 600 110 110 490
56 490 105 105 385
57 385 125 125 260
58 260 110 110 150
59 150 125 125 25
60 25 110 25 0
61 600 110 110 490
62 490 110 110 380
63 380 130 130 250
64 250 125 125 125
65 125 125 125 0
66 0 110 0 0
67 600 130 130 470
68 470 130 130 340
69 340 110 110 230
70 230 125 125 105
71 105 110 105 0
72 0 125 0 0
73 600 130 130 470
74 470 110 110 360
75 360 125 125 235
76 235 110 110 125
77 125 110 110 15
78 15 110 15 0
79 600 110 110 490
80 490 110 110 380
81 380 130 130 250
82 250 110 110 140
83 140 110 110 30
84 30 125 30 0
85 600 130 130 470
86 470 125 125 345
87 345 110 110 235
88 235 105 105 130
89 130 110 110 20
90 20 130 20 0
91 600 130 130 470
92 470 125 125 345
93 345 125 125 220
94 220 125 125 95
95 95 125 95 0
96 0 110 0 0
97 600 110 110 490
98 490 110 110 380
99 380 130 130 250
100 250 110 110 140
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 547.5 4.28108041 2343.89152 0 0
2 0 0 442.5 4.26102464 1885.50341 0 0
3 0 0 335 3.88837894 1302.60695 0 0
4 0 0 227.5 3.50551378 797.504385 0 0
5 0 0 112.5 3.45693998 388.905747 0 0
0 600 80 25 4.37023509 109.255877 400 500
1 0 0 545 3.94137521 2148.04949 0 0
2 0 0 437.5 4.84792449 2120.96696 0 0
3 0 0 320 4.69459997 1502.27199 0 0
4 0 0 200 4.07442575 814.88515 0 0
5 0 0 82.5 4.61091667 380.400625 0 0
0 600 90 10 4.20204289 42.0204289 450 500
1 0 0 535 4.28039803 2290.01294 0 0
2 0 0 415 3.19954967 1327.81311 0 0
3 0 0 295 3.03289986 894.705458 0 0
4 0 0 175 3.37724669 591.01817 0 0
5 0 5 60 3.06097383 183.65843 25 0
0 600 110 0 3.2227497 0 550 500
1 0 0 535 4.47846733 2395.98002 0 0
2 0 0 415 3.37822122 1401.96181 0 0
3 0 0 305 4.35601497 1328.58456 0 0
4 0 0 185 4.19649769 776.352073 0 0
5 0 0 67.5 4.09730014 276.567759 0 0
0 600 95 7.5 4.53496001 34.0122001 475 500
1 0 0 545 3.99436194 2176.92726 0 0
2 0 0 425 4.5483073 1933.0306 0 0
3 0 0 295 3.48292485 1027.46283 0 0
4 0 0 175 3.21035629 561.81235 0 0
5 0 0 67.5 3.81193527 257.305631 0 0
0 600 95 7.5 4.41647307 33.123548 475 500
1 0 0 537.5 4.2803734 2300.7007 0 0
2 0 0 412.5 3.82266333 1576.84862 0 0
3 0 0 295 4.13182401 1218.88808 0 0
4 0 0 177.5 4.98760123 885.299219 0 0
5 0 0 60 4.07991375 244.794825 0 0
0 600 100 2.5 3.96646639 9.91616597 500 500
1 0 0 547.5 3.53714781 1936.58843 0 0
2 0 0 440 3.29489231 1449.75262 0 0
3 0 0 330 4.70598278 1552.97432 0 0
4 0 0 212.5 3.70321052 786.932236 0 0
5 0 0 95 4.09455878 388.983084 0 0
0 600 70 20 3.88688364 77.7376729 350 500
1 0 0 545 4.24875994 2315.57417 0 0
2 0 0 435 4.26884358 1856.94696 0 0
3 0 0 325 4.54393427 1476.77864 0 0
4 0 0 205 3.67741454 753.86998 0 0
5 0 0 77.5 3.54317307 274.595913 0 0
0 600 115 7.5 3.78155799 28.3616849 575 500
1 0 0 547.5 3.09192002 1692.82621 0 0
2 0 0 432.5 4.50507691 1948.44576 0 0
3 0 0 315 4.8471817 1526.86224 0 0
4 0 0 197.5 3.5393879 699.02911 0 0
5 0 0 72.5 4.27785935 310.144803 0 0
0 600 100 5 3.47394297 17.3697148 500 500
1 0 0 545 3.56034033 1940.38548 0 0
2 0 0 437.5 4.22823468 1849.85267 0 0
3 0 0 322.5 3.54194087 1142.27593 0 0
4 0 0 205 3.25922929 668.142004 0 0
5 0 0 87.5 3.80665214 333.082063 0 0
0 600 85 12.5 3.02118824 37.764853 425 500
1 0 0 545 3.13565019 1708.92936 0 0
2 0 0 435 4.92112566 2140.68966 0 0
3 0 0 315 4.81661076 1517.23239 0 0
4 0 0 187.5 4.9602955 930.055407 0 0
5 0 0 62.5 3.47681001 217.300625 0 0
0 600 110 0 4.14874206 0 550 500
1 0 0 535 4.44375529 2377.40908 0 0
2 0 0 405 3.48786935 1412.58709 0 0
3 0 0 285 3.86650416 1101.95369 0 0
4 0 0 167.5 4.24107416 710.379922 0 0
5 0 5 52.5 4.89154383 256.806051 25 0
0 600 125 0 3.61549283 0 625 500
1 0 0 535 4.87359201 2607.37172 0 0
2 0 0 415 4.80157935 1992.65543 0 0
3 0 0 297.5 4.28346263 1274.33013 0 0
4 0 0 180 3.34220458 601.596824 0 0
5 0 0 70 4.50366851 315.256796 0 0
0 600 95 7.5 4.37019846 32.7764884 475 500
1 0 0 545 4.53004752 2468.8759 0 0
2 0 0 435 3.9629067 1723.86442 0 0
3 0 0 315 3.88221109 1222.89649 0 0
4 0 0 195 4.57163545 891.468913 0 0
5 0 0 85 4.03596736 343.057226 0 0
0 600 95 15 3.12832972 46.9249458 475 500
1 0 0 535 3.64630245 1950.77181 0 0
2 0 0 407.5 3.54751825 1445.61369 0 0
3 0 0 290 4.995572 1448.71588 0 0
4 0 0 182.5 4.16314445 759.773862 0 0
5 0 0 75 4.97795015 373.346261 0 0
0 600 110 10 3.91929106 39.1929106 550 500
1 0 0 535 4.80575714 2571.08007 0 0
2 0 0 407.5 4.43760608 1808.32448 0 0
3 0 0 282.5 3.49059636 986.093471 0 0
4 0 0 157.5 3.70002386 582.753757 0 0
5 0 30 47.5 3.55662448 168.939663 150 0
0 600 110 0 3.38426594 0 550 500
1 0 0 545 3.74563494 2041.37104 0 0
2 0 0 435 4.96576014 2160.10566 0 0
3 0 0 315 4.82523308 1519.94842 0 0
4 0 0 195 4.9229681 959.978779 0 0
Inventario
Final
6610tán7a5661

6610tán25a5661

6610tán14a5661

6610tán3a5661

6600tán21a5660

6600tán10a5660

6600tán28a5660
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 8

Costo Total

2343.9 Costo Promedio 1234.6


1885.5 Inventario Promedio 262.05
1302.6 Total de Faltantes Promedio 16.25
797.5 Total de Pedidos 16
388.9
1009.3 Costo Total 188578.077 160525.961 135597.262
2148.0 123463.7 3 4 5
2121.0 1 188578.077 160525.961 135597.262
1502.3 2 188578.077 160525.961 135597.262
814.9 3 188578.077 160525.961 135597.262
380.4 4 188578.077 160525.961 135597.262
992.0 5 188578.077 160525.961 135597.262
2290.0 6 188578.077 160525.961 135597.262
1327.8 7 188578.077 160525.961 135597.262
894.7 8 188578.077 160525.961 135597.262
591.0 9 188578.077 160525.961 135597.262
208.7 10 188578.077 160525.961 135597.262
1050.0 11 188578.077 160525.961 135597.262
2396.0 12 188578.077 160525.961 135597.262
1402.0 13 188578.077 160525.961 135597.262
1328.6 14 188578.077 160525.961 135597.262
776.4 15 188578.077 160525.961 135597.262
276.6 16 188578.077 160525.961 135597.262
1009.0 17 188578.077 160525.961 135597.262
2176.9 18 188578.077 160525.961 135597.262
1933.0 19 188578.077 160525.961 135597.262
1027.5 20 188578.077 160525.961 135597.262
561.8
257.3
1008.1
2300.7
1576.8
1218.9
885.3
244.8
1009.9
1936.6
1449.8
1553.0
786.9
389.0
927.7
2315.6
1856.9
1476.8
753.9
274.6
1103.4
1692.8
1948.4
1526.9
699.0
310.1
1017.4
1940.4
1849.9
1142.3
668.1
333.1
962.8
1708.9
2140.7
1517.2
930.1
217.3
1050.0
2377.4
1412.6
1102.0
710.4
281.8
1125.0
2607.4
1992.7
1274.3
601.6
315.3
1007.8
2468.9
1723.9
1222.9
891.5
343.1
1021.9
1950.8
1445.6
1448.7
759.8
373.3
1089.2
2571.1
1808.3
986.1
582.8
318.9
1050.0
2041.4
2160.1
1519.9
960.0
entario
Final

6 41 46 51 56 61 66 71 76 81 86 91 96 101

123463.744 115268.458 107938.812


6 7 8
123463.744 115268.458 107938.812 Costo Total T
123463.744 115268.458 107938.812 186764.919 3
123463.744 115268.458 107938.812 159292.001 4
123463.744 115268.458 107938.812 132738.541 5
123463.744 115268.458 107938.812 120750.533 6
123463.744 115268.458 107938.812 112537.971 7
123463.744 115268.458 107938.812 106468.338 8
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
123463.744 115268.458 107938.812
T
6600tán8a5660

6600tán7a5660

6600tán6a5660

6600tán5a5660

6600tán4a5660

6600tán3a5660

6600tán2a5660

6600tán1a5660

6600tán29a5660

6600tán28a5660
9340tán8a5934 700tán11a6070 2070tán16a6207
Datos

Demanda Probabilidad P. Acumulada Límite Inferior Límite Superior


125 0.25 0.25 0 0.25
110 0.45 0.7 0.25 0.7
130 0.22 0.92 0.7 0.92
105 0.08 1 0.92 1
1

Costo de Pedido: S 500 Dolares/pedido


Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 6 días
Capacidad del Almacen 600 kg
Costo de Inventario Unif(3;5) Dólares
0.21206971461 125

Día Inventario Demanda Venta Inventario


Inicial Real Final

1 600 110 110 490


2 490 130 130 360
3 360 110 110 250
4 250 125 125 125
5 125 110 110 15
6 15 130 15 0
7 600 110 110 490
8 490 110 110 380
9 380 130 130 250
10 250 130 130 120
11 120 125 120 0
12 0 130 0 0
13 600 110 110 490
14 490 105 105 385
15 385 125 125 260
16 260 105 105 155
17 155 130 130 25
18 25 110 25 0
19 600 130 130 470
20 470 125 125 345
21 345 125 125 220
22 220 110 110 110
23 110 130 110 0
24 0 110 0 0
25 600 110 110 490
26 490 130 130 360
27 360 110 110 250
28 250 110 110 140
29 140 125 125 15
30 15 110 15 0
31 600 130 130 470
32 470 125 125 345
33 345 110 110 235
34 235 110 110 125
35 125 130 125 0
36 0 110 0 0
37 600 105 105 495
38 495 105 105 390
39 390 125 125 265
40 265 125 125 140
41 140 125 125 15
42 15 110 15 0
43 600 130 130 470
44 470 125 125 345
45 345 105 105 240
46 240 125 125 115
47 115 110 110 5
48 5 125 5 0
49 600 110 110 490
50 490 110 110 380
51 380 125 125 255
52 255 125 125 130
53 130 130 130 0
54 0 110 0 0
55 600 125 125 475
56 475 125 125 350
57 350 110 110 240
58 240 110 110 130
59 130 125 125 5
60 5 110 5 0
61 600 130 130 470
62 470 125 125 345
63 345 125 125 220
64 220 110 110 110
65 110 125 110 0
66 0 130 0 0
67 600 130 130 470
68 470 110 110 360
69 360 110 110 250
70 250 110 110 140
71 140 105 105 35
72 35 110 35 0
73 600 125 125 475
74 475 110 110 365
75 365 110 110 255
76 255 125 125 130
77 130 125 125 5
78 5 130 5 0
79 600 130 130 470
80 470 125 125 345
81 345 110 110 235
82 235 110 110 125
83 125 110 110 15
84 15 110 15 0
85 600 130 130 470
86 470 125 125 345
87 345 110 110 235
88 235 110 110 125
89 125 110 110 15
90 15 125 15 0
91 600 110 110 490
92 490 110 110 380
93 380 110 110 270
94 270 110 110 160
95 160 110 110 50
96 50 125 50 0
97 600 125 125 475
98 475 110 110 365
99 365 125 125 240
100 240 110 110 130
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 545 3.74487652 2040.9577 0 0
2 0 0 425 3.8523056 1637.22988 0 0
3 0 0 305 4.87970969 1488.31146 0 0
4 0 0 187.5 3.23101707 605.8157 0 0
5 0 0 70 3.3165004 232.155028 0 0
0 600 115 7.5 3.73155071 27.9866303 575 500
1 0 0 545 4.22125129 2300.58195 0 0
2 0 0 435 3.50929776 1526.54452 0 0
3 0 0 315 3.61373637 1138.32696 0 0
4 0 0 185 4.70183469 869.839417 0 0
5 0 5 60 4.06614707 243.968824 25 0
0 600 130 0 3.05471424 0 650 500
1 0 0 545 3.03151548 1652.17594 0 0
2 0 0 437.5 4.71290834 2061.8974 0 0
3 0 0 322.5 3.3076041 1066.70232 0 0
4 0 0 207.5 4.58955754 952.33319 0 0
5 0 0 90 4.76188102 428.569291 0 0
0 600 85 12.5 3.1579836 39.474795 425 500
1 0 0 535 3.62471196 1939.2209 0 0
2 0 0 407.5 3.83238404 1561.6965 0 0
3 0 0 282.5 3.84106209 1085.10004 0 0
4 0 0 165 4.89810112 808.186685 0 0
5 0 20 55 3.73160991 205.238545 100 0
0 600 110 0 3.60749042 0 550 500
1 0 0 545 4.02465856 2193.43891 0 0
2 0 0 425 3.56413113 1514.75573 0 0
3 0 0 305 3.17916381 969.644963 0 0
4 0 0 195 3.94746964 769.75658 0 0
5 0 0 77.5 3.23162763 250.451141 0 0
0 600 95 7.5 3.77783472 28.3337604 475 500
1 0 0 535 3.03301844 1622.66487 0 0
2 0 0 407.5 3.92404802 1599.04957 0 0
3 0 0 290 4.41123093 1279.25697 0 0
4 0 0 180 4.3240253 778.324554 0 0
5 0 5 62.5 4.65104483 290.690302 25 0
0 600 110 0 4.84090768 0 550 500
1 0 0 547.5 4.8377571 2648.67201 0 0
2 0 0 442.5 4.25793492 1884.1362 0 0
3 0 0 327.5 3.42702436 1122.35048 0 0
4 0 0 202.5 3.51032451 710.840714 0 0
5 0 0 77.5 4.56745465 353.977735 0 0
0 600 95 7.5 3.51176748 26.3382561 475 500
1 0 0 535 3.32716981 1780.03585 0 0
2 0 0 407.5 3.60155565 1467.63393 0 0
3 0 0 292.5 4.83748917 1414.96558 0 0
4 0 0 177.5 4.42693831 785.78155 0 0
5 0 0 60 4.29409421 257.645653 0 0
0 600 120 2.5 4.06671353 10.1667838 600 500
1 0 0 545 3.84796245 2097.13954 0 0
2 0 0 435 4.57130425 1988.51735 0 0
3 0 0 317.5 3.08983742 981.023381 0 0
4 0 0 192.5 3.82949179 737.177169 0 0
5 0 0 65 4.08794833 265.716642 0 0
0 600 110 0 4.43609976 0 550 500
1 0 0 537.5 4.61481913 2480.46528 0 0
2 0 0 412.5 4.12398745 1701.14482 0 0
3 0 0 295 3.00629793 886.85789 0 0
4 0 0 185 3.33270589 616.550589 0 0
5 0 0 67.5 4.06543082 274.41658 0 0
0 600 105 2.5 3.08273401 7.70683501 525 500
1 0 0 535 4.77549388 2554.88922 0 0
2 0 0 407.5 3.70092574 1508.12724 0 0
3 0 0 282.5 4.17389588 1179.12559 0 0
4 0 0 165 4.00485852 660.801655 0 0
5 0 15 55 3.85901143 212.245629 75 0
0 600 130 0 3.93227809 0 650 500
1 0 0 535 4.10599652 2196.70814 0 0
2 0 0 415 3.10980011 1290.56704 0 0
3 0 0 305 4.5949524 1401.46048 0 0
4 0 0 195 4.0075412 781.470533 0 0
5 0 0 87.5 4.26781515 373.433825 0 0
0 600 75 17.5 3.5799465 62.6490637 375 500
1 0 0 537.5 4.87662273 2621.18472 0 0
2 0 0 420 3.31977402 1394.30509 0 0
3 0 0 310 3.65143914 1131.94613 0 0
4 0 0 192.5 4.59170908 883.903999 0 0
5 0 0 67.5 3.11548512 210.295246 0 0
0 600 125 2.5 4.13311936 10.3327984 625 500
1 0 0 535 4.64941946 2487.43941 0 0
2 0 0 407.5 3.55264766 1447.70392 0 0
3 0 0 290 3.92158633 1137.26004 0 0
4 0 0 180 4.65847895 838.526211 0 0
5 0 0 70 3.87177582 271.024307 0 0
0 600 95 7.5 4.55038824 34.1279118 475 500
1 0 0 535 4.83378069 2586.07267 0 0
2 0 0 407.5 3.11460697 1269.20234 0 0
3 0 0 290 3.94252972 1143.33362 0 0
4 0 0 180 4.26039665 766.871397 0 0
5 0 0 70 4.01576316 281.103421 0 0
0 600 110 7.5 4.56260289 34.2195217 550 500
1 0 0 545 3.07614637 1676.49977 0 0
2 0 0 435 4.41682137 1921.3173 0 0
3 0 0 325 3.0100398 978.262935 0 0
4 0 0 215 4.88335655 1049.92166 0 0
5 0 0 105 3.97456606 417.329436 0 0
0 600 75 25 3.42868064 85.717016 375 500
1 0 0 537.5 4.1843958 2249.11274 0 0
2 0 0 420 4.05417358 1702.7529 0 0
3 0 0 302.5 3.44325239 1041.58385 0 0
4 0 0 185 3.00223606 555.413671 0 0
Inventario
Final
6610tán7a5661

6610tán25a5661

6610tán14a5661

6610tán3a5661

6600tán21a5660

6600tán10a5660

6600tán28a5660
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 8

Costo Total

2041.0 Costo Promedio 1188.1


1637.2 Inventario Promedio 259.1
1488.3 Total de Faltantes Promedio 17.3
605.8 Total de Pedidos 16
232.2
1103.0
2300.6
1526.5
1138.3
869.8
269.0
1150.0
1652.2
2061.9
1066.7
952.3
428.6
964.5
1939.2
1561.7
1085.1
808.2
305.2
1050.0
2193.4
1514.8
969.6
769.8
250.5
1003.3
1622.7
1599.0
1279.3
778.3
315.7
1050.0
2648.7
1884.1
1122.4
710.8
354.0
1001.3
1780.0
1467.6
1415.0
785.8
257.6
1110.2
2097.1
1988.5
981.0
737.2
265.7
1050.0
2480.5
1701.1
886.9
616.6
274.4
1032.7
2554.9
1508.1
1179.1
660.8
287.2
1150.0
2196.7
1290.6
1401.5
781.5
373.4
937.6
2621.2
1394.3
1131.9
883.9
210.3
1135.3
2487.4
1447.7
1137.3
838.5
271.0
1009.1
2586.1
1269.2
1143.3
766.9
281.1
1084.2
1676.5
1921.3
978.3
1049.9
417.3
960.7
2249.1
1702.8
1041.6
555.4
entario
Final

6 41 46 51 56 61 66 71 76 81 86 91 96 101
Demanda 100
Costo de Pedido: S 500 Dolares/pedido
Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 6 días
Capacidad del Almacen 600 kg
Costo de Inventario Unif(3;5) Dólares
0.57493582725 Err:504

Inventario Venta Inventario


Día Demanda
Inicial Real Final

1 600 259 259 341


2 341 144 144 197
3 197 158 158 39
4 39 63 39 0
5 0 6 0 0
6 0 46 0 0
7 600 48 48 552
8 552 166 166 386
9 386 41 41 345
10 345 166 166 179
11 179 130 130 49
12 49 85 49 0
13 600 20 20 580
14 580 98 98 482
15 482 76 76 406
16 406 183 183 223
17 223 377 223 0
18 0 36 0 0
19 600 4 4 596
20 596 62 62 534
21 534 17 17 517
22 517 249 249 268
23 268 116 116 152
24 152 29 29 123
25 600 54 54 546
26 546 20 20 526
27 526 9 9 517
28 517 49 49 468
29 468 15 15 453
30 453 31 31 422
31 600 143 143 457
32 457 12 12 445
33 445 85 85 360
34 360 151 151 209
35 209 46 46 163
36 163 3 3 160
37 600 183 183 417
38 417 13 13 404
39 404 101 101 303
40 303 23 23 280
41 280 47 47 233
42 233 94 94 139
43 600 64 64 536
44 536 6 6 530
45 530 241 241 289
46 289 98 98 191
47 191 44 44 147
48 147 61 61 86
49 600 6 6 594
50 594 42 42 552
51 552 111 111 441
52 441 140 140 301
53 301 26 26 275
54 275 68 68 207
55 600 14 14 586
56 586 45 45 541
57 541 127 127 414
58 414 3 3 411
59 411 10 10 401
60 401 18 18 383
61 600 141 141 459
62 459 183 183 276
63 276 59 59 217
64 217 274 217 0
65 0 116 0 0
66 0 156 0 0
67 600 8 8 592
68 592 65 65 527
69 527 275 275 252
70 252 95 95 157
71 157 152 152 5
72 5 6 5 0
73 600 111 111 489
74 489 18 18 471
75 471 106 106 365
76 365 38 38 327
77 327 18 18 309
78 309 224 224 85
79 600 77 77 523
80 523 28 28 495
81 495 35 35 460
82 460 35 35 425
83 425 38 38 387
84 387 19 19 368
85 600 32 32 568
86 568 53 53 515
87 515 33 33 482
88 482 17 17 465
89 465 79 79 386
90 386 160 160 226
91 600 161 161 439
92 439 11 11 428
93 428 0 0 428
94 428 119 119 309
95 309 112 112 197
96 197 12 12 185
97 600 10 10 590
98 590 26 26 564
99 564 45 45 519
100 519 32 32 487
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 470.5 3.85862607 1815.48357 0 0
2 0 0 269 4.12736144 1110.26023 0 0
3 0 0 118 4.92609749 581.279504 0 0
4 0 24 19.5 3.73199575 72.7739171 120 0
5 0 6 0 3.45276224 0 30 0
0 600 46 0 4.14537148 0 230 500
1 0 0 576 3.77850131 2176.41676 0 0
2 0 0 469 3.51587227 1648.94409 0 0
3 0 0 365.5 3.06539864 1120.4032 0 0
4 0 0 262 4.65958911 1220.81235 0 0
5 0 0 114 3.33425306 380.104849 0 0
0 600 36 24.5 3.51313995 86.0719288 180 500
1 0 0 590 4.7248147 2787.64067 0 0
2 0 0 531 4.47893108 2378.3124 0 0
3 0 0 444 3.06766933 1362.04518 0 0
4 0 0 314.5 4.85902302 1528.16274 0 0
5 0 154 111.5 3.53428326 394.072583 770 0
0 600 36 0 3.79247057 0 180 500
1 0 0 598 4.48730748 2683.40988 0 0
2 0 0 565 4.34223662 2453.36369 0 0
3 0 0 525.5 3.74462943 1967.80277 0 0
4 0 0 392.5 4.86127514 1908.05049 0 0
5 0 0 210 3.35065379 703.637295 0 0
0 477 0 137.5 3.67757754 505.666912 0 500
1 0 0 573 3.74583759 2146.36494 0 0
2 0 0 536 3.0432467 1631.18023 0 0
3 0 0 521.5 4.3958707 2292.44657 0 0
4 0 0 492.5 3.12639509 1539.74958 0 0
5 0 0 460.5 4.52722217 2084.78581 0 0
0 178 0 437.5 4.52585827 1980.06299 0 500
1 0 0 528.5 4.14337348 2189.77288 0 0
2 0 0 451 3.51560688 1585.5387 0 0
3 0 0 402.5 3.58642354 1443.53548 0 0
4 0 0 284.5 3.67663726 1046.0033 0 0
5 0 0 186 3.4952458 650.115719 0 0
0 440 0 161.5 4.3387995 700.716119 0 500
1 0 0 508.5 4.23944558 2155.75808 0 0
2 0 0 410.5 3.61685941 1484.72079 0 0
3 0 0 353.5 3.4993537 1237.02153 0 0
4 0 0 291.5 4.56180891 1329.7673 0 0
5 0 0 256.5 3.27109441 839.035717 0 0
0 461 0 186 3.11882448 580.101353 0 500
1 0 0 568 4.38638624 2491.46739 0 0
2 0 0 533 4.61825217 2461.52841 0 0
3 0 0 409.5 3.90212061 1597.91839 0 0
4 0 0 240 3.21038989 770.493573 0 0
5 0 0 169 3.61430316 610.817234 0 0
0 514 0 116.5 3.76271328 438.356097 0 500
1 0 0 597 3.4964846 2087.40131 0 0
2 0 0 573 3.69209024 2115.56771 0 0
3 0 0 496.5 3.25978001 1618.48078 0 0
4 0 0 371 4.73877037 1758.08381 0 0
5 0 0 288 4.45651923 1283.47754 0 0
0 393 0 241 3.42611089 825.692725 0 500
1 0 0 593 3.1518346 1869.03792 0 0
2 0 0 563.5 3.83543828 2161.26947 0 0
3 0 0 477.5 3.31185767 1581.41204 0 0
4 0 0 412.5 4.53659249 1871.3444 0 0
5 0 0 406 3.01498265 1224.08295 0 0
0 217 0 392 3.21875568 1261.75222 0 500
1 0 0 529.5 4.57067985 2420.17498 0 0
2 0 0 367.5 3.27448128 1203.37187 0 0
3 0 0 246.5 3.74668909 923.55886 0 0
4 0 57 108.5 3.43291809 372.471613 285 0
5 0 116 0 4.71330247 0 580 0
0 600 156 0 4.21804511 0 780 500
1 0 0 596 3.23549121 1928.35276 0 0
2 0 0 559.5 3.26647775 1827.5943 0 0
3 0 0 389.5 3.61331615 1407.38664 0 0
4 0 0 204.5 4.92566616 1007.29873 0 0
5 0 0 81 4.56387117 369.673565 0 0
0 600 1 2.5 3.84918242 9.62295604 5 500
1 0 0 544.5 4.42247129 2408.03562 0 0
2 0 0 480 3.74344329 1796.85278 0 0
3 0 0 418 3.01124278 1258.69948 0 0
4 0 0 346 3.65513736 1264.67753 0 0
5 0 0 318 3.07740286 978.61411 0 0
0 515 0 197 4.44627645 875.91646 0 500
1 0 0 561.5 4.90479088 2754.04008 0 0
2 0 0 509 3.04514557 1549.97909 0 0
3 0 0 477.5 3.59506717 1716.64457 0 0
4 0 0 442.5 3.33634055 1476.3307 0 0
5 0 0 406 4.78961275 1944.58278 0 0
0 232 0 377.5 4.19778678 1584.66451 0 500
1 0 0 584 4.80214815 2804.45452 0 0
2 0 0 541.5 4.76288013 2579.09959 0 0
3 0 0 498.5 3.22442985 1607.37828 0 0
4 0 0 473.5 4.17455919 1976.65378 0 0
5 0 0 425.5 4.62102748 1966.24719 0 0
0 374 0 306 3.53459958 1081.58747 0 500
1 0 0 519.5 4.44047374 2306.82611 0 0
2 0 0 433.5 4.44881725 1928.56228 0 0
3 0 0 428 4.2035445 1799.11705 0 0
4 0 0 368.5 4.44812382 1639.13363 0 0
5 0 0 253 4.82866898 1221.65325 0 0
0 415 0 191 3.15696714 602.980723 0 500
1 0 0 595 3.42215262 2036.18081 0 0
2 0 0 577 4.87538653 2813.09803 0 0
3 0 0 541.5 3.78831725 2051.37379 0 0
4 0 0 503 4.5333823 2280.29129 0 0
6620tán19a5662
Costo Total

6610tán7a5661
1815.5 Costo Promedio 1567.6
1110.3 Inventario Promedio 369.975
581.3 Total de Faltantes Promedio 6.32 6610tán25a5661
192.8 Total de Pedidos 16
30.0
6610tán14a5661
730.0
2176.4
1648.9 6610tán3a5661
1120.4
1220.8
6600tán21a5660
380.1
766.1
2787.6 6600tán10a5660
2378.3
1362.0
6600tán28a5660
1528.2 1 5 9 13 17 21 25
1164.1
680.0
2683.4
2453.4
1967.8
1908.1
703.6
1005.7
2146.4
1631.2
2292.4
1539.7
2084.8
2480.1
2189.8
1585.5
1443.5
1046.0
650.1
1200.7
2155.8
1484.7
1237.0
1329.8
839.0
1080.1
2491.5
2461.5
1597.9
770.5
610.8
938.4
2087.4
2115.6
1618.5
1758.1
1283.5
1325.7
1869.0
2161.3
1581.4
1871.3
1224.1
1761.8
2420.2
1203.4
923.6
657.5
580.0
1280.0
1928.4
1827.6
1407.4
1007.3
369.7
514.6
2408.0
1796.9
1258.7
1264.7
978.6
1375.9
2754.0
1550.0
1716.6
1476.3
1944.6
2084.7
2804.5
2579.1
1607.4
1976.7
1966.2
1581.6
2306.8
1928.6
1799.1
1639.1
1221.7
1103.0
2036.2
2813.1
2051.4
2280.3
Inventario
Final
án19a5662

tán7a5661

án25a5661

án14a5661

tán3a5661

án21a5660

án10a5660

án28a5660
1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89 93 97101
Datos

Demanda Probabilidad P. Acumulada Límite Inferior Límite Superior


125 0.25 0.25 0 0.25
110 0.45 0.7 0.25 0.7
130 0.22 0.92 0.7 0.92
105 0.08 1 0.92 1
1

Costo de Pedido: S 500 Dolares/pedido


Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 5 días
Capacidad del Almacen 600 kg
Costo de Inventario Unif(3;5) Dólares
0.78998206287 130

Día Inventario Demanda Venta Inventario


Inicial Real Final

1 600 110 110 490


2 490 130 130 360
3 360 110 110 250
4 250 125 125 125
5 125 125 125 0
6 600 110 110 490
7 490 105 105 385
8 385 110 110 275
9 275 110 110 165
10 165 125 125 40
11 600 110 110 490
12 490 110 110 380
13 380 110 110 270
14 270 125 125 145
15 145 130 130 15
16 600 110 110 490
17 490 130 130 360
18 360 110 110 250
19 250 125 125 125
20 125 130 125 0
21 600 105 105 495
22 495 125 125 370
23 370 130 130 240
24 240 125 125 115
25 115 110 110 5
26 600 105 105 495
27 495 130 130 365
28 365 110 110 255
29 255 130 130 125
30 125 110 110 15
31 600 125 125 475
32 475 110 110 365
33 365 110 110 255
34 255 125 125 130
35 130 130 130 0
36 600 125 125 475
37 475 125 125 350
38 350 130 130 220
39 220 105 105 115
40 115 125 115 0
41 600 110 110 490
42 490 105 105 385
43 385 110 110 275
44 275 110 110 165
45 165 125 125 40
46 600 110 110 490
47 490 110 110 380
48 380 110 110 270
49 270 130 130 140
50 140 110 110 30
51 600 110 110 490
52 490 110 110 380
53 380 125 125 255
54 255 125 125 130
55 130 110 110 20
56 600 110 110 490
57 490 105 105 385
58 385 125 125 260
59 260 110 110 150
60 150 110 110 40
61 600 110 110 490
62 490 110 110 380
63 380 130 130 250
64 250 110 110 140
65 140 110 110 30
66 600 110 110 490
67 490 130 130 360
68 360 110 110 250
69 250 110 110 140
70 140 110 110 30
71 600 110 110 490
72 490 125 125 365
73 365 110 110 255
74 255 110 110 145
75 145 110 110 35
76 600 130 130 470
77 470 110 110 360
78 360 130 130 230
79 230 110 110 120
80 120 130 120 0
81 600 125 125 475
82 475 110 110 365
83 365 130 130 235
84 235 110 110 125
85 125 130 125 0
86 600 125 125 475
87 475 130 130 345
88 345 125 125 220
89 220 130 130 90
90 90 125 90 0
91 600 110 110 490
92 490 125 125 365
93 365 110 110 255
94 255 110 110 145
95 145 110 110 35
96 600 130 130 470
97 470 110 110 360
98 360 110 110 250
99 250 125 125 125
100 125 110 110 15
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 545 4.91676107 2679.63478 0 0
2 0 0 425 4.4825757 1905.09467 0 0
3 0 0 305 4.72793481 1442.02012 0 0
4 0 0 187.5 3.63474161 681.514052 0 0
0 600 0 62.5 4.21175856 263.23491 0 500
1 0 0 545 4.11856177 2244.61617 0 0
2 0 0 437.5 3.42321894 1497.65828 0 0
3 0 0 330 3.54808161 1170.86693 0 0
4 0 0 220 3.59108831 790.039427 0 0
0 560 0 102.5 4.86315934 498.473832 0 500
1 0 0 545 4.27987093 2332.52966 0 0
2 0 0 435 4.01831046 1747.96505 0 0
3 0 0 325 3.33433209 1083.65793 0 0
4 0 0 207.5 4.75510772 986.684852 0 0
0 585 0 80 4.07103925 325.68314 0 500
1 0 0 545 3.14241351 1712.61537 0 0
2 0 0 425 4.1568445 1766.65891 0 0
3 0 0 305 3.78666445 1154.93266 0 0
4 0 0 187.5 4.08008007 765.015013 0 0
0 600 5 62.5 4.15727989 259.829993 25 500
1 0 0 547.5 3.72904677 2041.65311 0 0
2 0 0 432.5 3.32675117 1438.81988 0 0
3 0 0 305 4.76239523 1452.53054 0 0
4 0 0 177.5 3.71031762 658.581378 0 0
0 595 0 60 4.10633952 246.380371 0 500
1 0 0 547.5 4.98316877 2728.2849 0 0
2 0 0 430 4.1554966 1786.86354 0 0
3 0 0 310 4.43345264 1374.37032 0 0
4 0 0 190 4.13254578 785.183698 0 0
0 585 0 70 4.01113869 280.779708 0 500
1 0 0 537.5 4.70911625 2531.14998 0 0
2 0 0 420 3.8012525 1596.52605 0 0
3 0 0 310 4.69877847 1456.62132 0 0
4 0 0 192.5 3.51338868 676.327321 0 0
0 600 0 65 3.26349859 212.127409 0 500
1 0 0 537.5 3.65728454 1965.79044 0 0
2 0 0 412.5 3.6602741 1509.86306 0 0
3 0 0 285 3.68844263 1051.20615 0 0
4 0 0 167.5 4.9846349 834.926345 0 0
0 600 10 57.5 3.2590095 187.393046 50 500
1 0 0 545 3.32619822 1812.77803 0 0
2 0 0 437.5 3.54140381 1549.36417 0 0
3 0 0 330 3.04835095 1005.95581 0 0
4 0 0 220 3.04479752 669.855454 0 0
0 560 0 102.5 4.81953649 494.00249 0 500
1 0 0 545 4.59090302 2502.04215 0 0
2 0 0 435 3.63868391 1582.8275 0 0
3 0 0 325 3.4688466 1127.37514 0 0
4 0 0 205 4.96685411 1018.20509 0 0
0 570 0 85 3.04671084 258.970422 0 500
1 0 0 545 3.6673751 1998.71943 0 0
2 0 0 435 3.11799277 1356.32686 0 0
3 0 0 317.5 3.94106917 1251.28946 0 0
4 0 0 192.5 4.02788929 775.368689 0 0
0 580 0 75 4.04609013 303.45676 0 500
1 0 0 545 3.29699235 1796.86083 0 0
2 0 0 437.5 4.4582305 1950.47584 0 0
3 0 0 322.5 4.91226454 1584.20531 0 0
4 0 0 205 3.32581476 681.792025 0 0
0 560 0 95 4.62774083 439.635379 0 500
1 0 0 545 3.04360419 1658.76428 0 0
2 0 0 435 4.8454524 2107.77179 0 0
3 0 0 315 4.30561163 1356.26766 0 0
4 0 0 195 4.4853075 874.634962 0 0
0 570 0 85 4.38019191 372.316312 0 500
1 0 0 545 3.10614106 1692.84688 0 0
2 0 0 425 3.66663692 1558.32069 0 0
3 0 0 305 3.91206458 1193.1797 0 0
4 0 0 195 3.76869034 734.894617 0 0
0 570 0 85 3.89638879 331.193047 0 500
1 0 0 545 3.3797108 1841.94239 0 0
2 0 0 427.5 4.11390296 1758.69352 0 0
3 0 0 310 3.2837326 1017.95711 0 0
4 0 0 200 4.21842134 843.684268 0 0
0 565 0 90 4.99950594 449.955535 0 500
1 0 0 535 4.56161834 2440.46581 0 0
2 0 0 415 4.90415953 2035.2262 0 0
3 0 0 295 3.06994638 905.634181 0 0
4 0 0 175 3.37374673 590.405678 0 0
0 600 10 60 4.23182976 253.909786 50 500
1 0 0 537.5 4.48142326 2408.765 0 0
2 0 0 420 4.98278471 2092.76958 0 0
3 0 0 300 4.76397457 1429.19237 0 0
4 0 0 180 3.52031444 633.656598 0 0
0 600 5 62.5 3.56457948 222.786217 25 500
1 0 0 537.5 4.97449334 2673.79017 0 0
2 0 0 410 3.67137636 1505.26431 0 0
3 0 0 282.5 4.72244659 1334.09116 0 0
4 0 0 155 4.3991012 681.860686 0 0
0 600 35 45 3.52483165 158.617424 175 500
1 0 0 545 4.68538501 2553.53483 0 0
2 0 0 427.5 4.49035724 1919.62772 0 0
3 0 0 310 4.49243291 1392.6542 0 0
4 0 0 200 4.25833194 851.666389 0 0
0 565 0 90 4.78932687 431.039418 0 500
1 0 0 535 3.41120504 1824.9947 0 0
2 0 0 415 4.7721225 1980.43084 0 0
3 0 0 305 4.08616539 1246.28044 0 0
4 0 0 187.5 4.61447676 865.214392 0 0
0 585 0 70 4.02442594 281.709816 0 500
Inventario
Final
6610tán7a5661

6610tán25a5661

6610tán14a5661

6610tán3a5661

6600tán21a5660

6600tán10a5660

6600tán28a5660
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 8

Costo Total

2679.6 Costo Promedio 1351.1


1905.1 Inventario Promedio 309.3
1442.0 Total de Faltantes Promedio 0.65
681.5 Total de Pedidos 20
763.2
2244.6
1497.7
1170.9
790.0
998.5
2332.5
1748.0
1083.7
986.7
825.7
1712.6
1766.7
1154.9
765.0
784.8
2041.7
1438.8
1452.5
658.6
746.4
2728.3
1786.9
1374.4
785.2
780.8
2531.1
1596.5
1456.6
676.3
712.1
1965.8
1509.9
1051.2
834.9
737.4
1812.8
1549.4
1006.0
669.9
994.0
2502.0
1582.8
1127.4
1018.2
759.0
1998.7
1356.3
1251.3
775.4
803.5
1796.9
1950.5
1584.2
681.8
939.6
1658.8
2107.8
1356.3
874.6
872.3
1692.8
1558.3
1193.2
734.9
831.2
1841.9
1758.7
1018.0
843.7
950.0
2440.5
2035.2
905.6
590.4
803.9
2408.8
2092.8
1429.2
633.7
747.8
2673.8
1505.3
1334.1
681.9
833.6
2553.5
1919.6
1392.7
851.7
931.0
1825.0
1980.4
1246.3
865.2
781.7
entario
Final

6 41 46 51 56 61 66 71 76 81 86 91 96 101
Datos

Demanda Probabilidad P. Acumulada Límite Inferior Límite Superior


125 0.25 0.25 0 0.25
110 0.45 0.7 0.25 0.7
130 0.22 0.92 0.7 0.92
105 0.08 1 0.92 1
1

Costo de Pedido: S 500 Dolares/pedido


Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 7 días
Capacidad del Almacen 600 kg
Costo de Inventario Unif(3;5) Dólares
0.67689744267 110

Día Inventario Demanda Venta Inventario


Inicial Real Final

1 600 110 110 490


2 490 130 130 360
3 360 130 130 230
4 230 130 130 100
5 100 110 100 0
6 0 110 0 0
7 0 125 0 0
8 600 125 125 475
9 475 130 130 345
10 345 110 110 235
11 235 110 110 125
12 125 125 125 0
13 0 125 0 0
14 0 125 0 0
15 600 125 125 475
16 475 110 110 365
17 365 130 130 235
18 235 110 110 125
19 125 130 125 0
20 0 130 0 0
21 0 110 0 0
22 600 125 125 475
23 475 125 125 350
24 350 110 110 240
25 240 125 125 115
26 115 110 110 5
27 5 130 5 0
28 0 110 0 0
29 600 105 105 495
30 495 110 110 385
31 385 125 125 260
32 260 110 110 150
33 150 110 110 40
34 40 110 40 0
35 0 110 0 0
36 600 130 130 470
37 470 130 130 340
38 340 125 125 215
39 215 110 110 105
40 105 110 105 0
41 0 110 0 0
42 0 105 0 0
43 600 110 110 490
44 490 130 130 360
45 360 110 110 250
46 250 110 110 140
47 140 130 130 10
48 10 130 10 0
49 0 130 0 0
50 600 125 125 475
51 475 110 110 365
52 365 125 125 240
53 240 110 110 130
54 130 125 125 5
55 5 125 5 0
56 0 130 0 0
57 600 110 110 490
58 490 125 125 365
59 365 125 125 240
60 240 110 110 130
61 130 110 110 20
62 20 110 20 0
63 0 125 0 0
64 600 110 110 490
65 490 110 110 380
66 380 110 110 270
67 270 130 130 140
68 140 110 110 30
69 30 130 30 0
70 0 130 0 0
71 600 105 105 495
72 495 130 130 365
73 365 110 110 255
74 255 125 125 130
75 130 130 130 0
76 0 125 0 0
77 0 130 0 0
78 600 110 110 490
79 490 110 110 380
80 380 110 110 270
81 270 130 130 140
82 140 110 110 30
83 30 130 30 0
84 0 130 0 0
85 600 130 130 470
86 470 130 130 340
87 340 105 105 235
88 235 130 130 105
89 105 130 105 0
90 0 130 0 0
91 0 125 0 0
92 600 110 110 490
93 490 130 130 360
94 360 110 110 250
95 250 130 130 120
96 120 130 120 0
97 0 130 0 0
98 0 110 0 0
99 600 130 130 470
100 470 110 110 360
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 545 3.85533266 2101.1563 0 0
2 0 0 425 4.8984166 2081.82706 0 0
3 0 0 295 4.47820883 1321.07161 0 0
4 0 0 165 3.74266103 617.53907 0 0
5 0 10 50 3.62310547 181.155273 50 0
6 0 110 0 4.8071954 0 550 0
0 600 125 0 4.60099375 0 625 500
1 0 0 537.5 4.68728597 2519.41621 0 0
2 0 0 410 3.25221927 1333.4099 0 0
3 0 0 290 4.24538937 1231.16292 0 0
4 0 0 180 4.14217478 745.59146 0 0
5 0 0 62.5 3.84875246 240.547029 0 0
6 0 125 0 3.90482554 0 625 0
0 600 125 0 3.66413282 0 625 500
1 0 0 537.5 4.43694126 2384.85593 0 0
2 0 0 420 4.45068124 1869.28612 0 0
3 0 0 300 4.87285718 1461.85715 0 0
4 0 0 180 3.33869838 600.965709 0 0
5 0 5 62.5 3.63427893 227.142433 25 0
6 0 130 0 3.79341188 0 650 0
0 600 110 0 3.94809521 0 550 500
1 0 0 537.5 4.77632995 2567.27735 0 0
2 0 0 412.5 3.52513232 1454.11708 0 0
3 0 0 295 3.0545216 901.083873 0 0
4 0 0 177.5 4.63988962 823.580407 0 0
5 0 0 60 3.77270185 226.362111 0 0
6 0 125 2.5 4.29303895 10.7325974 625 0
0 600 110 0 3.50767293 0 550 500
1 0 0 547.5 3.77756499 2068.21683 0 0
2 0 0 440 3.1371993 1380.36769 0 0
3 0 0 322.5 3.2202457 1038.52924 0 0
4 0 0 205 3.58343402 734.603974 0 0
5 0 0 95 4.7369896 450.014012 0 0
6 0 70 20 4.65830963 93.1661927 350 0
0 600 110 0 3.09092757 0 550 500
1 0 0 535 3.09972557 1658.35318 0 0
2 0 0 405 4.24790933 1720.40328 0 0
3 0 0 277.5 4.44542223 1233.60467 0 0
4 0 0 160 3.2444841 519.117456 0 0
5 0 5 52.5 3.52994675 185.322204 25 0
6 0 110 0 4.98955565 0 550 0
0 600 105 0 4.86401689 0 525 500
1 0 0 545 3.10742002 1693.54391 0 0
2 0 0 425 3.69478885 1570.28526 0 0
3 0 0 305 4.64679836 1417.2735 0 0
4 0 0 195 4.81167778 938.277167 0 0
5 0 0 75 3.85793218 289.344913 0 0
6 0 120 5 4.63363593 23.1681797 600 0
0 600 130 0 3.32905181 0 650 500
1 0 0 537.5 3.83811147 2062.98492 0 0
2 0 0 420 3.7324356 1567.62295 0 0
3 0 0 302.5 3.14879854 952.51156 0 0
4 0 0 185 4.23423189 783.3329 0 0
5 0 0 67.5 3.11194276 210.056137 0 0
6 0 120 2.5 4.61727446 11.5431861 600 0
0 600 130 0 4.24768403 0 650 500
1 0 0 545 3.43287069 1870.91452 0 0
2 0 0 427.5 3.64142855 1556.71071 0 0
3 0 0 302.5 4.7888675 1448.63242 0 0
4 0 0 185 3.76265308 696.090819 0 0
5 0 0 75 3.89379634 292.034725 0 0
6 0 90 10 3.67252539 36.7252539 450 0
0 600 125 0 4.54396395 0 625 500
1 0 0 545 4.22914997 2304.88673 0 0
2 0 0 435 3.20736282 1395.20283 0 0
3 0 0 325 4.45964083 1449.38327 0 0
4 0 0 205 3.21387857 658.845107 0 0
5 0 0 85 4.97352087 422.749274 0 0
6 0 100 15 3.03950037 45.5925055 500 0
0 600 130 0 3.18867881 0 650 500
1 0 0 547.5 4.49560088 2461.34148 0 0
2 0 0 430 4.28407296 1842.15137 0 0
3 0 0 310 3.78972354 1174.8143 0 0
4 0 0 192.5 3.55126997 683.619469 0 0
5 0 0 65 3.88843507 252.74828 0 0
6 0 125 0 4.73717575 0 625 0
0 600 130 0 3.68807717 0 650 500
1 0 0 545 3.76617923 2052.56768 0 0
2 0 0 435 4.58927265 1996.3336 0 0
3 0 0 325 4.88277851 1586.90302 0 0
4 0 0 205 4.36736183 895.309175 0 0
5 0 0 85 3.53494787 300.470569 0 0
6 0 100 15 3.34533424 50.1800135 500 0
0 600 130 0 3.28518319 0 650 500
1 0 0 535 4.08218098 2183.96682 0 0
2 0 0 405 4.73189309 1916.4167 0 0
3 0 0 287.5 3.69109202 1061.18896 0 0
4 0 0 170 3.79203377 644.64574 0 0
5 0 25 52.5 3.27917287 172.156575 125 0
6 0 130 0 3.15091831 0 650 0
0 600 125 0 3.60726437 0 625 500
1 0 0 545 3.79336013 2067.38127 0 0
2 0 0 425 3.51467756 1493.73796 0 0
3 0 0 305 4.04653055 1234.19182 0 0
4 0 0 185 4.39958118 813.922518 0 0
5 0 10 60 4.41943 265.1658 50 0
6 0 130 0 4.43058196 0 650 0
0 600 110 0 4.13822295 0 550 500
1 0 0 535 4.20780391 2251.17509 0 0
2 0 0 415 3.46337477 1437.30053 0 0
Inventario
Final
6610tán7a5661

6610tán25a5661

6610tán14a5661

6610tán3a5661

6600tán21a5660

6600tán10a5660

6600tán28a5660
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 8

Costo Total

2101.2 Costo Promedio 1121.9


2081.8 Inventario Promedio 223
1321.1 Total de Faltantes Promedio 33.35
617.5 Total de Pedidos 14
231.2
550.0
1125.0
2519.4
1333.4
1231.2
745.6
240.5
625.0
1125.0
2384.9
1869.3
1461.9
601.0
252.1
650.0
1050.0
2567.3
1454.1
901.1
823.6
226.4
635.7
1050.0
2068.2
1380.4
1038.5
734.6
450.0
443.2
1050.0
1658.4
1720.4
1233.6
519.1
210.3
550.0
1025.0
1693.5
1570.3
1417.3
938.3
289.3
623.2
1150.0
2063.0
1567.6
952.5
783.3
210.1
611.5
1150.0
1870.9
1556.7
1448.6
696.1
292.0
486.7
1125.0
2304.9
1395.2
1449.4
658.8
422.7
545.6
1150.0
2461.3
1842.2
1174.8
683.6
252.7
625.0
1150.0
2052.6
1996.3
1586.9
895.3
300.5
550.2
1150.0
2184.0
1916.4
1061.2
644.6
297.2
650.0
1125.0
2067.4
1493.7
1234.2
813.9
315.2
650.0
1050.0
2251.2
1437.3
entario
Final

6 41 46 51 56 61 66 71 76 81 86 91 96 101
Datos

Demanda Probabilidad P. Acumulada Límite Inferior Límite Superior


125 0.25 0.25 0 0.25
110 0.45 0.7 0.25 0.7
130 0.22 0.92 0.7 0.92
105 0.08 1 0.92 1
1

Costo de Pedido: S 500 Dolares/pedido


Costo de Faltante: 5 Dolares/unidad
Periodo de Revisión 6 días
Capacidad del Almacen 1000 kg
Costo de Inventario Unif(3;5) Dólares
0.73181169854 130

Día Inventario Demanda Venta Inventario


Inicial Real Final

1 1000 130 130 870


2 870 105 105 765
3 765 105 105 660
4 660 130 130 530
5 530 130 130 400
6 400 110 110 290
7 1000 110 110 890
8 890 110 110 780
9 780 110 110 670
10 670 130 130 540
11 540 110 110 430
12 430 125 125 305
13 1000 125 125 875
14 875 110 110 765
15 765 110 110 655
16 655 125 125 530
17 530 110 110 420
18 420 130 130 290
19 1000 125 125 875
20 875 110 110 765
21 765 125 125 640
22 640 110 110 530
23 530 110 110 420
24 420 130 130 290
25 1000 110 110 890
26 890 125 125 765
27 765 110 110 655
28 655 110 110 545
29 545 125 125 420
30 420 125 125 295
31 1000 110 110 890
32 890 105 105 785
33 785 110 110 675
34 675 110 110 565
35 565 130 130 435
36 435 130 130 305
37 1000 105 105 895
38 895 130 130 765
39 765 105 105 660
40 660 110 110 550
41 550 125 125 425
42 425 125 125 300
43 1000 130 130 870
44 870 125 125 745
45 745 130 130 615
46 615 110 110 505
47 505 110 110 395
48 395 130 130 265
49 1000 110 110 890
50 890 110 110 780
51 780 125 125 655
52 655 110 110 545
53 545 110 110 435
54 435 110 110 325
55 1000 125 125 875
56 875 125 125 750
57 750 130 130 620
58 620 130 130 490
59 490 110 110 380
60 380 110 110 270
61 1000 130 130 870
62 870 110 110 760
63 760 105 105 655
64 655 110 110 545
65 545 110 110 435
66 435 105 105 330
67 1000 125 125 875
68 875 125 125 750
69 750 125 125 625
70 625 130 130 495
71 495 110 110 385
72 385 110 110 275
73 1000 110 110 890
74 890 110 110 780
75 780 125 125 655
76 655 130 130 525
77 525 125 125 400
78 400 130 130 270
79 1000 130 130 870
80 870 125 125 745
81 745 130 130 615
82 615 110 110 505
83 505 130 130 375
84 375 130 130 245
85 1000 105 105 895
86 895 125 125 770
87 770 105 105 665
88 665 125 125 540
89 540 110 110 430
90 430 110 110 320
91 1000 130 130 870
92 870 125 125 745
93 745 125 125 620
94 620 105 105 515
95 515 130 130 385
96 385 125 125 260
97 1000 110 110 890
98 890 110 110 780
99 780 110 110 670
100 670 110 110 560
UNiF=a+(b-a)*Al
Revisión de Inventario Inventario de Problema Costos
Faltantes Inventario Costo de
¿Se pide? Cantidad Inventario Faltante Pedido
Promedio Inventario
1 0 0 935 4.29202486 4013.04324 0 0
2 0 0 817.5 4.78287683 3910.00181 0 0
3 0 0 712.5 4.54337231 3237.15277 0 0
4 0 0 595 3.11655317 1854.34914 0 0
5 0 0 465 3.17847416 1477.99049 0 0
0 710 0 345 4.19678215 1447.88984 0 500
1 0 0 945 3.68489185 3482.2228 0 0
2 0 0 835 4.89941374 4091.01047 0 0
3 0 0 725 4.60516132 3338.74195 0 0
4 0 0 605 3.33657762 2018.62946 0 0
5 0 0 485 3.45508133 1675.71444 0 0
0 695 0 367.5 3.02749575 1112.60469 0 500
1 0 0 937.5 3.80066333 3563.12187 0 0
2 0 0 820 4.58708058 3761.40608 0 0
3 0 0 710 3.45226836 2451.11054 0 0
4 0 0 592.5 4.43870406 2629.93216 0 0
5 0 0 475 4.23959391 2013.80711 0 0
0 710 0 355 3.21971379 1142.9984 0 500
1 0 0 937.5 4.59488894 4307.70838 0 0
2 0 0 820 4.80912643 3943.48367 0 0
3 0 0 702.5 3.46118024 2431.47912 0 0
4 0 0 585 3.45328045 2020.16906 0 0
5 0 0 475 3.05406792 1450.68226 0 0
0 710 0 355 4.89922149 1739.22363 0 500
1 0 0 945 3.83689658 3625.86727 0 0
2 0 0 827.5 4.34374361 3594.44784 0 0
3 0 0 710 3.98163992 2826.96434 0 0
4 0 0 600 3.57373604 2144.24163 0 0
5 0 0 482.5 3.40289714 1641.89787 0 0
0 705 0 357.5 4.53587367 1621.57484 0 500
1 0 0 945 3.33451947 3151.12089 0 0
2 0 0 837.5 3.20160264 2681.34221 0 0
3 0 0 730 3.27649429 2391.84083 0 0
4 0 0 620 3.39276077 2103.51168 0 0
5 0 0 500 3.54250683 1771.25341 0 0
0 695 0 370 4.80599003 1778.21631 0 500
1 0 0 947.5 3.92309627 3717.13372 0 0
2 0 0 830 3.34762707 2778.53046 0 0
3 0 0 712.5 4.92727569 3510.68393 0 0
4 0 0 605 3.05923341 1850.83621 0 0
5 0 0 487.5 3.55122938 1731.22432 0 0
0 700 0 362.5 3.79995089 1377.4822 0 500
1 0 0 935 4.40031783 4114.29717 0 0
2 0 0 807.5 3.57699633 2888.42454 0 0
3 0 0 680 4.16607722 2832.93251 0 0
4 0 0 560 3.47679977 1947.00787 0 0
5 0 0 450 4.01221866 1805.4984 0 0
0 735 0 330 4.68147026 1544.88519 0 500
1 0 0 945 4.60154226 4348.45743 0 0
2 0 0 835 4.11625317 3437.07139 0 0
3 0 0 717.5 4.20109973 3014.28906 0 0
4 0 0 600 3.92671155 2356.02693 0 0
5 0 0 490 3.6503417 1788.66743 0 0
0 675 0 380 3.18069719 1208.66493 0 500
1 0 0 937.5 3.62518116 3398.60734 0 0
2 0 0 812.5 4.67444884 3797.98968 0 0
3 0 0 685 4.18064157 2863.73948 0 0
4 0 0 555 4.9285231 2735.33032 0 0
5 0 0 435 3.77096577 1640.37011 0 0
0 730 0 325 3.37623313 1097.27577 0 500
1 0 0 935 4.40435399 4118.07098 0 0
2 0 0 815 4.40330487 3588.69347 0 0
3 0 0 707.5 3.17473791 2246.12707 0 0
4 0 0 600 4.41858334 2651.15001 0 0
5 0 0 490 3.06548634 1502.08831 0 0
0 670 0 382.5 4.81188168 1840.54474 0 500
1 0 0 937.5 4.62882407 4339.52256 0 0
2 0 0 812.5 3.88625963 3157.58595 0 0
3 0 0 687.5 3.25738949 2239.45527 0 0
4 0 0 560 4.9147659 2752.2689 0 0
5 0 0 440 3.37397571 1484.54931 0 0
0 725 0 330 4.08796798 1349.02943 0 500
1 0 0 945 4.26954961 4034.72438 0 0
2 0 0 835 3.18239595 2657.30061 0 0
3 0 0 717.5 3.52129185 2526.5269 0 0
4 0 0 590 3.50343709 2067.02789 0 0
5 0 0 462.5 3.11916031 1442.61164 0 0
0 730 0 335 4.20666462 1409.23265 0 500
1 0 0 935 3.01231566 2816.51514 0 0
2 0 0 807.5 3.66437426 2958.98221 0 0
3 0 0 680 3.2632185 2218.98858 0 0
4 0 0 560 4.63568684 2595.98463 0 0
5 0 0 440 4.74276842 2086.8181 0 0
0 755 0 310 4.59845753 1425.52183 0 500
1 0 0 947.5 3.27812107 3106.01971 0 0
2 0 0 832.5 4.06491848 3384.04464 0 0
3 0 0 717.5 4.71444592 3382.61495 0 0
4 0 0 602.5 3.09588938 1865.27335 0 0
5 0 0 485 3.6267095 1758.95411 0 0
0 680 0 375 4.42952229 1661.07086 0 500
1 0 0 935 4.47297894 4182.23531 0 0
2 0 0 807.5 3.99817501 3228.52632 0 0
3 0 0 682.5 3.99064424 2723.61469 0 0
4 0 0 567.5 3.88990443 2207.52076 0 0
5 0 0 450 3.00152288 1350.6853 0 0
0 740 0 322.5 4.77593999 1540.24065 0 500
1 0 0 945 4.72806059 4468.01726 0 0
2 0 0 835 4.06836931 3397.08838 0 0
3 0 0 725 3.30855892 2398.70522 0 0
4 0 0 615 4.53933801 2791.69287 0 0
Inventario
Final
6620tán24a5662
6620tán13a5662
6620tán1a5662
6620tán19a5662
6610tán7a5661
6610tán25a5661
6610tán14a5661
6610tán3a5661
6600tán21a5660
6600tán10a5660
6600tán28a5660
1 6 11 16 21 26 31 36 41 46 51 56 61 66 71 76 8

Costo Total

4013.0 Costo Promedio 2651.9


3910.0 Inventario Promedio 651.075
3237.2 Total de Faltantes Promedio 0
1854.3 Total de Pedidos 16
1478.0
1947.9
3482.2
4091.0
3338.7
2018.6
1675.7
1612.6
3563.1
3761.4
2451.1
2629.9
2013.8
1643.0
4307.7
3943.5
2431.5
2020.2
1450.7
2239.2
3625.9
3594.4
2827.0
2144.2
1641.9
2121.6
3151.1
2681.3
2391.8
2103.5
1771.3
2278.2
3717.1
2778.5
3510.7
1850.8
1731.2
1877.5
4114.3
2888.4
2832.9
1947.0
1805.5
2044.9
4348.5
3437.1
3014.3
2356.0
1788.7
1708.7
3398.6
3798.0
2863.7
2735.3
1640.4
1597.3
4118.1
3588.7
2246.1
2651.2
1502.1
2340.5
4339.5
3157.6
2239.5
2752.3
1484.5
1849.0
4034.7
2657.3
2526.5
2067.0
1442.6
1909.2
2816.5
2959.0
2219.0
2596.0
2086.8
1925.5
3106.0
3384.0
3382.6
1865.3
1759.0
2161.1
4182.2
3228.5
2723.6
2207.5
1350.7
2040.2
4468.0
3397.1
2398.7
2791.7
entario
Final

6 41 46 51 56 61 66 71 76 81 86 91 96 101

También podría gustarte