Excel Session 4

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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
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 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

Page1 / 5

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

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online