Hi, this is the one with Crystall ball if you can manage it here it is a link to free trial of it http://www.oracle.com/us/products/applications/crystalball/overview/index.html
I do not know why the second one is given as a pdf but it supposed to be in excel and the add ins. let me know if you can help
QM72 for Vickline only
M7A2 Part 2 Charlie Company sells virtual reality headsets and is expecting rapid growth. To convince angel s to invest $1,0 00,000 , they need to show consistent profits and growth for the next five years. They used the Delphi Method to build their forecasts, but there are risks and uncertainties they need to understand. The following table gives their year one data : Demand , units 50,000 Market Share 20% Sale Price per unit $179.99 Marketing Costs $700,000 Research & Development Costs $500,000 Variable costs per unit sold $70.00 Overhead $2 50,000 De mand for the product is forecast to increase each year following a tringle distribution with a best case of 20 % per year, worst cast of 5%, and most likely of 15 %, i.e. 5/15/20%. Market share is expected to grow uniformly between 5 % and 12 % per year. The group opinion is that the price Charlie c an charge can only increase slowly due to competition . The annual increase is normally distributed with a mean of $10.00 and a standard dist ribution of $2.5 0 ($10.00, $2.50) R&D co sts will decrease following a uniform distribution of 10 to 12% per year. Variable unit costs will increase following a triangular distribution of 5/7/9%. Overhead costs will increase following a normal distribution (10%,3 %). Marketing costs will increase each year at a rate that is normally distributed (10%, 5%) . Build a Crystal Ball model and run 3,000 s imulation trials, find the five -year cumulative profit and explain the percentile report. Generate and explain a trend chart showing net profit by year. What is the probability they will break even in year 2? What it the probability the cumulative five -year profit w ill exceed $2,000,000? Include graphs for each year ’s profits and the trend chart.