2. In your role as Napa Valley agriculture manager, you have been tasked with helping the...

Transcribed Image Text:

2. In your role as Napa Valley agriculture manager, you have been tasked with helping the grape farmers organize collective transportation of their finished wine (in casks) to bottling plants. You must do this in a way that limits overall truck emissions by minimizing the distance the casks need to travel. Use the information in the following diagram to set up and solve an optimization problem that both ensures that all the casks are processed into bottles and which minimizes the total cask-miles traveled. Explain your findings. Cask Supply Distance (in miles) Cask Capacity 72 85,000 Sutter Home Winery 67 Sacramento Bottling 40,000 25 82 Sonoma 25,000 59 SF Bottling 100,000 Vineyard 222 22 35,000 Napa Wine Growers 60 60 40 40 48 Santa Rosa Bottling 22,000 2. In your role as Napa Valley agriculture manager, you have been tasked with helping the grape farmers organize collective transportation of their finished wine (in casks) to bottling plants. You must do this in a way that limits overall truck emissions by minimizing the distance the casks need to travel. Use the information in the following diagram to set up and solve an optimization problem that both ensures that all the casks are processed into bottles and which minimizes the total cask-miles traveled. Explain your findings. Cask Supply Distance (in miles) Cask Capacity 72 85,000 Sutter Home Winery 67 Sacramento Bottling 40,000 25 82 Sonoma 25,000 59 SF Bottling 100,000 Vineyard 222 22 35,000 Napa Wine Growers 60 60 40 40 48 Santa Rosa Bottling 22,000