Question:

PROBLEM DESCRIPTION:

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.

1. Generate a solution to this problem using the Greedy Heuristic solution approach, and describe the solution in words. Detail each step of the solution approach! Provide your response within an inserted text box.
2. What are the objective function, decision variables, and constraints for this optimization problem? Provide your response within an inserted text box.
3. Develop an Excel spreadsheet and use Excel Solver to find an optimal solution for this problem. Provide a screenshot (or Snipping Tool capture) of the Solver Dialog Box.
4. Describe the optimal solution in words. Provide your response within an inserted text box.

Price: $2.99

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