Solver Referance Guide (Page 1)

Solver Referance Guide (Page 1) - Microsoft Excel’s...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Microsoft Excel’s Solver Reference Guide Written for the Cal Paly Industrial and Manufacturing Enqlnnring Department by Rob Connolly. October 2004 Microsofi Excel has an Add-in called “Solver" that can be used to solve linear programming (LP) problems. This reference demonstrates how to install and use the Solver for LP problems. Installation of the Solver The Solver Add-In is not included with default installations of Microsoft Excel. To check to see if Solver is installed, in the Tools menu, check to see if you see Solver in the menu. [fit is listed in your menu, the Solver has already been installed, and you may proceed to Solving LP Problems using Microsoft Excel’s Solver. See Figure l I Step "if Diasczjiption ' ; 1'. . . If the Solver is not in your Tools menu, select Add-Ins .. _ from the Tools Menu. See a .MMflm Select Solver Add-In, and click OK. ”the Solver will mm 31% then lac-installed and you can proceed to solve your LP .Rfim problem. See (b) Arm-um. wmnmmmnm madam»: Figure 1 Solving LP Problems using Microsoft Exeel’s Solver This Solver reference guide will use the Maximization problem below: Objective Function: Maximize Z = 50x1 + 80):; Subject to the Constraints: X] + X2 S 1000 x; 2 250 x; 2 250 x. - 2x2 2: 0 in, x: 2 0 I. First type in the Objective Function as in Figure 2. Row 6 Type in your variables x1, x2, (these will not be used in an calculation and are for our reference on] ) ' T J‘ue our Ob'ective Function coefficients - . Row 8, Cells Type in zeros underneath each variable. The Solver will Wows Ev." "on i . -; ' ' ' C8 & D8 change the values of these zeros to the values that will ' ' " " ivc ou an otimal solution to our LP formulation. Leave one blank cell to the riht of our variables Type in an “=” Sign for reference (this will serve fl . ur nose for Excel; it is there for our reference on] .) Using the “Borders“ tool 3 put a box around your “Target Cell"; in this case it is cell GS. Later, this will be where we tell Solver to calculate the optimal solution (Mafoin Z) for your problem _I ...
View Full Document

{[ 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