METHOD AND APPARATUS FOR END-TO-END RETAIL STORE SITE OPTIMIZATION

• US 20090187464A1
• Filed: 01/22/2008
• Published: 07/23/2009
• Est. Priority Date: 01/22/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Zhang, Bin, Dong, Jin, Li, Ta-Hsin, Yin, Wen Jun, Bai, Xin Xin
• Granted Patent: US 8,239,245 B2
• Time in Patent Office: Days
• US Class Current: 705/10
• CPC Class Codes: G06Q 10/04 Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem" market predictions or forecasting for commercial activities G06Q30/0202
• CPC Class Codes: G06Q 30/0205 Location or geographical consideration

Abstract

A method and apparatus for end-to-end retail store one-stop site configuration integrates multiple data sources, identifying key customers, forecasting merchandise demand. Site configuration is formulated as a mathematical optimization problem with both in-store and external data as input to the problem whose solution provides proper suggestions for retail store transformation.

Claims

1. A method of providing store site configuration, comprising:

integrating in-store and external data from multiple sources into a geographic information system platform;

determining customer segment profile, customer geo-distribution and customer demand from the integrated data in the geographic information system platform;

modeling and forecasting potential customer geo-distribution using said customer segment profile, said customer geo-distribution and said customer demand;

modeling and forecasting potential merchandise demand using said potential customer geo-distribution;

deriving one or more gaps using said forecasted potential customer geo-distribution or forecasted potential merchandise demand or combination of both; and

determining site configuration based on said one or more gaps, said site configuration providing recommendations based on location, format, capacity, merchandise mix and customer segment.

2. The method of claim 1, wherein said one or more gaps include:

gap between the number of potential customer and actual customer.

3. The method of claim 1, wherein said one or more gaps include:

gap between potential demand and actual sales of merchandise.

4. The method of claim 1 wherein said one or more gaps include:

gap between potential demand of merchandise by customer segment and actual demand of merchandise by customer segment.

5. The method of claim 1, wherein said in-store and external data from multiple sources include:

store information, transaction record, merchandise data, membership record, market survey data, competitor information, geographic data, or demographic data, or combinations thereof.

6. The method of claim 1, wherein the step of determining customer segment profile, customer geo-distribution and customer demand includes using a clustering algorithm to determine customer segment profile, customer geo-distribution and customer demand.

7. The method of claim 1, wherein the step of modeling and forecasting potential customer geo-distribution includes using statistical data mining algorithm to model and forecast potential customer geo-distribution.

8. The method of claim 1, wherein the step of determining site configuration includes building an optimization model to configure one or more stores based on said one or more gaps.

9. The method of claim 8, wherein the optimization model maximizes total profit of said one or more stores in a store network, the optimization model based on location, format, capacity, merchandise mix and customer segment factors.

10. The method of claim 1, further including:

presenting the determined site configuration using a geographical map.

11. The method of claim 1, wherein the step of determining site configuration includes:

configuring an existing store in a store network using data associated with existing stores in the store network;

configuring a new store to open in a store network using data associated with existing stores in the store network;

configuring exiting and new stores for opening in a store network using data associated with existing stores in the store network;

configuring an existing store using data associated with existing stores only in a store network having existing stores and opened new stores;

configuring a newly opened store in a store network having existing stores and newly opened stores using data associated with existing stores only;

configuring exiting and newly opened stores in a store network using data associated with existing stores only;

or combinations thereof.

12. The method of claim 1, wherein the step of integrating further includes:

converting said data into geographic information system format.

13. The method of claim 1, wherein said integrated data is represented with spatial attributes and non-spatial attributes.

14. A system for providing store site configuration, comprising:

data integration module operable to integrate in-store and external data from multiple sources into a geographic information system platform;

customer analytics module operable to determine customer segment profile, customer geo-distribution and customer demand from the integrated data in the geographic information system platform, the customer analytics module further operable to model and forecast potential customer geo-distribution using said customer segment profile, said customer geo-distribution and said customer demand, and to model and forecast potential merchandise demand using said potential customer geo-distribution;

gap analysis module operable to derive one or more gaps using said forecasted potential customer geo-distribution or forecasted potential merchandise demand or combination of both; and

configuration decision module operable to determine site configuration based on said one or more gaps, said site configuration providing recommendations based on location, format, capacity, merchandise mix and customer segment.

15. The system of claim 14, wherein said one or more gaps include:

gap between the number of potential customer and actual customer;

gap between potential demand and actual sales of merchandise;

gap between potential demand of merchandise by customer segment and actual demand of merchandise by customer segment;

or combinations thereof.

16. The system of claim 14, wherein said in-store and external data from multiple sources include:

store information, transaction record, merchandise data, membership record, market survey data, competitor information, geographic data, or demographic data, or combinations thereof.

17. The system of claim 14, wherein the configuration decision module includes an optimization model operable to configure one or more stores based on said one or more gaps, the optimization model farther operable to maximizes total profit of said one or more stores in a store network, the optimization model based on location, format, capacity, merchandise mix and customer segment factors.

18. The system of claim 14, further including:

a graphical user interface operable to present the determined site configuration using a geographical map.

19. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform a method of providing store site configuration, comprising:

integrating in-store and external data from multiple sources into a geographic information system platform;

determining customer segment profile, customer geo-distribution and customer demand from the integrated data in the geographic information system platform;

modeling and forecasting potential customer geo-distribution using said customer segment profile, said customer geo-distribution and said customer demand;

modeling and forecasting potential merchandise demand using said potential customer geo-distribution;

deriving one or more gaps using said forecasted potential customer geo-distribution or forecasted potential merchandise demand or combination of both; and

determining site configuration based on said one or more gaps, said site configuration providing recommendations based on location, format, capacity, merchandise mix and customer segment.

20. The program storage device of claim 19, wherein said one or more gaps include:

gap between the number of potential customer and actual customer;

gap between potential demand and actual sales of merchandise;

gap between potential demand of merchandise by customer segment and actual demand of merchandise by customer segment;

or

combinations thereof.