资源描述：
《风险管理软件crystalball使用指导》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Iso19011@126.comPage16CrystalBallMonte-CarloSimulationwithCrystalBall®TorunasimulationusingCrystalBall®:1.SetupSpreadsheetBuildaspreadsheetthatwillcalculatetheperformancemeasure(e.g.,profit)intermsoftheinputs(randomornot).Forrandominputs,justenteranynumber.2.DefineAssumptions—
2、i.e.,randomvariablesDefinewhichcellsarerandom,andwhatdistributiontheyshouldfollow.3.DefineForecast—i.e.,outputorperformancemeasureDefinewhichcell(s)youareinterestedinforecasting(typicallytheperformancemeasure,e.g.,profit).4.ChooseNumberofTrialsSelectthenumberoftrials.Ifyouwoul
3、dlaterliketogeneratetheSensitivityAnalysischart,choose“SensitivityAnalysis”underOptionsinRunPreferences.5.RunSimulationRunthesimulation.Ifyouwouldliketochangeparametersandre-runthesimulation,youshould“reset”thesimulation(clickonthe“ResetSimulation”buttononthetoolbarorintheRunm
4、enu)first.6.ViewResultsTheforecastwindowshowingtheresultsofthesimulationappearsautomaticallyafter(orduring)thesimulation.Manydifferentresultsareavailable(frequencychart,cumulativechart,statistics,percentiles,sensitivityanalysis,andtrendchart).Theresultscanbecopiedintotheworksh
5、eet.CrystalBallToolbar:Iso19011@126.comPage16CrystalBallDefineDefineRunStartResetForecastTrendAssumptionsForecastPreferencesSimulationSimulationWindowChartIso19011@126.comPage16CrystalBallWaltonBookstoreSimulationwithCrystalBall®RecalltheWaltonBookstoreexample:ItisAugust,andth
6、eymustdecidehowmanyofnextyear’snaturecalendarstoorder.Eachcalendarcoststhebookstore$7.50andissoldfor$10.AfterFebruary,allunsoldcalendarsarereturnedtothepublisherforarefundof$2.50percalendar.SupposeWaltonpredictsdemandwillbesomewherebetween100and300(discreteuniform).Demand=d~Un
7、iform[100,300]OrderQuantity=Q(decisionvariable)Revenue=$10*Min(Q,d)Cost=$7.50*QRefund=$2.50*Max(Q–d,0)Profit=Revenue–Cost+RefundStep#1(SetupSpreadsheet)Iso19011@126.comPage16CrystalBallWaltonBookstoreSimulationwithCrystalBall®Step#2(DefineAssumptions—i.e.,randomvariables)Selec
8、tthecellthatcontainstherandomvariable(B17)—colorcode(blue):an
