Need help with the Walsh's Company Case:

There is already one solution offered, such as the following one:

The help i need is, as I highted in red, to generate a solution using Excel. There has been excel solution offered to precisely this question. Unfortunately the author did it in a very haphazard way without bothering to read through the whole question. Both the process and the results are incorrect. I'd appreciate if someone can take a serious look into the question and provde some screen shots of the steps in Excel. (Please attach at least one screen shot of the inputs on the Solver interface, when uploading the answer). Much Thanks!!

WALSH's JUICE COMPANY The plants are different ages, have different equipment, and have different wage rates; thus, the cost of processing each product at each plant (S/ton) differs, as follows: alsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice con- centrate, and jelly. It purchases grape juice from three vine- reat 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. Vine- yard output typically differs each month in the harvesting Plant Product Virginia Michigan Tennessee Indiana Juice $2,100 $2,350 Concentrate 4,100 Jell S2,200 $1,900 3,900 2,800 4,300 3,950 2,500 2,600 2300 This month the company needs to process a total of 1,200 season, and the plants have different processing capacities. tons of bottled juice, 900 tons of frozen concentrate, and 700 tons of jelly at the four plants combined. However, the pro- n 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: duction process for frozen concentrate results in some j that evaporates water content. T quires 1.5 tons uice dehydration, and the process for jelly includes a cooking stage o process 1 ton of frozen con centrate requires 2 tons of unprocessed juice: 1 ton of jelly re- of unprocessed juice; and 1 ton of bottled juice requires 1 ton of unprocessed juice. Walsh's management wants to determine how m tons of grape juice to ship from each of the vineyards to ach 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 logistical aspects 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 prod 750uc processing costs. Help Walsh's solve this problem by formulating a linear programming model and solve it by Plant Vineyard New York Pennsylvania 970 Virginia $850 900 Michigan Tennessee Indiana S720 790 830 S50 $910 1,050 780 880 820 Ohio sing the computer WALSH's JUICE COMPANY The plants are different ages, have different equipment, and have different wage rates; thus, the cost of processing each product at each plant (S/ton) differs, as follows: alsh's Juice Company produces three products from unprocessed grape juice-bottled juice, frozen juice con- centrate, and jelly. It purchases grape juice from three vine- reat 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. Vine- yard output typically differs each month in the harvesting Plant Product Virginia Michigan Tennessee Indiana Juice $2,100 $2,350 Concentrate 4,100 Jell S2,200 $1,900 3,900 2,800 4,300 3,950 2,500 2,600 2300 This month the company needs to process a total of 1,200 season, and the plants have different processing capacities. tons of bottled juice, 900 tons of frozen concentrate, and 700 tons of jelly at the four plants combined. However, the pro- n 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: duction process for frozen concentrate results in some j that evaporates water content. T quires 1.5 tons uice dehydration, and the process for jelly includes a cooking stage o process 1 ton of frozen con centrate requires 2 tons of unprocessed juice: 1 ton of jelly re- of unprocessed juice; and 1 ton of bottled juice requires 1 ton of unprocessed juice. Walsh's management wants to determine how m tons of grape juice to ship from each of the vineyards to ach 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 logistical aspects 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 prod 750uc processing costs. Help Walsh's solve this problem by formulating a linear programming model and solve it by Plant Vineyard New York Pennsylvania 970 Virginia $850 900 Michigan Tennessee Indiana S720 790 830 S50 $910 1,050 780 880 820 Ohio sing the computer