Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Dados Semana Vendas Falta Demanda Perdas por falta Média Vendas * 42 1 40 3 43 R$ 4.50 Desv. Pad 1.4613669013423642 2 41 1 42 R$ 1.50 Max 45 3 40 1 41 R$ 1.50 Min 40 4 41 41 0.0 40 16.67% 1667 5 44 44 0.0 41 23.33% 4000 6 40 2 42 R$ 3.00 42 28.33% 6833 7 40 1 41 R$ 1.50 43 13.33% 8166 8 42 42 0.0 44 11.67% 9333 9 43 43 0.0 45 6.67% 10000 10 41 1 42 R$ 1.50 11 40 40 0.0 média 1 41.2 12 43 43 0.0 média 2 41.2 13 40 40 0.0 média 3 41.363636363636367 14 42 2 44 R$ 3.00 média 4 41.727272727272727 15 41 41 0.0 média 5 41.363636363636367 16 42 3 45 R$ 4.50 média 6 41.272727272727273 17 41 1 42 R$ 1.50 18 40 2 42 R$ 3.00 19 41 41 0.0 20 42 2 44 R$ 3.00 21 42 42 0.0 22 42 1 43 R$ 1.50 23 40 40 0.0 24 43 43 0.0 25 40 40 0.0 26 40 1 41 R$ 1.50 27 41 41 0.0 28 40 1 41 R$ 1.50 29 41 41 0.0 30 44 1 45 R$ 1.50 31 42 42 0.0 32 41 41 0.0 33 41 1 42 R$ 1.50 34 40 40 0.0 35 42 42 0.0 36 41 1 42 R$ 1.50 37 44 44 0.0 38 40 1 41 R$ 1.50 39 44 44 0.0 40 40 40 0.0 41 41 1 42 R$ 1.50 42 42 42 0.0 43 43 43 0.0 44 40 40 0.0 45 43 2 45 R$ 3.00 46 45 45 0.0 47 40 40 0.0 48 40 1 41 R$ 1.50 49 41 1 42 R$ 1.50 50 40 2 42 R$ 3.00 51 40 40 0.0 52 41 1 42 R$ 1.50 53 42 42 0.0 54 41 41 0.0 55 42 2 44 R$ 3.00 56 43 43 0.0 57 44 44 0.0 58 40 40 0.0 59 41 2 43 R$ 3.00 60 40 1 41 R$ 1.50 Sim_Dem.ant. Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 7529 43 43 64.5 Total Perdas 504.5 2 5532 43 -1 42 4 3 30 42 -2 40 8 1 437.5 437.5 324.5 minimo 4 9678 40 5 45 7.5 2 368.5 368.5 416.875 25 5 1205 45 -5 40 20 3 459 459 448 50 6 3306 40 1 41 1.5 4 390.5 390.5 473.25 75 7 1007 41 -1 40 4 5 392 392 555.5 máximo 8 502 40 0 40 0 6 374 374 Intervalo Frq. média 9 7284 40 3 43 4.5 7 467.5 467.5 324 348 324 - 348 1.0% 336 10 1935 43 -2 41 8 8 437.5 437.5 348 372 348 - 372 2.0% 360 11 2158 41 0 41 0 9 428.5 428.5 372 396 372 - 396 11.0% 384 12 1902 41 0 41 0 10 458 458 396 420 396 - 420 14.0% 408 13 7725 41 2 43 3 11 429.5 429.5 420 444 420 - 444 17.0% 432 14 2476 43 -2 41 8 12 464.5 464.5 444 468 444 - 468 27.0% 456 15 1553 41 -1 40 4 13 474 474 468 492 468 - 492 14.0% 480 16 2822 40 1 41 1.5 14 417 417 492 516 492 - 516 8.0% 504 17 4314 41 1 42 1.5 15 452.5 452.5 516 540 516 - 540 3.0% 528 18 6771 42 0 42 0 16 438.5 438.5 540 564 540 - 564 3.0% 552 19 6929 42 1 43 1.5 17 447 447 20 1089 43 -3 40 12 18 521 521 21 5834 40 2 42 3 19 493.5 493.5 22 5782 42 0 42 0 20 455 455 23 6350 42 0 42 0 21 407 407 24 2002 42 -1 41 4 22 494.5 494.5 25 7844 41 2 43 3 23 482.5 482.5 26 9737 43 2 45 3 24 423.5 423.5 27 3825 45 -4 41 16 25 459 459 28 1616 41 -1 40 4 26 458.5 458.5 29 9518 40 5 45 7.5 27 495 495 30 6824 45 -3 42 12 28 480 480 31 4384 42 0 42 0 29 380.5 380.5 32 3666 42 -1 41 4 30 447.5 447.5 33 107 41 -1 40 4 31 495 495 34 4720 40 2 42 3 32 409.5 409.5 35 5233 42 0 42 0 33 430.5 430.5 36 7354 42 1 43 1.5 34 487 487 0 18 37 1818 43 -2 41 8 35 419.5 419.5 1.5 10 38 9950 41 4 45 6 36 407 407 3 11 39 523 45 -5 40 20 37 415 415 4 18 40 4583 40 2 42 3 38 467.5 467.5 4.5 9 41 749 42 -2 40 8 39 448.5 448.5 6 3 42 8013 40 3 43 4.5 40 555.5 555.5 7.5 4 43 5676 43 -1 42 4 41 405.5 405.5 8 15 44 3309 42 -1 41 4 42 433.5 433.5 12 6 45 8929 41 3 44 4.5 43 502 502 16 4 46 2482 44 -3 41 12 44 483 483 20 2 47 2761 41 0 41 0 45 427.5 427.5 100 48 3248 41 0 41 0 46 423 423 49 661 41 -1 40 4 47 501.5 501.5 50 9692 40 5 45 7.5 48 481 481 51 6308 45 -3 42 12 49 465 465 52 2060 42 -1 41 4 50 401.5 401.5 53 9270 41 3 44 4.5 51 481 481 54 6386 44 -2 42 8 52 407 407 55 1771 42 -1 41 4 53 480 480 56 7912 41 2 43 3 54 446.5 446.5 57 3317 43 -2 41 8 55 365.5 365.5 58 1575 41 -1 40 4 56 407 407 59 4790 40 2 42 3 57 324.5 324.5 60 8487 42 2 44 3 58 418 418 61 5546 44 -2 42 8 59 442.5 442.5 62 9972 42 3 45 4.5 60 423.5 423.5 63 7573 45 -2 43 8 61 534 534 64 2848 43 -2 41 8 62 447 447 65 3721 41 0 41 0 63 385 385 66 46 41 -1 40 4 64 493.5 493.5 67 1043 40 0 40 0 65 478 478 68 2859 40 1 41 1.5 66 542 542 69 2724 41 0 41 0 67 416.5 416.5 70 343 41 -1 40 4 68 459 459 71 8897 40 4 44 6 69 508 508 72 381 44 -4 40 16 70 529 529 73 7241 40 3 43 4.5 71 385 385 74 9891 43 2 45 3 72 445.5 445.5 75 2543 45 -4 41 16 73 434 434 76 950 41 -1 40 4 74 453.5 453.5 77 9865 40 5 45 7.5 75 485.5 485.5 78 6919 45 -2 43 8 76 422 422 79 7035 43 0 43 0 77 437 437 80 2694 43 -2 41 8 78 372.5 372.5 81 3602 41 0 41 0 79 456.5 456.5 82 6297 41 1 42 1.5 80 389 389 83 417 42 -2 40 8 81 476 476 84 1842 40 1 41 1.5 82 453.5 453.5 85 8763 41 3 44 4.5 83 399 399 86 1079 44 -4 40 16 84 389 389 87 2135 40 1 41 1.5 85 392 392 88 1983 41 0 41 0 86 449.5 449.5 89 6438 41 1 42 1.5 87 437 437 90 1369 42 -2 40 8 88 472.5 472.5 91 7774 40 3 43 4.5 89 430.5 430.5 92 6782 43 -1 42 4 90 399 399 93 6125 42 0 42 0 91 540 540 94 9907 42 3 45 4.5 92 448.5 448.5 95 5675 45 -3 42 12 93 381 381 96 4669 42 0 42 0 94 451 451 97 709 42 -2 40 8 95 472 472 98 5573 40 2 42 3 96 448.5 448.5 99 3739 42 -1 41 4 97 473 473 100 9868 41 4 45 6 98 460.5 460.5 101 6048 45 -3 42 12 99 467 467 100 462 462 44561.5 4.5255140898883282 Sim_m.h Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 3037 42 -1 41 4 Total Perdas 329 1 2 8250 42 2 44 3 3 9782 42 3 45 4.5 1 273 273 243.5 minimo 4 3353 42 -1 41 4 2 325.5 325.5 298.375 25 5 589 42 -2 40 8 3 296 296 315.5 50 6 2790 42 -1 41 4 4 349 349 331.625 75 7 3119 42 -1 41 4 5 319 319 397 máximo 8 1531 42 -2 40 8 6 329 329 Intervalo Frq. 9 8829 42 2 44 3 7 311 311 Perda 315.64 243 259 243 - 259 3.0% 251 10 1796 42 -1 41 4 8 288.5 288.5 259 275 259 - 275 3.0% 267 11 6043 42 0 42 0 9 304 304 275 291 275 - 291 11.0% 283 12 389 42 -2 40 8 10 348.5 348.5 291 307 291 - 307 22.0% 299 13 8497 42 2 44 3 11 359.5 359.5 307 323 307 - 323 22.0% 315 14 6537 42 0 42 0 12 339.5 339.5 323 339 323 - 339 20.0% 331 15 2339 42 -1 41 4 13 381 381 339 355 339 - 355 12.0% 347 16 2575 42 -1 41 4 14 298 298 355 371 355 - 371 4.0% 363 17 9252 42 2 44 3 15 345 345 371 387 371 - 387 2.0% 379 18 7772 42 1 43 1.5 16 316.5 316.5 387 403 387 - 403 1.0% 395 19 9488 42 3 45 4.5 17 297.5 297.5 20 3766 42 -1 41 4 18 331.5 331.5 21 5700 42 0 42 0 19 299.5 299.5 22 235 42 -2 40 8 20 333.5 333.5 23 1864 42 -1 41 4 21 314.5 314.5 24 9602 42 3 45 4.5 22 281.5 281.5 25 6699 42 0 42 0 23 319.5 319.5 26 4900 42 0 42 0 24 281 281 27 668 42 -2 40 8 25 325.5 325.5 28 1304 42 -2 40 8 26 306 306 29 5027 42 0 42 0 27 327.5 327.5 30 4285 42 0 42 0 28 305.5 305.5 31 6279 42 0 42 0 29 339.5 339.5 32 7066 42 1 43 1.5 30 291 291 33 1966 42 -1 41 4 31 307 307 34 3377 42 -1 41 4 32 315 315 35 4956 42 0 42 0 33 323.5 323.5 36 7508 42 1 43 1.5 34 308.5 308.5 0 29 37 4381 42 0 42 0 35 297 297 1.5 8 38 981 42 -2 40 8 36 299.5 299.5 3 14 39 3418 42 -1 41 4 37 317.5 317.5 4 24 40 3130 42 -1 41 4 38 314.5 314.5 4.5 6 41 5114 42 0 42 0 39 298.5 298.5 6 0 42 6648 42 0 42 0 40 299 299 7.5 0 43 6423 42 0 42 0 41 281 281 8 19 44 9063 42 2 44 3 42 288.5 288.5 12 0 45 2211 42 -1 41 4 43 324.5 324.5 16 0 46 8717 42 2 44 3 44 331.5 331.5 20 0 47 26 42 -2 40 8 45 350 350 100 48 7055 42 1 43 1.5 46 243.5 243.5 49 1128 42 -2 40 8 47 247.5 247.5 50 1361 42 -2 40 8 48 307 307 51 4386 42 0 42 0 49 329.5 329.5 52 271 42 -2 40 8 50 294.5 294.5 53 3345 42 -1 41 4 51 279.5 279.5 54 1566 42 -2 40 8 52 351 351 55 2874 42 -1 41 4 53 306 306 56 416 42 -2 40 8 54 252 252 57 4007 42 0 42 0 55 343.5 343.5 58 4819 42 0 42 0 56 375 375 59 7552 42 1 43 1.5 57 318.5 318.5 60 4633 42 0 42 0 58 306 306 61 8852 42 2 44 3 59 327 327 62 7924 42 1 43 1.5 60 326 326 63 9923 42 3 45 4.5 61 293 293 64 2077 42 -1 41 4 62 344.5 344.5 65 4142 42 0 42 0 63 322 322 66 4898 42 0 42 0 64 326.5 326.5 67 8558 42 2 44 3 65 317.5 317.5 68 5907 42 0 42 0 66 305 305 69 2368 42 -1 41 4 67 306 306 70 5066 42 0 42 0 68 295 295 71 4891 42 0 42 0 69 310 310 72 6679 42 0 42 0 70 368 368 73 424 42 -2 40 8 71 305.5 305.5 74 9599 42 3 45 4.5 72 281.5 281.5 75 1589 42 -2 40 8 73 316 316 76 5553 42 0 42 0 74 269 269 77 7809 42 1 43 1.5 75 313 313 78 9089 42 2 44 3 76 337.5 337.5 79 6893 42 1 43 1.5 77 286.5 286.5 80 8853 42 2 44 3 78 285 285 81 4995 42 0 42 0 79 336.5 336.5 82 9141 42 2 44 3 80 364.5 364.5 83 6412 42 0 42 0 81 354 354 84 4394 42 0 42 0 82 276.5 276.5 85 904 42 -2 40 8 83 315 315 86 9675 42 3 45 4.5 84 308 308 87 1998 42 -1 41 4 85 336.5 336.5 88 187 42 -2 40 8 86 322 322 89 8255 42 2 44 3 87 330 330 90 3814 42 -1 41 4 88 397 397 91 8738 42 2 44 3 89 332 332 92 5676 42 0 42 0 90 343 343 93 5589 42 0 42 0 91 328 328 94 1577 42 -2 40 8 92 320.5 320.5 95 8747 42 2 44 3 93 355.5 355.5 96 1785 42 -1 41 4 94 322.5 322.5 97 567 42 -2 40 8 95 269 269 98 3935 42 -1 41 4 96 337.5 337.5 99 3684 42 -1 41 4 97 286 286 100 3720 42 -1 41 4 98 348.5 348.5 99 305.5 305.5 100 300.5 300.5 31568.5 2.8124722220850464 Sim_m.M.c Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 6640 42 42 63 Total Perdas 389.5 2 8866 44 44 66 3 9780 45 45 67.5 1 354.5 354.5 297 minimo 4 4804 42 42 63 2 370 370 359.875 25 5 4719 43 -1 42 4 3 398.5 398.5 371.75 50 6 6737 43 -1 42 4 4 369.5 369.5 398.125 75 7 7027 43 0 43 0 5 365 365 454.5 máximo 8 2937 42 -1 41 4 6 368.5 368.5 Intervalo Frq. média 9 4999 42 0 42 0 7 424 424 perda 379.08 297 313 297 - 313 1.0% 305 10 1646 42 -2 40 8 8 370 370 313 329 313 - 329 4.0% 321 11 8989 42 2 44 3 9 395 395 329 345 329 - 345 9.0% 337 12 9464 42 3 45 4.5 10 368.5 368.5 345 361 345 - 361 12.0% 353 13 6776 43 -1 42 4 11 382 382 361 377 361 - 377 27.0% 369 14 3658 43 -2 41 8 12 297 297 377 393 377 - 393 14.0% 385 15 1723 43 -2 41 8 13 365 365 393 409 393 - 409 13.0% 401 16 7372 42 1 43 1.5 14 361.5 361.5 409 425 409 - 425 12.0% 417 17 1799 42 -1 41 4 15 383.5 383.5 425 441 425 - 441 7.0% 433 18 5282 42 0 42 0 16 336 336 441 457 441 - 457 1.0% 449 19 9270 42 2 44 3 17 359.5 359.5 20 8879 43 1 44 1.5 18 362.5 362.5 21 1417 43 -3 40 12 19 389.5 389.5 22 9604 43 2 45 3 20 370 370 23 1575 43 -3 40 12 21 409 409 24 98 42 -2 40 8 22 397.5 397.5 25 7453 41 2 43 3 23 342.5 342.5 26 8127 42 1 43 1.5 24 402.5 402.5 27 7580 42 1 43 1.5 25 371.5 371.5 28 6532 42 0 42 0 26 378 378 29 1411 43 -3 40 12 27 349.5 349.5 30 7935 42 1 43 1.5 28 413.5 413.5 31 1046 42 -2 40 8 29 417.5 417.5 32 7086 41 2 43 3 30 398 398 33 6209 42 0 42 0 31 365.5 365.5 34 8566 42 2 44 3 32 422.5 422.5 35 8522 42 2 44 3 33 396 396 36 4479 43 -1 42 4 34 319 319 0 23 37 8763 43 1 44 1.5 35 366 366 1.5 17 38 2901 44 -3 41 12 36 371 371 3 14 39 973 43 -3 40 12 37 421 421 4 19 40 4753 42 0 42 0 38 395 395 4.5 4 41 6517 42 0 42 0 39 433 433 6 0 42 6112 41 1 42 1.5 40 337.5 337.5 7.5 0 43 7293 42 1 43 1.5 41 372 372 8 13 44 2253 42 -1 41 4 42 366 366 12 9 45 6882 42 1 43 1.5 43 319.5 319.5 16 1 46 7065 42 1 43 1.5 44 344.5 344.5 20 0 47 1860 43 -2 41 8 45 376 376 100 48 2795 42 -1 41 4 46 428.5 428.5 49 9991 42 3 45 4.5 47 433.5 433.5 50 9150 43 1 44 1.5 48 318 318 51 9910 43 2 45 3 49 409.5 409.5 52 1840 44 -3 41 12 50 363.5 363.5 53 1468 44 -4 40 16 51 359 359 54 7277 43 0 43 0 52 380 380 55 9266 42 2 44 3 53 433.5 433.5 56 5101 42 0 42 0 54 348.5 348.5 57 6908 42 1 43 1.5 55 367 367 58 1733 43 -2 41 8 56 381.5 381.5 59 5531 43 -1 42 4 57 376 376 60 7018 42 1 43 1.5 58 420.5 420.5 61 470 42 -2 40 8 59 427 427 62 4216 42 0 42 0 60 414 414 63 5387 42 0 42 0 61 365.5 365.5 64 9003 42 2 44 3 62 378.5 378.5 65 7223 42 1 43 1.5 63 388.5 388.5 66 5012 43 -1 42 4 64 386.5 386.5 67 2359 43 -2 41 8 65 320 320 68 1910 43 -2 41 8 66 454.5 454.5 69 2744 42 -1 41 4 67 407 407 70 2815 41 0 41 0 68 366 366 71 4249 41 1 42 1.5 69 426.5 426.5 72 372 41 -1 40 4 70 380.5 380.5 73 8216 41 3 44 4.5 71 416 416 74 4392 42 0 42 0 72 402 402 75 7275 42 1 43 1.5 73 396 396 76 6618 42 0 42 0 74 358 358 77 1399 43 -3 40 12 75 364.5 364.5 78 678 42 -2 40 8 76 405 405 79 3335 41 0 41 0 77 363 363 80 2748 41 0 41 0 78 344.5 344.5 81 7684 41 2 43 3 79 390 390 82 3725 41 0 41 0 80 343 343 83 9457 42 3 45 4.5 81 361.5 361.5 84 3946 43 -2 41 8 82 394 394 85 7162 43 0 43 0 83 341 341 86 5404 43 -1 42 4 84 360 360 87 4641 43 -1 42 4 85 381.5 381.5 88 3697 42 -1 41 4 86 393 393 89 4696 42 0 42 0 87 332 332 90 4812 42 0 42 0 88 355 355 91 4719 42 0 42 0 89 357.5 357.5 92 8773 42 2 44 3 90 346.5 346.5 93 9759 43 2 45 3 91 380 380 94 5631 43 -1 42 4 92 424 424 95 658 43 -3 40 12 93 346 346 96 8254 43 1 44 1.5 94 414.5 414.5 97 1445 43 -3 40 12 95 379 379 98 5873 42 0 42 0 96 426 426 99 4696 42 0 42 0 97 368.5 368.5 100 8922 42 2 44 3 98 337 337 101 3365 42 -1 41 4 99 367 367 102 2776 42 -1 41 4 100 356.5 356.5 103 3358 42 -1 41 4 37810 104 1480 42 -2 40 8 3.7821317007767195 Sim_m.M.b Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 4905 42 42 63 Total Perdas 265 2 83 40 40 60 3 5211 42 42 63 1 337.5 337.5 248.5 minimo 4 4098 42 42 63 2 312.5 312.5 293.125 25 5 6585 41 1 42 1.5 3 286.5 286.5 309.5 50 6 4324 41 1 42 1.5 4 254.5 254.5 338.625 75 7 2850 42 -1 41 4 5 307 307 395 máximo 8 6238 41 1 42 1.5 6 255 255 Intervalo Frq. média 9 7763 41 2 43 3 7 296 296 perda 315.05 248 263 248 - 263 4.0% 255.5 10 9432 42 3 45 4.5 8 309 309 263 278 263 - 278 8.0% 270.5 11 3594 42 -1 41 4 9 350 350 278 293 278 - 293 13.0% 285.5 12 4517 42 0 42 0 10 271.5 271.5 293 308 293 - 308 18.0% 300.5 13 9057 42 2 44 3 11 305 305 308 323 308 - 323 21.0% 315.5 14 9495 43 2 45 3 12 339 339 323 338 323 - 338 9.0% 330.5 15 3949 43 -2 41 8 13 288 288 338 353 338 - 353 16.0% 345.5 16 5266 43 -1 42 4 14 295 295 353 368 353 - 368 6.0% 360.5 17 4943 43 -1 42 4 15 303.5 303.5 368 383 368 - 383 3.0% 375.5 18 7147 42 1 43 1.5 16 292 292 383 398 383 - 398 2.0% 390.5 19 1371 42 -2 40 8 17 308.5 308.5 20 2668 41 0 41 0 18 353.5 353.5 21 5628 41 1 42 1.5 19 346 346 22 7457 41 2 43 3 20 338.5 338.5 23 9285 41 3 44 4.5 21 299 299 24 4692 42 0 42 0 22 339.5 339.5 25 2124 42 -1 41 4 23 341 341 26 6657 42 0 42 0 24 318 318 27 5579 42 0 42 0 25 290.5 290.5 28 8753 41 3 44 4.5 26 363 363 29 6151 42 0 42 0 27 309.5 309.5 30 9248 42 2 44 3 28 313 313 31 2388 43 -2 41 8 29 378.5 378.5 32 119 42 -2 40 8 30 342 342 33 8643 41 3 44 4.5 31 309.5 309.5 34 3154 42 -1 41 4 32 279.5 279.5 35 4447 41 1 42 1.5 33 349 349 36 189 41 -1 40 4 34 395 395 0 27 37 4287 41 1 42 1.5 35 271 271 1.5 22 38 5169 41 1 42 1.5 36 358 358 3 11 39 3736 41 0 41 0 37 271 271 4 21 40 2682 41 0 41 0 38 317 317 4.5 10 41 2078 41 0 41 0 39 359 359 6 1 42 8685 41 3 44 4.5 40 315.5 315.5 7.5 0 43 1949 41 0 41 0 41 379.5 379.5 8 8 44 4817 41 1 42 1.5 42 309.5 309.5 12 0 45 8008 42 1 43 1.5 43 310.5 310.5 16 0 46 2134 42 -1 41 4 44 274 274 20 0 47 528 41 -1 40 4 45 309.5 309.5 100 48 6457 41 1 42 1.5 46 290.5 290.5 49 1699 41 0 41 0 47 298 298 50 6711 41 1 42 1.5 48 327 327 51 6098 41 1 42 1.5 49 317.5 317.5 52 3576 41 0 41 0 50 312.5 312.5 53 3578 41 0 41 0 51 248.5 248.5 54 8739 41 3 44 4.5 52 280 280 55 3099 42 -1 41 4 53 327.5 327.5 56 6300 41 1 42 1.5 54 307 307 57 287 42 -2 40 8 55 326.5 326.5 58 3283 41 0 41 0 56 340 340 59 3164 41 0 41 0 57 291 291 60 1553 41 -1 40 4 58 290 290 61 4187 40 2 42 3 59 331.5 331.5 62 8213 41 3 44 4.5 60 297.5 297.5 63 3131 41 0 41 0 61 274 274 64 1709 41 0 41 0 62 309.5 309.5 65 3869 42 -1 41 4 63 308.5 308.5 66 5702 41 1 42 1.5 64 289.5 289.5 67 138 41 -1 40 4 65 290.5 290.5 68 4997 41 1 42 1.5 66 343.5 343.5 69 3955 41 0 41 0 67 338 338 70 9698 41 4 45 6 68 316 316 71 6102 42 0 42 0 69 294 294 72 5549 42 0 42 0 70 297 297 73 3796 42 -1 41 4 71 301 301 74 4607 42 0 42 0 72 340 340 75 8619 41 3 44 4.5 73 330.5 330.5 76 1381 42 -2 40 8 74 310.5 310.5 77 2733 41 0 41 0 75 267.5 267.5 78 8716 41 3 44 4.5 76 252 252 79 7368 42 1 43 1.5 77 322.5 322.5 80 5475 42 0 42 0 78 292 292 81 8376 42 2 44 3 79 291.5 291.5 82 7831 43 0 43 0 80 306 306 83 7356 43 0 43 0 81 363.5 363.5 84 1775 43 -2 41 8 82 370.5 370.5 85 8406 42 2 44 3 83 340.5 340.5 86 6516 42 0 42 0 84 300.5 300.5 87 7371 42 1 43 1.5 85 332.5 332.5 88 2402 42 -1 41 4 86 308 308 89 4662 42 0 42 0 87 333 333 90 2925 42 -1 41 4 88 341.5 341.5 91 7565 41 2 43 3 89 342.5 342.5 92 4025 41 1 42 1.5 90 330.5 330.5 93 3673 42 -1 41 4 91 342.5 342.5 94 4865 41 1 42 1.5 92 305.5 305.5 95 7365 42 1 43 1.5 93 358 358 96 3060 42 -1 41 4 94 389 389 97 7936 41 2 43 3 95 305 305 98 1322 42 -2 40 8 96 274.5 274.5 99 7529 41 2 43 3 97 301.5 301.5 100 174 41 -1 40 4 98 293.5 293.5 101 5282 41 1 42 1.5 99 312.5 312.5 102 534 41 -1 40 4 100 274.5 274.5 103 8302 41 3 44 4.5 31428.5 104 1328 41 -1 40 4 2.3197657492326962 Sim_40 Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 1821 40 1 41 1.5 Total Perdas 258 2 5526 40 2 42 3 1 3 5553 40 2 42 3 1 261 261 238.5 minimo 4 5563 40 2 42 3 2 283.5 283.5 286.5 25 5 3749 40 1 41 1.5 3 297 297 298.5 50 6 5276 40 2 42 3 4 285 285 309.75 75 7 7881 40 3 43 4.5 5 343.5 343.5 357 máximo 8 839 40 0 40 0 6 303 303 Intervalo Frq. 9 5744 40 2 42 3 7 340.5 340.5 Perda 299.8 238 250 238 - 250 2.0% 244 10 615 40 0 40 0 8 309 309 250 262 250 - 262 2.0% 256 11 8566 40 4 44 6 9 313.5 313.5 262 274 262 - 274 6.0% 268 12 3541 40 1 41 1.5 10 325.5 325.5 274 286 274 - 286 14.0% 280 13 8550 40 4 44 6 11 322.5 322.5 286 298 286 - 298 21.0% 292 14 6879 40 3 43 4.5 12 313.5 313.5 298 310 298 - 310 30.0% 304 15 2671 40 1 41 1.5 13 316.5 316.5 310 322 310 - 322 9.0% 316 16 2217 40 1 41 1.5 14 298.5 298.5 322 334 322 - 334 8.0% 328 17 464 40 0 40 0 15 297 297 334 346 334 - 346 7.0% 340 18 9708 40 5 45 7.5 16 303 303 346 358 346 - 358 1.0% 352 19 1245 40 0 40 0 17 303 303 20 9796 40 5 45 7.5 18 322.5 322.5 21 80 40 0 40 0 19 279 279 22 1034 40 0 40 0 20 303 303 23 9191 40 4 44 6 21 285 285 24 3739 40 1 41 1.5 22 307.5 307.5 25 6559 40 2 42 3 23 295.5 295.5 26 1233 40 0 40 0 24 277.5 277.5 27 2218 40 1 41 1.5 25 306 306 28 1603 40 0 40 0 26 276 276 29 1533 40 0 40 0 27 298.5 298.5 30 7220 40 3 43 4.5 28 289.5 289.5 31 2083 40 1 41 1.5 29 304.5 304.5 32 8067 40 3 43 4.5 30 328.5 328.5 33 2653 40 1 41 1.5 31 286.5 286.5 34 5674 40 2 42 3 32 306 306 35 1053 40 0 40 0 33 300 300 36 8846 40 4 44 6 34 307.5 307.5 0 25 37 1901 40 1 41 1.5 35 319.5 319.5 1.5 26 38 835 40 0 40 0 36 238.5 238.5 3 24 39 1357 40 0 40 0 37 240 240 4 0 40 5585 40 2 42 3 38 297 297 4.5 7 41 6287 40 2 42 3 39 292.5 292.5 6 13 42 8854 40 4 44 6 40 282 282 7.5 5 43 137 40 0 40 0 41 303 303 8 0 44 2746 40 1 41 1.5 42 298.5 298.5 12 0 45 5679 40 2 42 3 43 300 300 16 0 46 5113 40 2 42 3 44 298.5 298.5 20 0 47 5109 40 2 42 3 45 300 300 100 48 7058 40 3 43 4.5 46 274.5 274.5 49 8881 40 4 44 6 47 271.5 271.5 50 2406 40 1 41 1.5 48 297 297 51 844 40 0 40 0 49 301.5 301.5 52 5134 40 2 42 3 50 334.5 334.5 53 7958 40 3 43 4.5 51 318 318 54 2514 40 1 41 1.5 52 334.5 334.5 55 1118 40 0 40 0 53 268.5 268.5 56 8651 40 4 44 6 54 292.5 292.5 57 8662 40 4 44 6 55 309 309 58 5577 40 2 42 3 56 282 282 59 2554 40 1 41 1.5 57 261 261 60 6218 40 2 42 3 58 303 303 61 2340 40 1 41 1.5 59 337.5 337.5 62 9067 40 4 44 6 60 357 357 63 3861 40 1 41 1.5 61 331.5 331.5 64 420 40 0 40 0 62 295.5 295.5 65 1406 40 0 40 0 63 328.5 328.5 66 4176 40 2 42 3 64 277.5 277.5 67 8619 40 4 44 6 65 295.5 295.5 68 2770 40 1 41 1.5 66 298.5 298.5 69 5337 40 2 42 3 67 285 285 70 9570 40 5 45 7.5 68 291 291 71 7414 40 3 43 4.5 69 291 291 72 9259 40 4 44 6 70 309 309 73 3898 40 1 41 1.5 71 328.5 328.5 74 1386 40 0 40 0 72 271.5 271.5 75 8940 40 4 44 6 73 327 327 76 83 40 0 40 0 74 312 312 77 2285 40 1 41 1.5 75 297 297 78 2701 40 1 41 1.5 76 286.5 286.5 79 4735 40 2 42 3 77 282 282 80 5472 40 2 42 3 78 307.5 307.5 81 9615 40 5 45 7.5 79 300 300 82 6660 40 2 42 3 80 270 270 83 4082 40 2 42 3 81 304.5 304.5 84 3309 40 1 41 1.5 82 295.5 295.5 85 72 40 0 40 0 83 292.5 292.5 86 2353 40 1 41 1.5 84 303 303 87 780 40 0 40 0 85 315 315 88 183 40 0 40 0 86 288 288 89 3717 40 1 41 1.5 87 298.5 298.5 90 4397 40 2 42 3 88 271.5 271.5 91 2378 40 1 41 1.5 89 307.5 307.5 92 6533 40 2 42 3 90 295.5 295.5 93 9318 40 4 44 6 91 288 288 94 9658 40 5 45 7.5 92 336 336 95 872 40 0 40 0 93 336 336 96 3478 40 1 41 1.5 94 316.5 316.5 97 61 40 0 40 0 95 282 282 98 2110 40 1 41 1.5 96 292.5 292.5 99 5704 40 2 42 3 97 315 315 100 610 40 0 40 0 98 285 285 99 298.5 298.5 100 273 273 29979 2.2470182262480445 Sim_41 Semana Gera aleatório Oferta Diferença Demanda Perdas Média 1 8568 41 3 44 4.5 Total Perdas 255 2 4172 41 1 42 1.5 3 1216 41 -1 40 4 4 2502 41 0 41 0 243.5 5 2989 41 0 41 0 267.5 6 7398 41 2 43 3 232 7 190 41 -1 40 4 273 8 7895 41 2 43 3 233.5 9 626 41 -1 40 4 240 10 530 41 -1 40 4 222 11 5421 41 1 42 1.5 241.5 12 89 41 -1 40 4 233.5 13 4010 41 1 42 1.5 231.5 14 1749 41 0 41 0 231 15 3100 41 0 41 0 224 16 3551 41 0 41 0 236 17 9328 41 3 44 4.5 251 18 5638 41 1 42 1.5 212 19 7095 41 2 43 3 236.5 20 8521 41 3 44 4.5 244.5 21 5155 41 1 42 1.5 270 22 6463 41 1 42 1.5 257.5 23 1345 41 -1 40 4 231 24 312 41 -1 40 4 201.5 25 2878 41 0 41 0 261.5 26 992 41 -1 40 4 246.5 27 2045 41 0 41 0 239 28 6308 41 1 42 1.5 258 29 1871 41 0 41 0 256.5 30 8971 41 3 44 4.5 229.5 31 60 41 -1 40 4 230.5 32 2283 41 0 41 0 253 33 4058 41 1 42 1.5 217.5 34 820 41 -1 40 4 258.5 35 345 41 -1 40 4 240 36 8542 41 3 44 4.5 248 0 24 37 3966 41 0 41 0 246.5 1.5 21 38 1341 41 -1 40 4 243 3 10 39 2189 41 0 41 0 262 4 27 40 4897 41 1 42 1.5 214 4.5 15 41 2488 41 0 41 0 225 6 3 42 4679 41 1 42 1.5 230.5 7.5 0 43 2731 41 0 41 0 249 8 0 44 2796 41 0 41 0 234.5 12 0 45 5659 41 1 42 1.5 223.5 16 0 46 486 41 -1 40 4 222 20 0 47 8557 41 3 44 4.5 253.5 100 48 974 41 -1 40 4 240 49 8492 41 3 44 4.5 225 50 7423 41 2 43 3 237 51 6893 41 2 43 3 236.5 52 8623 41 3 44 4.5 227.5 53 1540 41 -1 40 4 229.5 54 4227 41 1 42 1.5 230 55 6472 41 1 42 1.5 233.5 56 6380 41 1 42 1.5 267.5 57 4266 41 1 42 1.5 222.5 58 8377 41 3 44 4.5 266.5 59 3586 41 0 41 0 257 60 2539 41 0 41 0 231.5 61 291 41 -1 40 4 258.5 62 8153 41 2 43 3 250.5 63 2002 41 0 41 0 234.5 64 67 41 -1 40 4 230 65 8202 41 3 44 4.5 261.5 66 5755 41 1 42 1.5 249 67 2525 41 0 41 0 269 68 162 41 -1 40 4 253 69 8116 41 2 43 3 215.5 70 8835 41 3 44 4.5 220.5 71 591 41 -1 40 4 223 72 7229 41 2 43 3 243.5 73 253 41 -1 40 4 245.5 74 2449 41 0 41 0 258.5 75 5427 41 1 42 1.5 265 76 1151 41 -1 40 4 251 77 5718 41 1 42 1.5 264 78 2733 41 0 41 0 241.5 79 3593 41 0 41 0 217.5 80 678 41 -1 40 4 222.5 81 764 41 -1 40 4 251.5 82 5063 41 1 42 1.5 231.5 83 3727 41 0 41 0 239 84 1112 41 -1 40 4 256 85 7936 41 2 43 3 268.5 86 6634 41 1 42 1.5 238 87 3122 41 0 41 0 247.5 88 9435 41 4 45 6 238.5 89 9711 41 4 45 6 236.5 90 9144 41 3 44 4.5 227 91 171 41 -1 40 4 266.5 92 9329 41 3 44 4.5 212.5 93 2654 41 0 41 0 251 94 8210 41 3 44 4.5 244 95 1580 41 -1 40 4 247 96 6756 41 1 42 1.5 246 97 9281 41 3 44 4.5 243.5 98 7178 41 2 43 3 264 99 9888 41 4 45 6 249 100 64 41 -1 40 4 214.5 251 299 232 Resultados DEM.ANT MED.HIST. MED.M.C. MED.M.B 40 41 437.5 273 354.5 337.5 261 243.5 368.5 325.5 370 312.5 283.5 267.5 459 296 398.5 286.5 297 232 Demanda anterior Media historica Media mes para cima Media mes para baixo 40 41 390.5 349 369.5 254.5 285 273 200 210 200 - 210 0 0 0 0 0 1 392 319 365 307 343.5 233.5 210 220 210 - 220 0 0 0 0 0 7 374 329 368.5 255 303 240 220 230 220 - 230 0 0 0 0 0 14 467.5 311 424 296 340.5 222 230 240 230 - 240 0 0 0 0 1 25 437.5 288.5 370 309 309 241.5 240 250 240 - 250 0 2 0 1 1 21 428.5 304 395 350 313.5 233.5 250 260 250 - 260 0 1 0 3 0 17 458 348.5 368.5 271.5 325.5 231.5 260 270 260 - 270 0 2 0 1 3 12 429.5 359.5 382 305 322.5 231 270 280 270 - 280 0 3 0 8 10 2 464.5 339.5 297 339 313.5 224 280 290 280 - 290 0 9 0 4 14 0 474 381 365 288 316.5 236 290 300 290 - 300 0 12 1 16 23 1 417 298 361.5 295 298.5 251 300 310 300 - 310 0 14 0 19 23 0 452.5 345 383.5 303.5 297 212 310 320 310 - 320 0 14 3 11 9 0 438.5 316.5 336 292 303 236.5 320 330 320 - 330 1 15 1 4 7 0 447 297.5 359.5 308.5 303 244.5 330 340 330 - 340 0 11 4 10 6 0 521 331.5 362.5 353.5 322.5 270 340 350 340 - 350 0 7 9 11 2 0 493.5 299.5 389.5 346 279 257.5 350 360 350 - 360 0 5 7 5 1 0 455 333.5 370 338.5 303 231 360 370 360 - 370 2 2 20 2 0 0 407 314.5 409 299 285 201.5 370 380 370 - 380 2 1 11 3 0 0 494.5 281.5 397.5 339.5 307.5 261.5 380 390 380 - 390 6 1 10 1 0 0 482.5 319.5 342.5 341 295.5 246.5 390 400 390 - 400 5 1 10 1 0 0 423.5 281 402.5 318 277.5 239 400 410 400 - 410 7 0 6 0 0 0 459 325.5 371.5 290.5 306 258 410 420 410 - 420 5 0 5 0 0 0 458.5 306 378 363 276 256.5 420 430 420 - 430 7 0 9 0 0 0 495 327.5 349.5 309.5 298.5 229.5 430 440 430 - 440 9 0 3 0 0 0 480 305.5 413.5 313 289.5 230.5 440 450 440 - 450 10 0 0 0 0 0 380.5 339.5 417.5 378.5 304.5 253 450 460 450 - 460 11 0 1 0 0 0 447.5 291 398 342 328.5 217.5 460 470 460 - 470 7 0 0 0 0 0 495 307 365.5 309.5 286.5 258.5 470 480 470 - 480 6 0 0 0 0 0 409.5 315 422.5 279.5 306 240 480 490 480 - 490 8 0 0 0 0 0 430.5 323.5 396 349 300 248 490 500 490 - 500 5 0 0 0 0 0 487 308.5 319 395 307.5 246.5 500 510 500 - 510 3 0 0 0 0 0 419.5 297 366 271 319.5 243 510 520 510 - 520 0 0 0 0 0 0 407 299.5 371 358 238.5 262 520 530 520 - 530 2 0 0 0 0 0 415 317.5 421 271 240 214 530 540 530 - 540 1 0 0 0 0 0 467.5 314.5 395 317 297 225 540 550 540 - 550 2 0 0 0 0 0 448.5 298.5 433 359 292.5 230.5 550 560 550 - 560 1 0 0 0 0 0 555.5 299 337.5 315.5 282 249 405.5 281 372 379.5 303 234.5 100 100 100 100 100 100 433.5 288.5 366 309.5 298.5 223.5 502 324.5 319.5 310.5 300 222 483 331.5 344.5 274 298.5 253.5 427.5 350 376 309.5 300 240 DEM.ANT MED.HIST. MED.M.C. MED.M.B 40 41 423 243.5 428.5 290.5 274.5 225 Perda esperada em 100 semanas 445.615 315.685 378.1 314.285 299.79 241.87 501.5 247.5 433.5 298 271.5 237 desvio padrao 43.1453881684 27.8833840497 30.7764011653 30.6902293372 21.0270604871 16.759230835 481 307 318 327 297 236.5 465 329.5 409.5 317.5 301.5 227.5 401.5 294.5 363.5 312.5 334.5 229.5 481 279.5 359 248.5 318 230 407 351 380 280 334.5 233.5 480 306 433.5 327.5 268.5 267.5 446.5 252 348.5 307 292.5 222.5 365.5 343.5 367 326.5 309 266.5 407 375 381.5 340 282 257 324.5 318.5 376 291 261 231.5 418 306 420.5 290 303 258.5 442.5 327 427 331.5 337.5 250.5 423.5 326 414 297.5 357 234.5 534 293 365.5 274 331.5 230 447 344.5 378.5 309.5 295.5 261.5 385 322 388.5 308.5 328.5 249 493.5 326.5 386.5 289.5 277.5 269 478 317.5 320 290.5 295.5 253 542 305 454.5 343.5 298.5 215.5 416.5 306 407 338 285 220.5 459 295 366 316 291 223 508 310 426.5 294 291 243.5 529 368 380.5 297 309 245.5 385 305.5 416 301 328.5 258.5 445.5 281.5 402 340 271.5 265 434 316 396 330.5 327 251 453.5 269 358 310.5 312 264 485.5 313 364.5 267.5 297 241.5 422 337.5 405 252 286.5 217.5 437 286.5 363 322.5 282 222.5 372.5 285 344.5 292 307.5 251.5 456.5 336.5 390 291.5 300 231.5 389 364.5 343 306 270 239 476 354 361.5 363.5 304.5 256 453.5 276.5 394 370.5 295.5 268.5 399 315 341 340.5 292.5 238 389 308 360 300.5 303 247.5 392 336.5 381.5 332.5 315 238.5 449.5 322 393 308 288 236.5 437 330 332 333 298.5 227 472.5 397 355 341.5 271.5 266.5 430.5 332 357.5 342.5 307.5 212.5 399 343 346.5 330.5 295.5 251 540 328 380 342.5 288 244 448.5 320.5 424 305.5 336 247 381 355.5 346 358 336 246 451 322.5 414.5 389 316.5 243.5 472 269 379 305 282 264 448.5 337.5 426 274.5 292.5 249 473 286 368.5 301.5 315 214.5 460.5 348.5 337 293.5 285 251 467 305.5 367 312.5 298.5 299 462 300.5 356.5 274.5 273 232
Compartilhar