Proyecto-Simulacion Gerencial Excel

  • Upload
    demi

  • View
    234

  • Download
    0

Embed Size (px)

Citation preview

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    1/294

    Demanda inicial de queso 100 UNIDADES

    Produccion de queso. 9 PERSONAS

    Personal necesario1

    Valor jornal 10,000 PESOS

    Valor litro de leche 2,000 PESOS

    Litros de leche por produccion de queso 1.5 LITROS

    Precio queso 5,000 PESOS

    Tasa aumento precio del queso 0.1%

    Venta sourcream 500 PESOS

    Litros por produccion de queso 3,000 PESOS

    Cap. Prod. por persona Sourcream 3 LITROS

    Litros de leche por prod. De Sourcream 1 LITROS

    RESUMEN DATOS ARROJADOS POR LA SIMULACION

    Demanda Promedio produccion Leche 1

    Co!o de Mano de O"ra Promedio 111#

    Co!o de Ma!eria&e Promedio ' $(5

    In*reo Promedio por +en!a de ,ueo ' 1#5-

    In*reo Promedio por +en!a de Sour ' %

    U!i&idad Promedio ' 1#/.

    DIA VALOR !"SO RA#D. L"C$"

    1 5000 77 5%

    2 5005 38 5%

    3 5010 84 5%

    4 5015 5 5%

    5 5020 39 5%

    6 5025 80 -5%

    7 5030 14 5%

    8 5035 72 5%

    9 5040 21 -5%

    10 5045 25 5%

    PORC. D"MA#DAL"C$"

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    2/294

    11 5050 32 5%

    12 5055 100 -5%

    13 5060 82 -5%

    14 5065 38 5%

    15 5070 19 -5%

    16 5076 21 5%

    17 5081 38 -5%

    18 5086 84 -5%

    19 5091 17 -5%

    20 5096 92 5%

    21 5101 68 5%

    22 5106 98 5%

    23 5111 44 -5%

    24 5116 55 5%

    25 5121 91 -5%

    26 5127 82 5%

    27 5132 9 5%

    28 5137 67 -5%

    29 5142 11 5%

    30 5147 82 -5%

    31 5152 19 5%

    32 5157 3 -5%

    33 5163 19 5%

    34 5168 2 5%

    35 5173 8 5%

    36 5178 57 -5%

    37 5183 82 -5%

    38 5188 21 5%

    39 5194 29 5%

    40 5199 3 5%

    41 5204 45 5%

    42 5209 60 5%

    43 5214 3 -5%

    44 5220 27 -5%

    45 5225 98 5%

    46 5230 21 -5%

    47 5235 47 5%

    48 5240 35 5%

    49 5246 5 5%

    50 5251 63 5%

    51 5256 27 -5%

    52 5261 73 5%

    53 5267 61 5%

    54 5272 70 -5%

    55 5277 27 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    3/294

    56 5283 51 5%

    57 5288 52 5%

    58 5293 35 -5%

    59 5298 18 5%

    60 5304 62 5%

    61 5309 16 -5%

    62 5314 37 -5%

    63 5320 65 5%

    64 5325 35 5%

    65 5330 39 -5%

    66 5336 72 5%

    67 5341 91 -5%

    68 5346 20 5%

    69 5352 92 -5%

    70 5357 19 5%

    71 5362 22 5%

    72 5368 37 -5%

    73 5373 79 5%

    74 5378 24 5%

    75 5384 63 -5%

    76 5389 76 5%

    77 5395 45 -5%

    78 5400 10 5%

    79 5405 11 -5%

    80 5411 50 5%

    81 5416 73 5%

    82 5422 37 -5%

    83 5427 22 -5%

    84 5432 33 5%

    85 5438 7 5%

    86 5443 48 5%

    87 5449 84 -5%

    88 5454 58 -5%

    89 5460 82 5%

    90 5465 2 -5%

    91 5471 19 5%

    92 5476 98 5%

    93 5482 38 -5%

    94 5487 83 5%

    95 5493 32 -5%

    96 5498 76 5%

    97 5504 54 5%

    98 5509 23 5%

    99 5515 95 5%

    100 5520 46 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    4/294

    101 5526 42 -5%

    102 5531 17 5%

    103 5537 82 5%

    104 5542 21 5%

    105 5548 40 -5%

    106 5553 45 -5%

    107 5559 97 5%

    108 5564 85 -5%

    109 5570 54 5%

    110 5576 7 5%

    111 5581 34 -5%

    112 5587 26 5%

    113 5592 44 -5%

    114 5598 56 -5%

    115 5603 59 -5%

    116 5609 50 5%

    117 5615 3 -5%

    118 5620 43 5%

    119 5626 7 5%

    120 5632 85 5%

    121 5637 44 -5%

    122 5643 26 -5%

    123 5648 83 5%

    124 5654 81 5%

    125 5660 9 -5%

    126 5665 15 -5%

    127 5671 57 -5%

    128 5677 63 5%

    129 5682 37 5%

    130 5688 51 5%

    131 5694 8 -5%

    132 5699 79 -5%

    133 5705 67 5%

    134 5711 89 -5%

    135 5717 99 -5%

    136 5722 7 5%

    137 5728 33 -5%

    138 5734 95 5%

    139 5739 92 5%

    140 5745 87 5%

    141 5751 2 5%

    142 5757 26 -5%

    143 5762 13 -5%

    144 5768 45 -5%

    145 5774 81 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    5/294

    146 5780 72 5%

    147 5786 94 -5%

    148 5791 84 -5%

    149 5797 14 5%

    150 5803 1 -5%

    151 5809 68 5%

    152 5815 58 5%

    153 5820 27 5%

    154 5826 51 5%

    155 5832 39 5%

    156 5838 35 -5%

    157 5844 65 -5%

    158 5850 95 -5%

    159 5855 97 5%

    160 5861 2 5%

    161 5867 46 5%

    162 5873 5 5%

    163 5879 80 5%

    164 5885 13 5%

    165 5891 94 -5%

    166 5896 79 -5%

    167 5902 20 5%

    168 5908 27 -5%

    169 5914 73 -5%

    170 5920 11 -5%

    171 5926 13 5%

    172 5932 75 5%

    173 5938 36 -5%

    174 5944 26 -5%

    175 5950 19 5%

    176 5956 16 5%

    177 5962 97 -5%

    178 5968 13 -5%

    179 5974 99 -5%

    180 5980 11 5%

    181 5986 14 5%

    182 5992 67 -5%

    183 5998 68 5%

    184 6004 40 5%

    185 6010 18 5%

    186 6016 7 -5%

    187 6022 75 5%

    188 6028 82 5%

    189 6034 1 5%

    190 6040 72 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    6/294

    191 6046 84 5%

    192 6052 47 -5%

    193 6058 76 -5%

    194 6064 64 5%

    195 6070 59 -5%

    196 6076 69 5%

    197 6082 42 -5%

    198 6088 78 5%

    199 6094 95 -5%

    200 6100 15 -5%

    201 6106 88 5%

    202 6113 8 -5%

    203 6119 89 5%

    204 6125 24 5%

    205 6131 33 5%

    206 6137 8 5%

    207 6143 39 5%

    208 6149 30 5%

    209 6155 20 -5%

    210 6162 38 5%

    211 6168 40 5%

    212 6174 33 -5%

    213 6180 5 -5%

    214 6186 8 -5%

    215 6192 73 -5%

    216 6199 22 5%

    217 6205 14 -5%

    218 6211 48 -5%

    219 6217 4 -5%

    220 6223 14 -5%

    221 6230 19 5%

    222 6236 87 5%

    223 6242 60 -5%

    224 6248 95 -5%

    225 6255 50 5%

    226 6261 19 5%

    227 6267 64 -5%

    228 6273 92 5%

    229 6280 97 5%

    230 6286 59 -5%

    231 6292 7 5%

    232 6299 84 5%

    233 6305 67 -5%

    234 6311 95 5%

    235 6317 8 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    7/294

    236 6324 100 5%

    237 6330 3 5%

    238 6336 47 -5%

    239 6343 29 -5%

    240 6349 22 -5%

    241 6355 84 5%

    242 6362 68 -5%

    243 6368 55 5%

    244 6375 89 5%

    245 6381 75 -5%

    246 6387 28 5%

    247 6394 10 5%

    248 6400 88 -5%

    249 6407 75 -5%

    250 6413 13 5%

    251 6419 2 5%

    252 6426 94 5%

    253 6432 100 -5%

    254 6439 62 5%

    255 6445 89 -5%

    256 6451 50 5%

    257 6458 80 5%

    258 6464 52 5%

    259 6471 42 -5%

    260 6477 76 5%

    261 6484 11 -5%

    262 6490 48 -5%

    263 6497 60 -5%

    264 6503 77 5%

    265 6510 42 5%

    266 6516 68 5%

    267 6523 77 5%

    268 6529 44 5%

    269 6536 14 5%

    270 6542 5 -5%

    271 6549 66 -5%

    272 6555 98 -5%

    273 6562 72 5%

    274 6569 21 -5%

    275 6575 86 -5%

    276 6582 47 5%

    277 6588 48 -5%

    278 6595 95 5%

    279 6602 35 -5%

    280 6608 23 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    8/294

    281 6615 8 5%

    282 6621 36 -5%

    283 6628 16 -5%

    284 6635 8 5%

    285 6641 98 5%

    286 6648 4 -5%

    287 6655 57 -5%

    288 6661 78 -5%

    289 6668 56 5%

    290 6674 98 5%

    291 6681 53 5%

    292 6688 67 5%

    293 6695 45 -5%

    294 6701 13 -5%

    295 6708 44 5%

    296 6715 87 -5%

    297 6721 81 5%

    298 6728 20 5%

    299 6735 31 5%

    300 6742 94 -5%

    301 6748 24 5%

    302 6755 97 -5%

    303 6762 91 5%

    304 6769 96 5%

    305 6775 17 -5%

    306 6782 76 -5%

    307 6789 42 5%

    308 6796 65 5%

    309 6802 71 -5%

    310 6809 76 -5%

    311 6816 87 -5%

    312 6823 79 -5%

    313 6830 12 -5%

    314 6837 3 5%

    315 6843 86 5%

    316 6850 9 -5%

    317 6857 6 5%

    318 6864 43 5%

    319 6871 86 -5%

    320 6878 62 5%

    321 6885 41 5%

    322 6891 39 -5%

    323 6898 29 -5%

    324 6905 86 5%

    325 6912 52 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    9/294

    326 6919 72 5%

    327 6926 73 5%

    328 6933 32 5%

    329 6940 91 -5%

    330 6947 4 -5%

    331 6954 26 5%

    332 6961 15 5%

    333 6968 100 5%

    334 6975 16 5%

    335 6982 10 -5%

    336 6989 16 5%

    337 6996 92 -5%

    338 7003 52 5%

    339 7010 81 5%

    340 7017 63 5%

    341 7024 28 -5%

    342 7031 67 5%

    343 7038 42 -5%

    344 7045 39 -5%

    345 7052 69 -5%

    346 7059 28 -5%

    347 7066 48 5%

    348 7073 75 5%

    349 7080 70 5%

    350 7087 34 -5%

    351 7094 37 -5%

    352 7101 11 -5%

    353 7108 72 5%

    354 7115 65 5%

    355 7123 97 5%

    356 7130 24 5%

    357 7137 36 -5%

    358 7144 69 5%

    359 7151 55 -5%

    360 7158 27 5%

    361 7165 72 5%

    362 7173 81 -5%

    363 7180 41 -5%

    364 7187 71 5%

    365 7194 96 -5%

    366 7201 51 5%

    367 7208 87 5%

    368 7216 88 5%

    369 7223 2 -5%

    370 7230 68 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    10/294

    371 7237 51 5%

    372 7245 29 5%

    373 7252 34 -5%

    374 7259 92 5%

    375 7266 68 5%

    376 7274 3 -5%

    377 7281 19 -5%

    378 7288 15 -5%

    379 7295 78 5%

    380 7303 89 5%

    381 7310 48 -5%

    382 7317 14 5%

    383 7325 99 -5%

    384 7332 20 5%

    385 7339 79 5%

    386 7347 95 -5%

    387 7354 43 5%

    388 7361 15 5%

    389 7369 64 -5%

    390 7376 98 -5%

    391 7383 41 5%

    392 7391 35 5%

    393 7398 78 -5%

    394 7406 82 -5%

    395 7413 6 -5%

    396 7420 74 -5%

    397 7428 32 5%

    398 7435 93 5%

    399 7443 62 -5%

    400 7450 33 5%

    401 7458 60 5%

    402 7465 12 -5%

    403 7473 61 -5%

    404 7480 94 -5%

    405 7488 3 -5%

    406 7495 29 -5%

    407 7502 96 -5%

    408 7510 21 5%

    409 7518 43 5%

    410 7525 74 5%

    411 7533 9 -5%

    412 7540 91 5%

    413 7548 88 5%

    414 7555 8 5%

    415 7563 10 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    11/294

    416 7570 66 -5%

    417 7578 2 5%

    418 7585 53 -5%

    419 7593 80 -5%

    420 7601 66 -5%

    421 7608 51 5%

    422 7616 21 -5%

    423 7623 100 5%

    424 7631 29 -5%

    425 7639 2 -5%

    426 7646 6 5%

    427 7654 3 5%

    428 7662 33 5%

    429 7669 98 -5%

    430 7677 64 5%

    431 7685 65 -5%

    432 7692 57 -5%

    433 7700 75 5%

    434 7708 26 5%

    435 7715 50 -5%

    436 7723 77 5%

    437 7731 54 -5%

    438 7739 46 5%

    439 7746 98 -5%

    440 7754 97 -5%

    441 7762 19 5%

    442 7770 6 -5%

    443 7777 87 5%

    444 7785 7 -5%

    445 7793 13 -5%

    446 7801 97 5%

    447 7809 72 5%

    448 7816 15 -5%

    449 7824 50 5%

    450 7832 52 5%

    451 7840 80 -5%

    452 7848 100 -5%

    453 7855 72 -5%

    454 7863 80 -5%

    455 7871 29 5%

    456 7879 73 5%

    457 7887 85 5%

    458 7895 31 -5%

    459 7903 6 -5%

    460 7911 83 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    12/294

    461 7919 94 5%

    462 7926 71 5%

    463 7934 39 5%

    464 7942 68 5%

    465 7950 96 5%

    466 7958 89 -5%

    467 7966 45 5%

    468 7974 50 -5%

    469 7982 35 5%

    470 7990 42 -5%

    471 7998 46 5%

    472 8006 54 5%

    473 8014 47 -5%

    474 8022 32 5%

    475 8030 60 -5%

    476 8038 60 5%

    477 8046 29 -5%

    478 8054 32 -5%

    479 8062 75 5%

    480 8070 78 5%

    481 8078 83 -5%

    482 8087 55 5%

    483 8095 78 5%

    484 8103 55 5%

    485 8111 34 -5%

    486 8119 6 5%

    487 8127 28 5%

    488 8135 19 -5%

    489 8143 36 5%

    490 8151 33 -5%

    491 8160 1 -5%

    492 8168 30 5%

    493 8176 3 5%

    494 8184 40 5%

    495 8192 97 5%

    496 8200 99 5%

    497 8209 28 -5%

    498 8217 41 -5%

    499 8225 48 -5%

    500 8233 63 -5%

    501 8242 82 -5%

    502 8250 93 5%

    503 8258 16 5%

    504 8266 29 5%

    505 8275 25 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    13/294

    506 8283 76 5%

    507 8291 89 5%

    508 8299 53 5%

    509 8308 7 5%

    510 8316 63 5%

    511 8324 30 -5%

    512 8333 89 -5%

    513 8341 17 -5%

    514 8349 8 -5%

    515 8358 43 -5%

    516 8366 50 -5%

    517 8374 13 -5%

    518 8383 71 -5%

    519 8391 69 5%

    520 8400 49 5%

    521 8408 3 5%

    522 8416 69 5%

    523 8425 78 5%

    524 8433 6 5%

    525 8442 8 -5%

    526 8450 75 5%

    527 8459 4 5%

    528 8467 36 -5%

    529 8475 15 -5%

    530 8484 51 -5%

    531 8492 98 -5%

    532 8501 97 5%

    533 8509 43 -5%

    534 8518 14 -5%

    535 8526 26 -5%

    536 8535 67 -5%

    537 8543 89 -5%

    538 8552 14 5%

    539 8561 20 5%

    540 8569 95 -5%

    541 8578 77 5%

    542 8586 50 5%

    543 8595 84 5%

    544 8603 93 -5%

    545 8612 57 5%

    546 8621 27 -5%

    547 8629 43 -5%

    548 8638 70 -5%

    549 8647 97 5%

    550 8655 11 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    14/294

    551 8664 18 -5%

    552 8673 99 5%

    553 8681 79 -5%

    554 8690 96 5%

    555 8699 4 -5%

    556 8707 87 5%

    557 8716 70 -5%

    558 8725 8 5%

    559 8733 22 -5%

    560 8742 85 -5%

    561 8751 58 5%

    562 8760 20 -5%

    563 8768 82 -5%

    564 8777 100 5%

    565 8786 34 5%

    566 8795 7 5%

    567 8804 67 5%

    568 8812 22 5%

    569 8821 21 5%

    570 8830 86 -5%

    571 8839 17 -5%

    572 8848 97 -5%

    573 8857 35 5%

    574 8865 1 -5%

    575 8874 90 -5%

    576 8883 92 5%

    577 8892 27 5%

    578 8901 32 -5%

    579 8910 61 5%

    580 8919 23 -5%

    581 8928 42 5%

    582 8937 79 5%

    583 8945 22 -5%

    584 8954 21 -5%

    585 8963 74 5%

    586 8972 26 5%

    587 8981 7 -5%

    588 8990 44 -5%

    589 8999 33 -5%

    590 9008 29 5%

    591 9017 29 -5%

    592 9026 91 -5%

    593 9035 49 5%

    594 9044 10 -5%

    595 9053 90 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    15/294

    596 9062 82 5%

    597 9072 17 -5%

    598 9081 57 -5%

    599 9090 4 5%

    600 9099 37 5%

    601 9108 43 -5%

    602 9117 20 5%

    603 9126 34 5%

    604 9135 77 5%

    605 9144 20 -5%

    606 9153 23 5%

    607 9163 69 5%

    608 9172 46 5%

    609 9181 55 5%

    610 9190 30 5%

    611 9199 69 5%

    612 9209 97 -5%

    613 9218 8 5%

    614 9227 91 5%

    615 9236 17 5%

    616 9245 82 5%

    617 9255 17 -5%

    618 9264 24 5%

    619 9273 26 -5%

    620 9282 50 5%

    621 9292 53 -5%

    622 9301 54 -5%

    623 9310 40 -5%

    624 9320 1 5%

    625 9329 63 -5%

    626 9338 29 -5%

    627 9348 82 -5%

    628 9357 79 5%

    629 9366 86 -5%

    630 9376 85 -5%

    631 9385 16 5%

    632 9394 28 -5%

    633 9404 5 5%

    634 9413 50 -5%

    635 9423 5 5%

    636 9432 25 -5%

    637 9442 73 -5%

    638 9451 73 -5%

    639 9460 70 5%

    640 9470 27 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    16/294

    641 9479 2 -5%

    642 9489 39 5%

    643 9498 23 5%

    644 9508 10 -5%

    645 9517 30 5%

    646 9527 40 -5%

    647 9536 92 5%

    648 9546 46 5%

    649 9555 63 -5%

    650 9565 17 -5%

    651 9575 95 -5%

    652 9584 15 -5%

    653 9594 70 -5%

    654 9603 34 5%

    655 9613 16 5%

    656 9623 33 -5%

    657 9632 63 5%

    658 9642 98 5%

    659 9651 12 5%

    660 9661 48 -5%

    661 9671 83 5%

    662 9680 27 5%

    663 9690 75 5%

    664 9700 87 5%

    665 9710 77 -5%

    666 9719 79 -5%

    667 9729 11 5%

    668 9739 49 5%

    669 9748 52 -5%

    670 9758 81 5%

    671 9768 75 -5%

    672 9778 54 -5%

    673 9787 20 5%

    674 9797 98 -5%

    675 9807 63 5%

    676 9817 49 -5%

    677 9827 37 5%

    678 9836 54 5%

    679 9846 95 5%

    680 9856 99 -5%

    681 9866 71 -5%

    682 9876 89 -5%

    683 9886 14 -5%

    684 9896 40 5%

    685 9906 23 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    17/294

    686 9915 30 -5%

    687 9925 72 5%

    688 9935 86 5%

    689 9945 27 -5%

    690 9955 83 5%

    691 9965 33 5%

    692 9975 9 5%

    693 9985 10 -5%

    694 9995 8 -5%

    695 10005 96 5%

    696 10015 87 5%

    697 10025 87 5%

    698 10035 7 -5%

    699 10045 35 -5%

    700 10055 38 5%

    701 10065 87 -5%

    702 10075 10 5%

    703 10085 91 5%

    704 10095 7 5%

    705 10106 7 5%

    706 10116 54 -5%

    707 10126 56 5%

    708 10136 43 5%

    709 10146 7 5%

    710 10156 50 5%

    711 10166 42 -5%

    712 10177 77 5%

    713 10187 39 5%

    714 10197 56 5%

    715 10207 17 -5%

    716 10217 62 5%

    717 10227 85 -5%

    718 10238 88 -5%

    719 10248 47 -5%

    720 10258 12 5%

    721 10268 71 -5%

    722 10279 79 -5%

    723 10289 21 5%

    724 10299 81 -5%

    725 10310 86 5%

    726 10320 16 5%

    727 10330 67 5%

    728 10341 72 -5%

    729 10351 22 5%

    730 10361 1 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    18/294

    731 10372 10 5%

    732 10382 9 -5%

    733 10392 11 5%

    734 10403 1 -5%

    735 10413 16 5%

    736 10424 17 5%

    737 10434 54 5%

    738 10444 71 -5%

    739 10455 60 -5%

    740 10465 60 5%

    741 10476 20 -5%

    742 10486 2 -5%

    743 10497 37 5%

    744 10507 59 5%

    745 10518 57 5%

    746 10528 53 5%

    747 10539 20 -5%

    748 10549 42 -5%

    749 10560 41 5%

    750 10570 66 -5%

    751 10581 53 -5%

    752 10592 12 -5%

    753 10602 44 5%

    754 10613 73 -5%

    755 10623 92 5%

    756 10634 30 -5%

    757 10645 89 5%

    758 10655 59 -5%

    759 10666 2 -5%

    760 10677 11 -5%

    761 10687 60 -5%

    762 10698 12 -5%

    763 10709 19 -5%

    764 10719 70 -5%

    765 10730 12 5%

    766 10741 35 -5%

    767 10752 87 5%

    768 10762 65 -5%

    769 10773 5 5%

    770 10784 46 5%

    771 10795 25 5%

    772 10805 25 5%

    773 10816 47 5%

    774 10827 61 5%

    775 10838 83 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    19/294

    776 10849 4 5%

    777 10860 14 -5%

    778 10870 2 5%

    779 10881 45 5%

    780 10892 55 5%

    781 10903 68 -5%

    782 10914 97 5%

    783 10925 66 5%

    784 10936 11 -5%

    785 10947 70 -5%

    786 10958 58 5%

    787 10969 41 5%

    788 10980 58 -5%

    789 10991 17 -5%

    790 11002 43 5%

    791 11013 68 5%

    792 11024 76 -5%

    793 11035 54 5%

    794 11046 87 5%

    795 11057 45 5%

    796 11068 66 -5%

    797 11079 21 5%

    798 11090 32 -5%

    799 11101 30 5%

    800 11112 25 -5%

    801 11123 77 -5%

    802 11134 54 5%

    803 11146 49 5%

    804 11157 24 5%

    805 11168 15 -5%

    806 11179 31 5%

    807 11190 27 -5%

    808 11201 29 5%

    809 11213 33 5%

    810 11224 71 -5%

    811 11235 83 -5%

    812 11246 100 5%

    813 11257 68 5%

    814 11269 49 5%

    815 11280 11 5%

    816 11291 37 -5%

    817 11303 7 5%

    818 11314 52 -5%

    819 11325 94 -5%

    820 11337 23 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    20/294

    821 11348 95 5%

    822 11359 61 -5%

    823 11371 99 -5%

    824 11382 49 5%

    825 11393 47 5%

    826 11405 43 -5%

    827 11416 14 5%

    828 11428 67 -5%

    829 11439 74 -5%

    830 11450 44 5%

    831 11462 92 5%

    832 11473 51 5%

    833 11485 97 -5%

    834 11496 40 5%

    835 11508 74 5%

    836 11519 12 5%

    837 11531 71 5%

    838 11542 1 5%

    839 11554 40 -5%

    840 11565 4 -5%

    841 11577 72 5%

    842 11589 23 5%

    843 11600 4 5%

    844 11612 39 -5%

    845 11623 72 -5%

    846 11635 14 -5%

    847 11647 75 -5%

    848 11658 79 -5%

    849 11670 66 5%

    850 11682 69 -5%

    851 11693 1 5%

    852 11705 60 -5%

    853 11717 29 5%

    854 11728 99 5%

    855 11740 8 -5%

    856 11752 76 5%

    857 11764 42 5%

    858 11775 21 5%

    859 11787 43 5%

    860 11799 16 5%

    861 11811 64 5%

    862 11823 34 5%

    863 11834 67 5%

    864 11846 61 -5%

    865 11858 73 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    21/294

    866 11870 41 5%

    867 11882 73 -5%

    868 11894 44 5%

    869 11906 41 5%

    870 11917 13 5%

    871 11929 47 5%

    872 11941 13 5%

    873 11953 36 5%

    874 11965 50 5%

    875 11977 51 -5%

    876 11989 7 -5%

    877 12001 64 -5%

    878 12013 26 5%

    879 12025 85 -5%

    880 12037 29 5%

    881 12049 94 5%

    882 12061 86 -5%

    883 12073 89 -5%

    884 12085 22 5%

    885 12097 85 5%

    886 12110 96 5%

    887 12122 98 -5%

    888 12134 27 5%

    889 12146 17 -5%

    890 12158 40 -5%

    891 12170 43 -5%

    892 12182 81 5%

    893 12195 73 -5%

    894 12207 9 -5%

    895 12219 42 5%

    896 12231 46 -5%

    897 12243 50 5%

    898 12256 14 -5%

    899 12268 89 5%

    900 12280 91 5%

    901 12292 27 -5%

    902 12305 36 -5%

    903 12317 3 5%

    904 12329 62 5%

    905 12342 86 -5%

    906 12354 53 -5%

    907 12366 68 5%

    908 12379 50 5%

    909 12391 78 -5%

    910 12404 53 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    22/294

    911 12416 79 -5%

    912 12428 71 5%

    913 12441 38 5%

    914 12453 67 -5%

    915 12466 93 5%

    916 12478 22 5%

    917 12491 63 -5%

    918 12503 90 5%

    919 12516 49 5%

    920 12528 79 -5%

    921 12541 29 5%

    922 12553 91 -5%

    923 12566 60 -5%

    924 12578 1 5%

    925 12591 99 -5%

    926 12604 1 -5%

    927 12616 47 -5%

    928 12629 48 5%

    929 12641 15 -5%

    930 12654 35 -5%

    931 12667 39 5%

    932 12679 41 -5%

    933 12692 71 5%

    934 12705 41 5%

    935 12717 2 5%

    936 12730 57 5%

    937 12743 93 5%

    938 12756 70 5%

    939 12768 6 5%

    940 12781 71 5%

    941 12794 22 5%

    942 12807 84 -5%

    943 12819 42 5%

    944 12832 60 -5%

    945 12845 51 5%

    946 12858 34 -5%

    947 12871 82 -5%

    948 12884 13 5%

    949 12897 24 5%

    950 12910 30 5%

    951 12922 91 -5%

    952 12935 52 -5%

    953 12948 20 5%

    954 12961 50 5%

    955 12974 53 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    23/294

    956 12987 19 5%

    957 13000 50 5%

    958 13013 99 5%

    959 13026 67 -5%

    960 13039 65 -5%

    961 13052 34 5%

    962 13065 5 -5%

    963 13078 5 -5%

    964 13091 5 5%

    965 13105 46 -5%

    966 13118 7 5%

    967 13131 61 5%

    968 13144 38 -5%

    969 13157 76 -5%

    970 13170 67 5%

    971 13183 9 5%

    972 13197 98 5%

    973 13210 50 5%

    974 13223 50 5%

    975 13236 57 -5%

    976 13249 1 5%

    977 13263 84 5%

    978 13276 39 5%

    979 13289 13 5%

    980 13302 7 -5%

    981 13316 69 5%

    982 13329 3 -5%

    983 13342 59 -5%

    984 13356 89 -5%

    985 13369 53 -5%

    986 13382 12 5%

    987 13396 7 -5%

    988 13409 3 5%

    989 13423 11 -5%

    990 13436 74 5%

    991 13450 67 5%

    992 13463 45 -5%

    993 13476 79 5%

    994 13490 71 5%

    995 13503 49 -5%

    996 13517 24 5%

    997 13530 77 5%

    998 13544 10 -5%

    999 13557 62 5%

    1000 13571 53 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    24/294

    1001 13585 76 -5%

    1002 13598 70 -5%

    1003 13612 50 -5%

    1004 13625 26 -5%

    1005 13639 20 5%

    1006 13653 7 -5%

    1007 13666 26 5%

    1008 13680 3 -5%

    1009 13694 45 5%

    1010 13707 38 5%

    1011 13721 9 5%

    1012 13735 13 -5%

    1013 13749 41 5%

    1014 13762 68 5%

    1015 13776 1 -5%

    1016 13790 93 5%

    1017 13804 79 5%

    1018 13817 8 5%

    1019 13831 95 -5%

    1020 13845 90 -5%

    1021 13859 82 -5%

    1022 13873 62 -5%

    1023 13887 34 -5%

    1024 13901 61 -5%

    1025 13914 32 -5%

    1026 13928 83 -5%

    1027 13942 84 -5%

    1028 13956 9 5%

    1029 13970 92 -5%

    1030 13984 46 -5%

    1031 13998 61 -5%

    1032 14012 68 5%

    1033 14026 15 -5%

    1034 14040 11 -5%

    1035 14054 94 5%

    1036 14068 34 -5%

    1037 14082 17 5%

    1038 14096 20 -5%

    1039 14111 37 -5%

    1040 14125 62 5%

    1041 14139 57 5%

    1042 14153 46 -5%

    1043 14167 74 -5%

    1044 14181 98 5%

    1045 14195 13 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    25/294

    1046 14210 75 -5%

    1047 14224 90 -5%

    1048 14238 92 5%

    1049 14252 83 5%

    1050 14266 85 -5%

    1051 14281 82 -5%

    1052 14295 64 5%

    1053 14309 47 5%

    1054 14324 15 5%

    1055 14338 25 5%

    1056 14352 78 -5%

    1057 14367 98 5%

    1058 14381 8 5%

    1059 14395 87 5%

    1060 14410 90 -5%

    1061 14424 54 -5%

    1062 14439 48 5%

    1063 14453 58 5%

    1064 14468 69 5%

    1065 14482 58 -5%

    1066 14496 51 5%

    1067 14511 2 5%

    1068 14525 74 -5%

    1069 14540 70 -5%

    1070 14555 39 5%

    1071 14569 35 5%

    1072 14584 27 5%

    1073 14598 84 -5%

    1074 14613 9 -5%

    1075 14627 24 5%

    1076 14642 97 -5%

    1077 14657 83 -5%

    1078 14671 14 5%

    1079 14686 88 5%

    1080 14701 66 5%

    1081 14715 99 5%

    1082 14730 70 5%

    1083 14745 30 5%

    1084 14760 45 5%

    1085 14774 84 -5%

    1086 14789 54 -5%

    1087 14804 23 -5%

    1088 14819 82 5%

    1089 14834 62 -5%

    1090 14848 9 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    26/294

    1091 14863 71 -5%

    1092 14878 15 5%

    1093 14893 56 5%

    1094 14908 29 -5%

    1095 14923 83 5%

    1096 14938 13 5%

    1097 14953 79 5%

    1098 14968 85 5%

    1099 14983 87 -5%

    1100 14998 49 5%

    1101 15013 23 -5%

    1102 15028 21 5%

    1103 15043 75 5%

    1104 15058 7 -5%

    1105 15073 30 5%

    1106 15088 99 -5%

    1107 15103 3 5%

    1108 15118 13 5%

    1109 15133 12 5%

    1110 15148 91 5%

    1111 15163 78 5%

    1112 15179 10 5%

    1113 15194 60 5%

    1114 15209 7 -5%

    1115 15224 54 -5%

    1116 15239 44 -5%

    1117 15255 61 -5%

    1118 15270 76 -5%

    1119 15285 25 -5%

    1120 15300 22 -5%

    1121 15316 85 5%

    1122 15331 96 5%

    1123 15346 36 -5%

    1124 15362 41 -5%

    1125 15377 24 5%

    1126 15392 19 -5%

    1127 15408 53 5%

    1128 15423 3 5%

    1129 15439 3 5%

    1130 15454 40 5%

    1131 15470 51 5%

    1132 15485 26 5%

    1133 15501 61 -5%

    1134 15516 26 -5%

    1135 15532 32 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    27/294

    1136 15547 90 5%

    1137 15563 24 -5%

    1138 15578 34 -5%

    1139 15594 2 -5%

    1140 15609 35 -5%

    1141 15625 24 5%

    1142 15641 80 5%

    1143 15656 45 -5%

    1144 15672 83 5%

    1145 15688 87 -5%

    1146 15703 99 5%

    1147 15719 27 -5%

    1148 15735 47 -5%

    1149 15750 75 -5%

    1150 15766 51 -5%

    1151 15782 68 -5%

    1152 15798 59 5%

    1153 15813 47 5%

    1154 15829 4 -5%

    1155 15845 100 5%

    1156 15861 70 5%

    1157 15877 22 5%

    1158 15893 53 5%

    1159 15909 73 -5%

    1160 15924 24 -5%

    1161 15940 92 -5%

    1162 15956 23 5%

    1163 15972 49 -5%

    1164 15988 52 5%

    1165 16004 49 -5%

    1166 16020 81 -5%

    1167 16036 42 -5%

    1168 16052 72 5%

    1169 16068 14 5%

    1170 16084 44 5%

    1171 16101 7 5%

    1172 16117 38 5%

    1173 16133 23 -5%

    1174 16149 51 -5%

    1175 16165 21 -5%

    1176 16181 9 5%

    1177 16197 50 -5%

    1178 16214 47 5%

    1179 16230 55 -5%

    1180 16246 24 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    28/294

    1181 16262 98 -5%

    1182 16279 22 5%

    1183 16295 83 -5%

    1184 16311 44 5%

    1185 16327 25 -5%

    1186 16344 82 5%

    1187 16360 14 5%

    1188 16376 47 -5%

    1189 16393 34 5%

    1190 16409 86 5%

    1191 16426 70 5%

    1192 16442 26 -5%

    1193 16459 9 -5%

    1194 16475 19 5%

    1195 16491 78 -5%

    1196 16508 57 -5%

    1197 16524 99 -5%

    1198 16541 19 -5%

    1199 16558 29 -5%

    1200 16574 13 -5%

    1201 16591 62 -5%

    1202 16607 35 -5%

    1203 16624 50 -5%

    1204 16640 84 -5%

    1205 16657 86 5%

    1206 16674 70 5%

    1207 16690 92 5%

    1208 16707 36 -5%

    1209 16724 17 -5%

    1210 16741 47 -5%

    1211 16757 59 5%

    1212 16774 14 5%

    1213 16791 69 -5%

    1214 16808 42 -5%

    1215 16824 58 5%

    1216 16841 94 5%

    1217 16858 24 5%

    1218 16875 71 5%

    1219 16892 40 5%

    1220 16909 58 5%

    1221 16926 57 5%

    1222 16943 10 5%

    1223 16959 83 -5%

    1224 16976 66 -5%

    1225 16993 28 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    29/294

    1226 17010 60 5%

    1227 17027 23 5%

    1228 17044 27 5%

    1229 17061 78 5%

    1230 17079 52 5%

    1231 17096 39 5%

    1232 17113 40 5%

    1233 17130 86 5%

    1234 17147 89 -5%

    1235 17164 23 5%

    1236 17181 72 -5%

    1237 17198 59 -5%

    1238 17216 15 5%

    1239 17233 7 5%

    1240 17250 75 5%

    1241 17267 62 -5%

    1242 17285 66 5%

    1243 17302 89 5%

    1244 17319 30 5%

    1245 17337 7 -5%

    1246 17354 46 -5%

    1247 17371 23 -5%

    1248 17389 31 5%

    1249 17406 17 5%

    1250 17423 63 -5%

    1251 17441 88 -5%

    1252 17458 74 5%

    1253 17476 72 5%

    1254 17493 70 -5%

    1255 17511 40 -5%

    1256 17528 100 5%

    1257 17546 30 5%

    1258 17563 62 5%

    1259 17581 26 5%

    1260 17598 8 -5%

    1261 17616 13 5%

    1262 17634 65 5%

    1263 17651 47 5%

    1264 17669 99 -5%

    1265 17687 53 5%

    1266 17704 70 5%

    1267 17722 71 5%

    1268 17740 11 -5%

    1269 17757 85 -5%

    1270 17775 77 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    30/294

    1271 17793 86 5%

    1272 17811 46 5%

    1273 17829 43 -5%

    1274 17846 74 -5%

    1275 17864 76 5%

    1276 17882 49 5%

    1277 17900 20 -5%

    1278 17918 99 5%

    1279 17936 79 5%

    1280 17954 37 5%

    1281 17972 61 5%

    1282 17990 67 5%

    1283 18008 10 -5%

    1284 18026 32 5%

    1285 18044 36 -5%

    1286 18062 49 -5%

    1287 18080 31 5%

    1288 18098 66 -5%

    1289 18116 11 5%

    1290 18134 57 5%

    1291 18152 73 -5%

    1292 18170 24 5%

    1293 18189 21 5%

    1294 18207 20 5%

    1295 18225 22 5%

    1296 18243 73 5%

    1297 18261 89 -5%

    1298 18280 93 -5%

    1299 18298 84 5%

    1300 18316 74 5%

    1301 18335 69 5%

    1302 18353 69 5%

    1303 18371 20 -5%

    1304 18390 11 -5%

    1305 18408 43 5%

    1306 18426 95 5%

    1307 18445 60 5%

    1308 18463 63 5%

    1309 18482 93 5%

    1310 18500 39 -5%

    1311 18519 100 5%

    1312 18537 54 -5%

    1313 18556 5 5%

    1314 18574 9 -5%

    1315 18593 85 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    31/294

    1316 18612 41 -5%

    1317 18630 58 5%

    1318 18649 16 -5%

    1319 18667 7 -5%

    1320 18686 69 -5%

    1321 18705 73 -5%

    1322 18723 79 -5%

    1323 18742 92 5%

    1324 18761 93 -5%

    1325 18780 99 -5%

    1326 18798 14 5%

    1327 18817 66 5%

    1328 18836 88 5%

    1329 18855 6 5%

    1330 18874 50 5%

    1331 18893 61 -5%

    1332 18912 75 -5%

    1333 18930 19 5%

    1334 18949 80 5%

    1335 18968 86 5%

    1336 18987 62 5%

    1337 19006 74 5%

    1338 19025 46 -5%

    1339 19044 24 5%

    1340 19063 67 -5%

    1341 19082 84 5%

    1342 19102 23 5%

    1343 19121 20 5%

    1344 19140 89 5%

    1345 19159 32 -5%

    1346 19178 5 5%

    1347 19197 30 -5%

    1348 19216 90 -5%

    1349 19236 21 5%

    1350 19255 36 -5%

    1351 19274 59 -5%

    1352 19293 93 -5%

    1353 19313 15 -5%

    1354 19332 50 -5%

    1355 19351 86 -5%

    1356 19371 14 5%

    1357 19390 64 5%

    1358 19409 52 -5%

    1359 19429 1 5%

    1360 19448 70 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    32/294

    1361 19468 1 5%

    1362 19487 61 -5%

    1363 19507 44 -5%

    1364 19526 20 5%

    1365 19546 41 -5%

    1366 19565 29 -5%

    1367 19585 81 -5%

    1368 19604 14 5%

    1369 19624 75 5%

    1370 19644 5 5%

    1371 19663 81 5%

    1372 19683 58 -5%

    1373 19703 28 -5%

    1374 19722 100 5%

    1375 19742 47 -5%

    1376 19762 60 -5%

    1377 19782 5 5%

    1378 19801 76 -5%

    1379 19821 49 5%

    1380 19841 25 5%

    1381 19861 12 5%

    1382 19881 7 5%

    1383 19901 17 5%

    1384 19920 27 5%

    1385 19940 57 5%

    1386 19960 3 5%

    1387 19980 40 -5%

    1388 20000 20 -5%

    1389 20020 54 5%

    1390 20040 40 5%

    1391 20060 90 5%

    1392 20080 55 5%

    1393 20100 100 5%

    1394 20121 33 -5%

    1395 20141 74 -5%

    1396 20161 41 5%

    1397 20181 62 5%

    1398 20201 54 5%

    1399 20221 55 -5%

    1400 20242 36 -5%

    1401 20262 59 5%

    1402 20282 35 -5%

    1403 20302 94 5%

    1404 20323 86 -5%

    1405 20343 35 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    33/294

    1406 20363 40 -5%

    1407 20384 45 -5%

    1408 20404 39 5%

    1409 20424 16 5%

    1410 20445 94 5%

    1411 20465 63 5%

    1412 20486 27 -5%

    1413 20506 100 -5%

    1414 20527 80 -5%

    1415 20547 53 5%

    1416 20568 57 5%

    1417 20588 83 -5%

    1418 20609 93 5%

    1419 20630 77 5%

    1420 20650 36 5%

    1421 20671 32 -5%

    1422 20692 66 -5%

    1423 20712 90 5%

    1424 20733 32 -5%

    1425 20754 99 -5%

    1426 20774 64 5%

    1427 20795 72 5%

    1428 20816 60 5%

    1429 20837 18 -5%

    1430 20858 26 5%

    1431 20879 96 -5%

    1432 20899 76 5%

    1433 20920 61 -5%

    1434 20941 89 5%

    1435 20962 61 5%

    1436 20983 95 -5%

    1437 21004 29 5%

    1438 21025 6 -5%

    1439 21046 33 5%

    1440 21067 44 -5%

    1441 21088 99 -5%

    1442 21109 96 -5%

    1443 21130 71 5%

    1444 21152 99 5%

    1445 21173 76 -5%

    1446 21194 24 5%

    1447 21215 55 -5%

    1448 21236 58 5%

    1449 21258 16 -5%

    1450 21279 31 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    34/294

    1451 21300 94 -5%

    1452 21321 47 5%

    1453 21343 97 5%

    1454 21364 84 -5%

    1455 21385 79 5%

    1456 21407 95 5%

    1457 21428 47 5%

    1458 21450 50 5%

    1459 21471 54 5%

    1460 21493 64 -5%

    1461 21514 76 5%

    1462 21536 50 -5%

    1463 21557 40 5%

    1464 21579 36 -5%

    1465 21600 38 5%

    1466 21622 100 -5%

    1467 21644 30 -5%

    1468 21665 67 5%

    1469 21687 5 -5%

    1470 21709 63 5%

    1471 21730 10 -5%

    1472 21752 3 5%

    1473 21774 59 -5%

    1474 21795 81 -5%

    1475 21817 2 5%

    1476 21839 34 5%

    1477 21861 4 5%

    1478 21883 56 -5%

    1479 21905 92 5%

    1480 21927 20 5%

    1481 21948 87 5%

    1482 21970 85 -5%

    1483 21992 67 -5%

    1484 22014 83 -5%

    1485 22036 69 5%

    1486 22058 45 5%

    1487 22081 77 5%

    1488 22103 15 5%

    1489 22125 95 -5%

    1490 22147 31 5%

    1491 22169 79 5%

    1492 22191 70 5%

    1493 22213 80 5%

    1494 22236 18 -5%

    1495 22258 6 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    35/294

    1496 22280 17 -5%

    1497 22302 18 -5%

    1498 22325 36 -5%

    1499 22347 84 5%

    1500 22369 22 5%

    1501 22392 98 5%

    1502 22414 93 -5%

    1503 22436 25 -5%

    1504 22459 57 -5%

    1505 22481 74 5%

    1506 22504 26 -5%

    1507 22526 91 5%

    1508 22549 78 5%

    1509 22571 82 5%

    1510 22594 82 5%

    1511 22617 97 -5%

    1512 22639 68 5%

    1513 22662 67 -5%

    1514 22685 63 -5%

    1515 22707 50 5%

    1516 22730 35 -5%

    1517 22753 8 5%

    1518 22775 27 -5%

    1519 22798 50 5%

    1520 22821 3 5%

    1521 22844 57 5%

    1522 22867 28 -5%

    1523 22889 73 -5%

    1524 22912 36 -5%

    1525 22935 46 -5%

    1526 22958 78 -5%

    1527 22981 53 5%

    1528 23004 63 5%

    1529 23027 13 5%

    1530 23050 36 -5%

    1531 23073 85 -5%

    1532 23096 11 5%

    1533 23119 29 -5%

    1534 23143 10 5%

    1535 23166 67 5%

    1536 23189 2 -5%

    1537 23212 36 5%

    1538 23235 57 5%

    1539 23258 79 -5%

    1540 23282 17 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    36/294

    1541 23305 39 -5%

    1542 23328 76 5%

    1543 23352 85 5%

    1544 23375 5 -5%

    1545 23398 39 -5%

    1546 23422 35 -5%

    1547 23445 40 -5%

    1548 23469 46 -5%

    1549 23492 61 -5%

    1550 23516 89 5%

    1551 23539 49 -5%

    1552 23563 17 -5%

    1553 23586 17 -5%

    1554 23610 21 -5%

    1555 23633 53 -5%

    1556 23657 63 5%

    1557 23681 98 5%

    1558 23704 5 -5%

    1559 23728 26 -5%

    1560 23752 11 -5%

    1561 23776 41 5%

    1562 23799 11 -5%

    1563 23823 21 5%

    1564 23847 69 5%

    1565 23871 20 -5%

    1566 23895 88 5%

    1567 23919 70 5%

    1568 23942 56 5%

    1569 23966 45 5%

    1570 23990 49 -5%

    1571 24014 73 5%

    1572 24038 83 5%

    1573 24062 24 5%

    1574 24087 57 5%

    1575 24111 88 5%

    1576 24135 62 5%

    1577 24159 91 5%

    1578 24183 27 5%

    1579 24207 8 -5%

    1580 24231 51 5%

    1581 24256 16 -5%

    1582 24280 56 5%

    1583 24304 68 -5%

    1584 24328 33 5%

    1585 24353 76 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    37/294

    1586 24377 20 5%

    1587 24402 96 -5%

    1588 24426 74 5%

    1589 24450 25 -5%

    1590 24475 21 -5%

    1591 24499 84 -5%

    1592 24524 65 5%

    1593 24548 31 -5%

    1594 24573 5 -5%

    1595 24597 33 -5%

    1596 24622 51 5%

    1597 24647 92 -5%

    1598 24671 3 5%

    1599 24696 6 5%

    1600 24721 36 5%

    1601 24745 51 5%

    1602 24770 78 -5%

    1603 24795 19 5%

    1604 24820 75 -5%

    1605 24845 34 -5%

    1606 24869 6 -5%

    1607 24894 36 -5%

    1608 24919 25 5%

    1609 24944 33 5%

    1610 24969 43 5%

    1611 24994 76 5%

    1612 25019 48 -5%

    1613 25044 99 -5%

    1614 25069 44 5%

    1615 25094 81 5%

    1616 25119 74 -5%

    1617 25144 63 -5%

    1618 25169 76 -5%

    1619 25195 48 -5%

    1620 25220 87 -5%

    1621 25245 97 -5%

    1622 25270 31 -5%

    1623 25296 52 -5%

    1624 25321 28 5%

    1625 25346 35 -5%

    1626 25371 84 5%

    1627 25397 78 -5%

    1628 25422 27 -5%

    1629 25448 87 -5%

    1630 25473 83 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    38/294

    1631 25499 63 -5%

    1632 25524 37 5%

    1633 25550 61 -5%

    1634 25575 81 -5%

    1635 25601 12 -5%

    1636 25626 94 -5%

    1637 25652 86 -5%

    1638 25678 47 5%

    1639 25703 19 -5%

    1640 25729 18 5%

    1641 25755 90 -5%

    1642 25780 94 5%

    1643 25806 66 5%

    1644 25832 89 5%

    1645 25858 38 -5%

    1646 25884 47 5%

    1647 25910 62 5%

    1648 25936 100 -5%

    1649 25961 22 5%

    1650 25987 9 5%

    1651 26013 87 -5%

    1652 26039 19 -5%

    1653 26065 40 5%

    1654 26092 38 -5%

    1655 26118 46 5%

    1656 26144 75 -5%

    1657 26170 22 5%

    1658 26196 23 5%

    1659 26222 2 -5%

    1660 26249 8 5%

    1661 26275 6 -5%

    1662 26301 64 -5%

    1663 26327 45 5%

    1664 26354 66 -5%

    1665 26380 44 -5%

    1666 26406 56 5%

    1667 26433 60 -5%

    1668 26459 30 5%

    1669 26486 3 5%

    1670 26512 78 -5%

    1671 26539 47 -5%

    1672 26565 92 5%

    1673 26592 72 5%

    1674 26618 13 5%

    1675 26645 80 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    39/294

    1676 26672 9 -5%

    1677 26698 59 5%

    1678 26725 42 -5%

    1679 26752 9 5%

    1680 26778 81 -5%

    1681 26805 51 5%

    1682 26832 95 5%

    1683 26859 99 5%

    1684 26886 91 -5%

    1685 26913 33 -5%

    1686 26940 44 5%

    1687 26967 65 5%

    1688 26993 54 5%

    1689 27020 67 -5%

    1690 27047 66 -5%

    1691 27075 62 5%

    1692 27102 72 5%

    1693 27129 29 -5%

    1694 27156 6 5%

    1695 27183 37 5%

    1696 27210 73 5%

    1697 27237 62 5%

    1698 27265 97 -5%

    1699 27292 2 -5%

    1700 27319 64 5%

    1701 27346 74 5%

    1702 27374 49 5%

    1703 27401 55 -5%

    1704 27429 46 -5%

    1705 27456 62 5%

    1706 27484 35 5%

    1707 27511 55 5%

    1708 27538 20 5%

    1709 27566 77 -5%

    1710 27594 63 -5%

    1711 27621 1 -5%

    1712 27649 28 -5%

    1713 27676 58 5%

    1714 27704 99 5%

    1715 27732 18 -5%

    1716 27760 91 5%

    1717 27787 43 5%

    1718 27815 82 -5%

    1719 27843 45 5%

    1720 27871 10 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    40/294

    1721 27899 48 -5%

    1722 27927 6 5%

    1723 27954 81 -5%

    1724 27982 77 5%

    1725 28010 12 -5%

    1726 28038 18 -5%

    1727 28066 49 -5%

    1728 28095 73 5%

    1729 28123 14 5%

    1730 28151 51 -5%

    1731 28179 36 -5%

    1732 28207 88 5%

    1733 28235 100 5%

    1734 28264 91 -5%

    1735 28292 34 5%

    1736 28320 62 5%

    1737 28348 26 -5%

    1738 28377 88 5%

    1739 28405 81 5%

    1740 28434 2 5%

    1741 28462 51 -5%

    1742 28490 82 -5%

    1743 28519 29 -5%

    1744 28547 9 5%

    1745 28576 80 5%

    1746 28605 47 -5%

    1747 28633 99 5%

    1748 28662 23 5%

    1749 28690 28 5%

    1750 28719 43 5%

    1751 28748 32 5%

    1752 28777 76 -5%

    1753 28805 49 5%

    1754 28834 13 -5%

    1755 28863 52 -5%

    1756 28892 60 5%

    1757 28921 30 5%

    1758 28950 1 -5%

    1759 28979 33 -5%

    1760 29008 44 5%

    1761 29037 51 5%

    1762 29066 68 5%

    1763 29095 32 -5%

    1764 29124 51 5%

    1765 29153 59 -5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    41/294

    1766 29182 65 -5%

    1767 29211 12 5%

    1768 29241 84 -5%

    1769 29270 53 5%

    1770 29299 93 -5%

    1771 29328 86 -5%

    1772 29358 3 5%

    1773 29387 74 5%

    1774 29416 14 5%

    1775 29446 11 5%

    1776 29475 54 -5%

    1777 29505 61 -5%

    1778 29534 9 5%

    1779 29564 76 5%

    1780 29593 88 -5%

    1781 29623 52 -5%

    1782 29653 8 5%

    1783 29682 63 -5%

    1784 29712 1 -5%

    1785 29742 20 -5%

    1786 29771 15 5%

    1787 29801 60 5%

    1788 29831 50 5%

    1789 29861 15 -5%

    1790 29891 93 5%

    1791 29920 94 5%

    1792 29950 66 5%

    1793 29980 61 -5%

    1794 30010 25 5%

    1795 30040 16 5%

    1796 30070 19 -5%

    1797 30100 89 5%

    1798 30131 28 -5%

    1799 30161 2 5%

    1800 30191 41 5%

    1801 30221 21 5%

    1802 30251 87 5%

    1803 30282 44 5%

    1804 30312 94 5%

    1805 30342 1 -5%

    1806 30372 54 5%

    1807 30403 48 5%

    1808 30433 61 -5%

    1809 30464 63 5%

    1810 30494 24 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    42/294

    1811 30525 49 5%

    1812 30555 15 5%

    1813 30586 31 5%

    1814 30616 12 5%

    1815 30647 15 -5%

    1816 30678 51 5%

    1817 30708 26 -5%

    1818 30739 75 -5%

    1819 30770 100 5%

    1820 30800 41 -5%

    1821 30831 67 -5%

    1822 30862 93 5%

    1823 30893 6 5%

    1824 30924 27 5%

    1825 30955 17 -5%

    1826 30986 22 5%

    1827 31017 46 5%

    1828 31048 6 -5%

    1829 31079 50 5%

    1830 31110 47 -5%

    1831 31141 47 5%

    1832 31172 70 5%

    1833 31203 34 -5%

    1834 31234 90 5%

    1835 31266 64 -5%

    1836 31297 35 5%

    1837 31328 44 5%

    1838 31360 11 5%

    1839 31391 96 -5%

    1840 31422 7 5%

    1841 31454 34 -5%

    1842 31485 45 5%

    1843 31517 21 -5%

    1844 31548 64 5%

    1845 31580 57 5%

    1846 31611 35 5%

    1847 31643 14 5%

    1848 31675 82 -5%

    1849 31706 10 -5%

    1850 31738 14 5%

    1851 31770 23 -5%

    1852 31801 76 5%

    1853 31833 7 -5%

    1854 31865 28 5%

    1855 31897 3 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    43/294

    1856 31929 24 -5%

    1857 31961 50 5%

    1858 31993 48 5%

    1859 32025 29 -5%

    1860 32057 99 -5%

    1861 32089 95 5%

    1862 32121 76 5%

    1863 32153 68 5%

    1864 32185 29 5%

    1865 32217 66 5%

    1866 32250 31 5%

    1867 32282 64 -5%

    1868 32314 10 5%

    1869 32346 42 5%

    1870 32379 60 5%

    1871 32411 16 -5%

    1872 32444 75 -5%

    1873 32476 4 5%

    1874 32509 37 5%

    1875 32541 39 5%

    1876 32574 60 5%

    1877 32606 72 -5%

    1878 32639 53 -5%

    1879 32671 42 5%

    1880 32704 81 5%

    1881 32737 67 -5%

    1882 32769 64 5%

    1883 32802 57 5%

    1884 32835 73 5%

    1885 32868 92 -5%

    1886 32901 59 -5%

    1887 32934 96 5%

    1888 32967 41 5%

    1889 33000 7 5%

    1890 33033 25 5%

    1891 33066 39 -5%

    1892 33099 1 5%

    1893 33132 100 5%

    1894 33165 7 5%

    1895 33198 30 5%

    1896 33231 66 5%

    1897 33264 38 -5%

    1898 33298 93 5%

    1899 33331 75 5%

    1900 33364 79 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    44/294

    1901 33398 52 -5%

    1902 33431 91 5%

    1903 33465 54 -5%

    1904 33498 56 -5%

    1905 33532 27 -5%

    1906 33565 93 -5%

    1907 33599 15 -5%

    1908 33632 98 5%

    1909 33666 46 -5%

    1910 33700 57 5%

    1911 33733 78 5%

    1912 33767 12 -5%

    1913 33801 20 5%

    1914 33835 34 5%

    1915 33868 84 5%

    1916 33902 12 5%

    1917 33936 93 -5%

    1918 33970 80 5%

    1919 34004 52 5%

    1920 34038 99 -5%

    1921 34072 4 5%

    1922 34106 91 5%

    1923 34140 100 5%

    1924 34174 4 5%

    1925 34209 97 -5%

    1926 34243 30 5%

    1927 34277 69 -5%

    1928 34311 35 5%

    1929 34346 22 -5%

    1930 34380 44 5%

    1931 34414 13 5%

    1932 34449 74 -5%

    1933 34483 34 5%

    1934 34518 67 5%

    1935 34552 29 -5%

    1936 34587 60 5%

    1937 34621 59 5%

    1938 34656 44 -5%

    1939 34691 58 5%

    1940 34725 5 -5%

    1941 34760 100 5%

    1942 34795 35 -5%

    1943 34830 16 5%

    1944 34864 20 5%

    1945 34899 69 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    45/294

    1946 34934 100 5%

    1947 34969 31 5%

    1948 35004 62 -5%

    1949 35039 79 -5%

    1950 35074 83 -5%

    1951 35109 61 -5%

    1952 35144 83 5%

    1953 35179 73 5%

    1954 35215 60 -5%

    1955 35250 86 -5%

    1956 35285 69 5%

    1957 35320 90 5%

    1958 35356 55 -5%

    1959 35391 3 5%

    1960 35426 11 5%

    1961 35462 98 5%

    1962 35497 16 5%

    1963 35533 85 5%

    1964 35568 32 5%

    1965 35604 83 5%

    1966 35640 13 5%

    1967 35675 91 -5%

    1968 35711 41 5%

    1969 35747 56 -5%

    1970 35782 48 -5%

    1971 35818 45 -5%

    1972 35854 56 5%

    1973 35890 83 -5%

    1974 35926 61 5%

    1975 35962 75 5%

    1976 35998 52 5%

    1977 36034 60 -5%

    1978 36070 5 5%

    1979 36106 13 5%

    1980 36142 39 5%

    1981 36178 87 5%

    1982 36214 73 -5%

    1983 36250 21 -5%

    1984 36287 60 -5%

    1985 36323 33 5%

    1986 36359 6 5%

    1987 36396 28 -5%

    1988 36432 22 5%

    1989 36468 61 5%

    1990 36505 31 5%

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    46/294

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    47/294

    Demanda de SIMPOLI

    D"MA#DA PRO%A%ILIDAD PRO.AC!. DI&ITOS

    -2% 0.15 0.15 1-15

    -1% 0.25 0.4 16-39

    1% 0.45 0.85 40-84

    3% 0.15 1 85-100

    Total '.((

    2

    1%

    #()%

    .#$5-

      ($

    %#(/2

    SIMPOLI

    VALOR L"C$" RA#D !"SO D"MA#DA !"SO

    2100 59 1% 101 11.22

    2100 82 -2% 98 10.89

    2100 40 1% 101 11.22

    2100 81 -1% 99 11.00

    2100 37 -2% 98 10.89

    1900 59 2% 102 11.33

    2100 5 1% 101 11.22

    2100 98 2% 102 11.33

    1900 43 1% 101 11.22

    2100 96 2% 102 11.33

    PORC. D"MA#DA!"SO

    D"MA#DTRA%A)ADOR

    EJECUTARMACRO

    0.00500000.00

    1000000.001500000.002000000.00

    A0i Ti!&e

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    48/294

    2100 39 1% 101 11.22

    1900 20 -2% 98 10.89

    1900 9 1% 101 11.22

    2100 33 -2% 98 10.89

    1900 38 1% 101 11.22

    2100 38 1% 101 11.22

    1900 45 2% 102 11.33

    1900 36 -2% 98 10.89

    1900 6 2% 102 11.33

    2100 74 -1% 99 11.00

    2100 80 -2% 98 10.89

    2100 68 1% 101 11.22

    1900 6 1% 101 11.22

    2100 13 2% 102 11.33

    1900 59 -1% 99 11.00

    2100 62 -1% 99 11.00

    2100 9 -1% 99 11.00

    1900 51 2% 102 11.33

    2100 16 -2% 98 10.89

    1900 50 2% 102 11.33

    2100 23 -2% 98 10.89

    1900 41 2% 102 11.33

    2100 76 1% 101 11.22

    2100 5 2% 102 11.33

    2100 80 1% 101 11.22

    1900 57 1% 101 11.22

    1900 41 1% 101 11.22

    2100 38 1% 101 11.22

    2100 62 1% 101 11.22

    2100 84 1% 101 11.22

    2100 34 2% 102 11.33

    2100 100 2% 102 11.33

    1900 4 1% 101 11.22

    1900 43 2% 102 11.33

    2100 33 -1% 99 11.00

    1900 42 1% 101 11.22

    2100 80 -1% 99 11.00

    2100 77 -1% 99 11.00

    2100 77 2% 102 11.33

    2100 85 -2% 98 10.89

    1900 51 1% 101 11.22

    2100 57 -1% 99 11.00

    2100 53 1% 101 11.22

    1900 56 1% 101 11.22

    2100 70 -1% 99 11.00

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    49/294

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    50/294

    1900 49 1% 101 11.22

    2100 69 1% 101 11.22

    2100 23 2% 102 11.33

    2100 69 1% 101 11.22

    1900 86 1% 101 11.22

    1900 89 -1% 99 11.00

    2100 22 -1% 99 11.00

    1900 44 -2% 98 10.89

    2100 34 1% 101 11.22

    2100 51 -1% 99 11.00

    1900 79 2% 102 11.33

    2100 64 1% 101 11.22

    1900 31 -1% 99 11.00

    1900 70 1% 101 11.22

    1900 46 1% 101 11.22

    2100 66 -1% 99 11.00

    1900 30 1% 101 11.22

    2100 38 -1% 99 11.00

    2100 19 -1% 99 11.00

    2100 69 1% 101 11.22

    1900 92 -1% 99 11.00

    1900 3 1% 101 11.22

    2100 35 2% 102 11.33

    2100 30 -1% 99 11.00

    1900 61 -2% 98 10.89

    1900 3 1% 101 11.22

    1900 56 -1% 99 11.00

    2100 70 2% 102 11.33

    2100 32 -1% 99 11.00

    2100 12 1% 101 11.22

    1900 69 1% 101 11.22

    1900 81 1% 101 11.22

    2100 80 -1% 99 11.00

    1900 91 -1% 99 11.00

    1900 49 1% 101 11.22

    2100 65 2% 102 11.33

    1900 80 1% 101 11.22

    2100 71 1% 101 11.22

    2100 9 2% 102 11.33

    2100 13 2% 102 11.33

    2100 21 -1% 99 11.00

    1900 87 -2% 98 10.89

    1900 76 1% 101 11.22

    1900 52 1% 101 11.22

    1900 56 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    51/294

    2100 22 -1% 99 11.00

    1900 18 1% 101 11.22

    1900 86 1% 101 11.22

    2100 60 1% 101 11.22

    1900 36 -1% 99 11.00

    2100 54 -1% 99 11.00

    2100 52 1% 101 11.22

    2100 39 -2% 98 10.89

    2100 88 2% 102 11.33

    2100 82 -2% 98 10.89

    1900 99 1% 101 11.22

    1900 91 1% 101 11.22

    1900 37 -1% 99 11.00

    2100 68 1% 101 11.22

    2100 23 1% 101 11.22

    2100 49 2% 102 11.33

    2100 36 1% 101 11.22

    2100 3 1% 101 11.22

    2100 29 -1% 99 11.00

    1900 27 1% 101 11.22

    1900 52 -2% 98 10.89

    2100 93 -2% 98 10.89

    1900 6 -1% 99 11.00

    1900 22 1% 101 11.22

    1900 2 -1% 99 11.00

    2100 19 2% 102 11.33

    2100 42 -1% 99 11.00

    1900 88 -1% 99 11.00

    1900 95 -2% 98 10.89

    2100 94 1% 101 11.22

    2100 44 2% 102 11.33

    1900 16 1% 101 11.22

    1900 11 -2% 98 10.89

    1900 30 1% 101 11.22

    2100 76 -1% 99 11.00

    2100 46 2% 102 11.33

    1900 84 2% 102 11.33

    2100 27 1% 101 11.22

    2100 84 1% 101 11.22

    2100 72 -2% 98 10.89

    1900 8 1% 101 11.22

    2100 83 2% 102 11.33

    2100 63 1% 101 11.22

    2100 45 1% 101 11.22

    2100 51 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    52/294

    2100 85 1% 101 11.22

    1900 93 -2% 98 10.89

    1900 86 1% 101 11.22

    2100 87 1% 101 11.22

    1900 21 -1% 99 11.00

    2100 13 -2% 98 10.89

    1900 38 1% 101 11.22

    2100 14 2% 102 11.33

    1900 19 1% 101 11.22

    1900 59 -1% 99 11.00

    2100 15 1% 101 11.22

    1900 37 1% 101 11.22

    2100 1 1% 101 11.22

    2100 3 2% 102 11.33

    2100 32 1% 101 11.22

    2100 94 1% 101 11.22

    2100 47 1% 101 11.22

    2100 48 1% 101 11.22

    1900 5 1% 101 11.22

    2100 76 1% 101 11.22

    2100 23 1% 101 11.22

    1900 50 1% 101 11.22

    1900 59 1% 101 11.22

    1900 49 2% 102 11.33

    1900 34 2% 102 11.33

    2100 30 1% 101 11.22

    1900 56 1% 101 11.22

    1900 17 -2% 98 10.89

    1900 92 1% 101 11.22

    1900 1 2% 102 11.33

    2100 67 -1% 99 11.00

    2100 77 -2% 98 10.89

    1900 93 1% 101 11.22

    1900 52 -1% 99 11.00

    2100 63 1% 101 11.22

    2100 14 -1% 99 11.00

    1900 65 -1% 99 11.00

    2100 1 -1% 99 11.00

    2100 28 2% 102 11.33

    1900 83 -2% 98 10.89

    2100 60 -2% 98 10.89

    2100 43 1% 101 11.22

    1900 20 -1% 99 11.00

    2100 60 2% 102 11.33

    2100 45 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    53/294

    2100 51 1% 101 11.22

    2100 54 -2% 98 10.89

    1900 92 -2% 98 10.89

    1900 98 -2% 98 10.89

    1900 58 1% 101 11.22

    2100 67 1% 101 11.22

    1900 20 1% 101 11.22

    2100 8 -2% 98 10.89

    2100 26 1% 101 11.22

    1900 69 -2% 98 10.89

    2100 42 1% 101 11.22

    2100 56 1% 101 11.22

    1900 25 1% 101 11.22

    1900 58 1% 101 11.22

    2100 48 -2% 98 10.89

    2100 25 2% 102 11.33

    2100 24 2% 102 11.33

    1900 24 -1% 99 11.00

    2100 18 -2% 98 10.89

    1900 75 2% 102 11.33

    2100 86 1% 101 11.22

    2100 31 2% 102 11.33

    2100 40 1% 101 11.22

    1900 86 1% 101 11.22

    2100 59 2% 102 11.33

    1900 22 2% 102 11.33

    1900 45 2% 102 11.33

    1900 1 2% 102 11.33

    2100 42 -2% 98 10.89

    2100 5 1% 101 11.22

    2100 46 -2% 98 10.89

    2100 92 1% 101 11.22

    2100 59 -2% 98 10.89

    2100 37 -1% 99 11.00

    1900 90 1% 101 11.22

    1900 17 -1% 99 11.00

    1900 3 -2% 98 10.89

    2100 9 1% 101 11.22

    1900 25 -2% 98 10.89

    1900 29 1% 101 11.22

    2100 78 1% 101 11.22

    1900 66 1% 101 11.22

    2100 84 -1% 99 11.00

    1900 2 -2% 98 10.89

    2100 23 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    54/294

    2100 31 1% 101 11.22

    1900 26 1% 101 11.22

    1900 46 1% 101 11.22

    2100 54 -2% 98 10.89

    2100 43 1% 101 11.22

    1900 21 -1% 99 11.00

    1900 39 1% 101 11.22

    1900 74 1% 101 11.22

    2100 60 1% 101 11.22

    2100 25 2% 102 11.33

    2100 32 1% 101 11.22

    2100 82 2% 102 11.33

    1900 70 -2% 98 10.89

    1900 33 -1% 99 11.00

    2100 23 -2% 98 10.89

    1900 75 1% 101 11.22

    2100 78 2% 102 11.33

    2100 14 -2% 98 10.89

    2100 34 -1% 99 11.00

    1900 14 2% 102 11.33

    2100 4 -1% 99 11.00

    1900 50 -2% 98 10.89

    2100 17 1% 101 11.22

    2100 12 2% 102 11.33

    1900 74 2% 102 11.33

    1900 45 1% 101 11.22

    2100 90 1% 101 11.22

    2100 39 -2% 98 10.89

    1900 28 -1% 99 11.00

    1900 91 -1% 99 11.00

    1900 61 1% 101 11.22

    1900 58 -2% 98 10.89

    1900 16 1% 101 11.22

    2100 7 1% 101 11.22

    2100 12 -1% 99 11.00

    1900 59 -1% 99 11.00

    2100 27 -1% 99 11.00

    2100 51 2% 102 11.33

    1900 33 -2% 98 10.89

    2100 86 2% 102 11.33

    2100 75 -2% 98 10.89

    1900 65 1% 101 11.22

    1900 67 -1% 99 11.00

    2100 45 1% 101 11.22

    2100 97 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    55/294

    2100 90 -1% 99 11.00

    2100 20 -1% 99 11.00

    2100 74 1% 101 11.22

    1900 3 -1% 99 11.00

    1900 53 1% 101 11.22

    2100 88 1% 101 11.22

    2100 7 -2% 98 10.89

    2100 3 1% 101 11.22

    2100 4 -1% 99 11.00

    1900 18 1% 101 11.22

    2100 76 -2% 98 10.89

    1900 49 1% 101 11.22

    2100 8 1% 101 11.22

    2100 15 -1% 99 11.00

    2100 77 -1% 99 11.00

    1900 98 1% 101 11.22

    2100 76 -1% 99 11.00

    1900 35 -2% 98 10.89

    1900 14 1% 101 11.22

    1900 82 -2% 98 10.89

    1900 46 1% 101 11.22

    2100 72 -2% 98 10.89

    2100 9 1% 101 11.22

    2100 96 -1% 99 11.00

    1900 5 1% 101 11.22

    1900 94 -1% 99 11.00

    1900 71 -1% 99 11.00

    2100 69 1% 101 11.22

    2100 61 -2% 98 10.89

    2100 16 1% 101 11.22

    2100 65 -1% 99 11.00

    1900 50 1% 101 11.22

    2100 35 -1% 99 11.00

    1900 39 -1% 99 11.00

    2100 53 -2% 98 10.89

    2100 87 -1% 99 11.00

    1900 27 -1% 99 11.00

    1900 59 2% 102 11.33

    2100 89 1% 101 11.22

    1900 30 1% 101 11.22

    2100 77 -1% 99 11.00

    2100 65 1% 101 11.22

    2100 79 1% 101 11.22

    1900 84 1% 101 11.22

    1900 80 -1% 99 11.00

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    56/294

    2100 55 -1% 99 11.00

    2100 82 -1% 99 11.00

    1900 55 -1% 99 11.00

    2100 89 2% 102 11.33

    2100 95 1% 101 11.22

    1900 37 2% 102 11.33

    1900 34 -1% 99 11.00

    1900 67 2% 102 11.33

    2100 45 2% 102 11.33

    2100 30 -2% 98 10.89

    1900 71 2% 102 11.33

    2100 39 2% 102 11.33

    1900 100 1% 101 11.22

    2100 39 2% 102 11.33

    2100 99 -2% 98 10.89

    1900 15 1% 101 11.22

    2100 4 -2% 98 10.89

    2100 49 1% 101 11.22

    1900 50 1% 101 11.22

    1900 42 1% 101 11.22

    2100 2 -1% 99 11.00

    2100 36 -1% 99 11.00

    1900 68 -1% 99 11.00

    1900 60 1% 101 11.22

    1900 25 1% 101 11.22

    1900 98 -1% 99 11.00

    2100 37 -2% 98 10.89

    2100 89 1% 101 11.22

    1900 77 1% 101 11.22

    2100 21 -2% 98 10.89

    2100 69 -1% 99 11.00

    1900 31 1% 101 11.22

    1900 2 2% 102 11.33

    1900 23 1% 101 11.22

    1900 20 -1% 99 11.00

    1900 96 -1% 99 11.00

    1900 59 2% 102 11.33

    2100 54 -2% 98 10.89

    2100 62 1% 101 11.22

    2100 4 -1% 99 11.00

    1900 83 -1% 99 11.00

    2100 33 1% 101 11.22

    2100 42 -1% 99 11.00

    2100 83 -1% 99 11.00

    1900 71 -1% 99 11.00

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    57/294

    1900 40 1% 101 11.22

    2100 98 2% 102 11.33

    1900 74 -2% 98 10.89

    1900 89 1% 101 11.22

    1900 47 -1% 99 11.00

    2100 16 1% 101 11.22

    1900 90 -1% 99 11.00

    2100 83 -1% 99 11.00

    1900 84 2% 102 11.33

    1900 50 -1% 99 11.00

    2100 8 1% 101 11.22

    2100 82 1% 101 11.22

    2100 87 1% 101 11.22

    1900 97 1% 101 11.22

    2100 59 2% 102 11.33

    1900 7 2% 102 11.33

    1900 65 1% 101 11.22

    2100 89 -2% 98 10.89

    2100 9 -1% 99 11.00

    1900 87 1% 101 11.22

    2100 9 2% 102 11.33

    1900 4 1% 101 11.22

    2100 46 -2% 98 10.89

    1900 62 -1% 99 11.00

    1900 66 2% 102 11.33

    2100 49 2% 102 11.33

    1900 45 1% 101 11.22

    2100 98 -2% 98 10.89

    1900 90 1% 101 11.22

    1900 28 -1% 99 11.00

    2100 69 1% 101 11.22

    2100 30 1% 101 11.22

    1900 26 -1% 99 11.00

    2100 43 1% 101 11.22

    2100 18 1% 101 11.22

    1900 73 1% 101 11.22

    1900 59 1% 101 11.22

    1900 8 -2% 98 10.89

    1900 55 -2% 98 10.89

    2100 43 1% 101 11.22

    2100 57 -1% 99 11.00

    2100 63 2% 102 11.33

    1900 24 1% 101 11.22

    1900 43 1% 101 11.22

    1900 59 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    58/294

    2100 82 -1% 99 11.00

    2100 50 1% 101 11.22

    2100 23 -1% 99 11.00

    2100 71 1% 101 11.22

    2100 58 1% 101 11.22

    1900 10 -2% 98 10.89

    2100 80 1% 101 11.22

    1900 62 1% 101 11.22

    2100 55 -2% 98 10.89

    1900 42 -1% 99 11.00

    2100 27 -1% 99 11.00

    2100 4 -2% 98 10.89

    1900 86 -2% 98 10.89

    2100 25 1% 101 11.22

    1900 94 -1% 99 11.00

    2100 14 -2% 98 10.89

    1900 94 1% 101 11.22

    1900 24 -1% 99 11.00

    2100 39 -1% 99 11.00

    2100 36 -2% 98 10.89

    1900 42 1% 101 11.22

    2100 11 1% 101 11.22

    2100 94 2% 102 11.33

    2100 49 1% 101 11.22

    1900 66 1% 101 11.22

    2100 36 -1% 99 11.00

    2100 6 1% 101 11.22

    1900 29 1% 101 11.22

    2100 60 1% 101 11.22

    1900 49 1% 101 11.22

    1900 87 1% 101 11.22

    2100 42 -1% 99 11.00

    2100 98 1% 101 11.22

    2100 9 -1% 99 11.00

    2100 12 -2% 98 10.89

    2100 56 -2% 98 10.89

    1900 19 1% 101 11.22

    1900 92 2% 102 11.33

    1900 17 -1% 99 11.00

    1900 74 1% 101 11.22

    1900 33 -1% 99 11.00

    2100 44 1% 101 11.22

    2100 77 -1% 99 11.00

    2100 19 -2% 98 10.89

    2100 69 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    59/294

    2100 71 1% 101 11.22

    2100 32 1% 101 11.22

    2100 62 -1% 99 11.00

    2100 94 -1% 99 11.00

    2100 71 -1% 99 11.00

    1900 97 2% 102 11.33

    1900 35 2% 102 11.33

    1900 82 -1% 99 11.00

    1900 90 1% 101 11.22

    1900 84 1% 101 11.22

    1900 48 1% 101 11.22

    1900 26 -2% 98 10.89

    1900 89 2% 102 11.33

    2100 76 1% 101 11.22

    2100 85 1% 101 11.22

    2100 38 1% 101 11.22

    2100 62 -1% 99 11.00

    2100 26 1% 101 11.22

    2100 36 1% 101 11.22

    1900 71 1% 101 11.22

    2100 38 -1% 99 11.00

    2100 91 -1% 99 11.00

    1900 89 1% 101 11.22

    1900 29 2% 102 11.33

    1900 7 1% 101 11.22

    1900 63 1% 101 11.22

    2100 61 1% 101 11.22

    1900 50 1% 101 11.22

    1900 39 -2% 98 10.89

    1900 79 1% 101 11.22

    1900 18 1% 101 11.22

    1900 10 -1% 99 11.00

    2100 11 -2% 98 10.89

    2100 80 1% 101 11.22

    1900 3 2% 102 11.33

    2100 81 1% 101 11.22

    2100 76 1% 101 11.22

    2100 38 -2% 98 10.89

    1900 62 1% 101 11.22

    2100 66 -2% 98 10.89

    1900 22 2% 102 11.33

    1900 10 1% 101 11.22

    1900 91 -1% 99 11.00

    2100 11 -2% 98 10.89

    1900 85 -1% 99 11.00

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    60/294

    1900 76 2% 102 11.33

    2100 48 1% 101 11.22

    1900 46 1% 101 11.22

    2100 2 2% 102 11.33

    1900 83 1% 101 11.22

    2100 17 1% 101 11.22

    1900 40 1% 101 11.22

    2100 73 -1% 99 11.00

    1900 6 2% 102 11.33

    1900 68 1% 101 11.22

    2100 80 -1% 99 11.00

    1900 68 1% 101 11.22

    1900 29 2% 102 11.33

    2100 30 1% 101 11.22

    2100 7 -2% 98 10.89

    2100 8 1% 101 11.22

    2100 47 2% 102 11.33

    2100 16 2% 102 11.33

    2100 19 -1% 99 11.00

    1900 27 -1% 99 11.00

    1900 19 1% 101 11.22

    1900 99 1% 101 11.22

    2100 2 1% 101 11.22

    1900 56 -2% 98 10.89

    1900 61 -1% 99 11.00

    2100 67 1% 101 11.22

    2100 77 1% 101 11.22

    1900 71 1% 101 11.22

    2100 58 1% 101 11.22

    1900 87 1% 101 11.22

    2100 55 -1% 99 11.00

    2100 34 -1% 99 11.00

    1900 35 1% 101 11.22

    1900 1 -1% 99 11.00

    2100 35 -1% 99 11.00

    2100 17 -2% 98 10.89

    1900 17 1% 101 11.22

    1900 74 1% 101 11.22

    1900 90 -1% 99 11.00

    2100 22 -2% 98 10.89

    1900 42 1% 101 11.22

    1900 69 -2% 98 10.89

    2100 90 -1% 99 11.00

    1900 71 2% 102 11.33

    1900 98 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    61/294

    2100 96 1% 101 11.22

    1900 79 -1% 99 11.00

    1900 45 1% 101 11.22

    2100 11 -1% 99 11.00

    2100 97 -1% 99 11.00

    1900 71 -1% 99 11.00

    2100 30 1% 101 11.22

    2100 96 1% 101 11.22

    2100 73 -2% 98 10.89

    1900 85 1% 101 11.22

    2100 57 -1% 99 11.00

    2100 40 1% 101 11.22

    2100 62 1% 101 11.22

    2100 27 1% 101 11.22

    2100 97 1% 101 11.22

    2100 49 -1% 99 11.00

    1900 81 1% 101 11.22

    2100 31 -2% 98 10.89

    2100 84 1% 101 11.22

    2100 81 1% 101 11.22

    2100 66 1% 101 11.22

    1900 100 -1% 99 11.00

    2100 98 1% 101 11.22

    1900 40 1% 101 11.22

    2100 90 -2% 98 10.89

    1900 20 1% 101 11.22

    1900 81 1% 101 11.22

    1900 58 -1% 99 11.00

    2100 9 2% 102 11.33

    1900 52 -2% 98 10.89

    1900 56 1% 101 11.22

    1900 5 2% 102 11.33

    2100 30 -2% 98 10.89

    1900 100 -2% 98 10.89

    1900 15 -1% 99 11.00

    2100 26 -1% 99 11.00

    1900 71 1% 101 11.22

    2100 45 1% 101 11.22

    1900 21 -2% 98 10.89

    2100 43 1% 101 11.22

    1900 29 1% 101 11.22

    1900 77 -1% 99 11.00

    1900 82 1% 101 11.22

    2100 91 1% 101 11.22

    2100 3 2% 102 11.33

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    62/294

    1900 79 -1% 99 11.00

    2100 40 2% 102 11.33

    2100 84 -2% 98 10.89

    1900 9 1% 101 11.22

    2100 23 1% 101 11.22

    1900 65 1% 101 11.22

    2100 74 1% 101 11.22

    2100 23 1% 101 11.22

    1900 62 -1% 99 11.00

    1900 13 2% 102 11.33

    1900 12 1% 101 11.22

    1900 81 1% 101 11.22

    1900 94 1% 101 11.22

    2100 70 1% 101 11.22

    2100 90 1% 101 11.22

    1900 46 1% 101 11.22

    2100 25 -1% 99 11.00

    2100 94 -1% 99 11.00

    2100 75 -1% 99 11.00

    1900 25 1% 101 11.22

    2100 9 1% 101 11.22

    2100 100 1% 101 11.22

    2100 96 -1% 99 11.00

    2100 53 2% 102 11.33

    1900 21 1% 101 11.22

    1900 38 -1% 99 11.00

    2100 82 -2% 98 10.89

    2100 98 -1% 99 11.00

    1900 20 1% 101 11.22

    2100 72 1% 101 11.22

    1900 1 1% 101 11.22

    1900 98 1% 101 11.22

    2100 12 -2% 98 10.89

    1900 84 1% 101 11.22

    2100 7 1% 101 11.22

    1900 34 -2% 98 10.89

    2100 48 1% 101 11.22

    2100 81 -1% 99 11.00

    2100 57 2% 102 11.33

    1900 9 1% 101 11.22

    1900 94 -1% 99 11.00

    1900 68 1% 101 11.22

    1900 90 -1% 99 11.00

    2100 88 1% 101 11.22

    2100 38 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    63/294

    1900 79 1% 101 11.22

    2100 33 -1% 99 11.00

    2100 63 -1% 99 11.00

    1900 72 1% 101 11.22

    2100 7 1% 101 11.22

    2100 87 1% 101 11.22

    2100 80 1% 101 11.22

    1900 7 1% 101 11.22

    1900 83 -2% 98 10.89

    2100 32 2% 102 11.33

    2100 27 -1% 99 11.00

    2100 20 1% 101 11.22

    1900 13 -2% 98 10.89

    1900 25 -2% 98 10.89

    2100 40 1% 101 11.22

    1900 85 1% 101 11.22

    2100 25 2% 102 11.33

    2100 37 2% 102 11.33

    2100 96 -1% 99 11.00

    2100 9 -1% 99 11.00

    1900 44 1% 101 11.22

    2100 30 1% 101 11.22

    2100 56 -2% 98 10.89

    2100 24 1% 101 11.22

    2100 86 -2% 98 10.89

    1900 65 -1% 99 11.00

    2100 17 1% 101 11.22

    2100 54 -1% 99 11.00

    2100 55 1% 101 11.22

    1900 4 -1% 99 11.00

    2100 91 2% 102 11.33

    1900 33 1% 101 11.22

    1900 37 1% 101 11.22

    1900 53 -1% 99 11.00

    2100 5 -2% 98 10.89

    1900 43 1% 101 11.22

    1900 40 -2% 98 10.89

    2100 84 1% 101 11.22

    1900 50 1% 101 11.22

    2100 23 1% 101 11.22

    2100 16 -1% 99 11.00

    2100 76 -1% 99 11.00

    1900 42 -2% 98 10.89

    2100 29 1% 101 11.22

    2100 1 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    64/294

    2100 82 1% 101 11.22

    1900 13 1% 101 11.22

    2100 25 -1% 99 11.00

    1900 19 -1% 99 11.00

    2100 9 1% 101 11.22

    2100 34 -1% 99 11.00

    2100 62 1% 101 11.22

    1900 38 1% 101 11.22

    1900 90 -2% 98 10.89

    2100 86 1% 101 11.22

    1900 24 1% 101 11.22

    1900 54 -2% 98 10.89

    2100 2 -2% 98 10.89

    2100 78 1% 101 11.22

    2100 9 1% 101 11.22

    2100 6 -2% 98 10.89

    1900 68 1% 101 11.22

    1900 41 -2% 98 10.89

    2100 42 -2% 98 10.89

    1900 21 1% 101 11.22

    1900 45 2% 102 11.33

    1900 85 2% 102 11.33

    2100 61 1% 101 11.22

    1900 29 1% 101 11.22

    2100 34 1% 101 11.22

    1900 83 2% 102 11.33

    2100 44 2% 102 11.33

    1900 10 -1% 99 11.00

    1900 25 1% 101 11.22

    1900 73 1% 101 11.22

    1900 10 -1% 99 11.00

    1900 6 -2% 98 10.89

    1900 85 1% 101 11.22

    1900 35 1% 101 11.22

    2100 25 -1% 99 11.00

    1900 94 1% 101 11.22

    2100 68 1% 101 11.22

    1900 86 2% 102 11.33

    2100 32 1% 101 11.22

    2100 57 1% 101 11.22

    2100 71 -1% 99 11.00

    2100 55 -2% 98 10.89

    2100 11 1% 101 11.22

    2100 73 -1% 99 11.00

    2100 32 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    65/294

    2100 19 2% 102 11.33

    1900 79 1% 101 11.22

    2100 100 2% 102 11.33

    2100 60 -2% 98 10.89

    2100 20 2% 102 11.33

    1900 21 -1% 99 11.00

    2100 5 -1% 99 11.00

    2100 5 1% 101 11.22

    1900 82 -2% 98 10.89

    1900 34 2% 102 11.33

    2100 38 1% 101 11.22

    2100 64 1% 101 11.22

    1900 78 2% 102 11.33

    1900 47 1% 101 11.22

    2100 89 -1% 99 11.00

    2100 50 2% 102 11.33

    1900 57 1% 101 11.22

    2100 95 2% 102 11.33

    2100 34 1% 101 11.22

    2100 92 1% 101 11.22

    1900 19 1% 101 11.22

    2100 27 1% 101 11.22

    1900 59 1% 101 11.22

    2100 5 2% 102 11.33

    1900 59 1% 101 11.22

    1900 16 -1% 99 11.00

    2100 75 -2% 98 10.89

    2100 13 -1% 99 11.00

    2100 27 1% 101 11.22

    1900 48 -1% 99 11.00

    2100 45 1% 101 11.22

    1900 46 -1% 99 11.00

    2100 26 -1% 99 11.00

    2100 45 1% 101 11.22

    1900 6 1% 101 11.22

    1900 46 2% 102 11.33

    2100 65 -2% 98 10.89

    2100 10 1% 101 11.22

    2100 50 -1% 99 11.00

    2100 47 1% 101 11.22

    1900 44 -2% 98 10.89

    2100 87 2% 102 11.33

    1900 10 -2% 98 10.89

    1900 21 1% 101 11.22

    2100 34 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    66/294

    2100 99 2% 102 11.33

    1900 70 1% 101 11.22

    1900 91 1% 101 11.22

    2100 93 -1% 99 11.00

    2100 4 -1% 99 11.00

    1900 82 2% 102 11.33

    2100 12 1% 101 11.22

    1900 31 1% 101 11.22

    1900 41 1% 101 11.22

    2100 16 1% 101 11.22

    2100 89 -2% 98 10.89

    2100 57 1% 101 11.22

    1900 91 1% 101 11.22

    2100 2 -1% 99 11.00

    2100 84 -2% 98 10.89

    2100 38 1% 101 11.22

    2100 47 1% 101 11.22

    2100 29 1% 101 11.22

    1900 63 -1% 99 11.00

    1900 91 -2% 98 10.89

    2100 34 1% 101 11.22

    2100 8 1% 101 11.22

    2100 56 -1% 99 11.00

    1900 44 1% 101 11.22

    1900 58 2% 102 11.33

    1900 2 1% 101 11.22

    1900 88 1% 101 11.22

    1900 44 -1% 99 11.00

    2100 12 -2% 98 10.89

    1900 8 -2% 98 10.89

    2100 78 1% 101 11.22

    1900 10 1% 101 11.22

    2100 78 1% 101 11.22

    2100 69 1% 101 11.22

    1900 3 -1% 99 11.00

    2100 81 1% 101 11.22

    2100 50 1% 101 11.22

    2100 15 2% 102 11.33

    2100 12 -2% 98 10.89

    2100 91 -2% 98 10.89

    2100 30 -2% 98 10.89

    2100 1 1% 101 11.22

    2100 47 -2% 98 10.89

    1900 20 1% 101 11.22

    1900 2 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    67/294

    2100 30 1% 101 11.22

    1900 58 -2% 98 10.89

    2100 48 -2% 98 10.89

    2100 59 1% 101 11.22

    2100 20 -2% 98 10.89

    2100 38 1% 101 11.22

    2100 93 1% 101 11.22

    2100 28 1% 101 11.22

    2100 94 1% 101 11.22

    1900 37 -1% 99 11.00

    1900 85 -1% 99 11.00

    1900 95 -1% 99 11.00

    2100 24 2% 102 11.33

    1900 29 1% 101 11.22

    2100 6 1% 101 11.22

    2100 32 1% 101 11.22

    1900 6 -1% 99 11.00

    1900 16 1% 101 11.22

    2100 9 -1% 99 11.00

    2100 75 -1% 99 11.00

    2100 19 1% 101 11.22

    1900 90 -1% 99 11.00

    2100 24 -1% 99 11.00

    1900 33 2% 102 11.33

    1900 2 -1% 99 11.00

    1900 15 1% 101 11.22

    2100 62 -1% 99 11.00

    1900 2 1% 101 11.22

    1900 61 1% 101 11.22

    2100 82 2% 102 11.33

    1900 3 -1% 99 11.00

    2100 91 -1% 99 11.00

    1900 39 -1% 99 11.00

    2100 51 -1% 99 11.00

    2100 50 -1% 99 11.00

    1900 59 1% 101 11.22

    1900 89 1% 101 11.22

    2100 42 2% 102 11.33

    2100 86 1% 101 11.22

    1900 82 -1% 99 11.00

    1900 78 -1% 99 11.00

    2100 71 -2% 98 10.89

    2100 76 -1% 99 11.00

    1900 2 -1% 99 11.00

    2100 99 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    68/294

    1900 82 1% 101 11.22

    2100 34 1% 101 11.22

    2100 5 -1% 99 11.00

    1900 98 -1% 99 11.00

    2100 42 2% 102 11.33

    2100 79 -2% 98 10.89

    1900 16 1% 101 11.22

    2100 32 1% 101 11.22

    2100 3 1% 101 11.22

    1900 49 -2% 98 10.89

    2100 34 2% 102 11.33

    1900 17 -2% 98 10.89

    1900 11 -1% 99 11.00

    2100 35 1% 101 11.22

    1900 77 1% 101 11.22

    1900 92 1% 101 11.22

    1900 38 1% 101 11.22

    2100 68 -2% 98 10.89

    1900 31 2% 102 11.33

    1900 88 2% 102 11.33

    2100 17 1% 101 11.22

    1900 90 1% 101 11.22

    2100 76 1% 101 11.22

    2100 59 -1% 99 11.00

    2100 76 1% 101 11.22

    2100 58 1% 101 11.22

    2100 37 1% 101 11.22

    2100 46 1% 101 11.22

    2100 34 2% 102 11.33

    2100 38 -1% 99 11.00

    2100 44 2% 102 11.33

    1900 15 1% 101 11.22

    2100 71 1% 101 11.22

    1900 48 -1% 99 11.00

    2100 13 1% 101 11.22

    1900 13 -1% 99 11.00

    1900 26 2% 102 11.33

    2100 28 2% 102 11.33

    2100 45 -2% 98 10.89

    2100 28 1% 101 11.22

    1900 76 2% 102 11.33

    1900 78 -2% 98 10.89

    2100 44 -2% 98 10.89

    2100 86 2% 102 11.33

    2100 12 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    69/294

    2100 21 -1% 99 11.00

    2100 78 1% 101 11.22

    2100 50 1% 101 11.22

    1900 89 2% 102 11.33

    1900 9 1% 101 11.22

    2100 37 2% 102 11.33

    1900 5 1% 101 11.22

    1900 98 -2% 98 10.89

    2100 13 1% 101 11.22

    1900 63 -2% 98 10.89

    2100 73 1% 101 11.22

    2100 70 1% 101 11.22

    1900 99 1% 101 11.22

    1900 18 -1% 99 11.00

    2100 3 1% 101 11.22

    2100 37 1% 101 11.22

    2100 62 1% 101 11.22

    2100 18 -2% 98 10.89

    2100 8 1% 101 11.22

    1900 9 1% 101 11.22

    2100 31 1% 101 11.22

    2100 21 -2% 98 10.89

    2100 35 1% 101 11.22

    2100 59 -1% 99 11.00

    1900 65 1% 101 11.22

    2100 63 -1% 99 11.00

    1900 34 -2% 98 10.89

    1900 43 -2% 98 10.89

    1900 6 1% 101 11.22

    1900 20 -2% 98 10.89

    2100 55 -2% 98 10.89

    1900 27 1% 101 11.22

    2100 98 2% 102 11.33

    1900 4 -2% 98 10.89

    2100 15 1% 101 11.22

    2100 7 -1% 99 11.00

    1900 41 1% 101 11.22

    2100 20 2% 102 11.33

    2100 4 -1% 99 11.00

    1900 53 1% 101 11.22

    2100 83 -2% 98 10.89

    2100 77 -2% 98 10.89

    1900 23 1% 101 11.22

    2100 82 -2% 98 10.89

    2100 95 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    70/294

    1900 26 -2% 98 10.89

    1900 18 1% 101 11.22

    1900 56 -1% 99 11.00

    1900 44 1% 101 11.22

    2100 26 1% 101 11.22

    1900 65 2% 102 11.33

    2100 74 -1% 99 11.00

    1900 46 2% 102 11.33

    2100 99 -1% 99 11.00

    2100 32 1% 101 11.22

    2100 11 -1% 99 11.00

    1900 61 -1% 99 11.00

    2100 66 1% 101 11.22

    2100 53 1% 101 11.22

    1900 67 -1% 99 11.00

    2100 86 1% 101 11.22

    2100 7 2% 102 11.33

    2100 94 -2% 98 10.89

    1900 84 -1% 99 11.00

    1900 11 1% 101 11.22

    1900 8 -2% 98 10.89

    1900 90 1% 101 11.22

    1900 51 1% 101 11.22

    1900 28 2% 102 11.33

    1900 94 1% 101 11.22

    1900 4 2% 102 11.33

    1900 11 -2% 98 10.89

    2100 70 1% 101 11.22

    1900 27 -1% 99 11.00

    1900 92 2% 102 11.33

    1900 64 1% 101 11.22

    2100 53 -2% 98 10.89

    1900 10 -1% 99 11.00

    1900 20 -2% 98 10.89

    2100 96 2% 102 11.33

    1900 35 -2% 98 10.89

    2100 84 -2% 98 10.89

    1900 70 1% 101 11.22

    1900 80 -2% 98 10.89

    2100 82 2% 102 11.33

    2100 1 1% 101 11.22

    1900 90 -1% 99 11.00

    1900 43 2% 102 11.33

    2100 67 1% 101 11.22

    2100 43 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    71/294

    1900 9 2% 102 11.33

    1900 53 -1% 99 11.00

    2100 49 -1% 99 11.00

    2100 2 -2% 98 10.89

    1900 36 1% 101 11.22

    1900 60 1% 101 11.22

    2100 10 2% 102 11.33

    2100 25 1% 101 11.22

    2100 10 -1% 99 11.00

    2100 38 1% 101 11.22

    1900 18 -1% 99 11.00

    2100 14 -1% 99 11.00

    2100 48 1% 101 11.22

    2100 88 -2% 98 10.89

    1900 40 -2% 98 10.89

    1900 39 1% 101 11.22

    2100 51 -1% 99 11.00

    2100 92 1% 101 11.22

    2100 48 1% 101 11.22

    1900 71 2% 102 11.33

    2100 88 1% 101 11.22

    2100 83 1% 101 11.22

    1900 54 2% 102 11.33

    1900 57 1% 101 11.22

    2100 62 1% 101 11.22

    2100 36 1% 101 11.22

    2100 58 1% 101 11.22

    1900 52 -2% 98 10.89

    1900 78 -1% 99 11.00

    2100 24 -1% 99 11.00

    1900 94 -1% 99 11.00

    1900 87 -1% 99 11.00

    2100 77 1% 101 11.22

    2100 43 -2% 98 10.89

    2100 89 -1% 99 11.00

    2100 12 -1% 99 11.00

    2100 2 1% 101 11.22

    2100 99 1% 101 11.22

    2100 36 1% 101 11.22

    1900 12 -1% 99 11.00

    1900 36 -1% 99 11.00

    1900 54 1% 101 11.22

    2100 25 1% 101 11.22

    1900 83 -1% 99 11.00

    2100 41 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    72/294

    1900 65 2% 102 11.33

    2100 22 -2% 98 10.89

    2100 92 -1% 99 11.00

    1900 56 -2% 98 10.89

    2100 70 2% 102 11.33

    2100 62 2% 102 11.33

    2100 43 2% 102 11.33

    2100 52 1% 101 11.22

    1900 16 -1% 99 11.00

    2100 100 -2% 98 10.89

    1900 14 -1% 99 11.00

    2100 51 1% 101 11.22

    2100 57 1% 101 11.22

    1900 66 1% 101 11.22

    2100 29 1% 101 11.22

    1900 81 -1% 99 11.00

    2100 60 1% 101 11.22

    2100 16 1% 101 11.22

    2100 57 1% 101 11.22

    2100 3 1% 101 11.22

    2100 4 1% 101 11.22

    2100 68 1% 101 11.22

    2100 5 1% 101 11.22

    1900 2 1% 101 11.22

    1900 4 1% 101 11.22

    1900 16 -1% 99 11.00

    1900 38 -1% 99 11.00

    1900 57 -1% 99 11.00

    1900 41 2% 102 11.33

    1900 21 1% 101 11.22

    2100 97 2% 102 11.33

    2100 5 1% 101 11.22

    1900 42 2% 102 11.33

    1900 88 1% 101 11.22

    2100 61 1% 101 11.22

    1900 12 2% 102 11.33

    2100 50 -1% 99 11.00

    2100 4 -1% 99 11.00

    2100 63 -2% 98 10.89

    2100 65 1% 101 11.22

    2100 3 -1% 99 11.00

    2100 77 1% 101 11.22

    1900 16 -1% 99 11.00

    1900 60 2% 102 11.33

    2100 42 2% 102 11.33

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    73/294

    2100 44 1% 101 11.22

    1900 40 1% 101 11.22

    1900 1 -2% 98 10.89

    1900 60 1% 101 11.22

    1900 97 -2% 98 10.89

    2100 3 1% 101 11.22

    2100 63 2% 102 11.33

    1900 64 1% 101 11.22

    2100 7 -2% 98 10.89

    1900 65 2% 102 11.33

    2100 68 2% 102 11.33

    1900 23 1% 101 11.22

    1900 2 1% 101 11.22

    1900 24 1% 101 11.22

    1900 63 -1% 99 11.00

    1900 23 2% 102 11.33

    2100 21 2% 102 11.33

    2100 68 1% 101 11.22

    1900 64 -1% 99 11.00

    2100 9 1% 101 11.22

    2100 28 -1% 99 11.00

    2100 76 1% 101 11.22

    2100 58 1% 101 11.22

    1900 32 1% 101 11.22

    1900 39 -1% 99 11.00

    1900 22 1% 101 11.22

    2100 34 2% 102 11.33

    1900 15 1% 101 11.22

    2100 37 2% 102 11.33

    1900 93 2% 102 11.33

    1900 57 1% 101 11.22

    1900 81 1% 101 11.22

    2100 33 1% 101 11.22

    2100 58 1% 101 11.22

    2100 41 2% 102 11.33

    2100 29 1% 101 11.22

    2100 60 1% 101 11.22

    1900 4 -1% 99 11.00

    1900 93 1% 101 11.22

    1900 67 -1% 99 11.00

    2100 68 1% 101 11.22

    1900 60 1% 101 11.22

    2100 90 -1% 99 11.00

    1900 70 1% 101 11.22

    1900 84 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    74/294

    1900 53 -1% 99 11.00

    2100 92 2% 102 11.33

    1900 4 -1% 99 11.00

    2100 21 -2% 98 10.89

    1900 56 1% 101 11.22

    2100 12 -1% 99 11.00

    2100 49 -1% 99 11.00

    1900 31 1% 101 11.22

    2100 69 2% 102 11.33

    2100 80 2% 102 11.33

    2100 69 -1% 99 11.00

    1900 91 -1% 99 11.00

    1900 13 1% 101 11.22

    2100 84 -2% 98 10.89

    1900 28 1% 101 11.22

    1900 6 -1% 99 11.00

    1900 40 -1% 99 11.00

    1900 9 1% 101 11.22

    1900 38 -1% 99 11.00

    1900 97 1% 101 11.22

    1900 49 1% 101 11.22

    1900 66 1% 101 11.22

    1900 57 -2% 98 10.89

    1900 52 1% 101 11.22

    2100 58 1% 101 11.22

    2100 24 1% 101 11.22

    2100 20 -1% 99 11.00

    1900 18 1% 101 11.22

    1900 14 -2% 98 10.89

    1900 89 -1% 99 11.00

    2100 1 2% 102 11.33

    2100 66 -1% 99 11.00

    1900 81 1% 101 11.22

    1900 4 1% 101 11.22

    2100 87 -2% 98 10.89

    2100 36 2% 102 11.33

    2100 16 -1% 99 11.00

    2100 35 2% 102 11.33

    2100 67 1% 101 11.22

    2100 85 -2% 98 10.89

    2100 14 1% 101 11.22

    2100 36 -1% 99 11.00

    1900 75 2% 102 11.33

    1900 27 1% 101 11.22

    1900 20 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    75/294

    2100 2 -1% 99 11.00

    2100 32 1% 101 11.22

    2100 60 1% 101 11.22

    2100 11 -1% 99 11.00

    2100 69 2% 102 11.33

    2100 56 -2% 98 10.89

    2100 59 -2% 98 10.89

    2100 35 2% 102 11.33

    1900 13 -1% 99 11.00

    2100 10 1% 101 11.22

    1900 93 1% 101 11.22

    1900 37 -1% 99 11.00

    2100 30 2% 102 11.33

    2100 11 -2% 98 10.89

    2100 50 2% 102 11.33

    1900 18 -1% 99 11.00

    2100 11 -1% 99 11.00

    2100 16 -2% 98 10.89

    2100 98 -1% 99 11.00

    1900 15 -1% 99 11.00

    1900 2 2% 102 11.33

    1900 34 -1% 99 11.00

    2100 30 1% 101 11.22

    2100 36 -1% 99 11.00

    1900 1 -1% 99 11.00

    1900 15 -1% 99 11.00

    2100 49 2% 102 11.33

    2100 37 -1% 99 11.00

    1900 89 2% 102 11.33

    1900 76 -2% 98 10.89

    2100 56 -2% 98 10.89

    2100 91 -1% 99 11.00

    2100 7 2% 102 11.33

    2100 15 1% 101 11.22

    1900 1 -2% 98 10.89

    2100 76 -2% 98 10.89

    2100 71 -1% 99 11.00

    2100 59 1% 101 11.22

    1900 11 1% 101 11.22

    2100 84 -1% 99 11.00

    2100 69 2% 102 11.33

    2100 3 -2% 98 10.89

    1900 20 1% 101 11.22

    1900 98 1% 101 11.22

    1900 13 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    76/294

    2100 70 2% 102 11.33

    2100 16 1% 101 11.22

    1900 24 1% 101 11.22

    1900 85 1% 101 11.22

    2100 14 1% 101 11.22

    2100 39 2% 102 11.33

    1900 87 1% 101 11.22

    2100 48 -1% 99 11.00

    2100 69 1% 101 11.22

    2100 22 1% 101 11.22

    2100 48 -1% 99 11.00

    2100 83 -1% 99 11.00

    1900 71 2% 102 11.33

    2100 85 1% 101 11.22

    1900 71 -2% 98 10.89

    1900 46 -2% 98 10.89

    2100 40 -2% 98 10.89

    1900 61 1% 101 11.22

    2100 52 1% 101 11.22

    2100 55 -1% 99 11.00

    1900 62 1% 101 11.22

    2100 28 1% 101 11.22

    2100 26 1% 101 11.22

    2100 20 2% 102 11.33

    2100 38 2% 102 11.33

    2100 9 -2% 98 10.89

    1900 89 1% 101 11.22

    1900 41 1% 101 11.22

    2100 28 1% 101 11.22

    2100 86 1% 101 11.22

    2100 54 1% 101 11.22

    2100 97 -2% 98 10.89

    1900 1 -1% 99 11.00

    1900 77 1% 101 11.22

    2100 82 -1% 99 11.00

    2100 15 2% 102 11.33

    2100 15 1% 101 11.22

    2100 68 -2% 98 10.89

    2100 62 1% 101 11.22

    1900 84 2% 102 11.33

    2100 89 -1% 99 11.00

    1900 9 1% 101 11.22

    2100 66 -2% 98 10.89

    1900 60 2% 102 11.33

    1900 94 1% 101 11.22

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    77/294

    1900 37 1% 101 11.22

    2100 6 2% 102 11.33

    1900 33 -2% 98 10.89

    1900 97 1% 101 11.22

    1900 58 -2% 98 10.89

    1900 88 1% 101 11.22

    1900 58 -2% 98 10.89

    2100 85 1% 101 11.22

    1900 13 1% 101 11.22

    1900 78 -1% 99 11.00

    2100 22 1% 101 11.22

    2100 21 1% 101 11.22

    2100 66 1% 101 11.22

    2100 62 2% 102 11.33

    2100 49 2% 102 11.33

    1900 52 -1% 99 11.00

    1900 16 -2% 98 10.89

    2100 46 -2% 98 10.89

    2100 53 1% 101 11.22

    2100 92 1% 101 11.22

    2100 27 -1% 99 11.00

    2100 67 1% 101 11.22

    1900 7 -1% 99 11.00

    2100 94 -2% 98 10.89

    1900 28 1% 101 11.22

    2100 91 1% 101 11.22

    2100 83 -2% 98 10.89

    2100 37 -2% 98 10.89

    2100 56 1% 101 11.22

    1900 43 2% 102 11.33

    2100 30 -1% 99 11.00

    1900 92 1% 101 11.22

    1900 48 -2% 98 10.89

    2100 63 -2% 98 10.89

    1900 89 2% 102 11.33

    1900 5 1% 101 11.22

    1900 51 1% 101 11.22

    1900 47 1% 101 11.22

    1900 89 -1% 99 11.00

    1900 64 -2% 98 10.89

    2100 25 1% 101 11.22

    2100 11 1% 101 11.22

    1900 85 2% 102 11.33

    2100 91 1% 101 11.22

    1900 73 -2% 98 10.89

  • 8/9/2019 Proyecto-Simulacion Gerencial Excel

    78/294

    2100 33 -1% 99 11.00

    1900 42 2% 102 11.33

    1900 88 2% 102 11.33

    2100 78 -2% 98 10.89

    1900 95 -1% 99 11.00

    1900 80 1% 101 11.22

    1900 5 1% 101 11.22

    2100 62 2% 102 11.33

    2100 87 1% 101 11.22

    2100 99 1% 101 11.22

    2100 90 1% 101 11.22

    1900 77 1% 101 11.22

    1900 82 1% 101 11.22

    2100 27 2% 102 11.33

    1900 32 1% 101 11.22

    1900 24 -1% 99 11.00

    2100 56 1% 101 11.22

    1900 24 -1% 99 11.00

    2100 72 -1% 99 11.00

    2100 19 1% 101 11.22

    2100 12 1% 101 11.22

    2100 76 1% 101 11.22

    2100 70 1% 101 11.22

    2100 59 1% 101 11.22

    2100 65 2% 102 11.33

    2100 33 -1% 99 11.00

    1900 83 1% 101 11.22

    1900 75 1% 101 11.22

    2100 17 -2% 98 10.89

    2100 73 -1% 99 11.00

    2100 47 2% 102 11.33

    2100 50 -1% 99 11.00

    2100 15 1% 101 11.22

    1900 35 -1% 99 11.00

    1900 28 1% 101 11.22

    2100 10 1% 101 11.22