Purchase Solution

Use excel solver to solve the network transportation

Not what you're looking for?

Ask Custom Question

Minfly Golf Company manufactures golf balls at Philadelphia, Chicago, and Denver. Cases of golf balls are shipped to warehouses in Orlando, Dallas, and Los Angeles. The following table provides the weekly capacities of the factories and the minimum weekly requirements of the warehouses along with the cost per case to ship between them. Which shipping plan will minimize total costs?

Factories Orlando Dallas Los Angeles Capacities
Philadelphia 6 9 16 2500
Chicago 7 5 10 1500
Denver 13 8 5 2000
Requirements 3000 1200 1800

After the #1 player on the tour started using Minfly balls, demand from the three warehouses has increased by 1,000 cases per week. To meet this increased demand, an additional factory needs to be built with a capacity of 3,000 cases per week. The two potential locations being considered are Memphis and San Francisco. The cost per case to ship between these locations and the warehouses are as follows:

Factories Orlando Dallas Los Angeles Capacities
Memphis 6 4 12 3000
San Francisco 13 8 5 3000
Requirements 4000 2200 2800

Where should the new factory be located?

Purchase this Solution

Solution Summary

The solution provides detailed explanation how to solve the network transportation problem.

Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.