AD 616: Enterprise Risk Analytics Assignment 4: Simulation Optimization to maximize profit
AD 616: Enterprise Risk Analytics
Assignment 4
What to submit?
Please submit (i) a word file explaining in detail your answers to each question (you can use screenshots of the R to explain your answers) AND (ii) an R file with a separate tab for each question. For each question, make sure you develop the model and present the simulation results – the R file should be self-explanatory. The assessment of your work will include both the accuracy and the clarity of your word file and the R file.
1. Refer to question 1 of assignment 3 to perform the following tasks:
a. Create a line/ribbon plot depicting the mean profit as well as an 80% and a 95% confidence interval for GWS’ profit if they create between 2000 and 15000 boats, counting by increments of 1000.
b. Create overlapping density plots depicting the distribution of GWS’ profit, assuming they create 2000, 4000, 6000, 8000, 10000, 12000, or 14,000 boats.
c. Use simulation optimization to determine the number of boats GWS should produce to maximize:
i. Their expected profit
ii. The 10th percentile of their profit
iii. The probability that they will earn a profit of at least $50 million
2.
Venture Inc. is sitting on $100 million in
liquidity and considering investing in two different start-ups: Company A and
Company B. After 3 years, Venture plans to sell their stake in both companies
regardless of their success or failure. Let 
represent the amount they invest in Company A
and 
represent the amount they invest in Company B.
Venture believes the total value of their investment after the 3-year
period from A will be lognormally distributed, with a mean of 
and a standard deviation of 
. The value from B will
follow a lognormal distribution with a mean of 
and a standard deviation of 
. They can also purchase a
certificate of deposit, which will guarantee their principal plus 8% of their
purchase price at the end of the three years. The combined profits of all three
investments will be taxed at a rate of 15%, and any loss can be used to offset
their profit. If they realize a loss they will incur no tax penalty. There’s a
chance both will be successful or both will fail, but since they’re competing
with one another, Venture believes their outcomes can be modelled with a
Spearman correlation coefficient of -0.6. Create an MC simulation with 10,000
trials.
a. Use simulation optimization to determine how much should Venture invest in each alternative to maximize their expected profit.
b. While Venture Inc. has some appetite for risk, they’re concerned they’ll face a liquidity crisis at the end of the period, so they want to be 95% certain they’ll be left with at least $60 million at the end of the three years. Given this constraint, how much should Venture invest in each alternative to maximize their expected profit?
