# KAU Big Fig Case Study Excel

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

### Problem VII.1.

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:

### Problem VII.1.b

The optimized total distance traveled (truck miles) in the optimized plant is the sum of RAW miles and FGI miles.

### Problem VII.1.c

How much is the volume produced (cases) at each of the following plant locations in the optimized plan?

Rockwall, TX

Joliet, IL

Atlanta, GA

York, PA

### Problem VII.1.d

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).

Joliet, IL

York, PA

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.

### Problem VII.1.e

The total distance traveled (truck miles) in the optimal plan is the sum of RAW miles and FGI miles.

### Problem VII.1.f

How much is the volume produced at each of the following plant locations in the optimal 2019 plan?

Joliet, IL

Atlanta, GA

York, PA

Nashvile, TN

### Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount

Posted in Uncategorized