This is the case study, which should be calculated in excel. The answer should be in Excel table format, thanks!

Sunkiss, founded in 1947 in Florida, US, is a leading producer of bottled orange juice. Sunkiss developed a patent process in 1954 that could rapidly raise the temperature of juice for a short time to preserve its fresh taste. For the first time, consumers could have the fresh taste of pure not-from-concentrate juice in a ready to serve chilled package. Its major customers are supermarket chains and grocery stores.

Question: Sunkiss is planning to restructure its logistics network for distributing its orange juice to over 100,000 customer locations. Suggest an approach that Sunkiss can use to simplify the model to be built for optimizing the logistics network. Discuss the pros and cons of the approach.