Assignment 9 ex3 - Michael Bubolz ME 190 2/10/2008...

Info iconThis preview shows pages 1–3. 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: 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.

Page1 / 5

Assignment 9 ex3 - Michael Bubolz ME 190 2/10/2008...

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

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