Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Problema da Florista Dados do Problema e Resolução Exemplo - Florista Dados do Problema Simulação Demanda Lucro Tendência - Lucro Valor de Venda 1 1 84 35.6 35.6 Valor de Compra 0.5 2 104 50 42.8 Valor quando sobra 0.1 3 96 46.4 44.0 4 132 50 45.5 Demanda 5 119 50 46.4 Média 100 6 85 36.5 44.8 Desvio-padrão 20 7 81 32.9 43.1 8 107 50 43.9 Quantidade Comprada 100 9 99 49.1 44.5 10 98 48.2 44.9 11 122 50 45.3 12 100 50 45.7 13 73 25.7 44.2 14 76 28.4 43.1 15 98 48.2 43.4 16 88 39.2 43.1 17 86 37.4 42.8 18 112 50 43.2 19 89 40.1 43.0 20 67 20.3 41.9 21 111 50 42.3 22 65 18.5 41.2 23 105 50 41.6 24 106 50 41.9 25 104 50 42.3 26 88 39.2 42.1 27 107 50 42.4 28 128 50 42.7 29 97 47.3 42.9 30 128 50 43.1 31 125 50 43.3 32 90 41 43.3 33 102 50 43.5 34 102 50 43.6 35 98 48.2 43.8 36 81 32.9 43.5 37 123 50 43.7 38 83 34.7 43.4 39 102 50 43.6 40 122 50 43.7 41 70 23 43.2 42 99 49.1 43.4 43 66 19.4 42.8 44 126 50 43.0 45 120 50 43.1 46 91 41.9 43.1 47 110 50 43.3 48 98 48.2 43.4 49 76 28.4 43.1 50 111 50 43.2 51 98 48.2 43.3 52 104 50 43.4 53 91 41.9 43.4 54 77 29.3 43.1 55 119 50 43.3 56 109 50 43.4 57 81 32.9 43.2 58 94 44.6 43.2 59 113 50 43.3 60 110 50 43.4 61 104 50 43.6 62 80 32 43.4 63 82 33.8 43.2 64 122 50 43.3 65 118 50 43.4 66 104 50 43.5 67 119 50 43.6 68 85 36.5 43.5 69 122 50 43.6 70 113 50 43.7 71 72 24.8 43.4 72 85 36.5 43.3 73 96 46.4 43.4 74 100 50 43.5 75 100 50 43.6 76 121 50 43.6 77 141 50 43.7 78 98 48.2 43.8 79 80 32 43.6 80 72 24.8 43.4 81 83 34.7 43.3 82 72 24.8 43.1 83 94 44.6 43.1 84 37 -6.7 42.5 85 84 35.6 42.4 86 99 49.1 42.5 87 137 50 42.6 88 69 22.1 42.3 89 85 36.5 42.3 90 92 42.8 42.3 91 114 50 42.4 92 120 50 42.4 93 112 50 42.5 94 77 29.3 42.4 95 89 40.1 42.4 96 102 50 42.4 97 95 45.5 42.5 98 98 48.2 42.5 99 85 36.5 42.5 100 105 50 42.5 Lucro Médio 42.548 Gráfico Tendência Lucro Tabela de Dados - Parte I Exemplo - Florista Dados do Problema Simulação Demanda Lucro Simulação 39.614 Valor de Venda 1 1 60 14 1 Valor de Compra 0.5 2 98 48.2 2 Valor quando sobra 0.1 3 66 19.4 3 4 107 50 4 Demanda 5 58 12.2 5 Média 100 6 122 50 6 Desvio-padrão 20 7 96 46.4 7 8 95 45.5 8 Quantidade Comprada 100 9 86 37.4 9 10 106 50 10 11 97 47.3 11 12 95 45.5 12 13 96 46.4 13 14 126 50 14 15 127 50 15 16 61 14.9 16 17 91 41.9 17 18 85 36.5 18 19 141 50 19 20 75 27.5 20 21 126 50 22 77 29.3 23 87 38.3 24 80 32 25 69 22.1 26 50 5 27 73 25.7 28 123 50 29 104 50 30 81 32.9 31 90 41 32 101 50 33 86 37.4 34 111 50 35 92 42.8 36 91 41.9 37 80 32 38 77 29.3 39 95 45.5 40 109 50 41 67 20.3 42 100 50 43 105 50 44 81 32.9 45 56 10.4 46 93 43.7 47 77 29.3 48 119 50 49 86 37.4 50 126 50 51 72 24.8 52 115 50 53 137 50 54 72 24.8 55 147 50 56 68 21.2 57 87 38.3 58 93 43.7 59 67 20.3 60 68 21.2 61 149 50 62 103 50 63 84 35.6 64 91 41.9 65 124 50 66 107 50 67 69 22.1 68 128 50 69 99 49.1 70 115 50 71 101 50 72 111 50 73 123 50 74 119 50 75 60 14 76 116 50 77 125 50 78 119 50 79 143 50 80 84 35.6 81 84 35.6 82 109 50 83 75 27.5 84 100 50 85 102 50 86 111 50 87 106 50 88 101 50 89 88 39.2 90 86 37.4 91 60 14 92 93 43.7 93 67 20.3 94 83 34.7 95 109 50 96 85 36.5 97 89 40.1 98 97 47.3 99 126 50 100 78 30.2 Lucro Médio 39.614 Tabela de Dados - Parte II Exemplo - Florista Dados do Problema Simulação Demanda Lucro Simulação do número de flores compradas - Tabela de Dados Valor de Venda 1 1 110 50 40.793 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 Valor de Compra 0.5 2 75 27.5 1 40.817 40.03 40.908 40.085 41.332 41.643 40.928 41.329 42.135 43.337 42.136 43.374 42.812 43.159 42.741 43.088 41.734 42.405 44.948 42.379 41.871 41.471 42.628 41.823 40.298 43.111 40.929 41.132 43.234 42.879 42.794 Valor quando sobra 0.1 3 123 50 2 40.808 40.813 42.375 41.138 41.674 40.221 42.08 40.546 43.26 40.799 42.199 41.646 41.534 42.493 42.759 43.88 41.509 41.334 43.103 43.792 42.456 43.487 41.341 43.092 43.061 41.374 40.524 43.193 39.382 41.718 41.543 4 82 33.8 3 39.899 39.58 40.629 41.192 41.71 41.805 41.918 41.554 41.145 42.95 41.929 42.006 43.433 43.456 43.758 44.042 39.907 41.685 43.454 42.604 42.312 41.075 43.708 41.481 42.728 42.652 43.368 41.078 42.28 41.484 47.051 Demanda 5 106 50 4 40.052 40.984 40.917 40.949 40.099 40.734 42.602 41.239 38.922 42.599 41.947 42.996 42.173 43.69 43.425 43.394 41.671 43.548 42.923 43.144 42.429 40.328 40.45 43.218 42.962 42.49 45.159 41.528 39.76 40.458 38.609 Média 100 6 117 50 5 40.475 41.263 41.223 40.517 42.925 42.165 41.522 41.095 42.567 43.562 43.189 41.898 43.856 39.793 43.461 43.043 41.203 42.81 43.292 42.298 42.357 41.516 42.871 41.787 40.676 41.635 41.685 42.338 43.585 37.794 43.082 Desvio-padrão 20 7 108 50 6 40.088 39.922 41.214 41.237 40.126 42.057 42.44 41.95 41.847 41.447 42.217 42.933 41.849 43.069 43.011 41.459 42.355 41.946 42.509 41.434 43.77 41.282 43.906 44.532 42.899 42.742 41.28 42.734 40.327 40.602 43.64 8 85 36.5 7 40.385 40.795 40.467 40.454 41.503 42.048 41.864 42.679 42.954 42.338 43.549 41.781 42.938 41.845 42.705 44.249 42.139 43.476 42.473 42.649 42.861 42.704 43.042 43.776 42.629 42.85 41.892 41.897 41.137 40.323 41.345 Quantidade Comprada 100 9 90 41 8 40.061 39.337 41.322 40.742 42.421 41.499 41.756 42.778 41.325 40.907 42.406 42.024 42.074 43.69 40.734 43.682 41.716 40.686 42.617 41.245 39.306 42.596 41.539 41.859 42.737 41.005 43.062 41.915 41.38 39.693 40.688 10 87 38.3 9 39.107 39.148 41.259 40.715 41.62 40.149 43.133 40.618 40.938 41.582 41.695 41.952 41.822 43.744 42.849 42.17 42.256 42.468 42.383 42.217 41.781 42.812 41.485 42.597 43.394 42.481 42.477 43.634 43.369 42.123 41.021 11 97 47.3 10 40.259 39.787 42.321 40.769 41.161 41.067 41.954 42.463 40.668 42.491 42.856 41.403 42.29 41.638 42.642 43.376 44.209 43.575 41.87 43.729 40.557 41.804 42.25 43.065 40.046 42.454 40.38 44.381 40.372 41.007 40.769 12 107 50 11 38.684 39.688 40.611 39.635 41.566 41.247 40.748 41.725 42.153 41.717 41.929 43.167 41.417 41.377 44.847 42.566 40.456 42.693 41.177 41.497 42.969 41.777 41.593 42.876 41.576 42.247 42.747 42.752 39.805 42.447 40.625 13 84 35.6 12 39.44 41.083 40.539 40.184 40.612 41.445 41.135 42.679 42.63 40.475 41.038 42.78 40.058 41.008 44.217 43.187 41.986 43.179 42.833 42.424 44.994 42.2 43.654 41.094 45.167 40.996 40.551 41.789 43.018 38.478 41.057 14 116 50 13 40.187 40.48 41.619 41.795 40.639 40.833 42.557 40.915 42.513 43.535 40.714 43.383 43.874 43.186 40.491 42.458 42.976 42.837 42.311 43.396 42.285 42.686 41.242 43.497 39.848 41.356 43.953 40.826 39.553 38.487 41.84 15 65 18.5 14 40.394 40.615 40.755 39.518 41.89 41.409 41.387 42.004 41.586 41.186 43.36 42.042 41.075 42.511 40.554 42.71 45.136 41.109 42.302 45.043 43.302 43.136 43.825 42.426 40.838 42.193 41.154 41.312 39.76 42.357 39.959 16 58 12.2 15 39.818 40.084 40.143 39.149 41.737 42.012 40.73 42.058 43.557 42.617 43.405 40.98 42.983 42.241 43.632 41.27 42.931 42.513 43.049 42.208 42.312 41.138 42.088 43.101 39.74 42.751 41.739 40.817 40.921 41.295 42.155 17 111 50 16 39.836 39.517 39.675 40.787 39.946 42.075 41.135 42.175 41.973 42.059 43.09 43.266 42.227 42.151 42.966 41.36 43.579 42.207 43.751 42.046 42.681 43.199 44.23 41.823 42.53 42.85 40.02 44.3 41.209 42.663 38.924 18 115 50 17 39.836 39.301 40.521 40.328 41.233 40.689 41.774 41.896 42.99 41.06 41.83 42.501 42.794 44.671 42.948 44.564 40.627 42.351 42.068 41.803 42.699 42.569 43.546 43.398 43.025 42.877 41.802 42.707 41.632 42.186 40.121 19 89 40.1 18 39.809 40.417 40.863 41.525 40.018 41.913 42.737 42.976 41.595 43.202 43.585 41.088 42.308 43.006 42.93 43.565 40.843 43.314 42.068 43.621 42.906 44.531 42.376 41.589 41.612 41.869 42.765 43.562 42.766 42.357 41.282 20 121 50 19 39.791 41.425 40.341 41.03 40.801 40.698 40.982 42.004 42.099 41.789 41.785 42.645 42.317 42.619 42.966 42.413 42.733 39.957 42.896 44.08 41.061 44.783 42.718 41.976 43.925 41.419 43.404 45.776 42.307 40.431 41.615 21 114 50 20 41.519 40.867 40.773 40.112 41.899 41.454 42.161 42.841 39.399 42.716 42.388 40.971 42.884 40.936 42.156 43.79 41.788 42.477 42.833 44.269 41.862 42.227 43.321 43.245 41.486 40.294 41.163 40.844 40.687 41.205 41.435 22 89 40.1 21 40.025 40.696 39.378 39.545 40.036 41.661 41.054 42.31 41.145 41.519 42.262 43.698 40.931 43.384 43.407 42.881 39.943 43.467 41.276 43.261 44.688 41.507 43.006 41.04 41.27 42.328 42.45 42.581 40.534 42.294 44.945 23 60 14 22 39.764 41.353 40.539 41.417 40.036 42.066 42.773 42.004 40.047 41.717 41.398 42.564 42.362 43.636 43.38 42.242 40.852 42.117 43.472 43.972 41.988 43.163 42.817 43.308 42.881 42.625 42.954 42.527 41.839 40.116 39.113 24 93 43.7 23 39.683 39.922 40.845 40.607 41.728 41.85 42.98 42.778 42.378 41.996 40.957 42.159 41.489 42.988 42.984 42.764 43.12 42.648 44.03 43.414 40.287 43.982 41.89 40.707 42.782 41.545 42.315 41.024 41.038 44.445 41.822 25 81 32.9 24 40.025 40.75 40.656 41.579 41.485 42.093 42.152 42.553 42.693 40.844 41.218 42.159 42.893 42.304 42.102 43.178 41.896 41.496 41.843 41.326 43.365 44.225 40.873 43.911 40.019 42.742 43.017 41.249 41.065 43.671 41.858 26 123 50 25 39.17 41.722 40.359 40.733 40.765 40.167 38.966 41.959 42.198 42.104 44.89 42.987 42.227 44.194 41.301 40.829 45.055 43.305 44.057 42.424 42.141 40.904 41.35 42.66 41.387 44.335 41.811 42.059 41.434 41.943 40.463 27 55 9.5 26 39.197 39.562 38.415 39.869 41.53 42.615 41.756 43.012 41.019 42.329 40.498 41.772 42.02 44.662 42.3 43.07 42.805 42.396 43.886 41.488 44.166 43.046 43.159 42.813 43.394 42.553 44.151 40.709 40.75 39.441 42.92 28 84 35.6 27 40.421 39.535 40.962 41.48 41.305 40.941 41.774 41.617 40.848 42.734 43.135 42.42 43.622 42.493 43.506 42.35 41.869 43.539 41.168 40.687 43.644 43.559 44.428 41.526 39.236 44.785 42.621 42.581 41.803 41.277 41.588 29 103 50 28 40.367 38.473 40.521 40.724 41.404 39.924 41.513 40.447 41.658 42.698 42.901 40.899 43.244 41.224 41.031 41.441 43.066 42.954 42.671 44.053 40.836 43.118 42.592 45.198 42.494 43.003 43.971 41.645 43.198 38.973 39.374 30 117 50 29 39.008 40.381 40.26 40.994 41.098 40.14 41.288 39.241 41.973 41.789 41.929 43.023 43.649 42.655 43.11 40.874 41.032 40.641 43.688 43.54 42.195 44.288 44.752 41.994 43.439 40.627 39.336 41.15 41.848 41.817 40.274 31 69 22.1 30 40.16 40.471 40.89 40.76 40.396 39.771 41.594 40.339 42.108 43.445 43.585 42.096 41.795 40.783 43.272 43.862 41.968 44.88 41.456 44.449 41.655 42.965 40.72 41.058 42.962 42.256 39.849 42.176 40.453 41.736 41.642 32 94 44.6 31 40.376 40.111 41.358 41.093 39.955 40.392 40.55 42.175 40.578 41.6 41.776 42.618 41.795 42.331 43.38 43.043 40.528 41.856 45.245 42.604 41.187 39.698 42.547 42.138 43.943 40.204 42.198 41.069 40.561 41.754 42.353 33 99 49.1 32 39.332 40.246 40.197 40.544 40.693 41.625 41.594 40.87 42.261 42.959 40.966 41.556 41.3 41.035 43.497 43.079 41.86 40.893 43.094 42.424 42.645 42.425 43.087 42.336 42.629 41.122 43.341 42.527 41.074 40.953 41.156 34 88 39.2 33 39.863 40.759 40.719 40.121 40.558 41.472 41.711 42.265 41.847 40.295 41.2 43.176 40.346 43.87 40.851 39.947 42.58 42.936 42.761 39.598 42.366 43.208 41.053 41.877 41.864 42.04 42.927 39.35 41.128 43.797 34.487 35 81 32.9 34 40.043 40.03 41.331 41.318 41.602 41.301 41.864 41.446 42.045 42.302 41.002 41.286 41.174 44.383 41.715 42.656 43.255 41.631 43.931 42.712 41.88 41.399 41.332 41.769 39.659 40.51 43.98 39.233 42.505 44.427 41.606 36 87 38.3 35 40.727 40.075 40.404 40.742 41.656 41.076 40.622 42.67 42.117 42.635 43.306 41.16 40.931 42.016 43.218 44.15 43.435 41.307 44.138 43.81 44.094 40.913 43.294 42.3 43.412 42.661 41.604 42.446 42.019 41.988 40.58 37 107 50 36 39.161 39.895 40.467 41.003 41.161 42.165 42.278 42.265 40.11 41.699 42.775 42.141 42.839 42.439 42.984 40.235 42.193 42.072 43.319 42.883 43.104 40.607 42.997 41.193 41.711 45.181 42.36 42.068 41.677 41.565 43.1 38 102 50 37 38.648 39.904 41.25 41.012 41.935 41.445 42.296 42.814 41.163 42.41 42.433 41.016 41.84 42.619 40.41 42.854 41.851 41.658 41.627 42.676 42.843 44.828 42.997 42.021 43.556 44.407 42.972 42.338 41.767 39.162 40.661 39 62 15.8 38 40.781 39.958 38.865 41.804 40.396 42.21 41.729 43.291 40.893 41.933 42.262 43.977 41.786 41.98 43.524 43.16 41.473 41.397 41.267 41.731 43.644 41.894 41.944 42.246 39.704 42.868 43.215 39.647 39.994 43.239 40.229 40 88 39.2 39 40.736 39.715 40.26 40.76 41.134 41.166 42.71 40.735 41.568 42.428 42.613 41.16 41.12 42.124 43.056 42.413 42.13 44.295 42.41 44.611 42.483 41.687 42.034 42.084 42.494 41.158 39.723 41.429 40.876 43.131 38.744 41 85 36.5 40 39.314 40.507 40.395 40.319 41.107 41.562 41.135 42.886 40.677 42.401 42.064 43.203 43.334 43.051 42.462 41.981 43.129 42.414 43.805 41.812 44.184 40.499 41.188 41.949 41.45 43.129 43.467 40.079 41.713 42.978 41.966 42 105 50 41 40.079 40.111 40.062 39.068 41.701 40.815 41.729 41.338 42.324 43.58 42.667 40.845 42.74 41.674 43.614 44.519 42.751 42.477 42.32 43.414 40.989 40.76 42.115 41.571 40.136 41.419 41.271 43.517 41.911 41.511 41.093 43 91 41.9 42 40.763 40.876 40.035 41.192 41.368 40.626 41.252 41.68 42.414 41.798 43.09 43.356 40.787 42.88 43.263 41.099 41.365 42.288 41.807 43.675 43.14 38.987 44.05 43.587 41.936 44.596 42.693 43.544 40.174 40.845 42.074 44 104 50 43 40.349 41.137 39.216 39.608 41.98 41.967 41.216 42.265 41.568 42.437 42.64 43.275 42.173 41.161 41.787 42.998 40.267 41.964 42.347 44.197 41.034 43.253 45.391 42.174 42.485 44.299 42.63 41.141 44.422 41.52 38.231 45 106 50 44 40.322 40.543 39.9 40.148 41.17 41.634 42.053 40.366 43.17 42.104 41.668 43.617 40.391 43.195 43.191 40.901 42.832 42.873 42.158 43.846 43.581 42.236 44.572 41.859 41.333 39.484 42.117 42.104 41.227 43.086 41.984 46 85 36.5 45 39.665 39.886 40.089 40.454 42.736 40.959 40.784 43.129 41.1 42.176 42.496 42.969 42.416 41.485 44.064 43.664 43.363 43.044 42.41 41.812 44.202 42.695 42.925 42.75 41.567 41.599 42.423 42.356 41.713 40.575 41.471 47 70 23 46 39.881 40.813 40.62 41.183 42.115 42.174 42.71 41.167 40.371 41.141 42.784 41.187 41.57 43.06 42.948 42.503 42.85 41.91 40.835 41.974 42.168 42.146 40.603 41.409 40.361 41.977 44.205 41.069 42.766 40.242 40.841 48 94 44.6 47 40.016 40.03 40.017 40.832 41.305 41.949 42.179 42.859 41.793 41.762 42.91 42.726 42.227 42.133 43.281 43.421 42.364 43.656 40.871 42.019 41.214 43.298 40.414 40.797 42.845 40.285 43.899 42.707 44.251 42.204 40.472 49 52 6.8 48 39.755 41.155 39.477 40.58 40.324 39.114 40.658 41.698 41.559 41.231 42.712 41.16 41.444 42.34 42.615 41.954 41.545 41.676 43.373 41.362 40.917 43.703 43.609 43.605 44.411 41.572 40.74 42.554 37.906 40.854 43.415 50 70 23 49 39.854 40.471 39.9 41.561 40.45 42.885 40.964 42.643 40.749 41.204 43.414 42.591 42.443 42.781 44.289 40.928 43.156 42.423 42.68 43.738 40.908 41.741 40.558 40.428 40.631 42.598 41.406 42.212 39.751 42.645 40.814 51 107 50 50 39.557 38.914 39.459 40.121 41.935 41.571 42.629 41.986 40.938 40.664 41.353 43.104 43.127 42.583 42.723 43.394 43.966 43.386 42.968 44.638 42.474 42.371 41.287 42.975 42.35 43.129 40.389 43.202 37.573 42.825 41.804 52 83 34.7 51 39.908 40.462 41.25 40.472 40.81 40.518 41.369 42.301 43.476 42.365 41.713 40.152 41.858 42.079 43.641 42.467 40.357 43.161 43.679 43.162 41.736 40.832 43.15 42.696 42.989 42.841 40.443 41.339 40.705 37.866 41.615 53 68 21.2 52 38.468 40.543 39.891 40.535 41.854 40.779 40.739 40.672 40.938 41.888 43.306 43.23 42.614 43.177 41.292 43.673 40.879 42.801 44.768 42.658 41.151 40.157 44.158 41.202 43.358 43.03 43.296 41.312 42.523 41.196 41.966 54 107 50 53 39.404 38.077 41.169 40.94 40.387 41.355 41.432 41.95 40.551 43.22 43.468 43.068 43.532 42.043 42.183 41.108 42.598 43.152 41.753 44.656 41.106 41.777 41.917 41.094 39.857 42.355 43.458 42.347 40.597 42.609 41.12 55 101 50 54 39.026 40.957 40.728 41.966 41.251 42.435 41.063 42.706 41.991 42.509 43.234 42.006 43.064 44.32 42.939 42.989 43.156 43.557 45.209 44.368 43.473 41.102 40.459 40.383 41.369 37.567 40.137 43.58 41.938 42.078 42.695 56 82 33.8 55 40.223 41.029 40.836 41.3 41.782 41.832 41.648 42.463 41.082 41.744 42.946 41.952 43.334 40.558 41.94 40.046 41.554 42.243 43.175 43.828 42.699 40.175 42.331 40.455 41.837 41.599 42.324 41.186 39.418 40.926 40.598 57 84 35.6 56 40.529 40.489 40.593 40.517 40.81 40.608 41.288 39.466 40.785 41.438 43.378 41.745 41.741 43.429 43.101 43.835 43.786 45.006 43.22 41.668 40.728 41.822 42.331 41.265 41.648 44.506 40.614 42.662 42.37 41.853 42.326 58 103 50 57 39.647 39.985 41.043 40.94 40.099 40.455 41.045 42.301 41.163 41.06 40.372 43.383 41.669 42.466 40.896 41.369 42.769 43.881 44.894 43.477 41.745 43.424 42.25 41.571 42.422 42.265 41.757 41.861 39.823 41.259 40.292 59 74 26.6 58 39.719 41.164 40.845 41.246 41.791 40.689 40.928 42.076 42.819 41.888 42.478 41.844 43.307 41.872 42.3 42.26 43.417 40.731 40.79 43.855 41.799 42.83 39.721 42.858 41.702 41.32 40.218 39.872 41.425 41.844 42.263 60 114 50 59 39.602 40.552 40.656 42.038 41.269 40.59 40.964 40.411 42.828 41.888 41.335 40.98 43.073 41.719 42.75 43.493 42.967 42.036 42.428 41.29 42.438 42.875 42.376 42.705 43.988 43.237 38.58 41.717 39.067 42.078 41.156 61 70 23 60 39.728 40.282 39.945 41.192 41.71 40.68 40.19 42.202 41.64 41.951 41.056 40.629 41.309 40.918 43.443 43.106 43.318 43.161 44.264 42.055 42.807 43.091 41.836 42.588 43.349 42.544 42.954 41.141 42.037 41.349 43.631 62 122 50 61 39.449 41.263 41.43 41.021 41.044 41.436 41.684 41.617 40.866 41.825 42.559 43.5 42.281 42.556 42.354 40.109 44.236 40.839 42.797 42.685 40.206 42.47 40.684 43.371 40.964 41.734 41.901 40.016 39.832 41.619 42.056 63 111 50 62 39.863 40.03 40.728 41.327 40.837 41.652 40.919 43.102 40.857 41.591 41.209 42.969 42.659 42.871 41.355 41.702 41.833 43.62 44.984 41.812 39.963 43.703 40.945 40.689 39.002 42.94 44.07 39.521 43.774 40.287 40.76 64 89 40.1 63 40.268 40.624 40.071 42.047 41.116 41.787 41.387 42.634 40.812 42.446 42.361 40.611 42.983 43.915 43.155 43.34 43.426 41.577 43.913 43.243 42.015 42.218 41.53 41.454 40.451 40.978 39.912 38.324 41.146 41.178 40.643 65 105 50 64 39.359 40.786 40.845 41.507 39.532 41.346 41.54 41.536 42.405 42.077 41.452 43.833 42.2 42.637 43.281 42.818 42.58 42.702 43.571 43.315 41.421 42.416 42.016 40.977 43.763 42.499 41.64 42.779 41.947 41.025 41.138 66 69 22.1 65 40.151 41.038 41.745 40.886 39.748 42.228 42.305 41.527 41.109 41.492 41.776 42.681 43.505 43.078 43.578 43.277 42.913 42.351 41.051 42.145 42.726 41.849 42.25 42.111 42.593 41.086 39.012 40.601 41.479 42.429 39.734 67 81 32.9 66 39.89 41.38 40.395 40.769 41.26 41.112 40.748 42.94 39.651 40.484 42.343 42.915 41.822 42.385 44.721 42.998 42.202 40.632 41.906 42.271 42.483 42.965 41.107 43.038 40.793 42.256 42.684 40.151 42.316 42.006 41.642 68 117 50 67 40.187 40.417 40.251 40.778 41.584 40.743 42.242 41.959 43.089 41.609 42.586 41.547 42.632 41.161 42.219 41.693 44.524 44.7 44.129 43.549 42.951 43.55 42.457 41.193 40.487 38.386 41.001 43.094 39.112 43.878 41.012 69 102 50 68 40.196 41.965 41.349 41.156 40.54 41.337 40.649 41.41 42.333 41.537 42.874 40.305 42.911 41.476 41.616 43.646 42.607 41.955 43.724 41.326 42.942 42.542 41.863 42.615 43.781 44.893 40.722 42.23 40.804 43.86 43.145 70 91 41.9 69 39.647 41.416 41.772 40.76 42.25 41.652 39.704 40.051 43.035 41.339 41.218 43.617 43.172 41.8 40.077 43.331 41.959 43.287 45.236 40.534 44.454 43.028 43.816 43.758 43.07 42.994 42.927 42.032 40.975 40.818 43.811 71 105 50 70 40.241 40.579 40.17 40.931 41.161 41.598 40.037 41.248 42.765 42.419 41.686 41.619 42.533 43.789 41.697 42.989 42.742 40.704 43.229 41.74 42.069 40.994 42.538 41.652 43.232 41.95 43.098 40.313 40.741 43.356 41.489 72 108 50 71 39.566 40.39 40.863 40.175 40.495 41.769 40.334 40.825 41.397 43.04 42.307 40.908 41.741 41.125 40.266 42.143 42.436 41.775 41.6 41.893 42.519 40.886 41.8 43.569 42.647 41.599 43.845 43.346 42.982 41.061 42.992 73 111 50 72 39.818 39.823 41.151 39.923 39.919 40.347 42.062 41.932 40.965 42.806 41.101 42.645 41.75 40.567 42.957 43.358 44.209 40.641 43.193 44.791 42.393 41.021 42.799 42.804 39.857 41.806 42.279 41.573 43.432 42.888 40.562 74 118 50 73 40.493 39.166 39.522 41.147 40.873 41.85 41.153 42.859 40.947 40.772 41.704 43.338 43.064 42.34 42.3 41.63 41.212 38.13 43.265 43.576 41.646 42.758 41.899 45.567 41.54 41.293 41.433 42.365 41.146 42.006 42.362 75 105 50 74 41.159 40.309 41.574 40.382 41.224 40.761 41.018 40.141 42.09 42.176 41.425 43.545 40.643 41.386 42.3 42.728 41.167 41.46 45.137 43.756 42.042 43.838 41.899 41.967 43.259 44.074 40.137 42.302 39.67 41.961 40.769 76 132 50 75 40.619 41.533 40.431 39.986 41.503 41.31 41.252 41.644 42.405 42.644 41.731 43.761 42.578 40.99 42.894 42.863 43.075 43.152 42.185 43.117 42.879 44.576 42.106 45.675 41.099 42.121 41.982 43.085 40.183 40.377 43.721 77 135 50 76 40.574 39.436 40.809 41.138 40.18 41.841 41.135 41.689 42.639 42.383 41.956 42.483 42.236 42.853 43.407 42.107 41.383 41.568 43.148 43.045 43.653 44.297 43.078 43.173 39.956 40.564 42.045 42.131 42.046 42.726 39.383 78 37 -6.7 77 39.836 39.742 40.611 41.606 40.801 42.246 41.468 41.716 40.047 41.852 42.352 42.645 40.445 42.952 44.055 42.458 44.308 42.684 43.238 41.164 42.411 40.679 42.412 43.218 43.322 40.591 41.613 39.251 39.283 43.788 41.903 79 128 50 78 40.169 40.201 40.008 39.851 41.026 40.815 40.442 40.222 41.325 41.933 42.181 40.719 42.83 42.34 42.318 42.296 42.652 44.367 42.554 44.665 42.564 42.668 43.591 41.859 41.693 43.183 45.483 40.835 41.407 40.242 39.077 80 102 50 79 38.954 41.29 40.584 41.129 40.783 43.119 41.981 41.383 42.801 42.797 43.693 42.492 42.677 40.927 43.596 42.647 42.337 42.315 42.815 41.164 41.97 41.606 41.881 41.247 41.819 42.85 42.468 41.285 41.263 42.708 42.047 81 108 50 80 40.178 40.552 41.106 41.021 42.07 40.977 41.837 42.418 41.919 41.51 41.776 42.717 42.272 42.979 42.516 42.629 40.924 41.64 40.682 39.49 43.599 41.219 43.87 43.371 42.422 43.426 39.948 41.348 42.19 40.647 42.02 82 110 50 81 40.115 41.101 41.034 39.689 41.359 41.994 42.62 41.95 41.118 41.942 40.921 43.833 42.92 42.295 43.623 42.503 41.563 40.497 41.393 41.2 42.105 39.554 43.618 43.821 41.054 42.157 43.278 41.402 40.615 41.781 40.526 83 43 -1.3 82 39.863 40.57 40.197 40.292 40.495 40.257 40.766 40.573 41.541 40.844 40.579 41.736 43.316 41.926 41.49 42.881 41.977 43.953 42.122 39.409 42.681 43.361 42.835 41.004 41.648 43.138 43.377 42.293 41.155 41.844 40.886 84 89 40.1 83 39.89 41.344 40.53 41.129 41.071 42.948 40.694 41.986 42.027 41.501 41.632 43.275 42.11 43.285 41.409 43.187 42.688 41.334 41.825 46.258 44.4 42.677 40.477 41.535 42.89 42.796 43.98 43.607 42.325 42.798 43.091 85 111 50 84 40.565 39.616 40.377 41.561 40.738 41.679 41.396 41.149 43.476 41.231 41.767 42.285 42.731 44.365 42.3 41.774 41.311 43.539 41.051 45.124 42.6 42.731 43.744 42.777 41.9 42.904 42.459 39.458 39.022 42.303 44.135 86 121 50 85 40.988 39.508 40.683 40.328 41.305 41.454 41.693 41.248 43.053 43.679 42.739 43.437 44 43.078 42.678 42.449 43.183 43.872 42.932 41.308 42.429 42.956 42.745 42.21 43.547 41.383 40.38 39.071 41.704 40.62 43.019 87 124 50 86 40.43 41.488 41.025 41.03 40.576 41.742 41.729 41.995 40.551 42.095 41.11 42.177 42.686 43.861 43.191 41.873 44.173 45.006 41.258 43.369 43.194 43.208 38.146 43.803 42.116 45.046 43.962 41.618 40.102 40.89 41.903 88 112 50 87 39.143 41.11 39.846 41.246 41.485 41.985 41.999 41.869 42.063 42.707 40.822 41.673 43.172 41.557 41.94 41.747 42.661 42.027 44.975 43.441 42.843 43.127 44.329 44.19 42.521 42.112 42.522 42.779 41.983 42.843 42.515 89 116 50 88 40.628 41.074 40.458 40.634 41.494 41.445 41.936 41.149 41.415 42.059 43.495 43.437 41.759 42.979 42.831 42.215 41.365 40.335 44.633 41.2 41.88 41.678 42.673 46.017 42.584 42.067 38.58 41.303 40.975 41.169 41.606 90 140 50 89 40.61 40.903 41.277 40.877 40.756 41.13 41.495 41.887 42.801 41.807 43.09 42.51 42.974 44.311 44.262 40.388 42.211 41.055 42.329 42.91 41.286 41.462 42.268 40.014 42.953 43.075 43.278 39.161 39.67 42.591 42.758 91 90 41 90 40.538 39.895 40.836 40.643 41.953 42.849 41.315 41.347 41.064 41.717 40.309 41.385 43.748 43.429 43.236 41.477 40.933 42.126 43.067 44.521 44.139 42.263 40.441 42.993 42.773 44.119 41.064 41.132 42.046 41.475 40.391 92 108 50 91 39.359 39.967 40.737 40.922 39.37 39.888 41.279 41.356 40.524 41.6 41.632 42.159 43.973 42.295 43.254 41.558 43.021 43.809 43.058 42.613 42.636 43.208 41.314 41.445 45.419 39.997 42.945 39.215 42.586 41.142 39.482 93 100 50 92 40.781 40.732 38.667 40.625 41.242 40.878 40.208 42.148 41.955 42.473 42.667 43.428 40.121 41.827 42.588 43.232 42.22 41.604 43.211 41.389 41.898 41.804 43.087 40.959 42.143 40.537 41.523 44.48 42.352 42.33 39.437 94 93 43.7 93 39.584 40.579 41.088 40.13 41.989 41.877 41.459 41.815 42.765 40.052 42.658 40.764 42.326 41.341 43.038 43.835 41.599 42.828 40.115 43.306 43.329 41.714 42.466 42.111 45.014 43.057 41.901 41.249 42.208 42.375 41.669 95 83 34.7 94 39.458 40.273 41.484 38.132 41.143 40.653 40.091 41.311 41.46 42.554 40.732 41.322 41.624 43.447 42.3 44.375 42.625 42.702 41.492 42.73 42.717 42.344 42.574 42.903 39.614 42.445 40.785 42.554 42.91 41.934 40.355 96 93 43.7 95 40.691 39.076 40.116 40.13 40.423 41.139 41.531 40.375 42.099 42.797 41.272 42.249 42.794 41.188 45.711 43.871 42.94 42.117 43.697 41.866 42.708 42.767 42.943 42.516 42.755 41.302 41.1 42.203 39.085 39.801 43.244 97 77 29.3 96 40.331 40.075 40.692 39.509 41.395 41.598 41.423 41.869 41.631 41.096 42.208 42.483 42.101 42.304 42.741 44.069 43.039 42.324 43.193 43.486 43.653 43.262 42.889 43.74 42.53 44.983 43.062 39.845 41.704 41.835 43.613 98 106 50 97 40.646 39.625 41.313 40.697 41.296 41.454 41.189 42.391 41.352 41.195 43.369 40.818 42.893 44.176 42.642 43.7 41.725 42.972 41.699 43.603 42.501 42.893 43.096 45.081 42.017 40.987 42.945 44.156 39.571 38.577 39.356 99 112 50 98 39.764 40.741 40.773 40.292 40.846 40.896 42.278 41.608 42.09 42.563 44.008 41.115 42.956 42.439 43.002 42.044 44.119 41.586 42.824 42.991 42.798 43.244 42.331 43.245 43.907 44.29 42.018 40.52 40.804 40.656 43.532 100 92 42.8 99 39.17 41.2 40.782 41.903 40.252 41.175 40.109 39.124 41.739 41.708 42.163 42.429 41.156 43.618 44.298 41.603 41.932 41.73 42.851 42.784 44.49 41.912 44.536 43.182 42.035 42.067 40.362 42.914 40.462 41.745 42.335 100 39.971 39.49 40.107 40.175 41.359 41.049 38.561 42.139 39.597 41.411 42.505 42.87 42.101 41.845 43.947 44.159 42.184 43.755 41.213 40.219 43.707 42.236 42.862 43.173 41.891 42.949 41.163 43.166 40.642 43.401 41.444 Lucro Médio 40.793 101 40.421 40.813 41.313 41.489 39.856 40.644 41.945 41.572 40.677 42.608 43.27 42.717 39.905 41.8 43.389 44.834 44.02 41.343 41.357 43.324 43.059 43.028 40.162 42.048 40.586 43.408 43.035 43.787 40.354 39.261 42.29 Número 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 Lucro médio 39.9814257426 40.3742277228 40.6042277228 40.7242673267 41.089980198 41.3376237624 41.4290594059 41.7286534653 41.6563960396 41.9863762376 42.2047029703 42.2839306931 42.2825148515 42.4932673267 42.7532079208 42.6290891089 42.368990099 42.3812970297 42.7980693069 42.7463069307 42.4597425743 42.3289405941 42.3762673267 42.4399009901 42.0760792079 42.2771188119 42.0375148515 41.7853465347 41.2213861386 41.5672277228 41.447029703 Gráfico Compra x Lucro Tabela de Dados - Parte III Exemplo - Florista Dados do Problema Simulação Demanda Lucro Valor de Venda 1 1 88 39.2 Quantidade de flores a serem compradas Valor de Compra 0.5 2 87 38.3 42.647 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 Valor quando sobra 0.1 3 111 50 Demanda Média 90 36.749 38.365 37.434 38.249 38.002 37.242 37.544 39.043 37.05 37.514 38.284 37.668 38.42 36.049 37.107 37.634 36.685 35.961 37.649 36.187 37.335 35.657 36.634 36.396 33.296 36.262 36.699 36.632 35.62 32.493 35.225 39.043 4 130 50 91 37.847 36.664 38.343 37.7 38.002 38.925 37.337 37.702 36.609 39.062 35.962 37.632 36.683 35.626 37.881 35.789 37.459 35.754 36.02 36.124 37.578 36.089 39.28 37.161 35.285 34.876 35.853 37.172 33.496 35.643 37.394 39.28 Demanda 5 104 50 92 37.802 37.951 38.37 39.32 37.444 38.7 37.499 38.494 40.83 36.551 37.942 39.216 39.014 39.253 39.096 38.507 39.169 37.851 39.692 38.05 37.434 37.232 36.022 37.638 35.744 40.636 34.116 35.975 34.882 34.527 34.028 40.83 Média 100 6 117 50 93 38.756 37.096 38.64 38.681 38.263 39.204 40.253 38.332 38.265 38.144 36.439 40.179 39.788 38.488 38.736 40.505 35.731 37.356 37.289 36.25 35.751 35.621 39.145 37.116 41.108 39.394 36.879 35.111 38.662 37.803 36.017 41.108 Desvio-padrão 20 7 98 48.2 94 38.981 38.68 40.008 39.329 38.506 40.572 40.325 38.548 38.202 39.431 41.767 40.026 41.408 39.415 40.653 40.325 39.619 41.442 38.189 35.827 38.406 40.265 39.712 36.108 41.594 38.08 38.175 37.856 38.635 37.578 36.26 41.767 8 139 50 95 37.352 39.589 39.531 39.176 40.171 40.374 40.82 39.196 41.01 41.51 38.806 40.233 41.282 40.531 41.76 40.415 41.536 39.966 39.566 40.804 40.404 41.138 38.695 40.716 38.732 38.089 38.85 36.659 36.736 36.642 38.816 41.76 Quantidade Comprada 100 9 146 50 96 38.765 38.68 39.621 37.142 39.415 40.5 39.713 39.862 39.795 40.133 39.292 40.728 38.834 41.404 40.635 41.639 39.358 39.75 41.384 40.462 39.387 41.543 40.567 37.593 38.003 37.702 39.336 37.712 40.525 40.503 36.557 41.639 10 116 50 97 40.241 39.346 38.739 40.076 40.009 40.743 40.01 41.536 40.533 41.159 40.642 40.251 42.047 40.675 39.942 39.101 39.556 41.226 41.942 41.164 43.14 39.995 43.132 39.339 41.405 41.473 41.037 38.702 43.279 39.792 38.267 43.279 11 77 29.3 98 39.242 40.165 39.054 39.41 40.261 40.545 41.612 40.159 39.939 41.456 40.201 40.305 40.004 42.763 42.453 41.774 40.294 44.169 41.33 40.696 42.969 39.077 41.539 39.33 39.83 40.213 41.577 36.965 41.857 40.629 40.454 44.169 12 119 50 99 40.367 39.292 40.845 39.527 39.991 41.058 40.208 40.798 39.84 41.474 42.316 43.104 41.678 42.916 42.426 43.898 40.564 41.361 38.702 43.342 42.771 41.525 43.672 43.146 42.737 40.852 41.874 41.276 42.253 42.213 40.751 43.898 13 122 50 100 40.043 40.597 40.449 40.22 40.657 43.128 41.045 41.545 40.587 42.68 42.838 41.331 43.352 41.251 42.363 42.422 43.444 42.099 42.122 44.701 42.294 42.965 41.206 43.452 42.701 44.002 43.665 41.114 42.37 40.026 41.948 44.701 14 82 33.8 101 38.792 41.425 40.548 39.725 42.043 41.625 42.386 41.86 41.19 43.49 41.623 42.375 42.488 41.791 42.066 42.602 43.489 42.954 42.212 42.109 43.05 40.571 42.529 41.598 42.89 44.65 40.848 40.799 43.072 41.214 40.724 44.65 15 104 50 102 41.393 40.732 41.187 42.11 41.845 41.913 43.187 41.671 43.989 41.258 43.261 41.925 42.839 41.008 44.748 42.233 44.569 43.215 42.428 44.305 43.419 40.958 44.914 44.919 43.043 43.966 44.259 46.523 43.171 44.382 40.103 46.523 16 78 30.2 103 40.826 41.614 41.619 41.084 41.773 42.372 42.44 43.093 42.405 43.292 42.631 44.211 42.641 44.797 44.091 43.916 45.064 42.495 45.722 44.044 45.408 44.432 41.998 41.13 43.115 44.218 42.792 43.895 43.306 41.691 43.073 45.722 17 106 50 104 40.844 39.94 40.44 41.885 41.548 41.904 41.981 42.562 43.377 41.879 42.325 43.437 43.118 43.528 43.182 42.917 45.235 45.528 44.813 43.549 45.66 43.802 44.968 45.144 45.365 45.037 44.646 40.412 46.528 43.005 44.657 46.528 18 104 50 105 41.024 40.642 42.051 42.776 42.376 42.372 42.98 43.237 44.367 42.752 44.737 43.923 44.342 43.483 44.496 45.428 43.795 44.781 44.354 45.889 46.056 44.567 45.661 44.694 44.42 44.731 45.708 44.381 45.754 44.346 45.827 46.056 19 89 40.1 106 41.663 41.236 42.528 42.434 43.006 43.569 42.764 43.849 45.069 43.013 43.882 44.031 44.468 44.455 45.324 44.222 44.47 44.709 45.686 46.303 47.226 47.402 45.112 45.315 47.192 43.606 44.79 48.71 43.369 44.463 43.325 48.71 20 128 50 107 41.249 42.028 40.899 40.697 42.43 42.858 43.79 43.102 43.629 42.932 44.314 44.544 45.701 45.454 46.143 45.131 44.65 44.754 45.092 47.995 46.209 46.07 46.534 47.448 47.957 47.197 47.499 47.315 46.213 45.237 46.889 47.995 21 64 17.6 108 41.114 41.758 41.745 42.578 42.961 43.614 43.862 43.759 44.205 44.651 44.854 45.12 45.089 45.49 45.657 47.795 46.468 47.715 43.697 45.853 45.606 47.114 47.92 46.989 47.264 46.684 45.006 48.17 46.951 46.155 47.177 48.17 22 108 50 109 41.564 41.866 42.357 41.696 43.798 42.831 43.169 43.966 44.862 44.525 44.35 43.401 45.323 45.148 46.125 44.753 46.306 45.546 46.451 47.203 46.191 46.484 48.055 48.105 45.563 47.125 45.798 46.559 48.301 47.631 48.707 48.707 23 79 31.1 110 42.329 42.307 42.231 42.776 42.538 43.983 43.466 43.507 44.619 44.687 44.467 45.48 46.439 46.768 45.117 46.589 47.044 47.292 47.144 48.76 46.92 47.861 47.155 47.34 48.569 47.791 48.192 46.253 47.887 48.162 48.95 48.95 24 106 50 25 108 50 26 128 50 27 111 50 28 129 50 29 133 50 30 50 5 31 72 24.8 32 66 19.4 33 120 50 34 102 50 35 112 50 36 92 42.8 37 110 50 38 89 40.1 39 73 25.7 40 91 41.9 41 114 50 42 102 50 43 107 50 44 84 35.6 45 90 41 46 94 44.6 47 95 45.5 48 117 50 49 117 50 50 52 6.8 51 70 23 52 95 45.5 53 124 50 54 82 33.8 55 101 50 56 79 31.1 57 117 50 58 74 26.6 59 140 50 60 83 34.7 61 112 50 62 95 45.5 63 108 50 64 106 50 65 80 32 66 91 41.9 67 105 50 68 77 29.3 69 96 46.4 70 103 50 71 117 50 72 106 50 73 96 46.4 74 83 34.7 75 62 15.8 76 100 50 77 79 31.1 78 111 50 79 92 42.8 80 104 50 81 100 50 82 96 46.4 83 70 23 84 89 40.1 85 92 42.8 86 107 50 87 97 47.3 88 104 50 89 118 50 90 88 39.2 91 126 50 92 85 36.5 93 102 50 94 113 50 95 91 41.9 96 77 29.3 97 74 26.6 98 107 50 99 127 50 100 105 50 Lucro Médio 42.647
Compartilhar