{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Assignment 9 ex3

# Assignment 9 ex3 - Michael Bubolz ME 190 Assignment#9...

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

Michael Bubolz ME 190 2/10/2008 Assignment #9: non-linear Optimization Exercise 2: Problem: We were to formulate a shipping strategy for a television company in order to get the product to the distributers from the manufacturing plants with the lowest cost in shipping total. The Manufacturing plants can only produce the following quantities of product shown in fig.1 below: Philly 12000 St Louis 8000 phoenix 5000 Fig.1 Distributers can only use the following quantities of product shown in fig.2 below: Atlanta 6000 Chicago 8000 Denver 5000 Seattle 6000 Fig.2 Finally, it will cost the following amounts to ship product from one location to another shown in fig.3 below. From Philly St. Louis Phoenix To Atlanta 20 25 60 Chicago 25 12 50 Denver 40 20 15 Seattle 65 45 35 Fig.3

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

View Full Document
Solution Approach: In order to use Excel’s Solver feature we need to develop an equation, variables and constraints. The equation for the total cost of shipping relies on the amount of product that is shipped from each location, for each distributor.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

Assignment 9 ex3 - Michael Bubolz ME 190 Assignment#9...

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

View Full Document
Ask a homework question - tutors are online