The Wiggly Piggly Grocery Company owns and operates numerous grocery stores throughout the state of Florida. It is developing plans to consolidate warehouse operations so that there will be three different warehouses that supply stores in ten different regions of the state. The company plans to sell all its existing warehouses and build new, state-of-the-art warehouses. Each warehouse can supply multiple regions; however, all stores in a particular region will be assigned to only one warehouse. The locations of the different regions are summarized in the following table.

a. Create a spreadsheet model to determine approximately where Wiggly Piggly should locate its new warehouses and which regions should be assigned to each of the new warehouses. Assume that the company wants to build its warehouses in locations that minimize the distances to each of the regions they serve.
b. What is the optimalsolution?

Transcribed Image Text:

Location Region 1 Panama City 1.0 14.0 2 Tallahassee 6. 15.0 3 Jacksonvl 13.0 15.0 4 Ocala 5 Orlando 6 Tampa 7 Ft Pierce 8 Ft Myers 9 West Palm 12.0 11.0 13.5 9.0 11.0 7.5 17.0 6.0 12.5 3.5 17.5 17.0 1.0 4.0 10 Miami