Produce a cumulative probabilities report and graph

Assignment Help Business Management

Reference no: EM13942827

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:

a) Selling price: uniformly distributed between $70 and $40.

b) Unit costs: normally distributed, mean of $32.00, standard deviation of $5.00.

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,000,000.

Your task:

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

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

Reference no: EM13942827

Questions Cloud

Links between corporate culture and ethics : Links between corporate culture and ethics can take two directions. On the one hand, corporate culture can be viewed as a fundamental ingredient in institutionalizing ethics in organizations. On the other hand, culture can be considered the backbone ..

Creating a technology risk mitigation and data protection : This response will discuss mitigation strategies to enable business continuity in the event of a power outage in a small office.

Estimate the average heat transfer coefficient : Estimate the average heat transfer coefficient for the exhaust gas flowing inside the tube - estimate the heat transfer coefficient for the air flowing across the outside of the tube.

Publishes hard copy dictionaries : You work for Don's Dictionaries, a traditional business that publishes hard copy dictionaries in several common languages, including English, Spanish, French, Japanese, and Italian. In the innovative economy, Don's Dictionaries is struggling to stay ..

Produce a cumulative probabilities report and graph : 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?

Breadth of heath care information on the internet : The wide-reaching span of today's global society is increasingly being seen in the breadth of heath care information on the Internet. Today's patients are more informed than ever and can easily find information on anything from diseases to treatme..

How could iger and his top management : What challenges do you think Disney might face in doing business in Russia? How could Iger and his top management team use planning to best prepare for those challenges?

Describe the concept of a signal, and indicate configuration : When a child process is fork()ed, a parent may wait for the successful completion of the child via the wait() service (or one of its variants) so that the return result of that application can be read from the process descriptor block.

Privacy-confidentiality and security issues : Loss of data, theft, and penetration of system safeguards are the main ways in which large scale electronic data can be compromised. With the increasing use of digital and electronic information technologies in health care, it is more important th..

User Account

All Pages