{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

IME 301-W10 - Lab 1 Solver Reference Guide

IME 301-W10 - Lab 1 Solver Reference Guide - Microsoft...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel’s Solver Reference Guide Written for the Cal Poly Industrial and Manufacturing Engineering Department by Rob Connelly, October 2004 Microsoft 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. If it 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 1 (a) (b) Step Description 1 If the Solver is not in your Tools menu, select Add-Ins from the Tools Menu. See (a) 2 Select Solver Add-In , and click OK . The Solver will then be installed and you can proceed to solve your LP problem. See (b) Figure 1 Solving LP Problems using Microsoft Excel’s Solver This Solver reference guide will use the Maximization problem below: Objective Function: Maximize Z = 50x 1 + 80x 2 Subject to the Constraints: x 1 + x 2 1000 x 1 250 x 2 250 x 1 - 2x 2 0 x 1 , x 2 0 1. First type in the Objective Function as in Figure 2. Cell Description Row 6 Type in your variables x1, x2, … (these will not be used in any calculation and are for your reference only) Row 7 Type your Objective Function coefficients Row 8, Cells C8 & D8 Type in zeros underneath each variable. The Solver will change the values of these zeros to the values that will give you an optimal solution to your LP formulation. Cell E8 Leave one blank cell to the right of your variables Cell F8 Type in an “=” sign for reference (this will serve no purpose for Excel; it is there for your reference only.) Cell G8 Using the “Borders” tool put a box around your “Target Cell”; in this case it is cell G8. Later, this will be where we tell Solver to calculate the optimal solution (Max/Min Z) for your problem 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

{[ snackBarMessage ]}