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
Unformatted text preview: ARE 155 Fall 1999 Excel Session #4 Richard Howitt Setting Up Transport Problems in Solver In todays 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 youve 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 conveniences sake) setting up our constraints both vertically and horizontally, as you can see below....
View Full Document
- Spring '08