Lesson 2

# Lesson 2 - Spreadsheet UsingSolver Lesson2 Introduction...

This preview shows pages 1–14. Sign up to view the full content.

Modeling and Solving LP Problems in a  Spreadsheet

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

View Full Document
Using Solver
Rutgers Business School Lesson 2 Introduction Solving LP problems graphically is only possible when there  are two decision variables Few real-world LP have only two decision variables Fortunately, we can now use spreadsheets to solve LP  problems

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

View Full Document
Rutgers Business School Lesson 2 Original Potato Problem Model Maximize: 5S 1 + 6S 2 Subject to: French Fries .2S 1 + .3S 2 <= 1.8 Hash Browns .2S 1 + .1S 2 <= 1.2 Flakes .3S 1 + .3S 2 <= 2.4 S 1 , S 2 >= 0 (Non Negativity Constraint)
As an introduction to Solver we will simply translate  the mathematical model to a spreadsheet

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

View Full Document
The first step is to label our variables, place  the coefficients for the Objective Function  into the appropriate cells

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

View Full Document
Next we will add a row for the values of the  decision variables We arbitrarily place a value of “1” in each respective  cell.  These values will be optimized by the Solver

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

View Full Document
We then create a spreadsheet formula to compute  the total profit that will be generated by the solution We use the =sumproduct(range 1,range 2) function  to compute this.

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

View Full Document
Next we will create a row for each constraint Within the appropriate column, we place the respective  coefficient for each variable

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 54

Lesson 2 - Spreadsheet UsingSolver Lesson2 Introduction...

This preview shows document pages 1 - 14. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online