excel mac 水晶球_水晶球软件使用crystalball.pptx

水晶球软件使用crystalball

Project ManagementSession 9Crystal BallOPIM 5270Session 9 GoalsUnderstand why risk must be analyzedKnow pros / cons for three ways to analyze riskIdentify random variables in modelsKnow the four steps of a simulation processGenerate random numbers with Crystal BallUse the four steps of a simulation processExplain how Crystal Ball supports Proj. Mgmt.Dealing with RandomnessMost real-world business situations today are probabilistic, but the decision models used to deal with them are deterministic.How to deal with randomness?Ignore itSimplify problem to make it analytically tractable, get solution, then ignore real-life complicationsFind a way to obtain an approximate solution to real-world problemsMonte Carlo SimulationMonte Carlo simulation is a method by which approximate solutions are obtained to realistic (and therefore complicated) problemsThis is in contrast to analytical methods, which obtain exact solutions to highly stylized problemsTradeoff between rigor and relevanceIntroduction to SimulationWhat is this? Y = f(X1, X2, …, Xk)Often, the values for one or more "input" cells are unknown or uncertain This creates uncertainty about the value of the "output" cellSimulation can be used to analyze these types of modelsRandom Variables & RiskA random variable is any variable whose value cannot be predicted or set with certainty.Many “input cells” in spreadsheet models are actually random variables. For example:the future cost of raw materialsfuture interest ratesfuture number of employees in a firmexpected product demandDecisions made using uncertain information often involve risk. What risks?Why Analyze Risk?Using expected values for uncertain cells tells us nothing about the variability of the performance measure.Suppose an $1,000 investment is expected to return $2,000 in two years. Would you invest if...the outcomes could range from $1,060 to $4,000?the outcomes could range from $0 to $2,100?Alternatives with the same expected value may involve very differe