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 revisiting 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 costminimization problem, which youve seen in lecture. Since we now are dealing with 2dimensional decision variables (i.e. variables that have a source and destination associated with them), we will have to do some 2dimensional 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
 Staff

Click to edit the document details