Description
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. Refer to question 1 of assignment 3 to perform the following tasks: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.Create overlapping density plots depicting the distribution of GWS’ profit, assuming they create 2000, 4000, 6000, 8000, 10000, 12000, or 14,000 boats.Use simulation optimization to determine the number of boats GWS should produce to maximize:Their expected profitThe 10th percentile of their profitThe probability that they will earn a profit of at least $50 millionVenture 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.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?
