Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to purchase grapes. The grapes are processed into juice at the farms and stored in refrigerated vats. Then the juice is shipped to two plants, where it is processed into bottled grape juice and frozen concentrate. The juice and concentrate are then transported to three food warehouses/distribution centers. The transportation costs per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and demand at the distribution centers are summarized in the following tables: Plant 4. Indiana 5. Georgia Supply (1,000 tons) $16 21 72 16 105 25 83 Farm 1. Ohio 2. Pennsylvania 18 3. New York 22 Distribution Center Plant 6. Virginia 7. Kentucky 8. Louisiana 4. Indiana $23 $15 $29 5. Georgia 20 17 24 Demand (1,000 tons) 90 80 120 a. Determine the optimal shipments from farms to plants to distribution centers to minimize total transportation costs. b. What would be the effect on the solution if the capacity at each plant were 140,000 tons?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Question:
Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to purchase grapes.
The grapes are processed into juice at the farms and stored in refrigerated vats. Then the juice is shipped
to two plants, where it is processed into bottled grape juice and frozen concentrate. The juice and
concentrate are then transported to three food warehouses/distribution centers. The transportation costs
per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and
demand at the distribution centers are summarized in the following tables:
Plant
Farm
1. Ohio
2. Pennsylvania 18
3. New York 22
4. Indiana 5. Georgia Supply (1,000 tons)
$16
21
72
16
105
25
Plant
83
Distribution Center
6. Virginia 7. Kentucky 8. Louisiana
4. Indiana
$23 $15
$29
5. Georgia
20
17
24
Demand (1,000 tons) 90
80
120
a. Determine the optimal shipments from farms to plants to distribution centers to minimize total
transportation costs.
b. What would be the effect on the solution if the capacity at each plant were 140,000 tons?
Transcribed Image Text:Question: Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to purchase grapes. The grapes are processed into juice at the farms and stored in refrigerated vats. Then the juice is shipped to two plants, where it is processed into bottled grape juice and frozen concentrate. The juice and concentrate are then transported to three food warehouses/distribution centers. The transportation costs per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and demand at the distribution centers are summarized in the following tables: Plant Farm 1. Ohio 2. Pennsylvania 18 3. New York 22 4. Indiana 5. Georgia Supply (1,000 tons) $16 21 72 16 105 25 Plant 83 Distribution Center 6. Virginia 7. Kentucky 8. Louisiana 4. Indiana $23 $15 $29 5. Georgia 20 17 24 Demand (1,000 tons) 90 80 120 a. Determine the optimal shipments from farms to plants to distribution centers to minimize total transportation costs. b. What would be the effect on the solution if the capacity at each plant were 140,000 tons?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 10 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.