![]() ![]() If the allowable increase (or decrease) is less than unity, the shadow-price rate applies only up to that fractional change. Shadow Price is the rate of change in the value of the objective function per unit increment in the RHS of that constraint. "1E+30" reflects sloppy report documentation. Thus, from the point of view of the spreadsheet model, Solver is a very useful black box that eliminates the need for what-if guesswork altogether. ![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |