Un almacén desea evaluar mediante simulación el costo de inventarios de café que se distribuyen desde este

CENDIS. Los pedidos de café se realizan cada semana los pedidos los hacen por la capacidad de la bodega menos
la cantidad de bultos de cargas de café disponibles en el momento; la entrega de las cargas de café es inmediata.
La información con la que se cuenta es la siguiente:

Capacidad de la bodega: 7,000 cargas de café

Costo de ordenar: $ 10,200 por carga
Costo de faltante: $ 10,000 por carga
Costo de almacenamiento de inventario: $ 3,000 por carga

Se tiene un registro de cargas diarias distribuidas desde la bodega del último año, validados mediante una prueba
de bondad de ajuste con los siguientes datos:

VARIABLE ALEATORIO TIPO DISTRIBUCION PARAMETROS

Venta de café carga/dia Continua Exponencial Media=1100

La gerencia de la empresa distribuidora de café requiere realizar un estudio de simulación completo para estimar
el costo de mantenimiento del inventario.

Considere un Alfa de 0.1 y un error de 200 cargas.

Determine:
a. Modelo de simulación de 90 días de operación incluyendo grafico de estabilidad.
b. Cálculo del número de corridas necesarias para estabilizar la
variable de interés.
c. Adecuar el número de corridas según el caso del modelo del punto a.
d. Generar 15 corridas del modelo y calcular el intervalo de confianza.
e. Establecer conclusiones y recomendaciones a la gerencia sobre la variable de interésm que le permitan;

* Valida un modelo de simulación, basado en los resultados de las pruebas de comparación de

medias

* Explica los resultados de un experimento de simulación, con base en los intervalos de confianza

* Escoge ante sí varias alternativas de solución a un problema, basado en los resultados de la

simulación.
distribuyen desde este
ad de la bodega menos
as de café es inmediata.

os mediante una prueba

PARAMETROS

Media=1100

n completo para estimar

abilidad.

o a.
a.
ésm que le permitan;

s de comparación de

ntervalos de confianza

n los resultados de la
 Capacidad de la bodega: 7,000 cargas de café
Costo de ordenar: $ 10,200 por carga
Costo de faltante: $ 10,000 por carga
Costo de almacenamiento de inventario: $ 3,000 por carga
Parametro 1100 media

Inventario Entrega Inventario Demanda Ventas Inv. Final

Dia
inicial proveedor(bultos) total (bultos) (bultos) (bultos)

1 0 7,000 7,000 -1063.273158 -1,063 8,063

2 8,063 0 8,063 -369.4129936 -369 8,433
3 8,433 0 8,433 -589.7899976 -590 9,022
4 9,022 0 9,022 -2704.634086 -2,705 11,727
5 11,727 0 11,727 -392.9842862 -393 12,120
6 12,120 0 12,120 -1507.411257 -1,507 13,628
7 13,628 -6627.50577869798 7,000 -86.02799997 -86 7,086
8 7,086 0 7,086 -67.45717946 -67 7,153
9 7,153 0 7,153 -396.9154557 -397 7,550
10 7,550 0 7,550 -3110.825678 -3,111 10,661
11 10,661 0 10,661 -2289.27694 -2,289 12,951
12 12,951 0 12,951 -1122.097948 -1,122 14,073
13 14,073 0 14,073 -1153.832555 -1,154 15,226
14 15,226 -8226.43375618782 7,000 -1348.049184 -1,348 8,348
15 8,348 0 8,348 -2720.829328 -2,721 11,069
16 11,069 0 11,069 -365.3410073 -365 11,434
17 11,434 0 11,434 -394.6018103 -395 11,829
18 11,829 0 11,829 -847.7995891 -848 12,677
19 12,677 0 12,677 -1780.887061 -1,781 14,458
20 14,458 0 14,458 -509.5532147 -510 14,967
21 14,967 -7967.06119392881 7,000 -519.9993199 -520 7,520
22 7,520 0 7,520 -83.60913819 -84 7,604
23 7,604 0 7,604 -1413.431233 -1,413 9,017
24 9,017 0 9,017 -1038.332503 -1,038 10,055
25 10,055 0 10,055 -1186.796024 -1,187 11,242
26 11,242 0 11,242 -103.6941644 -104 11,346
27 11,346 0 11,346 -1231.903676 -1,232 12,578
28 12,578 -5577.7660584008 7,000 -435.6601275 -436 7,436
29 7,436 0 7,436 -62.16259019 -62 7,498
30 7,498 0 7,498 -1608.527412 -1,609 9,106
31 9,106 0 9,106 -156.2207503 -156 9,263
32 9,263 0 9,263 -62.42878613 -62 9,325
33 9,325 0 9,325 -846.1300331 -846 10,171
34 10,171 0 10,171 -4481.481408 -4,481 14,653
35 14,653 -7652.61110762432 7,000 -564.5262325 -565 7,565
36 7,565 0 7,565 -1970.291141 -1,970 9,535
37 9,535 0 9,535 -464.6623783 -465 9,999
38 9,999 0 9,999 -1745.339101 -1,745 11,745
39 11,745 0 11,745 -414.6384049 -415 12,159
40 12,159 0 12,159 -2434.022092 -2,434 14,593
41 14,593 0 14,593 -1959.896557 -1,960 16,553
42 16,553 -9553.37590746886 7,000 -2859.356439 -2,859 9,859
43 9,859 0 9,859 -412.0317544 -412 10,271
44 10,271 0 10,271 -2318.195094 -2,318 12,590
45 12,590 0 12,590 -973.5211971 -974 13,563
46 13,563 0 13,563 -2941.348563 -2,941 16,504
47 16,504 0 16,504 -165.3539694 -165 16,670
48 16,670 0 16,670 -2412.820047 -2,413 19,083
49 19,083 -12082.6270640008 7,000 -493.7354603 -494 7,494
50 7,494 0 7,494 -2095.679217 -2,096 9,589
51 9,589 0 9,589 -1240.202522 -1,240 10,830
52 10,830 0 10,830 -156.3998691 -156 10,986
53 10,986 0 10,986 -2244.507064 -2,245 13,231
54 13,231 0 13,231 -1536.928502 -1,537 14,767
55 14,767 0 14,767 -337.5077988 -338 15,105
56 15,105 -8104.96043357424 7,000 -355.1008605 -355 7,355
57 7,355 0 7,355 -327.2372453 -327 7,682
58 7,682 0 7,682 -1101.916433 -1,102 8,784
59 8,784 0 8,784 -933.4660761 -933 9,718
60 9,718 0 9,718 -279.1687194 -279 9,997
61 9,997 0 9,997 -289.7385002 -290 10,287
62 10,287 0 10,287 -1183.656052 -1,184 11,470
63 11,470 -4470.28388619779 7,000 -1604.173185 -1,604 8,604
64 8,604 0 8,604 -256.7117994 -257 8,861
65 8,861 0 8,861 -195.3631352 -195 9,056
66 9,056 0 9,056 -141.3642723 -141 9,198
67 9,198 0 9,198 -661.1797587 -661 9,859
68 9,859 0 9,859 -1259.077578 -1,259 11,118
69 11,118 0 11,118 -600.7818598 -601 11,719
70 11,719 -4718.65158853156 7,000 -906.2562588 -906 7,906
71 7,906 0 7,906 -171.4469665 -171 8,078
72 8,078 0 8,078 -656.7565721 -657 8,734
73 8,734 0 8,734 -1901.069776 -1,901 10,636
74 10,636 0 10,636 -1573.273819 -1,573 12,209
75 12,209 0 12,209 -2039.072593 -2,039 14,248
76 14,248 0 14,248 -422.2933956 -422 14,670
77 14,670 -7670.16938056425 7,000 -308.3548891 -308 7,308
78 7,308 0 7,308 -696.2474274 -696 8,005
79 8,005 0 8,005 -626.6222775 -627 8,631
80 8,631 0 8,631 -832.1273642 -832 9,463
81 9,463 0 9,463 -1689.011268 -1,689 11,152
82 11,152 0 11,152 -94.68091207 -95 11,247
83 11,247 0 11,247 -11.8079905 -12 11,259
84 11,259 -4258.85212924048 7,000 -3.203440759 -3 7,003
85 7,003 0 7,003 -1022.26865 -1,022 8,025
86 8,025 0 8,025 -83.02067619 -83 8,108
87 8,108 0 8,108 -354.7315608 -355 8,463
88 8,463 0 8,463 -1221.541177 -1,222 9,685
89 9,685 0 9,685 -1351.653411 -1,352 11,036
90 11,036 0 11,036 -958.7906863 -959 11,995
 ESTADISTICO
PROMEDIO $ 31,918,552
DESVIACION 7098511.6038
PEDIDOS CADA 7 MAXIMO $ 53,628,651
MINIMO $ 12,105,110
Inv.
Ventas perdidas Costos de Costos Costo de
Promedio Costo total
(bultos) ordenar faltante mantenimiento
(bultos)
4031.63658 0 $ 10,200 $0 $ 12,094,910 $ 12,105,110
8247.97965 0 $0 $0 $ 24,743,939 $ 24,743,939
8727.58115 0 $0 $0 $ 26,182,743 $ 26,182,743
10374.7932 0 $0 $0 $ 31,124,380 $ 31,124,380
11923.6024 0 $0 $0 $ 35,770,807 $ 35,770,807
12873.8002 0 $0 $0 $ 38,621,400 $ 38,621,400
10356.7669 0 $0 $0 $ 31,070,301 $ 31,070,301
7119.75659 0 $0 $0 $ 21,359,270 $ 21,359,270
7351.94291 0 $0 $0 $ 22,055,829 $ 22,055,829
9105.81347 0 $0 $0 $ 27,317,440 $ 27,317,440
11805.8648 0 $0 $0 $ 35,417,594 $ 35,417,594
13511.5522 0 $0 $0 $ 40,534,657 $ 40,534,657
14649.5175 0 $0 $0 $ 43,948,552 $ 43,948,552
11787.2415 0 $0 $0 $ 35,361,724 $ 35,361,724
9708.46385 0 $0 $0 $ 29,125,392 $ 29,125,392
11251.549 0 $0 $0 $ 33,754,647 $ 33,754,647
11631.5204 0 $0 $0 $ 34,894,561 $ 34,894,561
12252.7211 0 $0 $0 $ 36,758,163 $ 36,758,163
13567.0644 0 $0 $0 $ 40,701,193 $ 40,701,193
14712.2846 0 $0 $0 $ 44,136,854 $ 44,136,854
11243.5303 0 $0 $0 $ 33,730,591 $ 33,730,591
7561.80389 0 $0 $0 $ 22,685,412 $ 22,685,412
8310.32407 0 $0 $0 $ 24,930,972 $ 24,930,972
9536.20594 0 $0 $0 $ 28,608,618 $ 28,608,618
10648.7702 0 $0 $0 $ 31,946,311 $ 31,946,311
11294.0153 0 $0 $0 $ 33,882,046 $ 33,882,046
11961.8142 0 $0 $0 $ 35,885,443 $ 35,885,443
10006.7131 0 $0 $0 $ 30,020,139 $ 30,020,139
7466.74142 0 $0 $0 $ 22,400,224 $ 22,400,224
8302.08642 0 $0 $0 $ 24,906,259 $ 24,906,259
9184.46051 0 $0 $0 $ 27,553,382 $ 27,553,382
9293.78527 0 $0 $0 $ 27,881,356 $ 27,881,356
9748.06468 0 $0 $0 $ 29,244,194 $ 29,244,194
12411.8704 0 $0 $0 $ 37,235,611 $ 37,235,611
11108.5687 0 $0 $0 $ 33,325,706 $ 33,325,706
8549.6718 0 $0 $0 $ 25,649,015 $ 25,649,015
9767.14856 0 $0 $0 $ 29,301,446 $ 29,301,446
10872.1493 0 $0 $0 $ 32,616,448 $ 32,616,448
11952.1381 0 $0 $0 $ 35,856,414 $ 35,856,414
13376.4683 0 $0 $0 $ 40,129,405 $ 40,129,405
15573.4276 0 $0 $0 $ 46,720,283 $ 46,720,283
13206.3662 0 $0 $0 $ 39,619,099 $ 39,619,099
10065.3723 0 $0 $0 $ 30,196,117 $ 30,196,117
11430.4857 0 $0 $0 $ 34,291,457 $ 34,291,457
13076.3439 0 $0 $0 $ 39,229,032 $ 39,229,032
15033.7788 0 $0 $0 $ 45,101,336 $ 45,101,336
16587.13 0 $0 $0 $ 49,761,390 $ 49,761,390
17876.217 0 $0 $0 $ 53,628,651 $ 53,628,651
13288.1813 0 $0 $0 $ 39,864,544 $ 39,864,544
8541.57507 0 $0 $0 $ 25,624,725 $ 25,624,725
10209.5159 0 $0 $0 $ 30,628,548 $ 30,628,548
10907.8171 0 $0 $0 $ 32,723,451 $ 32,723,451
12108.2706 0 $0 $0 $ 36,324,812 $ 36,324,812
13998.9884 0 $0 $0 $ 41,996,965 $ 41,996,965
14936.2065 0 $0 $0 $ 44,808,620 $ 44,808,620
11230.0306 0 $0 $0 $ 33,690,092 $ 33,690,092
7518.71948 0 $0 $0 $ 22,556,158 $ 22,556,158
8233.29632 0 $0 $0 $ 24,699,889 $ 24,699,889
9250.98758 0 $0 $0 $ 27,752,963 $ 27,752,963
9857.30497 0 $0 $0 $ 29,571,915 $ 29,571,915
10141.7586 0 $0 $0 $ 30,425,276 $ 30,425,276
10878.4559 0 $0 $0 $ 32,635,368 $ 32,635,368
10037.2285 0 $0 $0 $ 30,111,686 $ 30,111,686
8732.52908 0 $0 $0 $ 26,197,587 $ 26,197,587
8958.56655 0 $0 $0 $ 26,875,700 $ 26,875,700
9126.93026 0 $0 $0 $ 27,380,791 $ 27,380,791
9528.20227 0 $0 $0 $ 28,584,607 $ 28,584,607
10488.3309 0 $0 $0 $ 31,464,993 $ 31,464,993
11418.2607 0 $0 $0 $ 34,254,782 $ 34,254,782
9812.45392 0 $0 $0 $ 29,437,362 $ 29,437,362
7991.97974 0 $0 $0 $ 23,975,939 $ 23,975,939
8406.08151 0 $0 $0 $ 25,218,245 $ 25,218,245
9684.99469 0 $0 $0 $ 29,054,984 $ 29,054,984
11422.1665 0 $0 $0 $ 34,266,499 $ 34,266,499
13228.3397 0 $0 $0 $ 39,685,019 $ 39,685,019
14459.0227 0 $0 $0 $ 43,377,068 $ 43,377,068
10989.2621 0 $0 $0 $ 32,967,786 $ 32,967,786
7656.4786 0 $0 $0 $ 22,969,436 $ 22,969,436
8317.91346 0 $0 $0 $ 24,953,740 $ 24,953,740
9047.28828 0 $0 $0 $ 27,141,865 $ 27,141,865
10307.8576 0 $0 $0 $ 30,923,573 $ 30,923,573
11199.7037 0 $0 $0 $ 33,599,111 $ 33,599,111
11252.9481 0 $0 $0 $ 33,758,844 $ 33,758,844
9131.02778 0 $0 $0 $ 27,393,083 $ 27,393,083
7514.33777 0 $0 $0 $ 22,543,013 $ 22,543,013
8066.98243 0 $0 $0 $ 24,200,947 $ 24,200,947
8285.85855 0 $0 $0 $ 24,857,576 $ 24,857,576
9073.99492 0 $0 $0 $ 27,221,985 $ 27,221,985
10360.5922 0 $0 $0 $ 31,081,777 $ 31,081,777
11515.8143 0 $0 $0 $ 34,547,443 $ 34,547,443
 ESTADISTICO
PROMEDIO $ 31,089,578 Costo total (promedio acumulado)
DESVIACION 3201041.84736 $ 40,000,000

MAXIMO $ 33,517,548 $ 35,000,000

MINIMO $ 12,105,110 $ 30,000,000
Costo total $ 25,000,000
(promedio
acumulado) $ 20,000,000
$ 12,105,110 $ 15,000,000
$ 18,424,524
$ 10,000,000
$ 21,010,597
$ 23,539,043 $ 5,000,000

$ 25,985,396 $0
1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89
$ 28,091,397
$ 28,516,954
$ 27,622,244 Inv. Final (bultos)
$ 27,003,753 25,000
$ 27,035,122
$ 27,797,165
20,000
$ 28,858,622
$ 30,019,386
15,000
$ 30,400,982
$ 30,315,943
10,000
$ 30,530,862
$ 30,787,550
5,000
$ 31,119,251
$ 31,623,563
$ 32,249,228 0
1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89
$ 32,319,769
$ 31,881,844
$ 31,579,632 Costo de mantenimiento
$ 31,455,840 $60,000,000
$ 31,475,458
$ 31,568,019 $50,000,000
$ 31,727,924
$40,000,000
$ 31,666,932
$ 31,347,390
$30,000,000
$ 31,132,686
$ 31,017,224 $20,000,000
$ 30,919,228
$ 30,868,470 $10,000,000

$0
1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89
 $20,000,000

$10,000,000
$ 31,055,739
$0
$ 31,120,595 1 5 9 13 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 89
$ 30,968,607
$ 30,923,548
$ 30,968,098
Costos faltante
$ 31,093,440 $1
$ 31,319,339
$ 31,694,971
$ 31,883,641
$ 31,844,396
$ 31,900,011 $1
$ 32,062,879
$ 32,346,323
$ 32,716,857
$ 33,152,519
$ 33,289,499
$0
$ 33,136,204 0 10 20 30 40 50 60 70 80 90 100
$ 33,087,034
$ 33,080,042
$ 33,141,264
$ 33,305,258
$ 33,514,411
$ 33,517,548
$ 33,325,243
$ 33,176,530
$ 33,084,605
$ 33,026,060
$ 32,983,424
$ 32,977,810
$ 32,932,316
$ 32,827,086
$ 32,735,526
$ 32,654,394
$ 32,593,651
$ 32,577,053
$ 32,601,368
$ 32,556,168
$ 32,435,319
$ 32,335,082
$ 32,290,149
$ 32,316,857
$ 32,415,099
$ 32,559,336
$ 32,564,640
$ 32,441,625
$ 32,346,841
$ 32,281,779
$ 32,265,011
$ 32,281,281
$ 32,299,083
$ 32,240,678
$ 32,126,588
$ 32,034,429
$ 31,951,936
$ 31,898,187
$ 31,889,014
$ 31,918,552
73 77 81 85 89

77 81 85 89

77 81 85 89
77 81 85 89

90 100
 ESTADISTICO ESTADISTICO
PROMEDIO (x) 35031774.660359 35
DESVIACION(s) 9042489.1546805 9
MAXIMO 62773554.036474 63
MINIMO 12263068.332496 12
costo total
Costo total (promedio
acumulado)
$ 12,263,068 12
$ 25,430,459 25
$ 26,951,539 27
$ 29,230,037 29
$ 30,921,453 31
$ 31,264,049 31
$ 28,420,740 28
$ 25,557,107 26 longitud de la corrida: $ 0.0204
$ 27,046,369 27
$ 28,662,042 29
$ 29,206,875 29 Alfa (a)
$ 30,058,108 30 error €
$ 32,514,120 33 media
$ 30,300,763 30 Promedio (x)
$ 26,871,769 27 Desviacion(s)
$ 29,791,009 30
$ 34,430,502 34 NOTA:
LA FORMULA DEL NUMERO DE CORRIDAS DIO COMO
$ 43,120,548 43 RESULTADO 0 POR ELLO NO TENGO QUE REALIZAR MA
$ 51,600,286 52 CORRIDAS.
$ 54,116,415 54
$ 41,738,756 42
$ 32,627,101 33
$ 38,791,377 39
$ 43,778,164 44
$ 46,509,368 47
$ 47,836,002 48
$ 50,287,201 50
$ 38,882,253 39
$ 33,096,733 33
$ 40,558,933 41
$ 41,501,317 42
$ 41,900,580 42
$ 46,415,097 46
$ 52,202,699 52
$ 38,248,698 38
$ 24,093,191 24
$ 26,243,680 26
$ 27,572,233 28
$ 27,994,760 28
$ 28,819,421 29
$ 31,346,429 31
$ 32,856,925 33
$ 35,337,402 35
$ 42,007,714 42
$ 47,124,677 47
$ 49,908,377 50
$ 56,389,816 56
$ 62,773,554 63
$ 46,080,387 46
$ 29,268,466 29
$ 31,125,268 31
$ 32,253,508 32
$ 33,010,714 33
$ 35,992,706 36
$ 43,459,022 43
$ 35,581,828 36
$ 24,299,252 24
$ 25,844,844 26
$ 31,496,436 31
$ 38,286,268 38
$ 39,933,347 40
$ 42,413,027 42
$ 33,301,494 33
$ 22,034,897 22
$ 22,741,364 23
$ 24,671,837 25
$ 26,520,371 27
$ 28,738,033 29
$ 30,688,203 31
$ 27,977,254 28
$ 26,964,641 27
$ 30,691,090 31
$ 34,990,178 35
$ 38,517,404 39
$ 39,882,483 40
$ 41,726,376 42
$ 34,399,947 34
$ 26,371,482 26
$ 28,094,387 28
$ 31,409,852 31
$ 34,456,243 34
$ 36,882,860 37
$ 39,978,442 40
$ 32,079,050 32
$ 24,526,671 25
$ 27,895,228 28
$ 30,748,891 31
$ 33,471,791 33
$ 44,713,095 45
$ 54,741,368 55
 0.1
200
1,100
35.03
9

MERO DE CORRIDAS DIO COMO

O NO TENGO QUE REALIZAR MAS
CORRIDAS.
 Capacidad de la bodega: 7,000 cargas de café
Costo de ordenar: $ 10,200 por carga
Costo de faltante: $ 10,000 por carga
Costo de almacenamiento de inventario: $ 3,000 por carga
Parametro 1100 media

PEDIDOS
CADA

Entrega Inv.
Inventario Inventario Demanda Ventas Inv. Final
Dia proveedor(bult Promedio
inicial total (bultos) (bultos) (bultos)
os) (bultos)
1 0 7,000 7,000 -6188.09626 -6,188 13,188 6594.04813
2 13,188 0 13,188 -2842.41361 -2,842 16,031 14609.3031
3 16,031 0 16,031 -411.258213 -411 16,442 16236.139
4 16,442 0 16,442 -2755.61166 -2,756 19,197 17819.5739
5 19,197 0 19,197 -946.206642 -946 20,144 19670.4831
6 20,144 0 20,144 -909.326846 -909 21,053 20598.2498
7 21,053 -14052.913226 7,000 -139.044766 -139 7,139 14095.979
8 7,139 0 7,139 -820.48306 -820 7,960 7549.2863
9 7,960 0 7,960 -1502.76556 -1,503 9,462 8710.9106
10 9,462 0 9,462 -109.195621 -109 9,571 9516.89119
11 9,571 0 9,571 -970.307194 -970 10,542 10056.6426
12 10,542 0 10,542 -657.707393 -658 11,200 10870.6499
13 11,200 0 11,200 -516.573275 -517 11,716 11457.7902
14 11,716 -4716.0768649 7,000 -1401.24437 -1,401 8,401 10058.6606
15 8,401 0 8,401 -634.256748 -634 9,036 8718.37274
16 9,036 0 9,036 -1395.38944 -1,395 10,431 9733.19584
17 10,431 0 10,431 -135.548812 -136 10,566 10498.665
18 10,566 0 10,566 -1956.29688 -1,956 12,523 11544.5878
19 12,523 0 12,523 -19.8445192 -20 12,543 12532.6585
20 12,543 0 12,543 -2380.58191 -2,381 14,923 13732.8717
21 14,923 -7923.1626829 7,000 -970.286001 -970 7,970 11446.7243
22 7,970 0 7,970 -465.215382 -465 8,436 8202.89369
23 8,436 0 8,436 -1438.38504 -1,438 9,874 9154.69391
24 9,874 0 9,874 -375.016719 -375 10,249 10061.3948
25 10,249 0 10,249 -774.163274 -774 11,023 10635.9848
26 11,023 0 11,023 -647.601884 -648 11,671 11346.8674
27 11,671 0 11,671 -627.92735 -628 12,299 11984.632
28 12,299 -5298.5956555 7,000 -2083.60857 -2,084 9,084 10691.1021
29 9,084 0 9,084 -330.34729 -330 9,414 9248.78221
30 9,414 0 9,414 -1693.53766 -1,694 11,107 10260.7247
31 11,107 0 11,107 -10.158217 -10 11,118 11112.5726
32 11,118 0 11,118 -363.302731 -363 11,481 11299.3031
33 11,481 0 11,481 -674.364309 -674 12,155 11818.1366
34 12,155 0 12,155 -653.490554 -653 12,809 12482.064
35 12,809 -5808.8093255 7,000 -1670.16512 -1,670 8,670 10739.4872
36 8,670 0 8,670 -836.60847 -837 9,507 9088.46936
37 9,507 0 9,507 -1402.83879 -1,403 10,910 10208.193
38 10,910 0 10,910 -376.183286 -376 11,286 11097.704
39 11,286 0 11,286 -475.622053 -476 11,761 11523.6067
40 11,761 0 11,761 -961.866581 -962 12,723 12242.351
41 12,723 0 12,723 -840.219844 -840 13,564 13143.3942
42 13,564 -6563.5041426 7,000 -2112.03731 -2,112 9,112 11337.7707
43 9,112 0 9,112 -450.552275 -451 9,563 9337.31345
44 9,563 0 9,563 -1704.5447 -1,705 11,267 10414.8619
45 11,267 0 11,267 -376.013073 -376 11,643 11455.1408
46 11,643 0 11,643 -597.656892 -598 12,241 11941.9758
47 12,241 0 12,241 -2226.90053 -2,227 14,468 13354.2545
48 14,468 0 14,468 -3416.43592 -3,416 17,884 16175.9227
49 17,884 -10884.140698 7,000 -215.448026 -215 7,215 12549.7944
50 7,215 0 7,215 -87.1372418 -87 7,303 7259.01665
51 7,303 0 7,303 -805.763228 -806 8,108 7705.46688
52 8,108 0 8,108 -7355.76457 -7,356 15,464 11786.2308
53 15,464 0 15,464 -604.509355 -605 16,069 15766.3677
54 16,069 0 16,069 -5371.33996 -5,371 21,440 18754.2924
55 21,440 0 21,440 -905.289808 -905 22,345 21892.6073
56 22,345 -15345.252187 7,000 -1156.08244 -1,156 8,156 15250.6673
57 8,156 0 8,156 -962.835325 -963 9,119 8637.5001
58 9,119 0 9,119 -342.787579 -343 9,462 9290.31155
59 9,462 0 9,462 -278.308995 -278 9,740 9600.85984
60 9,740 0 9,740 -60.0827918 -60 9,800 9770.05573
61 9,800 0 9,800 -952.000229 -952 10,752 10276.0972
62 10,752 0 10,752 -3331.47906 -3,331 14,084 12417.8369
63 14,084 -7083.5764194 7,000 -744.798725 -745 7,745 10914.1876
64 7,745 0 7,745 -901.464982 -901 8,646 8195.53122
65 8,646 0 8,646 -40.5323374 -41 8,687 8666.52988
66 8,687 0 8,687 -1662.24231 -1,662 10,349 9517.9172
67 10,349 0 10,349 -1650.42539 -1,650 11,999 11174.2511
68 11,999 0 11,999 -827.328639 -827 12,827 12413.1281
69 12,827 0 12,827 -66.1458644 -66 12,893 12859.8653
70 12,893 -5892.9382516 7,000 -448.127604 -448 7,448 10170.5329
71 7,448 0 7,448 -321.23718 -321 7,769 7608.74619
72 7,769 0 7,769 -573.470411 -573 8,343 8056.09999
73 8,343 0 8,343 -434.059246 -434 8,777 8559.86482
74 8,777 0 8,777 -21.788269 -22 8,799 8787.78858
75 8,799 0 8,799 -2733.82152 -2,734 11,533 10165.5935
76 11,533 0 11,533 -965.023588 -965 12,498 12015.016
77 12,498 -5497.5278188 7,000 -513.116905 -513 7,513 10005.3224
78 7,513 0 7,513 -1316.22495 -1,316 8,829 8171.22938
79 8,829 0 8,829 -255.083212 -255 9,084 8956.88346
80 9,084 0 9,084 -5340.76524 -5,341 14,425 11754.8077
81 14,425 0 14,425 -1208.92952 -1,209 15,634 15029.6551
82 15,634 0 15,634 -1585.69979 -1,586 17,220 16426.9697
83 17,220 0 17,220 -0.52567156 -1 17,220 17220.0825
84 17,220 -10220.345291 7,000 -1533.17741 -1,533 8,533 12876.7614
85 8,533 0 8,533 -824.910665 -825 9,358 8945.63274
86 9,358 0 9,358 -2886.1122 -2,886 12,244 10801.1442
87 12,244 0 12,244 -488.13352 -488 12,732 12488.267
88 12,732 0 12,732 -2563.64291 -2,564 15,296 14014.1553
89 15,296 0 15,296 -935.136958 -935 16,231 15763.5452
90 16,231 0 16,231 -1430.34415 -1,430 17,661 16946.2857
 ESTADISTICO ESTADISTICO
PROMEDIO ### PROMEDIO ###
DESVIACION 9251003.47 DESVIACION 3219726.46
7
MAXIMO ### MAXIMO ###
MINIMO ### MINIMO ###
Ventas Costo total
Costos de Costos Costo de
perdidas Costo total (promedio
ordenar faltante mantenimiento
(bultos) acumulado)
0 10200 $0 $ 19,782,144 ### ###
0 0 $0 $ 43,827,909 ### ###
0 0 $0 $ 48,708,417 ### ###
0 0 $0 $ 53,458,722 ### ###
0 0 $0 $ 59,011,449 ### ###
0 0 $0 $ 61,794,749 ### ###
0 0 $0 $ 42,287,937 ### ###
0 0 $0 $ 22,647,859 ### ###
0 0 $0 $ 26,132,732 ### ###
0 0 $0 $ 28,550,674 ### ###
0 0 $0 $ 30,169,928 ### ###
0 0 $0 $ 32,611,950 ### ###
0 0 $0 $ 34,373,371 ### ###
0 0 $0 $ 30,175,982 ### ###
0 0 $0 $ 26,155,118 ### ###
0 0 $0 $ 29,199,588 ### ###
0 0 $0 $ 31,495,995 ### ###
0 0 $0 $ 34,633,763 ### ###
0 0 $0 $ 37,597,976 ### ###
0 0 $0 $ 41,198,615 ### ###
0 0 $0 $ 34,340,173 ### ###
0 0 $0 $ 24,608,681 ### ###
0 0 $0 $ 27,464,082 ### ###
0 0 $0 $ 30,184,184 ### ###
0 0 $0 $ 31,907,954 ### ###
0 0 $0 $ 34,040,602 ### ###
0 0 $0 $ 35,953,896 ### ###
0 0 $0 $ 32,073,306 ### ###
0 0 $0 $ 27,746,347 ### ###
0 0 $0 $ 30,782,174 ### ###
0 0 $0 $ 33,337,718 ### ###
0 0 $0 $ 33,897,909 ### ###
0 0 $0 $ 35,454,410 ### ###
0 0 $0 $ 37,446,192 ### ###
0 0 $0 $ 32,218,462 ### ###
0 0 $0 $ 27,265,408 ### ###
0 0 $0 $ 30,624,579 ### ###
0 0 $0 $ 33,293,112 ### ###
0 0 $0 $ 34,570,820 ### ###
0 0 $0 $ 36,727,053 ### ###
0 0 $0 $ 39,430,183 ### ###
0 0 $0 $ 34,013,312 ### ###
0 0 $0 $ 28,011,940 ### ###
0 0 $0 $ 31,244,586 ### ###
0 0 $0 $ 34,365,422 ### ###
0 0 $0 $ 35,825,927 ### ###
0 0 $0 $ 40,062,764 ### ###
0 0 $0 $ 48,527,768 ### ###
0 0 $0 $ 37,649,383 ### ###
0 0 $0 $ 21,777,050 ### ###
0 0 $0 $ 23,116,401 ### ###
0 0 $0 $ 35,358,692 ### ###
0 0 $0 $ 47,299,103 ### ###
0 0 $0 $ 56,262,877 ### ###
0 0 $0 $ 65,677,822 ### ###
0 0 $0 $ 45,752,002 ### ###
0 0 $0 $ 25,912,500 ### ###
0 0 $0 $ 27,870,935 ### ###
0 0 $0 $ 28,802,580 ### ###
0 0 $0 $ 29,310,167 ### ###
0 0 $0 $ 30,828,292 ### ###
0 0 $0 $ 37,253,511 ### ###
0 0 $0 $ 32,742,563 ### ###
0 0 $0 $ 24,586,594 ### ###
0 0 $0 $ 25,999,590 ### ###
0 0 $0 $ 28,553,752 ### ###
0 0 $0 $ 33,522,753 ### ###
0 0 $0 $ 37,239,384 ### ###
0 0 $0 $ 38,579,596 ### ###
0 0 $0 $ 30,511,599 ### ###
0 0 $0 $ 22,826,239 ### ###
0 0 $0 $ 24,168,300 ### ###
0 0 $0 $ 25,679,594 ### ###
0 0 $0 $ 26,363,366 ### ###
0 0 $0 $ 30,496,780 ### ###
0 0 $0 $ 36,045,048 ### ###
0 0 $0 $ 30,015,967 ### ###
0 0 $0 $ 24,513,688 ### ###
0 0 $0 $ 26,870,650 ### ###
0 0 $0 $ 35,264,423 ### ###
0 0 $0 $ 45,088,965 ### ###
0 0 $0 $ 49,280,909 ### ###
0 0 $0 $ 51,660,247 ### ###
0 0 $0 $ 38,630,284 ### ###
0 0 $0 $ 26,836,898 ### ###
0 0 $0 $ 32,403,433 ### ###
0 0 $0 $ 37,464,801 ### ###
0 0 $0 $ 42,042,466 ### ###
0 0 $0 $ 47,290,636 ### ###
0 0 $0 $ 50,838,857 ### ###
STADISTICO
$ 36
$3

$ 48
$ 20

$ 20
$ 32
$ 37
$ 41
$ 45
$ 48
$ 47
$ 44
$ 42
$ 41
$ 40
$ 39
$ 39
$ 38
$ 37
$ 37
$ 36
$ 36
$ 36
$ 37
$ 37
$ 36
$ 36
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 34
$ 34
$ 34
$ 34
$ 35
$ 35
$ 34
$ 34
$ 34
$ 34
$ 34
$ 35
$ 35
$ 35
$ 34
$ 34
$ 35
$ 35
$ 36
$ 36
$ 36
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 35
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 34
$ 35
$ 34
$ 34
$ 34
$ 35
$ 35
$ 35
 ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO
PROMEDIO 35475920.1281 33455737.665 30057635.695 26092216.72 22408930.103

DESVIACION 3017713.07124 3742485.79361 4135881.0339 3851292.4808 3119030.6006

MAXIMO 37888279.622 35475920.1281 33455737.665 30057635.695 26092216.72
MINIMO 14055640.0015 14055640.0015 14055640 14055640.002 14055640.002

Costo total Costo total Costo total Costo total Costo total
(promedio (promedio (promedio (promedio (promedio
acumulado) acumulado) acumulado) acumulado) acumulado)
CORRIDA 1 CORRIDA 2 CORRIDA 3 CORRIDA 4 CORRIDA 5
$ 14,055,640 14055640.0015 14055640.0015 14055640 14055640.002 14055640.002
$ 31,724,853 22890246.5888 18472943.2951 16264291.648 15159965.825 14607802.913
$ 35,591,175 27123889.5129 21356592.0344 17961725.11 16093885.587 15103163.804
$ 38,213,979 29896412.0096 23491547.0282 19344180.59 16906459.338 15553987.688
$ 42,045,052 32326140.004 25258465.6233 20527037.597 17630574.989 15969305.148
$ 44,304,382 34322513.646 26769140.2938 21567388.046 18286710.499 16355539.373
$ 36,642,508 34653941.344 27895540.4438 22471409.817 18884524.687 16716822.989
$ 31,773,025 34293826.8453 28695326.244 23249399.371 19430134.023 17055986.869
$ 36,181,857 34503608.0284 29340690.8867 23926209.539 19929697.969 17375288.102
$ 38,372,918 34890538.9806 29895675.6961 24523156.155 20389043.787 17676663.67
$ 39,869,664 35343186.7183 30390903.9709 25056587.774 20813365.968 17961818.425
$ 42,486,823 35938489.744 30853202.7853 25539639.025 21207222.056 18232268.727
$ 46,552,279 36754935.0895 31307182.1933 25983296.192 21574612.374 18489372.085
$ 36,806,540 36758621.1898 31696570.6931 26391387.228 21918667.721 18734321.773
$ 26,890,840 36100769.1246 31990183.9218 26764640.341 22241732.562 18968149.159
$ 29,338,344 35678117.5593 32220679.7742 27105642.805 22545726.952 19191747.771
$ 31,150,871 35411808.9328 32408393.2541 27417569.302 22832305.914 19405898.25
$ 39,733,674 35651912.5561 32588588.7709 27704848.162 23103002.706 19611292.942
$ 47,578,916 36279649.5714 32782855.1288 27972111.686 23359271.599 19808554.977
$ 53,707,292 37151031.7028 33001263.9575 28223569.3 23602486.484 19998251.552
$ 42,184,875 37390738.5094 33210286.5552 28461032.026 23833845.796 20180898.897
$ 28,429,859 36983425.8183 33381792.8853 28684702.974 24054339.304 20356964.37
$ 33,596,410 36836164.2806 33531982.946 28895454.278 24264822.564 20526871.248
$ 37,624,623 36869016.7304 33671026.0204 29094436.433 24466056.475 20691003.966
$ 41,943,461 37071994.4934 33807064.7593 29282941.567 24658731.879 20849713.082
$ 44,820,542 37370015.5541 33944101.3283 29462216.942 24843481.304 21003319.552
$ 50,146,013 37843200.6335 34088512.4137 29633561.219 25020891.671 21152118.52
$ 39,105,412 37888279.622 34224218.3854 29797513.26 25191485.3 21296381.619
$ 26,719,379 37503145.1027 34337284.8239 29954057.107 25355711.914 21436358.526
$ 29,896,862 37249602.3355 34434362.0743 30103400.606 25513968.203 21572278.848
$ 31,486,374 37063691.7319 34519179.1601 30245845.076 25666609.393 21704354.027
$ 34,545,088 36984985.3662 34596235.604 30381794.78 25813958.936 21832779.181
$ 37,091,854 36988223.8039 34668720.0949 30511701.608 25956314.775 21957734.805
$ 39,664,144 37066927.353 34739255.6025 30636041.431 26093953.794 22079388.304
$ 31,500,412 36907884.0523 34801216.4153 30755046.43 26227127.869 22197895.149
$ 22,720,047 36513777.46 34848787.5555 30868761.462 26356062.136 22313399.788
$ 24,902,490 36199958.8702 34885305.6991 30977316.711 26480960.908 22426036.575
$ 27,297,602 35965686.3208 34913736.7681 31080906.713 26602012.113 22535930.668
$ 30,324,873 35821050.082 34937001.212 31179780.931 26719390.801 22643198.876
$ 32,130,079 35728775.7946 34956795.5766 31274206.297 26833261.189 22747950.434
$ 35,676,207 35727493.6169 34975593.0898 31364484.024 26943778.819 22850287.712
$ 31,847,911 35635122.5979 34991296.1733 31450836.694 27051089.72 22950306.807
$ 25,334,954 35395583.7969 35000698.2111 31533391.613 27155329.299 23048098.028
$ 26,606,663 35195835.5974 35005133.1517 31612294.83 27256623.97 23143746.345
$ 28,216,167 35040731.8479 35005924.2338 31687708.816 27355092.523 23237331.816
$ 32,934,099 34994935.4714 35005685.3477 31759838.741 27450847.875 23328929.991
$ 38,253,944 35064276.0687 35006931.9588 31828925.831 27543998.47 23418612.299
$ 41,085,381 35189715.7463 35010739.9543 31895213.625 27634648.786 23506446.392
$ 32,154,327 35127769.0287 35013128.3028 31958844.537 27722897.679 23592496.419
$ 24,399,886 34913211.3677 35011129.9641 32019890.245 27808837.53 23676823.241
$ 30,429,441 34825294.2986 35007486.1275 32078470.557 27892555.825 23759484.664
$ 37,803,762 34882572.5277 35005083.9429 32134751.583 27974136.512 23840535.661
$ 42,574,787 35027708.6561 35005510.8243 32188916.852 28053660.67 23920028.586
$ 45,923,030 35229473.8691 35009658.2881 32241152.805 28131206.82 23998013.368
$ 52,310,969 35540046.5095 35019301.7103 32291664.603 28206851.507 24074537.698
$ 45,003,381 35709034.6274 35031618.3695 32340592.349 28280668.308 24149647.173
$ 35,169,455 35699568.3269 35043336.7898 32388008.918 28352726.915 24223385.414
$ 38,796,619 35752965.754 35055571.772 32434001.381 28423093.716 24295794.178
$ 41,783,320 35855175.1547 35069124.3717 32478664.482 28491832.204 24366913.466
$ 46,779,544 36037247.9764 35085259.7651 32522107.737 28559003.463 24436781.633
$ 52,850,650 36312877.5175 35105384.6463 32564456.539 28624666.628 24505435.485
$ 55,450,539 36621549.4734 35129838.9177 32605833.674 28688879 24572910.381
$ 40,636,190 36685273.9203 35154528.3622 32646289.145 28751695.034 24639240.296
$ 25,975,411 36517932.3063 35175831.5488 32685813.245 28813165.631 24704457.879
$ 28,270,130 36391043.0414 35194527.1102 32724408.843 28873338.603 24768594.506
$ 30,539,499 36302383.278 35211312.8097 32762089.206 28932259.067 24831680.332
$ 32,112,720 36239850.9894 35226664.1258 32798873.907 28989969.736 24893744.353
$ 33,751,471 36203257.1723 35241025.7883 32834787.905 29046511.18 24954814.454
$ 35,136,785 36187801.0591 35254747.169 32869859.778 29101922.029 25014917.462
$ 35,187,373 36173509.2345 35267872.3414 32904117.101 29156239.102 25074079.2
$ 35,040,305 36157548.6068 35280402.993 32937585.916 29209497.507 25132324.528
$ 36,470,295 36161892.3085 35292645.9002 32970295.082 29261730.807 25189677.393
$ 37,995,861 36187015.1629 35304897.5339 33002275.938 29312971.151 25246160.869
$ 39,248,659 36228388.7331 35317377.1447 33033561.089 29363249.394 25301797.201
$ 42,836,051 36316490.9002 35330698.6614 33064189.59 29412595.263 25356607.841
$ 45,961,575 36443399.9035 35345339.4673 33094204.72 29461037.493 25410613.495
$ 34,761,324 36421554.7657 35359316.2893 33123621.754 29508603.522 25463834.144
$ 23,967,767 36261890.8168 35370887.7576 33152432.856 29555319.283 25516289.082
$ 26,816,089 36142323.705 35380652.7696 33180638.172 29601209.395 25567996.934
$ 28,809,473 36050663.0712 35389027.8984 33208243.043 29646297.316 25618975.689
$ 32,308,883 36004468.2616 35396625.9276 33235260.116 29690605.499 25669242.724
$ 42,218,378 36080247.6448 35404962.7778 33261719.904 29734155.674 25718814.833
$ 49,121,524 36237371.4561 35414991.798 33287662.939 29776969.015 25767708.257
$ 35,900,210 36233357.635 35424734.24843 33313104.264 29819065.863 25815938.704
$ 24,391,236 36094038.5623 35432608.4168 33338039.607 29860465.554 25863521.373
$ 31,419,869 36039687.758 35439667.4789 33362477.141 29901186.619 25910470.969
$ 39,736,659 36082181.6764 35447052.6996 33386437.779 29941246.977 25956801.728
$ 44,925,467 36182673.5523 35455412.0275 33409948.85 29980664.044 26002527.436
$ 47,172,152 36306150.8421 35464970.8906 33433038.986 30019454.774 26047661.451
$ 49,288,779 36450402.271 35475920.1281 33455737.665 30057635.695 26092216.72
ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO
19471986.757 17375321.6911 15998880.231 15151879.926 14656190.3319 14377165.083

2266189.0535 1512345.9485 943955.05056 559008.83795 317703.816485 174877.67523

22408930.103 19471986.7575 17375321.691 15998880.231 15151879.9257 14656190.332
14055640.002 14055640.0015 14055640.002 14055640 14055640.0015 14055640.002

Costo total Costo total Costo total Costo total Costo total Costo total
(promedio (promedio (promedio (promedio (promedio (promedio
acumulado) acumulado) acumulado) acumulado) acumulado) acumulado)
CORRIDA 6 CORRIDA 7 CORRIDA 8 CORRIDA 9 CORRIDA 10 CORRIDA 11
14055640.002 14055640.0015 14055640.002 14055640 14055640.0015 14055640.002
14331721.457 14193680.7294 14124660.365 14090150.184 14072895.0925 14064267.547
14588868.906 14325410.1218 14191576.951 14123959.106 14089916.4303 14072817.175
14830148.602 14451594.7417 14256581.399 14157114.679 14106715.9925 14081291.879
15057979.911 14572871.7756 14319839.474 14189659.638 14123304.7216 14089694.448
15274239.821 14689766.4499 14381493.97 14221632.027 14139692.6058 14098027.474
15480323.131 14802703.1186 14441666.706 14253065.552 14155888.741 14106293.369
15677281.098 14912025.3661 14500461.538 14283990.051 14171901.4047 14114494.374
15865948.543 15018016.8302 14557967.682 14314432.01 14187738.1386 14122632.57
16047020.056 15120917.1527 14614262.629 14344415.071 14203405.8319 14130709.896
16221092.635 15220933.1057 14669414.49 14373960.473 14218910.7993 14138728.16
16388690.643 15318246.2337 14723483.802 14403087.417 14234258.8508 14146689.051
16550281.523 15413018.179 14776524.908 14431813.378 14249455.3529 14154594.151
16706284.398 15505394.3375 14828587.01 14460154.352 14264505.2814 14162444.946
16857075.382 15595506.4071 14879714.97 14488125.06 14279413.2666 14170242.834
17002992.406 15683474.2821 14929949.927 14515739.114 14294183.632 14177989.134
17144339.809 15769407.5484 14979329.787 14543009.154 14308820.4274 14185685.092
17281392.761 15853406.7268 15027889.617 14569946.957 14323327.4568 14193331.89
17414401.298 15935564.3358 15075661.971 14596563.537 14337708.3032 14200930.649
17543593.811 16015965.8096 15122677.163 14622869.218 14351966.3489 14208482.434
17669179.767 16094690.2838 15168963.502 14648873.708 14366104.7946 14215988.261
17791351.795 16171811.2616 15214547.491 14674586.152 14380126.6745 14223449.098
17910287.423 16247397.1816 15259453.999 14700015.189 14394034.8708 14230865.87
18026150.613 16321511.9079 15303706.412 14725168.99 14407832.1257 14238239.464
18139093.111 16394215.1561 15347326.762 14750055.301 14421521.0527 14245570.728
18249255.667 16465562.868 15390335.843 14774681.476 14435104.1459 14252860.475
18356769.106 16535607.5435 15432753.313 14799054.507 14448583.7889 14260109.486
18461755.267 16604398.5336 15474597.785 14823181.052 14461962.2626 14267318.514
18564327.793 16671982.3012 15515886.907 14847067.461 14475241.7522 14274488.281
18664592.828 16738402.6521 15556637.431 14870719.794 14488424.3536 14281619.483
18762649.641 16803700.9421 15596865.287 14894143.842 14501512.079 14288712.793
18858591.189 16867916.2623 15636585.63 14917345.148 14514506.8624 14295768.858
18952504.632 16931085.6068 15675812.902 14940329.019 14527410.5641 14302788.303
19044471.799 16993244.0242 15714560.876 14963100.544 14540224.9753 14309771.735
19134569.609 17054424.7552 15752842.701 14985664.606 14552951.8219 14316719.737
19222870.447 17114659.3578 15790670.941 15008025.893 14565592.7683 14323632.877
19309442.505 17173977.8212 15828057.614 15030188.912 14578149.4208 14330511.703
19394350.088 17232408.6703 15865014.221 15052158 14590623.3308 14337356.745
19477653.903 17289979.0609 15901551.781 15073937.327 14603015.9974 14344168.521
19559411.316 17346714.8673 15937680.858 15095530.915 14615328.8703 14350947.53
19639676.594 17402640.7631 15973411.587 15116942.639 14627563.3525 14357694.257
19718501.123 17457780.2955 16008753.699 15138176.236 14639720.8021 14364409.175
19795933.609 17512155.9539 16043716.542 15159235.313 14651802.5349 14371092.741
19872020.262 17565789.2337 16078309.104 15180123.353 14663809.8262 14377745.402
19946804.964 17618700.6944 16112540.028 15200843.724 14675743.9128 14384367.592
20020329.421 17670910.0145 16146417.636 15221399.678 14687605.9947 14390959.731
20092633.312 17722436.0421 16179949.943 15241794.365 14699397.2366 14397522.231
20163754.418 17773296.8416 16213144.67 15262030.83 14711118.7698 14404055.492
20233728.744 17823509.7376 16246009.263 15282112.022 14722771.6933 14410559.904
20302590.634 17873091.3555 16278550.905 15302040.8 14734357.0754 14417035.848
20370372.87 17922057.6597 16310776.527 15321819.932 14745875.955 14423483.693
20437106.77 17970423.9887 16342692.825 15341452.103 14757329.3424 14429903.802
20502822.276 18018205.0885 16374306.264 15360939.917 14768718.2212 14436296.527
20567548.037 18065415.1431 16405623.095 15380285.902 14780043.5486 14442662.212
20631311.485 18112067.8038 16436649.362 15399492.51 14791306.257 14449001.195
20694138.908 18158176.2164 16467390.913 15418562.125 14802507.2547 14455313.803
20756055.513 18203753.0462 16497853.407 15437497.059 14813647.4267 14461600.358
20817085.49 18248810.5021 16528042.322 15456299.564 14824727.6359 14467861.173
20877252.066 18293360.3592 16557962.967 15474971.825 14835748.7239 14474096.555
20936577.559 18337413.9792 16587620.484 15493515.969 14846711.5113 14480306.804
20995083.427 18380982.3308 16617019.858 15511934.066 14857616.7991 14486492.214
21052790.313 18424076.0079 16646165.925 15530228.128 14868465.3689 14492653.072
21109718.091 18466705.2473 16675063.375 15548400.116 14879257.9839 14498789.657
21165885.9 18508879.945 16703716.759 15566451.939 14889995.3895 14504902.247
21221312.186 18550609.6718 16732130.496 15584385.455 14900678.3136 14510991.11
21276014.734 18591903.6879 16760308.878 15602202.476 14911307.4676 14517056.509
21330010.698 18632770.9567 16788256.073 15619904.769 14921883.5467 14523098.704
21383316.636 18673220.1578 16815976.133 15637494.054 14932407.2306 14529117.947
21435948.532 18713259.6995 16843472.996 15654972.009 14942879.1839 14535114.486
21487921.827 18752897.7299 16870750.492 15672340.273 14953300.0566 14541088.566
21539251.443 18792142.1484 16897812.347 15689600.444 14963670.4846 14547040.424
21589951.803 18831000.6158 16924662.184 15706754.079 14973991.0901 14552970.294
21640036.859 18869480.5643 16951303.531 15723802.701 14984262.482 14558878.406
21689520.107 18907589.2068 16977739.824 15740747.798 14994485.2566 14564764.985
21738414.61 18945333.5455 17003974.407 15757590.819 15004659.9974 14570630.252
21786733.016 18982720.3806 17030010.538 15774333.184 15014787.2762 14576474.424
21834487.576 19019756.3182 17055851.393 15790976.277 15024867.6528 14582297.712
21881690.16 19056447.7777 17081500.064 15807521.454 15034901.6759 14588100.327
21928352.271 19092800.9992 17106959.57 15823970.038 15044889.883 14593882.473
21974485.063 19128822.05 17132232.851 15840323.323 15054832.801 14599644.353
22020099.355 19164516.8315 17157322.777 15856582.576 15064730.9464 14605386.162
22065205.642 19199891.0853 17182232.146 15872749.034 15074584.8255 14611108.097
22109814.107 19234950.3988 17206963.691 15888823.909 15084394.9349 14616810.348
22153934.638 19269700.2112 17231520.079 15904808.387 15094161.7618 14622493.103
22197576.835 19304145.8185 17255903.911 15920703.629 15103885.7837 14628156.547
22240750.022 19338292.379 17280117.73 15936510.77 15113567.4696 14633800.86
 22283463.26 19372144.9179 17304164.02 15952230.922 15123207.2794 14639426.221
22325725.353 19405708.3319 17328045.205 15967865.175 15132805.6646 14645032.805
22367544.86 19438987.3941 17351763.657 15983414.596 15142363.0683 14650620.786
22408930.103 19471986.7575 17375321.691 15998880.231 15151879.9257 14656190.332
ESTADISTICO ESTADISTICO ESTADISTICO ESTADISTICO
14224745.742 14143380.775 14100700.4101 14078605.649 20071286.5 PROMEDIO
DESVIACION
93912.305767 49488.604119 25708.3403333 13212.7034151 1597185.17 ESTANDAR
14377165.083 14224745.742 14143380.7749 14100700.4101 37888279.6 MAXIMO
14055640.002 14055640.002 14055640.0015 14055640.0015 14055640 MINIMO

Costo total Costo total Costo total Costo total

(promedio (promedio (promedio (promedio
acumulado) acumulado) acumulado) acumulado)
CORRIDA 12 CORRIDA 13 CORRIDA 14 CORRIDA 15
14055640.002 14055640.002 14055640.0015 14055640.0015
14059953.774 14057796.888 14056718.4447 14056179.2231
14064241.574 14059945.117 14057794.0021 14056717.4828
14068504.151 14062084.875 14058866.7203 14057254.7922
14072742.21 14064216.342 14059936.6447 14057791.1627 PROMEDIO PROMEDIO
14076956.421 14066339.689 14061003.8187 14058326.6053 35475920.128 35.5
14081147.413 14068455.078 14062068.2843 14058861.1309 33455737.665 33.5
14085315.783 14070562.666 14063130.082 14059394.7498 30057635.695 30.1
14089462.093 14072662.602 14064189.2509 14059927.4721 26092216.72 26.1
14093586.873 14074755.029 14065245.8288 14060459.3078 22408930.103 22.4
14097690.627 14076840.084 14066299.852 14060990.2664 19471986.757 19.5
14101773.829 14078917.896 14067351.3556 14061520.3571 17375321.691 17.4
14105836.93 14080988.591 14068400.3737 14062049.5892 15998880.231 16.0
14109880.36 14083052.289 14069446.9391 14062577.9713 15151879.926 15.2
14113904.525 14085109.104 14070491.0834 14063105.5121 14656190.332 14.7
14117909.813 14087159.149 14071532.8375 14063632.22 14377165.083 14.4
14121896.594 14089202.528 14072572.2311 14064158.103 14224745.742 14.2
14125865.222 14091239.344 14073609.2929 14064683.1691 14143380.775 14.1
14129816.034 14093269.696 14074644.051 14065207.426 14100700.41 14.1
14133749.354 14095293.679 14075676.5324 14065730.8813 14078605.649 14.1
14137665.492 14097311.385 14076706.7634 14066253.5424
14141564.747 14099322.901 14077734.7697 14066775.4164
14145447.405 14101328.314 14078760.576 14067296.5103
14149313.74 14103327.707 14079784.2064 14067816.8309
14153164.02 14105321.159 14080805.6845 14068336.3851
14156998.499 14107308.749 14081825.0332 14068855.1792
14160817.424 14109290.552 14082842.2746 14069373.2198
14164621.035 14111266.641 14083857.4306 14069890.513
14168409.56 14113237.086 14084870.5221 14070407.0651
14172183.225 14115201.958 14085881.57 14070922.8819
14175942.243 14117161.322 14086890.5942 14071437.9694
14179686.825 14119115.244 14087897.6145 14071952.3333
14183417.172 14121063.787 14088902.6501 14072465.9793
14187133.483 14123007.013 14089905.7196 14072978.9128
14190835.947 14124944.983 14090906.8414 14073491.1393
14194524.751 14126877.754 14091906.0334 14074002.6642
14198200.074 14128805.384 14092903.3132 14074513.4925
14201862.092 14130727.929 14093898.6978 14075023.6295
14205510.975 14132645.443 14094892.2041 14075533.0801
14209146.888 14134557.979 14095883.8485 14076041.8494
14212769.995 14136465.59 14096873.647 14076549.942
14216380.452 14138368.324 14097861.6156 14077057.3628
14219978.412 14140266.233 14098847.7695 14077564.1164
14223564.025 14142159.365 14099832.1239 14078070.2075
14227137.438 14144047.767 14100814.6937 14078575.6405
14230698.792 14145931.485 14101795.4935 14079080.4199
14234248.227 14147810.564 14102774.5376 14079584.5501
14237785.878 14149685.05 14103751.8399 14080088.0353
14241311.879 14151554.985 14104727.4143 14080590.8798
14244826.358 14153420.413 14105701.2743 14081093.0877
14248329.443 14155281.374 14106673.4331 14081594.6631
14251821.258 14157137.91 14107643.9038 14082095.61
14255301.923 14158990.062 14108612.6993 14082595.9324
14258771.558 14160837.867 14109579.832 14083095.6343
14262230.279 14162681.365 14110545.3144 14083594.7194
14265678.199 14164520.595 14111509.1587 14084093.1915
14269115.43 14166355.592 14112471.3768 14084591.0544
14272542.081 14168186.393 14113431.9806 14085088.3118
14275958.258 14170013.035 14114390.9815 14085584.9672
14279364.067 14171835.552 14115348.391 14086081.0242
14282759.611 14173653.979 14116304.2203 14086576.4865
14286144.989 14175468.351 14117258.4805 14087071.3573
14289520.301 14177278.699 14118211.1824 14087565.6403
14292885.644 14179085.057 14119162.3367 14088059.3387
14296241.113 14180887.458 14120111.9539 14088552.4558
14299586.801 14182685.933 14121060.0445 14089044.995
14302922.799 14184480.513 14122006.6187 14089536.9596
14306249.198 14186271.229 14122951.6865 14090028.3526
14309566.087 14188058.111 14123895.2579 14090519.1773
14312873.551 14189841.189 14124837.3426 14091009.4368
14316171.676 14191620.492 14125777.9503 14091499.1342
14319460.545 14193396.048 14126717.0906 14091988.2725
14322740.242 14195167.886 14127654.7727 14092476.8547
14326010.847 14196936.034 14128591.006 14092964.8838
14329272.439 14198700.52 14129525.7995 14093452.3626
14332525.096 14200461.369 14130459.1622 14093939.2942
14335768.897 14202218.61 14131391.1031 14094425.6813
14339003.915 14203972.268 14132321.6309 14094911.5268
14342230.226 14205722.368 14133250.7541 14095396.8335
14345447.902 14207468.938 14134178.4814 14095881.6041
14348657.017 14209212 14135104.8212 14096365.8414
14351857.64 14210951.581 14136029.7816 14096849.548
14355049.841 14212687.705 14136953.3711 14097332.7265
14358233.689 14214420.395 14137875.5976 14097815.3798
14361409.252 14216149.676 14138796.4691 14098297.5102
14364576.597 14217875.57 14139715.9935 14098779.1205
14367735.788 14219598.102 14140634.1787 14099260.2131
14370886.89 14221317.292 14141551.0322 14099740.7906
14374029.968 14223033.165 14142466.5618 14100220.8555
14377165.083 14224745.742 14143380.7749 14100700.4101
ALFA 0.1
ERROR € 200
DESVIACION ESTANDAR (S) 1597185.17
PROMEDIO (x) 20071286.5
REPLICAS 15
GRADOS DE LIBERTAD 14
T-STUDENT -1.34503037

LIMITE SUPERIOR 21915557

LIMITE INFERIOR 18227015.9

PROMEDIO
40.0

35.0

30.0

25.0

20.0

15.0

10.0

5.0

0.0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
 Análisis: si analizamos este trabajo podemos darnos cuenta que el almacén evaluado necesita mejorar la venta del produc
mercancía en bodega o stock lo cual nos da a entender que no tenemos una demanda razonable y debemos aumentarla ya
perdida),realizando una apertura de nuevos puntos de ventas en diferentes zonas para así poder hacer un buen estudio de
bultos de café ,también debemos mantener una buena rotación de stock para así evitar el daño de mercancía, nos podemos
en los 90 días planteados, por ello llego a la conclusión que a la empresa le hace falta un buen estudio de marketing y prom
logramos traer los 7000 bultos de café se estaría gastando la misma cantidad de dinero en transporte que si trajéramos 30
én evaluado necesita mejorar la venta del producto de café, ya que nos damos cuenta que la mayoría de veces queda
una demanda razonable y debemos aumentarla ya sea poniendo promociones, disminuyendo los precios(sin significar
s zonas para así poder hacer un buen estudio de marketing a todos los puntos de venta y aumentar la demanda de los
ara así evitar el daño de mercancía, nos podemos dar cuenta que nuestra empresa al tener pocas ventas no se estabiliza
e hace falta un buen estudio de marketing y promocionarse para así aumentar ventas, aumentando ganancias ya que si
dad de dinero en transporte que si trajéramos 3000 o 5000, ello tiene como significado un margen de ganancia mayor.