Michael BubolzME 1902/10/2008Assignment #9: non-linear OptimizationExercise 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:Philly12000St Louis8000phoenix5000Fig.1Distributers can only use the following quantities of product shown in fig.2 below:Atlanta6000Chicago8000Denver5000Seattle6000Fig.2Finally, it will cost the following amounts to ship product from one location to another shown in fig.3 below.FromPhillySt. LouisPhoenixToAtlanta202560Chicago251250Denver402015Seattle654535Fig.3

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

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.