Reference no: EM133828581

Homework: Modifications to R code and reports

This is an R script modification job. I will provide a completed work as a reference, please help me check the correctness of the code process and results. If it is correct, you need to rewrite a report and simply modify the code process (just make the modified R script different from the R script I provided while ensuring the same results).After accepting the invitation, I will post the completed reference work

Task

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.

A. Refer to question 1 of homework 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

B. 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.

C. 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?