TL;DR: Want to recalculate a model based on random variables and take the result and put it in a table. What's best way to do that?
Longer Explanation: I have a model that is built upon multiple random variables. I am trying to understand the distribution of potential outcomes by recalculating that spreadsheet multiple times to see what the resulting value / outcome is. In the below picture you can see a super simple example. The Est Budget column is RANDBTWN(Min Budget, Max Budget). So, now how can we fill that table with all the simulations / outcome for the demand for that $5 widget
So far I have attempted to do this with data tables but I don't necessarily want to change certain inputs, just want to simulate with the existing assumptions. Really appreciate the help - thanks everyone.