The demand for a given product next year will be 150,000 units with a 70% probability.

However, there is a 30% chance that demand could drop to 100,000 units because of the uncertainty associated with one big customer. Simulate 500 trials where the demand is sampled from this probability distribution. In this, and all the following problems, you shall use the “Data Table” tool in Excel to efficiently collect the simulated results.