风险管理软件CrystalBall使用指导中英文
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
查看结果
在模拟最后或者运行的过程中，预测窗口会自动显示模拟的结果。可以获得不同的结果（频率图，累计图，统计图，百分比图，模拟分析图和趋势图），结果可以复制到工作表中。
Crystal Ball Toolbar:（水晶球的工具栏）
DefineDefineRunStartResetForecastTrend
3．预测结果的确定—例如，数据输出或者性能的测定
确定哪些单元格的数据是你想预测的（典型的性能指标，例如，利润）
4. Choose Number of Trials
Select the number of trials. If you would later like to generate the Sensitivity Analysis chart, choose “Sensitivity Analysis” under Options in Run Preferences.
通过建立数据表可以对输入数据（随机的，非随机）进行评估。随机数据的输入，输入任意数即可。
2. Define Assumptions—i.e., random variables
Define which cells are random, and what distribution they should follow.
Recall the Walton Bookstore example: It is August, and they must decide how many of next year’s nature calendars to order. Each calendar costs the bookstore $7.50 and is sold for $10. After February, all unsold calendars are returned to the publisher for a refund of $2.50 per calendar. Suppose Walton predicts demand will be somewhere between 100 and 300 (discrete uniform).
Monte-Carlo Simulation with Crystal Ball®
用水晶球软件进行蒙特卡洛模拟
To run a simulation using Crystal Ball®:
1.Setup SpБайду номын сангаасeadsheet
1．设定数据表
Build a spreadsheet that will calculate the performance measure (e.g., profit) in terms of the inputs (random or not). For random inputs, just enter any number.
运行模拟
运行模拟。如果要改变参数重新进行模拟，需要首先重置模拟（点击运行菜单工具栏或者运行菜单下的“重置模拟”按钮）。
6. View Results
The forecast window showing the results of the simulation appears automatically after (or during) the simulation. Many different results are available (frequency chart, cumulative chart, statistics, percentiles, sensitivity analysis, and trend chart). The results can be copied into the worksheet.
回想Walton书店的例子。在八月份，书店需要确定订购的明年的日历的数量。单个日历的进价是7.5美元，售价是10美元。二月份之后，所有未售的日历将会以2.5美元的价格退还给出版商。假设Walton 日历的销售量在100~300之间（离散型均匀分布）
Demand= d ~ Uniform[100, 300]
AssumptionsForecastPreferencesSimulationSimulationWindowChart
（确定假设）确定预测结果 优先运行 开始模拟 模拟重置 预测窗口 趋势图
Walton Bookstore Simulation with Crystal Ball®
水晶球在Walton书店模拟中的应用
4. 选择试验的次数
选择试验的次数。如果 要生成敏感度分析图表，选择优先运行下的“敏感度分析”
5. Run Simulation
Run the simulation. If you would like to change parameters and re-run the simulation, you should “reset” the simulation (click on the “Reset Simulation” button on the toolbar or in the Run menu) first.
Order Quantity= Q (decision variable)
Revenue= $10 * Min(Q,d)
Cost= $7.50 *Q
Refund= $2.50 * Max(Q–d, 0)
Profit= Revenue – Cost + Refund
需求量=d ~ Uniform[100, 300]
2．定义假设的前提—例如，随机变量
确定那些单元格的数据时随机的，这些数据应该服从什么样的分布
3. Define Forecast—i.e., output or performance measure
Define which cell(s) you are interested in forecasting (typically the performance measure, e.g., profit).
在模拟最后或者运行的过程中，预测窗口会自动显示模拟的结果。可以获得不同的结果（频率图，累计图，统计图，百分比图，模拟分析图和趋势图），结果可以复制到工作表中。
Crystal Ball Toolbar:（水晶球的工具栏）
DefineDefineRunStartResetForecastTrend
3．预测结果的确定—例如，数据输出或者性能的测定
确定哪些单元格的数据是你想预测的（典型的性能指标，例如，利润）
4. Choose Number of Trials
Select the number of trials. If you would later like to generate the Sensitivity Analysis chart, choose “Sensitivity Analysis” under Options in Run Preferences.
通过建立数据表可以对输入数据（随机的，非随机）进行评估。随机数据的输入，输入任意数即可。
2. Define Assumptions—i.e., random variables
Define which cells are random, and what distribution they should follow.
Recall the Walton Bookstore example: It is August, and they must decide how many of next year’s nature calendars to order. Each calendar costs the bookstore $7.50 and is sold for $10. After February, all unsold calendars are returned to the publisher for a refund of $2.50 per calendar. Suppose Walton predicts demand will be somewhere between 100 and 300 (discrete uniform).
Monte-Carlo Simulation with Crystal Ball®
用水晶球软件进行蒙特卡洛模拟
To run a simulation using Crystal Ball®:
1.Setup SpБайду номын сангаасeadsheet
1．设定数据表
Build a spreadsheet that will calculate the performance measure (e.g., profit) in terms of the inputs (random or not). For random inputs, just enter any number.
运行模拟
运行模拟。如果要改变参数重新进行模拟，需要首先重置模拟（点击运行菜单工具栏或者运行菜单下的“重置模拟”按钮）。
6. View Results
The forecast window showing the results of the simulation appears automatically after (or during) the simulation. Many different results are available (frequency chart, cumulative chart, statistics, percentiles, sensitivity analysis, and trend chart). The results can be copied into the worksheet.
回想Walton书店的例子。在八月份，书店需要确定订购的明年的日历的数量。单个日历的进价是7.5美元，售价是10美元。二月份之后，所有未售的日历将会以2.5美元的价格退还给出版商。假设Walton 日历的销售量在100~300之间（离散型均匀分布）
Demand= d ~ Uniform[100, 300]
AssumptionsForecastPreferencesSimulationSimulationWindowChart
（确定假设）确定预测结果 优先运行 开始模拟 模拟重置 预测窗口 趋势图
Walton Bookstore Simulation with Crystal Ball®
水晶球在Walton书店模拟中的应用
4. 选择试验的次数
选择试验的次数。如果 要生成敏感度分析图表，选择优先运行下的“敏感度分析”
5. Run Simulation
Run the simulation. If you would like to change parameters and re-run the simulation, you should “reset” the simulation (click on the “Reset Simulation” button on the toolbar or in the Run menu) first.
Order Quantity= Q (decision variable)
Revenue= $10 * Min(Q,d)
Cost= $7.50 *Q
Refund= $2.50 * Max(Q–d, 0)
Profit= Revenue – Cost + Refund
需求量=d ~ Uniform[100, 300]
2．定义假设的前提—例如，随机变量
确定那些单元格的数据时随机的，这些数据应该服从什么样的分布
3. Define Forecast—i.e., output or performance measure
Define which cell(s) you are interested in forecasting (typically the performance measure, e.g., profit).