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 |