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