I'm working on a Monte Carlo Simulation and I need a bit of help. Essentially, I am trying to find out how many units to produce in the next two years when there is an equal 25% probability. The two main problems that I am running into are: there are not always two outcomes, because sometimes one unit being produced too high. Additionally, I cannot get the "Help!" work book to automatically show which units need to be produced each time I run the simulation, which ideally I would like to link up.
Attached is my workbook, along with a brief write up.
Thanks in advanced!
Bookmarks