1. Simulation. You are projecting sales for the next year by
running simulations of different scenarios. You need to use Excel
to complete this portion of the assignment, though you need not
turn in your spreadsheet.
(a) The quantity demanded for your company’s products next year
can be 100,000, 200,000, or 300,000 with equal probability.
Describe your strategy to simulate such scenarios, and write down
the Excel functions you would use.
(b) The potential price of your company’s product next...