Random numbers -
1470,9283,6264,3555,9743,2506,
7959,5352,6912,4167,7984,8579,
2486,0788,8872,6599,9769,
4629,3246,1781.
As a first step, random numbers 0000-9999 are allocated to various possible sale values in proportion to the probabilities associated with them.
Sales (units) |
Probability |
Cumulative Probability |
Random Number Interval |
27 |
0.10 |
0.10 |
0000-0999 |
28 |
0.15 |
0.25 |
1000-2499 |
29 |
0.20 |
0.45 |
2500-4499 |
30 |
0.35 |
0.80 |
4500-7999 |
31 |
0.15 |
0.95 |
8000-9499 |
32 |
0.05 |
1.00 |
9500-9999 |
Now, we simulate the demand for the next ten days using given random numbers as shown in table.
From the given information, we have,
Profit per unit sold = Rs 50 – Rs 40 = Rs 10
Loss per unit unsold = Rs 15
Penalty for refusing demand = Rs 5 per unit
Using these inputs the profit/loss for the ten days is calculated as given in the table, first when production is 30 units per day and then when it is 29 units.
Simulation Worksheet: Calculation of Profit/Loss
As we can see for the first ten random numbers the total profit for ten days is Rs 2809 when 30 units are produced. And the total profit for ten days is Rs 2830 if 29 units are produced. Therefore it’s advantageous to produced 29 units.
As we can see for second simulation the total profit for ten days is 2790 for 30 units produced and 2750 for 29 units produced therefore if 29 units produced is disadvantageous.