L2 (R) Solutions of Dilation Equations and

O R A C L E ® C R Y S T A L B A L L D E C I S I O N O P T I M I Z E R ,
F U S I O N E D I T I O N
R E L E A S E 1 1 . 1 . 1 . 3 . 0 0
O P T Q U E S T U S E R ' S G U I D ECrystal Ball Decision Optimizer OptQuest User's Guide, 11.1.1.3.00
Copyright © 1988, 2009, Oracle and/or its affiliates. All rights reserved.
Authors: EPM Information Development Team
The Programs (which include both the software and documentation) contain proprietary information; they are provided
under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and
other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except
to the extent required to obtain interoperability with other independently created software or as specified by law, is
prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the
documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be
expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or
transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the
United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to
U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the
applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication,
disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject
to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional
rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous
applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures
to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any
damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other
names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is
not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with
the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly
between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b)
fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty
obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you
may incur from dealing with any third party.Contents
Chapter 1. Welcome ................................................................. 9
Introduction .......................................................... 9
How This Manual is Organized ............................................ 9
Screen Capture Notes .................................................. 10
Getting Help ......................................................... 10
Additional Resources 11
Chapter 2. Overview ................................................................ 13
Introduction 13
What OptQuest Does 13
How OptQuest Works ................................................. 14
About Optimization Models ............................................. 15
Optimization Objectives ................................................ 16
Forecast Statistics .................................................. 16
Minimizing or Maximizing ........................................... 16
Requirements ..................................................... 17
Decision Variables .................................................... 17
Constraints .......................................................... 18
Model and Solution Feasibility ............................................ 19
Efficient Frontier Analysis ............................................... 19
Efficient Portfolios ................................................. 20
OptQuest and Process Capability .......................................... 21
Chapter 3. Setting Up and Optimizing a Model .............................................. 23
Introduction ......................................................... 23
Overview ........................................................... 23
For Users of OptQuest Versions Earlier Than 11.1.1.x ........................ 24
Developing a Crystal Ball Optimization Model ................................ 24
Developing the Worksheet ............................................ 24
Defining Assumptions, Decision Variables, and Forecasts ..................... 25
Setting Crystal Ball Run Preferences ..................................... 25
Starting OptQuest ..................................................... 26
Contents iiiSelecting the Forecast Objective .......................................... 26
Selecting Decision Variables to Optimize .................................... 27
Specifying Constraints ................................................. 28
Specifying Constraints in Simple Entry Mode .............................. 29
Specifying Constraints in Advanced Entry Mode ............................ 29
Constraints Editor and Related Buttons .................................. 31
Constraint Rules and Syntax .......................................... 32
Constraints and Cell References in Advanced Entry Mode ..................... 33
Constraint Types .................................................. 34
Setting Options ....................................................... 34
Advanced Options ................................................. 35
Running Optimizations 35
OptQuest Control Panel Buttons and Commands ........................... 36
OptQuest Results Window ........................................... 36
Interpreting the Results 40
Viewing a Solution Analysis 40
Running a Longer Simulation of the Results ............................... 42
Printing OptQuest Results ............................................ 42
Viewing Charts in Crystal Ball ......................................... 42
Creating OptQuest Reports 42
Extracting OptQuest Data 44
Saving optimization models and settings .................................... 45
Closing OptQuest ..................................................... 45
Setting Up Efficient Frontier Analysis in OptQuest ............................. 46
Efficient Frontier Variable Bound Example ................................ 46
Transferring Settings from .opt Files ........................................ 46
Learning More About OptQuest .......................................... 48
Chapter 4. OptQuest Tutorials ......................................................... 49
Introduction 49
Tutorial 1 — Futura Apartments Model ..................................... 49
Running OptQuest ................................................. 50
Tutorial 2 — Portfolio Allocation Model .................................... 54
Problem Description ................................................ 55
Using OptQuest ................................................... 55
Chapter 5. Examples Using OptQuest .................................................... 67
Overview ........................................................... 67
Product Mix ......................................................... 69
Product Mix Problem Statement ....................................... 69
iv ContentsProduct Mix Spreadsheet Model ....................................... 70
Product Mix OptQuest Solution 70
Hotel Design and Pricing Problem ......................................... 72
Hotel Design Problem Statement 72
Hotel Design Spreadsheet Model 73
Hotel Design OptQuest Solution 73
Budget-constrained Project Selection ....................................... 75
Project Selection Problem Statement .................................... 75
Project Selection Spreadsheet Model 76
Project Selection OptQuest Solution 77
Groundwater Cleanup .................................................. 79
Groundwater Cleanup Problem Statement ................................ 79
Groundwater Cleanup Spreadsheet Model 79
Groundwater Cleanup OptQuest Solution 81
Oil Field Development ................................................. 83
Oil Field Development Problem Statement 83
Oil Field Development Spreadsheet Model 84
Oil Field Development OptQuest Solution ............