Trying to run a sensitivity with 4 variables each with a range of values
its is simple product of x*y*z*d = revenue but I would like to have a range with each variable
hours of operation = x (8 - 18 hrs)(every 2)
People per year = y (50,000 - 500,000)(every 50,000)
ticket price per hour = z (50 - 300)(every 50)
operating day per year = d (180 - 360)(every 30)
Is there an easy way to generate this matrix and then graph it?
Thanks
KJK
Bookmarks