Costo de
Entregas del Inventario Inventario Costo de
Día Demanda Ventas llevar el
proveedor inicial Final ordenar inventario
0 700 700 195.032354 195.032354 504.967646 1000 602.483823
1 0 504.967646 28.4320747 28.4320747 476.535571 0 490.751608
2 0 476.535571 31.5363736 31.5363736 444.999197 0 460.767384
3 0 444.999197 35.6952228 35.6952228 409.303975 0 427.151586
4 0 409.303975 5.86759247 5.86759247 403.436382 0 406.370178
5 0 403.436382 41.5787726 41.5787726 361.85761 0 382.646996
6 0 361.85761 99.4550583 99.4550583 262.402551 0 312.13008
7 437.597449 700 9.19715969 9.19715969 690.80284 1000 695.40142
8 0 690.80284 13.2620982 13.2620982 677.540742 0 684.171791
9 0 677.540742 187.131222 187.131222 490.40952 0 583.975131
10 0 490.40952 389.119276 389.119276 101.290245 0 295.849883
11 0 101.290245 48.5323547 48.5323547 52.75789 0 77.0240674
12 0 52.75789 5.82345192 5.82345192 46.9344381 0 49.846164
13 0 46.9344381 104.930548 46.9344381 0 0 23.467219
14 700 700 256.864289 256.864289 443.135711 1000 571.567855
15 0 443.135711 4.0214968 4.0214968 439.114214 0 441.124962
16 0 439.114214 15.9948513 15.9948513 423.119363 0 431.116788
17 0 423.119363 261.536236 261.536236 161.583127 0 292.351245
18 0 161.583127 71.675981 71.675981 89.907146 0 125.745137
19 0 89.907146 4.5891391 4.5891391 85.3180069 0 87.6125765
20 0 85.3180069 354.787786 85.3180069 0 0 42.6590035
21 700 700 7.08554362 7.08554362 692.914456 1000 696.457228
22 0 692.914456 76.676214 76.676214 616.238242 0 654.576349
23 0 616.238242 35.8957705 35.8957705 580.342472 0 598.290357
24 0 580.342472 92.9247356 92.9247356 487.417736 0 533.880104
25 0 487.417736 104.932793 104.932793 382.484944 0 434.95134
26 0 382.484944 128.941443 128.941443 253.543501 0 318.014222
27 0 253.543501 124.564194 124.564194 128.979307 0 191.261404
28 571.020693 700 9.00490569 9.00490569 690.995094 1000 695.497547
29 0 690.995094 141.855051 141.855051 549.140043 0 620.067569
30 0 549.140043 45.4032457 45.4032457 503.736797 0 526.43842
31 0 503.736797 66.3163754 66.3163754 437.420422 0 470.578609
32 0 437.420422 10.0978266 10.0978266 427.322595 0 432.371508
33 0 427.322595 25.1394807 25.1394807 402.183114 0 414.752855
34 0 402.183114 87.9297618 87.9297618 314.253353 0 358.218234
35 385.746647 700 20.474977 20.474977 679.525023 1000 689.762511
36 0 679.525023 74.8918108 74.8918108 604.633212 0 642.079118
37 0 604.633212 208.549519 208.549519 396.083693 0 500.358452
38 0 396.083693 367.57844 367.57844 28.5052528 0 212.294473
39 0 28.5052528 107.3204 28.5052528 0 0 14.2526264
40 0 0 148.32209 0 0 0 0
41 0 0 64.6077859 0 0 0 0
42 700 700 1.31829196 1.31829196 698.681708 1000 699.340854
43 0 698.681708 27.3619821 27.3619821 671.319726 0 685.000717
44 0 671.319726 333.90986 333.90986 337.409866 0 504.364796
45 0 337.409866 106.394319 106.394319 231.015547 0 284.212706
46 0 231.015547 59.8536328 59.8536328 171.161914 0 201.088731
47 0 171.161914 14.193859 14.193859 156.968055 0 164.064985
48 0 156.968055 50.5467956 50.5467956 106.42126 0 131.694658
49 593.57874 700 261.059312 261.059312 438.940688 1000 569.470344
50 0 438.940688 113.360921 113.360921 325.579767 0 382.260228
51 0 325.579767 19.1482619 19.1482619 306.431505 0 316.005636
52 0 306.431505 85.9760936 85.9760936 220.455411 0 263.443458
53 0 220.455411 221.101143 220.455411 0 0 110.227706
54 0 0 29.5169169 0 0 0 0
55 0 0 105.522411 0 0 0 0
56 700 700 194.929004 194.929004 505.070996 1000 602.535498
57 0 505.070996 123.60355 123.60355 381.467446 0 443.269221
58 0 381.467446 46.1579277 46.1579277 335.309518 0 358.388482
59 0 335.309518 146.602131 146.602131 188.707387 0 262.008453
60 0 188.707387 76.6691606 76.6691606 112.038227 0 150.372807
Inventario final
Costo Costo 800
Costo total
faltante promedio
700
0 1602.48382 1602.48382 600
0 490.751608 1046.61772
500
0 460.767384 851.334272
0 427.151586 745.2886 400
0 406.370178 677.504916 300
0 382.646996 628.361929
200
0 312.13008 583.185951
0 1695.40142 722.212885 100
0 684.171791 717.986096 0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 61
0 583.975131 704.585
0 295.849883 667.427262
0 77.0240674 618.226996
0 49.846164 574.505393 Costo promedio
347.976662 371.443881 560.001 1800
0 1571.56786 627.43879 1600
0 441.124962 615.794176
1400
0 431.116788 604.9308
1200
0 292.351245 587.565269
0 125.745137 563.258946 1000
0 87.6125765 539.476628 800
1616.81868 1659.47768 592.810011 600
0 1696.45723 642.975794 400
0 654.576349 643.480166
200
0 598.290357 641.597257
0
0 533.880104 637.288571 0 10 20 30 40 50 60 70
0 434.95134 629.50637
0 318.014222 617.969624
0 191.261404 602.730044
0 1695.49755 640.411682
0 620.067569 639.733545
0 526.43842 636.078864
0 470.578609 630.906981
0 432.371508 624.890754
0 414.752855 618.710228
0 358.218234 611.2676
0 1689.76251 641.225792
0 642.079118 641.248854
0 500.358452 637.541212
0 212.294473 626.63745
472.89088 487.143507 623.150101
889.932541 889.932541 629.65699
387.646715 387.646715 623.894841
0 1699.34085 648.905213
0 685.000717 649.725565
0 504.364796 646.495326
0 284.212706 638.619617
0 201.088731 629.310449
0 164.064985 619.617835
0 131.694658 609.660219
0 1569.47034 628.856422
0 382.260228 624.021202
0 316.005636 618.097826
0 263.443458 611.406234
3.87438961 114.102095 602.196898
177.101501 177.101501 594.467891
633.134468 633.134468 595.158366
0 1602.5355 612.831649
0 443.269221 609.908159
0 358.388482 605.645113
0 262.008453 599.917836
0 150.372807 592.548245
40 43 46 49 52 55 58 61
50 60 70