Skip to main content Accessibility help
×
Hostname: page-component-68945f75b7-9klrw Total loading time: 0 Render date: 2024-08-05T18:34:21.906Z Has data issue: false hasContentIssue false

9 - Scenario Generation and Optimization

from SECTION 3 - LEVERAGING DYNAMIC ANALYSIS

Published online by Cambridge University Press:  06 July 2010

Elliot Bendoly
Affiliation:
Emory University, Atlanta
Get access

Summary

A natural extension of a discussion of simulation, given our existing understanding of optimization, is how the two methods can be used together. The basic question behind simulation optimization is:

What decision (if any) tends to provide relatively superior results regardless of the uncertainty associated with the real world problems they are designed to resolve?

Simulation provides the means by which to incorporate uncertainty into the evaluation of a specific decision, or a predetermined handful of such decisions; however, this question implies much greater scope. It suggests a formal search for the best decision across a very wide range of possible alternative decisions. For simulated variants, the term best takes into account not just the average/expected value of parameters describing the setting (as would be common in discrete optimization), but also the potentially extreme performance of outliers, be that good or bad. For system simulations, the best would necessarily need to further relate to performance as the result of a sequence of events where the interplay of initial guiding decisions, complicated by uncertainty, might be extremely difficult to assess without sufficient simulation runs. The follow-up question then is:

How can we integrate the techniques associated with simulation and optimization in a single solid mechanism for meaningful decision support?

Here again we gain from the robustness of Excel and the availability of additional applications that capitalize on Excel's computational strengths.

Type
Chapter
Information
Excel Basics to Blackbelt
An Accelerated Guide to Decision Support Designs
, pp. 209 - 228
Publisher: Cambridge University Press
Print publication year: 2008

Access options

Get access to the full version of this content by using one of the access options below. (Log in options will check for institutional or personal access. Content may require purchase if you do not have access.)

Save book to Kindle

To save this book to your Kindle, first ensure coreplatform@cambridge.org is added to your Approved Personal Document E-mail List under your Personal Document Settings on the Manage Your Content and Devices page of your Amazon account. Then enter the ‘name’ part of your Kindle email address below. Find out more about saving to your Kindle.

Note you can select to save to either the @free.kindle.com or @kindle.com variations. ‘@free.kindle.com’ emails are free but can only be saved to your device when it is connected to wi-fi. ‘@kindle.com’ emails can be delivered even when you are not connected to wi-fi, but note that service fees apply.

Find out more about the Kindle Personal Document Service.

Available formats
×

Save book to Dropbox

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Dropbox.

Available formats
×

Save book to Google Drive

To save content items to your account, please confirm that you agree to abide by our usage policies. If this is the first time you use this feature, you will be asked to authorise Cambridge Core to connect with your account. Find out more about saving content to Google Drive.

Available formats
×