The actual problem size has been reduced to fit within the constraints of solver. Please use the provided spreadsheet to get the HW data.
The capacities of the locations are given below:
Stockton, CA – 25,000
Rockwall, TX – 15,000
Joliet, IL – 60,000
Atlanta, GA – 30,000
York, PA – 20,000
Establish the base case and answer the following questions:
The total distance traveled (in truck miles) in the big fig’s current network (2017 base case) is the sum of RAW miles and FGI miles.
For problem parts b and c, optimize the 2017 network (keep the bottling network fixed but optimize the assignment of customer locations to bottling plants) and answer the following questions:
The optimized total distance traveled (truck miles) in the optimized plant is the sum of RAW miles and FGI miles.
How much is the volume produced (cases) at each of the following plant locations in the optimized plan?
If there is no capacity constraint (i.e. existing capacities are removed on the current plants), how much is the volume produced at following plants? (Hint: You could add a very high capacity to each plant in the model to make is unconstrainted. For example, 150,000).
For problem parts e, f, and g, optimize the network for 2019 data. The capacity for the Stockton, Joliet, Atlanta and York plants remains unchanged. i.e. Stockton is 25,000, Joliet is 60,000, Atlanta is 30,000 and York is 20,000, but increase the capacity of Rockwall to 25,000 cases/week. Furthermore, add a candidate plant in Nashville, TN with a capacity of 25,000 cases/week.
The total distance traveled (truck miles) in the optimal plan is the sum of RAW miles and FGI miles.
How much is the volume produced at each of the following plant locations in the optimal 2019 plan?