In this article, cannibalization and its effects on location decisions in a competitive retail environment is investigated. The authors analyze maximizing market share while minimizing cannibalization using the gravity (Huff) model. The efficient frontier according to these two noncompatible objectives is constructed and illustrated on an example problem. An easy to implement analysis that provides insight into management decisions is provided. To illustrate the ease of implementing the model using Excel, a description of the spreadsheet along with the Visual Basic for Applications (VBA) code are provided.
Albright, S.C.2001. VBA for Modelers, Deνeloping Decision Support Systems with Microsoft® Excel. Duxbury Press.
2.
Chandy, R.K., and G.J. Tellis.1998. Organizing for radical product innovation: The overlooked role of willingness to cannibalize. Journal of Marketing Research35:474-87.
3.
Drezner, T.1994a. Optimal continuous location of a retail facility, facility attractiveness, and market share: An interactive model. Journal of Retailing70:49-64.
4.
---. 1994b. Locating a single new facility among existing unequally attractive facilities. Journal of Regional Science34:237-52.
5.
---. 1995. Competitive facility location in the plane. In Facility location: A surνey of applications and methods, ed. Z. Drezner, 285-300. Berlin: Springer.
6.
Drezner, T., and Z. Drezner.2004. Finding the optimal solution to the Huff based competitive location model. Computational Management Science1:193-208.
7.
Drezner, Z., and A. Suzuki.2004. The big triangle small triangle method for the solution of non-convex facility location problems. Operations Research52:128-35.
8.
Eiselt, H.A., G. Laporte, and J.-F. Thisse.1993. Competitive location models: A framework and bibliography. Transportation Science27:44-54.
9.
Fernandez, J., B. Pelegrin, F. Plastria, and B. Toth.2007. Planar location and design of a new facility with inner and outer competition: An interval lexicographical-like solution procedure. Networks and Spatial Economics7:19-44.
10.
Ghosh, A., and C.S. Craig.1991. FRANSYS: A franchise distribution system location model. Journal of Retailing67:466-95.
11.
Ghosh, A., S. McLafferty, and C.S. Craig.1995. Multifacility retail networks. In Facility location: A surνey of applications and methods, ed. Z. Drezner, 301-330. Berlin: Springer.
12.
Huff, D.L.1964. Defining and estimating a trade area. Journal of Marketing28:34-8.
13.
---. 1966. A programmed solution for approximating an optimum retail location. Land Economics42:293-303.
14.
Mason, C.H., and G.R. Milne.1994. An approach for identifying cannibalization within product line extensions and multi-brand strategies. Journal of Business Research31:163-70.
15.
Mazumdar, T., K. Sivakumar, and D. Wilemon.1996. Launching new products with cannibalization potential: An optimal timing framework. Journal of Marketing Theory and Practice4:83-94.
16.
Moorthy, K.S., and I.P.L. Png.1992. Market segmentation, cannibalization, and the timing of product introductions. Management Science38:345-59.
17.
Patel, D., and J. Corgel.1995. An analysis of hotel-impact studies . Hotel and Restaurant Administration Quarterly36:27-37.
18.
Plastria, F.2001. Static competitive facility location: An overview of optimisation approaches. European Journal of Operational Research129:461-70.
19.
---. 2005. Avoiding cannibalisation and/or competitor reaction in planar single facility location. Journal of the Operations Research Society of Japan48:148-57.
20.
Plastria, F., and E. Carrizosa.2004. Optimal location and design of a competitive facility. Mathematical Programming100:247-65.
21.
Powel, S.G., and K.R. Baker.2006. The art of modeling with spreadsheets: Management science, spreadsheet engineering, and modeling craft. New YorkJohn Wiley.
22.
Schneider, K., J. Johnson, B. Sleeper, and W. Rodgers.1998. A note on applying retail location models in franchise systems: A view from the trenches. Journal of Consumer Marketing15:290-6.
23.
Serra, D., and C. ReVelle.1995. Competitive location in discrete space . In Facility location: A surνey of applications and methods , ed. Z. Drezner, 367-86. Berlin : Springer.
24.
Zeller, R.E., D.D. Achabal, and L.A. Brown.1980. Market penetration and locational conflict in franchise systems. Decision Sciences11:58-80.
