This preview shows pages 1–3. 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: 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 Solution Approach: In order to use Excels 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...
View Full Document
This note was uploaded on 05/02/2008 for the course ME 190 taught by Professor Musto during the Spring '08 term at Milwaukee School of Engineering.
- Spring '08