Xbook

Xbook is a company that buys old books and sells them to enthusiastic collectors in the USA. Transactions typically happen on the internet but physical copies of the books must be delivered to local book stores from where customers pick them up.

Old books often arrive in boxes and need to be cleaned, entered into the system, and priced before they are ready to be shipped to customers, i.e., the collectors. Currently, Xbook has only one warehouse where they receive, process, and store all the books they buy.

Because the business is growing rapidly, Xbook foresees that the current warehouse will run out of capacity soon. In addition, they see a pressing need to deliver the books faster. Therefore, it's a good time for Xbook to consider setting up a few new facilities around the country.

Setting up a new facility involves significant investment and requires proper planning. Specifically, Xbook has four candidate facilities, including the existing one, with estimated building and maintenance costs.

Transportation cost is also a big factor, the closer the facility is to the destination stores, the cheaper the delivery fee will be. For simplicity, we estimate delivery fees to be a factor of the distance.

  • Facilities

Facility ID Facility Name Storage Capacity Setup Cost Latitude Longitude
F1 Facility 1 120 0 40.53 -112.07
F2 Facility 2 150 250 32.86 -97.19
F3 Facility 3 90 300 41.75 -87.74
F4 Facility 4 200 150 39.79 -75.04
  • Stores

Store ID Store Name Demand Latitude Longitude
S1 Store 1 23 47.41 -122.19
S2 Store 2 43 45.41 -122.32
S3 Store 3 23 37.87 -122.92
S4 Store 4 34 39.45 -106.02
S5 Store 5 32 32.74 -97.06
S6 Store 6 54 38.63 -90.38
S7 Store 7 37 41.95 -87.96
S8 Store 8 19 36.22 -86.51
S9 Store 9 82 33.63 -84.22
S10 Store 10 63 28.43 -81.32
S11 Store 11 28 38.9 -77.02
S12 Store 12 40 39.96 -75.18
  • Transportation Lanes

Origin Site ID Dest. Site ID Distance
F1 S1 1779.78
F1 S2 1590.02
F1 S3 1567.75
F1 S4 846.56
F1 S5 2546.5
F1 S6 2985.71
F1 S7 3224.68
F1 S8 3632.91
F1 S9 4119.25
F1 S10 4962.77
F1 S11 4773.94
F1 S12 4973.64
F2 S1 4241.67
F2 S2 4097.59
F2 S3 3824.68
F2 S4 1725.63
F2 S5 28.87
F2 S6 1420.67
F2 S7 2075.03
F2 S8 1674.25
F2 S9 1933.44
F2 S10 2550.69
F2 S11 3091.64
F2 S12 3383.82
F3 S1 4441.31
F3 S2 4468.89
F3 S3 4823.14
F3 S4 2498.08
F3 S5 2073.8
F3 S6 660.87
F3 S7 46.0
F3 S8 998.42
F3 S9 1526.9
F3 S10 2545.44
F3 S11 1538.62
F3 S12 1718.25
F4 S1 6125.67
F4 S2 6181.14
F4 S3 6564.95
F4 S4 4224.66
F4 S5 3387.41
F4 S6 2122.07
F4 S7 1778.31
F4 S8 1727.21
F4 S9 1705.77
F4 S10 2221.16
F4 S11 315.08
F4 S12 35.78