[go: up one dir, main page]
Scribd
Upload
729 views3 pages

Vlookup (B13,$G$2:$H$7,2)

Uploaded by

api-25888404

The document contains a table showing the probability distribution of weekly sales from 0 to 5 units over 50 weeks. It then simulates 120 random numbers between 0 and 1 to estimate demand using a VLOOKUP table to match the random numbers to an expected sales value.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt

Vlookup (B13,$G$2:$H$7,2)

Uploaded by

api-25888404
729 views3 pages
The document contains a table showing the probability distribution of weekly sales from 0 to 5 units over 50 weeks. It then simulates 120 random numbers between 0 and 1 to estimate demand using a VLOOKUP table to match the random numbers to an expected sales value.

Original Title

null

Copyright

© Attribution Non-Commercial (BY-NC)

Available Formats

PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The document contains a table showing the probability distribution of weekly sales from 0 to 5 units over 50 weeks. It then simulates 120 random numbers between 0 and 1 to estimate demand using a VLOOKUP table to match the random numbers to an expected sales value.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
729 views3 pages

Vlookup (B13,$G$2:$H$7,2)

Uploaded by

api-25888404
The document contains a table showing the probability distribution of weekly sales from 0 to 5 units over 50 weeks. It then simulates 120 random numbers between 0 and 1 to estimate demand using a VLOOKUP table to match the random numbers to an expected sales value.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 3

Number of

Sales/Week # Weeks Probability % Cumu % Ranges VLOOKUP TABLE


0 2 0.04 0.04 0.00 - 0.039 0.00 0
1 5 0.10 0.14 0.04 - 0.139 0.04 1
2 12 0.24 0.38 0.14 - 0.379 0.14 2
3 16 0.32 0.70 0.38 - 0.699 0.38 3
4 8 0.16 0.86 0.70 - 0.859 0.70 4
5 7 0.14 1.00 0.86 - 1.000 0.86 5

50 1.00

Simulated
Simulations Random # Demand
1 0.872 5.00 =VLOOKUP(B13,$G$2:$H$7,2)
2 0.537 3.00
3 0.089 1.00
4 0.402 3.00
5 0.108 1.00
6 0.799 4.00
7 0.257 2.00
8 0.614 3.00
9 0.695 3.00
10 0.050 1.00
11 0.919 5.00
12 0.392 3.00
13 0.298 2.00
14 0.790 4.00
15 0.884 5.00
16 0.147 2.00
17 0.336 2.00
18 0.941 5.00
19 0.204 2.00
20 0.265 2.00
21 0.966 5.00
22 0.062 1.00
23 0.201 2.00
24 0.158 2.00
25 0.507 3.00
26 0.105 1.00
27 0.545 3.00
28 0.581 3.00
29 0.707 4.00
30 0.174 2.00
31 0.402 3.00
32 0.377 2.00
33 0.033 0.00
34 0.129 1.00
35 0.218 2.00
36 0.819 4.00
37 0.381 3.00
38 0.502 3.00
39 0.133 1.00
40 0.822 4.00
41 0.922 5.00
42 0.559 3.00
43 0.116 1.00
44 0.403 3.00
45 0.701 4.00
46 0.315 2.00
47 0.510 3.00
48 0.618 3.00
49 0.431 3.00
50 0.186 2.00
51 0.932 5.00
52 0.904 5.00
53 0.838 4.00
54 0.120 1.00
55 0.359 2.00
56 0.603 3.00
57 0.214 2.00
58 0.218 2.00
59 0.647 3.00
60 0.460 3.00
61 0.791 4.00
62 0.358 2.00
63 0.206 2.00
64 0.185 2.00
65 0.764 4.00
66 0.188 2.00
67 0.704 4.00
68 0.336 2.00
69 0.866 5.00
70 0.068 1.00
71 0.003 0.00
72 0.614 3.00
73 0.283 2.00
74 0.550 3.00
75 0.703 4.00
76 0.366 2.00
77 0.412 3.00
78 0.103 1.00
79 0.230 2.00
80 0.106 1.00
81 0.541 3.00
82 0.717 4.00
83 0.946 5.00
84 0.370 2.00
85 0.245 2.00
86 0.919 5.00
87 0.822 4.00
88 0.254 2.00
89 0.262 2.00
90 0.751 4.00
91 0.891 5.00
92 0.572 3.00
93 0.830 4.00
94 0.328 2.00
95 0.738 4.00
96 0.705 4.00
97 0.393 3.00
98 0.905 5.00
99 0.908 5.00
100 0.038 0.00
101 0.802 4.00
102 0.994 5.00
103 0.499 3.00
104 0.383 3.00
105 0.348 2.00
106 0.574 3.00
107 0.397 3.00
108 0.374 2.00
109 0.882 5.00
110 0.607 3.00
111 0.227 2.00
112 0.910 5.00
113 0.541 3.00
114 0.378 2.00
115 0.646 3.00
116 0.255 2.00
117 0.628 3.00
118 0.548 3.00
119 0.853 4.00
120 0.012 0.00

You might also like