{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Session 4

# Excel Session 4 - ARE 155 Fall 1999 Excel Session#4 Richard...

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

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.

Unformatted text preview: ARE 155 Fall 1999 Excel Session #4 Richard Howitt Setting Up Transport Problems in Solver In today’s session, we will be re-visiting some familiar themes in using Excel Solver, with a few new twists. In this session you will begin to truly appreciate the flexibility and convenience that the SUMPRODUCT operator affords you in setting up a transport problem. We will also use the SUM operator in setting up our constraints. The mathematical program that we will be setting up is given below: Min (14 x 11 + 9 x 12 + 7 x 13 + 8 x 21 + 10 x 22 + 5 x 23 ) s . t . x 11 + x 12 + x 13 ≤ 30 − − − ( JeffersonCity ) x 21 + x 22 + x 23 ≤ 20 − − − − − ( Omaha ) x 11 + x 21 ≥ 25 − − − ( DesMoines ) x 12 + x 22 ≥ 15 − − − − − − − − − ( KansasCity ) x 13 + x 23 ≥ 10 − − − − − − − − − ( St . Louis ) x 11 , x 12 , x 13 , x 21 , x 22 , x 23 ≥ This is a typical transport cost-minimization problem, which you’ve seen in lecture. Since we now are dealing with 2-dimensional decision variables (i.e. variables that have a source and destination associated with them), we will have to do some 2-dimensional programming in Excel as well. This means that we will be (for convenience’s sake) setting up our constraints both vertically and horizontally, as you can see below....
View Full Document

• Spring '08
• Staff
• U.S. state, Missouri, Missouri River, Des Moines, St. Louis Omaha Des Moines Omaha Kansas City Omaha St. Louis

{[ snackBarMessage ]}

### Page1 / 5

Excel Session 4 - ARE 155 Fall 1999 Excel Session#4 Richard...

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

View Full Document
Ask a homework question - tutors are online