E15-D15 Begin by putting Eagle Manufacturing Company in cell A1. The rows and columns above correspond to the cells in the Excel spreadsheet. The changing cells The changing cells refers to the choice variable and is now examined. Cell refers to the location of the respective changing variable. Name is assigned by Excel based on row and column labels.
Final value is the value found in the optimal solution.
The objective coefficient states how much one unit of a changing cell contributes to the objective value. Allowable increase and allowable decrease establish limits over which the objective coefficient can vary with out varying the final values of the changing cells. We should produce 20 of Product 1 and 20 of Product 2. A set of mathematical relationships that must be met when optimization is performed. If the final value is positive then the corresponding reduced cost must be 0.