Net Present Value

When the above analysis reached the Chief Executive Officer (CEO) of your company, he became very concerned about the assumptions made in the model. His experience has taught him to consider the uncertainty associated with selling price and production costs more thoroughly. He required further analysis to be done by incorporating the following uncertainties to Question 1 model:

He applied different decision criteria and was willing to go ahead with the product proposal if there was at least an 80% chance the net present value would be greater than $1,850,000.

YOUR TASK:

• You are required to use Visual DSS to run a Monte Carlo simulation (a Risk Analysis). Based on your results determine whether the CEO will proceed under these uncertainties.
• Produce a cumulative probabilities report and graph for the question. Based on results and the decision criteria, will the CEO accept or reject the proposed production of the product?

• A word document with the answers to the questions for Part A, Part B and Part C. For the second question, the screenshots can be included in the word document.
• The three Visual DSS files created for Part A (Questions 1, 2 and 3). Please ensure that these files are named clearly as Agt1_PartA_1.dss, Agt1_PartA_2.dss and Agt1_PartA_3.dss respectively. No zip file is allowed for the submission.