BU275 Lecture Notes - Lecture 6: Sensitivity Analysis, Spreadsheet, Shadow Price
Document Summary
Simplex method: procedure involving a set of mathematical steps to solve linear programming problems. Only way to solve a linear programming problem in 40s lengthy manual procedure. Mathematical steps programmed in prewritten software packages designed for solution of linear programming problems. Knowledge of simplex method is useful in gaining overall, in-depth understanding of linear programming. Not used often now because of easy and low-cost availability of personal computers and linear programming software. Spreadsheet requires column and row headings for specific model be set up and that constraint and objective function formulas be input in their entirety, as opposed to just model parameters. Advantage: enables problem to be set up in attractive format for reports and presentations, can also be used as a template for other problems. Data tab solver : input objective function cell, cells representing the decision variables, and cells that make up the model constraints. Answer report provides a summary of the solution results.
