Math Solutions

(Solved) A company has three manufacturing plants (in Atlanta, Tulsa, and Springfield) that produce a product that is then shipped to one of four distribution

Question: A company has three manufacturing plants (in Atlanta, Tulsa, and Springfield) that produce a product that is then shipped to one of four distribution centers – A, B, C, or D. The three plants can produce 13, 18, and 12 truckloads of product each week, respectively. Each distribution center needs 10 truckloads of product each week. The shipping costs per truckload between the plants and distribution centers are given in the table. The company needs to determine how much to ship from each plant to each distribution center, and would like to minimize total shipping costs.

Distribution Center
Plant A B C D
Atlanta $ 800 $1300 $400 $ 700
Tulsa $1100 $1400 $600 $1000
Springfield $ 600 $1200 $800 $ 900
  1. What are the objective function, decision variables, and constraints for this optimization problem?
  2. Develop an Excel spreadsheet and use Excel-Solver to find an optimal solution for this problem. (Follow the highlighted instructions given in Problem 1!)
  3. Describe the optimal solution in words.

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in