Management Science Chapter 1 and 2 notes.docx

If the model had not been previously set up with

This preview shows page 33 - 35 out of 44 pages.

back and forth, without losing any Solver data. If the model had not been previously set up with Excel’s Solver, the steps for doing so with Analytic Solver are analogous to the steps used with Excel’s Solver as covered in Section 2.5 . In both cases, we need to specify the location of the objective cell, the changing cells, and the functional constraints, and then click to solve the model. However, the user interface is somewhat different. Analytic Solver uses the buttons on the Analytic Solver ribbon instead of the Solver dialog box. We will now walk you through the steps to set up the Wyndor problem in Analytic Solver. To specify TotalProfit (G12) as the objective cell, select the cell in the spreadsheet and then click on the Objective button on the Analytic Solver ribbon. As shown in Figure 2.14 , this will drop down a menu where you can choose to minimize (Min) or maximize (Max) the objective cell. Within the options of Min or Max are further options (Normal, Expected, Chance). For now, we will always choose the Normal option.
Image of page 33

Subscribe to view the full document.

FIGURE 2.13 The screenshot for the Wyndor problem that shows both the ribbon and the Solver Options and Model Specifications pane that are revealed after choosing the tab called Analytic Solver on the Excel ribbon. FIGURE 2.14 The screenshot for the Wyndor problem that shows the drop-down menu generated by clicking on the Objective button on the Analytic Solver ribbon after choosing TotalProfit (G12) as the objective cell. To specify UnitsProduced (C12:D12) as the changing cells, select these cells in the spreadsheet and then click on the Decisions button on the Analytic Solver ribbon. As shown in Figure 2.15 , this will drop down a menu where you can choose various options (Plot, Normal, Recourse). For linear programming, we will always choose the Normal option. Analytic Solver Tip: Another way to add an objective, changing cells, or constraints using Analytic Solver is to click on the big green plus (+) on the Mode pane and choose Add Objective, Add Variable, or Add Constraint, respectively. Next the functional constraints need to be specified. For the Wyndor problem, the functional constraints are HoursUsed (E7:E9) <= HoursAvailable (G7:G9). To enter these constraints in Analytic Solver, select the cells representing the left-hand side of these constraints (HoursUsed, or E7:E9) and click the Constraints button on the Analytic Solver ribbon. As shown in Figure 2.16 , this drops down a menu for various kinds of constraints. For linear programming functional constraints, choose Normal Constraint and then the type of constraint desired (either <=, =, or >=). For the Wyndor problem, choosing <= would then bring up the Add Constraint dialog box shown in Figure 2.17 . This is much like the Add Constraint dialog box for Excel’s Solver (see Figure 2.9 ). HoursUsed and <= already
Image of page 34
are filled in when the Add Constraint dialog box is brought up (because the HoursUsed cells were selected and <= was chosen under the Constraints button menu). The Add Constraint dialog box then can be used to fill in the remaining right-hand side of the constraint—HoursAvailable (G7:G9)—by clicking in the box labeled Constraint and choosing these cells on the spreadsheet. Figure 2.17
Image of page 35
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern