Homework Help is Here – Start Your Trial Now!
Business
Operations Management
IV. Walsh's Juice Company Walsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice concentrate, and jelly. Iit purchases grape juice from three vineyards near the Great Lakes. The grapes are harvested at the vineyards and immediately converted into juice at plants at the vineyard sites and stored there in refrigerated tanks. The juice is then transported to four different plants in Virginia, Michigan, Tennessee, and Indiana, where it is processed into bottled grape juice, frozen juice concentrate, and jelly. Vineyard output typically differs each month in the harvesting season, and the plants have different processing capacities. In a particular month the vineyard in New York has 1,400 tons of unprocessed grape juice available, whereas the vineyard in Ohio has 1,700 tons and the vineyard in Pennsylvania has 1,100 tons. The processing capacity per month is 1,200 tons of unprocessed juice at the plant in Virginia, 1,100 tons of juice at the plant in Michigan, 1,400 tons at the plant in Tennessee, and 1,400 tons at the plant in Indiana. The cost per ton of transporting unprocessed juice from the vineyards to the plant is as follows:

IV. Walsh's Juice Company Walsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice concentrate, and jelly. Iit purchases grape juice from three vineyards near the Great Lakes. The grapes are harvested at the vineyards and immediately converted into juice at plants at the vineyard sites and stored there in refrigerated tanks. The juice is then transported to four different plants in Virginia, Michigan, Tennessee, and Indiana, where it is processed into bottled grape juice, frozen juice concentrate, and jelly. Vineyard output typically differs each month in the harvesting season, and the plants have different processing capacities. In a particular month the vineyard in New York has 1,400 tons of unprocessed grape juice available, whereas the vineyard in Ohio has 1,700 tons and the vineyard in Pennsylvania has 1,100 tons. The processing capacity per month is 1,200 tons of unprocessed juice at the plant in Virginia, 1,100 tons of juice at the plant in Michigan, 1,400 tons at the plant in Tennessee, and 1,400 tons at the plant in Indiana. The cost per ton of transporting unprocessed juice from the vineyards to the plant is as follows:

Practical Management Science
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...
See similar textbooks
icon
Related questions
Question

Can someone solve this problem by formulating a linear programming model and solve it by using the computer.

IV. Walsh's Juice Company Walsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice concentrate, and jelly. It purchases grape juice from three vineyards near the Great Lakes. The grapes are harvested at the vineyards and immediately sonverted into juice at plants at the vineyard sites and stored there in refrigerated tanks. The juice is then transported to four different plants in Virginia, Michigan, Tennessee, and Indiana, where it is processed into bottled grape juice, frozen juice concentrate, and jelly. Vineyard output typically differs each month in the harvesting season, and the plants have different processing capacities. In a particular month the vineyard in New York has 1,400 tons of unprocessed grape juice available, whereas the vineyard in Qhio has 1,700 tons and the vineyard in Pennsylvania has 1,100 tons. The processing capacity per month is 1,200 tons of unprocessed juice at the plant in Virginia, 1,100 tons of juice at the plant in Michigan, 1,400 tons at the plant in Tennessee, and 1,400 tons at the plant in Indiana. The cost per ton of transporting unprocessed juice from the vineyards to the plant is as follows: Plant Vineyard Virginia Michigan Tennessee Indiana $850 970 New York $720 $910 $750 Pennsylvania Ohio 790 1,050 880 900 830 780 820 The plants are differentages, have different equipment, and have different wage rates; thus, the cost of processing each product at each plant (S/ton) differs, as follows: Plant Product Virginia Michigan Tennessee Indiana Juice $2,100 $2,350 $2,200 $1,900 Concentrate 4,100 4,300 3,950 3,900 Jelly 2,600 2,300 2,500 2,800 This month the company needs to process a total of 1,200 tons of bottled juice, 900 tons of frozen concentrate, and 700 tons of jelly at the four plants combined. However, the production process for frozen concentrate results in some juice dehydration, and the process for jelly includes a cooking stage that evaporates water content. To process 1 ton of frozen concentrate requires 2 tons of unprocessed juice; 1 ton of jelly requires 15 tons of unprocessed juice; and 1 ton of bottled juice requires 1 ton of unprocessed juice. Walsh's management wants to determine how many tons of grape juice to ship from each of the vineyards to each of the plants and the number of tons of each product to process at each plant. Thus, management needs a model that includes both the logisticalaspects of this problem and the production processing aspects. It wants a solution that will minimize total costs, including the cost of transporting grape juice from the vineyards to the plants and the product processing costs. Help Walsh's solve this problem by formulating a linear programming model and solve it by using the computer.
Transcribed Image Text:IV. Walsh's Juice Company Walsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice concentrate, and jelly. It purchases grape juice from three vineyards near the Great Lakes. The grapes are harvested at the vineyards and immediately sonverted into juice at plants at the vineyard sites and stored there in refrigerated tanks. The juice is then transported to four different plants in Virginia, Michigan, Tennessee, and Indiana, where it is processed into bottled grape juice, frozen juice concentrate, and jelly. Vineyard output typically differs each month in the harvesting season, and the plants have different processing capacities. In a particular month the vineyard in New York has 1,400 tons of unprocessed grape juice available, whereas the vineyard in Qhio has 1,700 tons and the vineyard in Pennsylvania has 1,100 tons. The processing capacity per month is 1,200 tons of unprocessed juice at the plant in Virginia, 1,100 tons of juice at the plant in Michigan, 1,400 tons at the plant in Tennessee, and 1,400 tons at the plant in Indiana. The cost per ton of transporting unprocessed juice from the vineyards to the plant is as follows: Plant Vineyard Virginia Michigan Tennessee Indiana $850 970 New York $720 $910 $750 Pennsylvania Ohio 790 1,050 880 900 830 780 820 The plants are differentages, have different equipment, and have different wage rates; thus, the cost of processing each product at each plant (S/ton) differs, as follows: Plant Product Virginia Michigan Tennessee Indiana Juice $2,100 $2,350 $2,200 $1,900 Concentrate 4,100 4,300 3,950 3,900 Jelly 2,600 2,300 2,500 2,800 This month the company needs to process a total of 1,200 tons of bottled juice, 900 tons of frozen concentrate, and 700 tons of jelly at the four plants combined. However, the production process for frozen concentrate results in some juice dehydration, and the process for jelly includes a cooking stage that evaporates water content. To process 1 ton of frozen concentrate requires 2 tons of unprocessed juice; 1 ton of jelly requires 15 tons of unprocessed juice; and 1 ton of bottled juice requires 1 ton of unprocessed juice. Walsh's management wants to determine how many tons of grape juice to ship from each of the vineyards to each of the plants and the number of tons of each product to process at each plant. Thus, management needs a model that includes both the logisticalaspects of this problem and the production processing aspects. It wants a solution that will minimize total costs, including the cost of transporting grape juice from the vineyards to the plants and the product processing costs. Help Walsh's solve this problem by formulating a linear programming model and solve it by using the computer.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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.
SEE MORE TEXTBOOKS