6. Lab Week 6 Problem Solutions

6. Lab Week 6 Problem Solutions - Lab Week 6 Problem...

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

View Full Document Right Arrow Icon
Lab Week 6 Problem Solutions CHAPTER 5 DISTRIBUTION AND NETWORK FLOW MODELS 1. 1a. Let Xij = the number of units shipped from plant i to warehouse j. Where i = A, B, C j= 1, 2, 3 Objective Function (Minimize): Min. Z = 50X A1 + 32X A2 + 40X A3 + 16X B1 + 30X B2 + 20X B3 + 35X C1 + 28X C2 + 42X C3 Subject to Supply Constraints: Non-negativity Constraints X A1 + X A2 + X A3 = 700 All variables ≥0 X B1 + X B2 + X B3 = 200 X C1 + X C2 + X C3 = 200 Demand Constraints: X A1 + X B1 + X C1 = 300 X A2 + X B2 + X C2 = 400 X A3 + X B3 + X C3 = 400
Background image of page 1

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

View Full DocumentRight Arrow Icon
1b. When using solver, make sure “assume linear model” and “assume non-negativity” are checked under the options menu. Excel formatting:
Background image of page 2
1c. To make sure route 3-A is unacceptable, change the cost to a very high number (e.g., ten times the next highest cost). Note the cost of $500 from plant A to warehouse 3. The solver constraints are the same.
Background image of page 3

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

View Full DocumentRight Arrow Icon
15. 15a.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/04/2011 for the course ADM 2302 taught by Professor El during the Spring '05 term at University of Ottawa.

Page1 / 9

6. Lab Week 6 Problem Solutions - Lab Week 6 Problem...

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

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