| Problem 2-22 |
| | Carolina | Other | | | Solver will place results in yellow shaded cells (decision variables) |
| Number of pounds | | | | | <--------------------I | | Formula for objective function in green shaded cell |
| Cost | $1.80 | $0.60 | $0.00 | | | <------- | SUMPRODUCT(B5:C5,$B$4:$C$4) |
| Constraints: | | | | | | | Formula for constraint in blue shaded cell |
| Pounds per bag | 1 | 1 | 0.00 | = | 60.00 | <------- | SUMPRODUCT(B7:C7,$B$4:$C$4) |
| Aroma rating | 2 | 1.2 | 0.00 | >= | 0.00 | <------- | SUMPRODUCT(B8:C8,$B$4:$C$4) |
| Min Carolina, pounds | 1 | | 0.00 | >= | 0.00 | <------- | SUMPRODUCT(B9:C9,$B$4:$C$4) |
| | | | LHS | Sign | RHS |
| Note: |
| Once all values are entered in the appropriate shaded areas, go to the DATA tab on the Excel sheet ribbon, click on the Data Analysis Group, and then choose Solver. Click SOLVE to run Excel's Solver add-in to obtain the optimized solution. Note that if Solver is not on the DATA tab, refer to the Help file (Solver) for instructions or pages 569–571 of Balakrishnan (2013) Managerial Decision Modeling With Spreadsheets. For more information on entering information in Solver, refer to pages 44–49 of Balakrishnan (2013). To learn more about how to set up and solve linear programming (LP) problems, refer to pages 40–51 of Balakrishnan (2013).
For the changing variable cells (yellow shaded), the initial entries in the cells can be blank or any value of your choice based on the given constraints.
|