Monte Carlo Simulation using What If Analysis - Normal Distribution
Revenue FC VC Total simulations: 1000
Order Cost Holding Cost Simulation Outcome
Expected 428,824 104,650 84,496 1 237,177
Std 550 4,097 2,317 2 239,023
Net 3 247,194
1st simulation 427,662 102,720 87,765 237,177 4 241,941
5 233,324
6 235,371
Probability of Profit 7 239,325
mean 239,840 8 247,470
std 4,731 9 239,000
min 225,844 10 241,266
max 255,422 11 230,529
12 247,670
Risk of loss 0% 13 240,209
14 243,283
15 242,547
16 241,165
17 236,086
18 240,406
19 227,983
20 238,081
21 241,020
22 234,641
23 235,918
24 238,228
25 248,864
26 245,387
27 231,597
28 243,906
29 243,717
30 239,442
31 246,044
32 241,695
33 241,656
34 246,573
35 230,870
36 242,718
37 237,149
38 235,746
39 234,974
40 235,726
41 240,534
42 231,420
43 243,601
44 230,827
45 239,371
46 236,314
47 240,991
48 234,844
49 247,147
50 247,042
51 235,988
52 235,440
53 238,618
54 230,162
55 236,461
56 237,407
57 241,207
58 234,873
59 231,936
60 246,194
61 243,215
62 240,998
63 237,466
64 234,991
65 242,674
66 234,698
67 237,255
68 228,097
69 231,247
70 237,701
71 238,295
72 234,373
73 241,535
74 241,529
75 241,804
76 244,343
77 236,277
78 242,709
79 237,185
80 241,297
81 241,301
82 234,753
83 243,535
84 233,268
85 243,605
86 233,550
87 233,892
88 234,528
89 233,998
90 244,481
91 241,207
92 239,414
93 240,326
94 232,393
95 240,443
96 226,820
97 236,856
98 244,839
99 234,207
100 242,387
101 239,115
102 243,066
103 246,333
104 238,360
105 243,087
106 237,920
107 239,173
108 247,344
109 243,059
110 244,524
111 241,675
112 233,264
113 240,939
114 235,229
115 241,494
116 237,060
117 238,419
118 233,217
119 240,050
120 238,776
121 244,055
122 229,697
123 231,568
124 243,711
125 237,998
126 240,690
127 246,013
128 241,964
129 248,561
130 241,796
131 234,323
132 243,581
133 246,316
134 242,111
135 233,899
136 241,871
137 229,386
138 239,246
139 233,149
140 233,857
141 242,495
142 238,071
143 228,284
144 239,348
145 244,617
146 242,994
147 243,571
148 240,800
149 240,254
150 234,380
151 243,036
152 232,719
153 243,896
154 240,027
155 246,249
156 232,472
157 238,205
158 230,063
159 235,421
160 236,169
161 241,621
162 240,868
163 239,744
164 244,001
165 238,176
166 234,707
167 239,363
168 232,615
169 245,600
170 229,533
171 239,658
172 239,751
173 242,665
174 243,961
175 240,365
176 233,785
177 247,075
178 240,935
179 241,162
180 245,325
181 236,391
182 236,181
183 241,589
184 239,498
185 236,450
186 235,741
187 241,856
188 239,082
189 244,106
190 234,056
191 229,291
192 244,536
193 239,453
194 231,467
195 243,095
196 236,606
197 252,076
198 240,535
199 239,774
200 232,528
201 243,283
202 234,219
203 243,765
204 247,537
205 243,160
206 236,462
207 242,297
208 241,879
209 231,023
210 249,420
211 238,933
212 240,968
213 244,961
214 238,479
215 232,552
216 237,043
217 242,426
218 235,134
219 235,522
220 237,102
221 244,693
222 242,874
223 241,341
224 233,314
225 242,693
226 232,446
227 241,206
228 238,521
229 241,086
230 250,580
231 243,977
232 243,730
233 237,000
234 241,796
235 246,088
236 242,733
237 231,882
238 234,695
239 238,563
240 235,991
241 235,007
242 250,882
243 232,442
244 237,804
245 239,817
246 236,902
247 241,058
248 243,612
249 234,122
250 240,815
251 241,208
252 237,520
253 226,585
254 241,103
255 238,695
256 229,453
257 246,137
258 241,594
259 246,723
260 238,721
261 240,224
262 228,891
263 249,557
264 235,246
265 243,150
266 252,320
267 240,021
268 236,309
269 236,338
270 236,165
271 235,856
272 239,716
273 242,059
274 233,731
275 239,574
276 242,305
277 235,323
278 239,645
279 247,439
280 245,670
281 248,598
282 236,840
283 234,674
284 241,334
285 240,622
286 242,613
287 232,418
288 243,046
289 238,263
290 245,977
291 235,916
292 241,053
293 234,687
294 245,138
295 246,018
296 244,052
297 235,587
298 241,681
299 249,376
300 225,844
301 237,179
302 241,223
303 247,526
304 240,698
305 242,239
306 242,936
307 236,930
308 236,476
309 240,587
310 237,615
311 241,571
312 240,638
313 242,251
314 242,741
315 239,251
316 231,265
317 236,388
318 233,152
319 233,064
320 238,845
321 233,874
322 242,421
323 234,370
324 244,734
325 237,138
326 237,346
327 241,178
328 236,500
329 247,341
330 243,614
331 245,928
332 234,059
333 245,630
334 226,065
335 248,615
336 241,871
337 243,588
338 246,922
339 245,862
340 243,958
341 243,147
342 255,422
343 241,281
344 236,888
345 233,104
346 242,674
347 238,861
348 241,530
349 245,419
350 239,136
351 238,822
352 244,494
353 242,165
354 238,007
355 237,359
356 238,683
357 237,705
358 252,446
359 242,635
360 246,302
361 242,854
362 246,876
363 237,246
364 240,853
365 229,745
366 243,513
367 238,754
368 249,302
369 237,374
370 237,694
371 240,740
372 232,904
373 243,155
374 231,451
375 239,380
376 251,104
377 242,830
378 241,745
379 238,669
380 232,397
381 240,233
382 242,981
383 232,598
384 244,244
385 243,323
386 235,408
387 236,448
388 239,287
389 250,548
390 230,727
391 234,812
392 243,467
393 239,806
394 239,059
395 243,771
396 239,716
397 229,714
398 238,598
399 240,771
400 234,823
401 242,265
402 244,809
403 245,554
404 244,712
405 250,089
406 245,279
407 242,816
408 242,529
409 236,817
410 234,564
411 237,935
412 242,931
413 236,251
414 243,070
415 241,237
416 236,213
417 236,229
418 237,859
419 239,135
420 234,730
421 244,490
422 232,748
423 235,935
424 238,446
425 243,647
426 238,764
427 242,880
428 242,814
429 245,162
430 243,294
431 246,921
432 241,798
433 241,654
434 244,681
435 237,489
436 236,977
437 230,128
438 241,530
439 239,912
440 236,252
441 242,947
442 244,059
443 243,590
444 237,985
445 239,898
446 242,089
447 241,485
448 248,625
449 231,763
450 244,624
451 250,313
452 252,670
453 242,025
454 242,633
455 243,489
456 240,908
457 232,148
458 235,483
459 236,121
460 238,760
461 240,579
462 241,821
463 236,472
464 244,459
465 232,181
466 243,495
467 242,524
468 233,302
469 236,517
470 235,508
471 240,912
472 232,314
473 236,023
474 249,395
475 232,920
476 239,585
477 240,269
478 239,047
479 247,888
480 233,213
481 250,447
482 245,035
483 244,458
484 241,865
485 244,288
486 238,031
487 241,593
488 241,586
489 242,343
490 238,989
491 244,260
492 245,287
493 244,004
494 238,549
495 237,284
496 238,128
497 234,676
498 231,669
499 237,246
500 238,957
501 241,086
502 250,715
503 238,793
504 232,322
505 235,333
506 235,869
507 248,004
508 245,632
509 243,674
510 231,409
511 234,957
512 247,776
513 240,248
514 239,560
515 237,750
516 238,645
517 233,405
518 239,603
519 235,828
520 235,495
521 236,545
522 239,326
523 241,264
524 237,036
525 240,745
526 236,635
527 245,178
528 234,703
529 246,651
530 241,101
531 242,597
532 245,175
533 238,271
534 236,883
535 236,342
536 238,148
537 241,782
538 235,866
539 246,323
540 240,199
541 240,700
542 244,775
543 235,519
544 241,669
545 240,827
546 235,091
547 241,985
548 237,013
549 239,674
550 241,927
551 245,833
552 243,017
553 241,161
554 236,125
555 244,254
556 248,600
557 242,473
558 238,994
559 239,528
560 235,329
561 235,935
562 239,419
563 231,493
564 242,443
565 247,679
566 238,040
567 244,436
568 233,532
569 246,936
570 231,396
571 248,096
572 237,074
573 239,069
574 238,770
575 244,552
576 237,884
577 236,565
578 241,199
579 235,746
580 242,989
581 246,634
582 234,789
583 242,455
584 248,168
585 233,019
586 236,568
587 244,848
588 246,491
589 243,777
590 241,290
591 237,593
592 241,411
593 242,038
594 238,224
595 234,953
596 234,335
597 242,238
598 234,724
599 237,995
600 239,316
601 238,348
602 244,078
603 238,080
604 247,210
605 238,051
606 235,223
607 245,751
608 234,574
609 237,099
610 237,759
611 244,329
612 244,483
613 236,353
614 231,666
615 234,211
616 244,183
617 244,394
618 240,304
619 240,032
620 244,370
621 238,054
622 240,724
623 241,053
624 241,208
625 238,274
626 232,587
627 241,710
628 237,599
629 239,250
630 239,470
631 246,083
632 233,334
633 234,417
634 243,674
635 233,668
636 243,873
637 235,514
638 243,474
639 235,581
640 246,816
641 246,423
642 239,750
643 237,281
644 235,126
645 240,212
646 232,051
647 234,649
648 239,733
649 240,333
650 237,760
651 245,862
652 239,894
653 240,852
654 236,090
655 244,766
656 245,241
657 233,455
658 244,276
659 232,695
660 238,303
661 245,389
662 249,286
663 238,404
664 251,412
665 236,322
666 240,810
667 237,282
668 240,816
669 241,878
670 241,653
671 245,182
672 244,285
673 245,046
674 247,049
675 240,409
676 235,750
677 243,205
678 246,125
679 239,874
680 242,653
681 242,049
682 237,611
683 238,910
684 240,859
685 236,536
686 241,625
687 238,945
688 243,781
689 236,227
690 250,258
691 242,064
692 242,109
693 244,288
694 241,480
695 241,826
696 242,063
697 240,723
698 240,426
699 240,323
700 241,086
701 237,995
702 245,864
703 237,621
704 247,691
705 245,752
706 239,199
707 232,260
708 241,161
709 234,236
710 243,689
711 237,923
712 234,774
713 241,758
714 241,620
715 244,493
716 241,831
717 236,922
718 246,903
719 246,480
720 246,531
721 241,574
722 229,670
723 239,259
724 231,114
725 240,212
726 236,982
727 240,008
728 240,142
729 231,875
730 241,300
731 237,529
732 236,320
733 235,302
734 238,320
735 234,875
736 246,511
737 237,714
738 234,133
739 248,158
740 249,424
741 243,637
742 240,479
743 234,690
744 233,149
745 235,471
746 238,182
747 241,745
748 248,508
749 243,000
750 238,535
751 242,006
752 240,164
753 237,454
754 237,593
755 239,137
756 238,329
757 239,601
758 240,250
759 234,750
760 236,309
761 237,149
762 236,729
763 240,865
764 247,296
765 249,998
766 237,618
767 240,187
768 240,413
769 242,605
770 235,275
771 242,747
772 243,755
773 239,013
774 235,659
775 246,227
776 238,606
777 239,660
778 241,371
779 247,442
780 236,123
781 232,997
782 234,574
783 237,063
784 246,687
785 242,887
786 235,568
787 246,505
788 235,541
789 243,988
790 239,882
791 235,262
792 245,180
793 239,452
794 238,446
795 232,502
796 246,224
797 238,607
798 239,993
799 242,871
800 248,909
801 247,214
802 241,418
803 240,124
804 237,329
805 242,591
806 246,367
807 238,645
808 238,621
809 233,896
810 241,111
811 248,883
812 246,796
813 236,743
814 242,036
815 239,039
816 246,968
817 237,631
818 238,120
819 237,599
820 246,972
821 238,869
822 241,512
823 246,437
824 237,231
825 239,194
826 244,254
827 240,737
828 243,211
829 241,591
830 239,745
831 243,343
832 241,597
833 237,729
834 233,749
835 241,272
836 231,633
837 242,099
838 245,500
839 241,422
840 231,459
841 239,572
842 236,507
843 234,073
844 238,421
845 236,833
846 239,734
847 235,889
848 234,462
849 242,847
850 243,243
851 243,721
852 239,633
853 241,913
854 233,152
855 237,441
856 235,803
857 242,995
858 245,571
859 243,801
860 239,933
861 236,005
862 243,857
863 238,288
864 233,960
865 237,486
866 236,466
867 245,700
868 234,637
869 236,336
870 234,864
871 242,490
872 238,081
873 240,541
874 233,636
875 238,737
876 235,280
877 239,120
878 236,605
879 234,011
880 241,550
881 244,724
882 242,399
883 239,414
884 241,906
885 237,454
886 245,120
887 242,488
888 234,866
889 236,796
890 234,829
891 244,075
892 237,950
893 231,493
894 240,369
895 244,700
896 236,457
897 238,411
898 241,399
899 234,355
900 242,180
901 235,529
902 235,689
903 231,581
904 234,237
905 239,504
906 244,921
907 239,924
908 231,970
909 246,731
910 241,039
911 239,565
912 241,360
913 240,341
914 240,828
915 235,253
916 241,882
917 237,131
918 242,485
919 238,558
920 240,883
921 246,086
922 243,545
923 242,710
924 240,038
925 243,753
926 244,382
927 232,935
928 234,473
929 231,623
930 229,252
931 234,315
932 243,393
933 234,171
934 244,243
935 237,253
936 235,097
937 236,717
938 236,358
939 242,132
940 248,088
941 243,912
942 239,901
943 242,084
944 234,927
945 240,941
946 233,526
947 238,393
948 240,138
949 236,119
950 248,162
951 240,150
952 235,542
953 239,457
954 234,907
955 247,482
956 236,732
957 242,288
958 237,141
959 239,378
960 239,364
961 239,495
962 238,736
963 245,254
964 244,693
965 251,419
966 237,260
967 245,910
968 234,356
969 243,383
970 236,045
971 231,588
972 247,665
973 244,117
974 237,312
975 233,944
976 236,725
977 243,140
978 242,215
979 239,717
980 237,717
981 242,625
982 232,983
983 247,894
984 243,416
985 239,684
986 244,715
987 239,377
988 240,446
989 236,178
990 238,574
991 243,567
992 248,419
993 237,505
994 241,937
995 243,227
996 235,827
997 242,949
998 245,277
999 236,264
1000 234,296