| Lumenaut Simulation Report |
|
| Cell: |
Lumenaut Monte
Model'!$B$18 |
|
Workbook: |
Bob's Wigets Ltd.xls |
| Cell Name: |
Profit |
|
Date: |
22-May-05 |
| Iterations: |
10000 |
|
Time: |
9:25:37 PM |
|
|
|
|
| Percentile |
Left to Right |
|
Percentile |
Right to Left |
| 0% |
-50275.0471 |
|
0% |
89379.9749 |
| 10% |
-4165.8098 |
|
10% |
44636.2621 |
| 20% |
4102.1409 |
|
20% |
36180.9609 |
| 30% |
10000.1746 |
|
30% |
30162.9988 |
| 40% |
15179.086 |
|
40% |
24959.4256 |
| 50% |
20032.9783 |
|
50% |
20032.9783 |
| 60% |
24959.4256 |
|
60% |
15179.086 |
| 70% |
30162.9988 |
|
70% |
10000.1746 |
| 80% |
36180.9609 |
|
80% |
4102.1409 |
| 90% |
44636.2621 |
|
90% |
-4165.8098 |
| 100% |
89379.9749 |
|
100% |
-50275.0471 |
|
|
|
| Mean |
20064.78262 |
|
| Median |
20034.3272 |
|
| Mode |
N/A |
|
| Stand. Deviation |
19157.39031 |
|
| Variance |
367005603.5 |
|
| Mean Std. Error |
191.5739031 |
|
| Range |
139655.022 |
|
| Range Min |
-50275.0471 |
|
| Range Max |
89379.9749 |
|
| Skewness |
-0.030945738 |
|
| Kurtosis |
3.024665108 |
|
|
| Lumenaut Simulation Input |
|
|
| Cell Name: |
Variable Costs Per Widget |
|
| Cell: |
Lumenaut Monte
Model'!$B$8 |
|
| Distribution: |
Normal |
|
| Mean: |
5 |
|
| Standard Deviantion: |
0.5 |
|
| Min: |
2.999998833 |
|
| Max: |
7.000001167 |
|
|
|
|
|
|
|
| Cell Name: |
Number of Widgets Sold |
|
| Cell: |
Lumenaut Monte
Model'!$B$9 |
|
| Distribution: |
Normal |
|
| Mean: |
2000 |
|
| Standard Deviantion: |
200 |
|
| Min: |
1199.999533 |
|
| Max: |
2800.000467 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
