You should be able to put your model, including all variables and relationships between them, in two rows; with the first row being the variable names, and the second row being the formulas.


Passengers

Time Per Passenger

Passenger Loading Time

Bus Travel Time

Total Travel Time

=Rand(…)

10

=A2*B2

500

=C2+D2


Then you can fill the second row down through row 1001 and get 1000 random samplings.

Then you can make a chart using the last column to show the distribution.

EDIT: meh... what DCMonkey said.