ICG, Inc has been struggling to launch a new product for the past 12 months.
Given the info below, what is the uncertainty distribution of the expected revenues of a new product?
The average price for the product can be minimally $10, most likely $12 and maximally $15.
Sales may be between 1,000 and 100,000 products, with most likely sales of 30,000.
Use the regular PERT distributions (see a description of the Pert distribution in @Risk) to determine:
1.Average expected total revenue
2.What is the probability that expected revenue will be less than $123,123
3.What is the probability that expected revenue will be higher than $800,000
OBS: Simulation settings: 5,000 iterations
Sampling Type: = Latin Hypercube
Initial Seed Fixed =123
RGN = Mersenne Twister
Multiple simulations All use same seeds
4. What is the difference between choosing static values or random values for distribution returns when a simulation is not running?
Submit your Excel analysis and bring a hardcopy with you.
The post risk financial modeling appeared first on Savvy Essay Writers.
I absolutely LOVE this essay writing service. This is perhaps the tenth time I am ordering from them, and they have not failed me not once! My research paper was of excellent quality, as always. You can order essays, discussion, article critique, coursework, projects, case study, term papers, research papers, reaction paper, movie review, research proposal, capstone project, speech/presentation, book report/review, annotated bibliography, and more.
STUCK with your assignments? Hire Someone to Write Your papers. 100% plagiarism-free work Guarantee!