What is the best way to set this up in excel- i do not need


What is the best way to set this up in excel- I do not need someone to do all the work, I would just like to know the setup or any certain equations that might be helpful.

-Application of Risk Analysis Problem: Your group is a decision-making team in your firm and is considering a $10 million expansion project. Estimates of key input factors are as following (all uniformly distributed):

-Market size: 100,000 to 350,000 tons

-Selling price: $375 to $575

-Market growth rate: 0 to 6% per year

-Market share: 3% to 17%

-Total investment required: $7 million to $10.5 million

-Useful life of the new facility: 5 to 15 years

-Residual value of the facility: $3.5 million to $5 million

-Operating costs: $320 to $550 per ton

-Fixed costs: $250,000 to $375,000 per year

Request for Solution File

Ask an Expert for Answer!!
Operation Management: What is the best way to set this up in excel- i do not need
Reference No:- TGS0590530

Expected delivery within 24 Hours