![]() A "black box" is a modular subsystem with known input/output characteristics but whose internal details remain hidden from view. ![]() Determination of the optimal solution is a higher-level mathematical problem implemented as a black box by the Solver. Linear programming, however, obtains not just any solution but the optimal solution: the absolute best with respect to a given objective. Traditional what-if analysis is a rudimentary method that uses this very same spreadsheet to examine a subset of possible solutions. ![]() The inputs are the quantities to be placed in cells B4 and C4 (to be determined by Solver), the output is given in cell D9, and the computational processes are embodied by the model's formulas. Comment: Seen as a computational system, the spreadsheet expresses a simple Input-Process-Output (IPO) model.
0 Comments
Leave a Reply. |