IDEAS home Printed from https://ideas.repec.org/a/eee/ejores/v237y2014i2p677-689.html
   My bibliography  Save this article

Upper and lower bounds for the sales force deployment problem with explicit contiguity constraints

Author

Listed:
  • Haase, Knut
  • Müller, Sven

Abstract

The sales force deployment problem arises in many selling organizations. This complex planning problem involves the concurrent resolution of four interrelated subproblems: sizing of the sales force, sales representatives locations, sales territory alignment, and sales resource allocation. The objective is to maximize the total profit. For this, a well-known and accepted concave sales response function is used. Unfortunately, literature is lacking approaches that provide valid upper bounds. Therefore, we propose a model formulation with an infinite number of binary variables. The linear relaxation is solved by column generation where the variables with maximum reduced costs are obtained analytically. For the optimal objective function value of the linear relaxation an upper bound is provided. To obtain a very tight gap for the objective function value of the optimal integer solution we introduce a Branch-and-Price approach. Moreover, we propose explicit contiguity constraints based on flow variables. In a series of computational studies we consider instances which may occur in the pharmaceutical industry. The largest instance comprises 50 potential locations and more than 500 sales coverage units. We are able to solve this instance in 1273seconds with a gap of less than 0.01%. A comparison with Drexl and Haase (1999) shows that we are able to halve the solution gap due to tight upper bounds provided by the column generation procedure.

Suggested Citation

  • Haase, Knut & Müller, Sven, 2014. "Upper and lower bounds for the sales force deployment problem with explicit contiguity constraints," European Journal of Operational Research, Elsevier, vol. 237(2), pages 677-689.
  • Handle: RePEc:eee:ejores:v:237:y:2014:i:2:p:677-689
    DOI: 10.1016/j.ejor.2014.01.061
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0377221714001003
    Download Restriction: Full text for ScienceDirect subscribers only

    File URL: https://libkey.io/10.1016/j.ejor.2014.01.061?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Lee, Chung-Yee & Yang, Ruina, 2013. "Compensation plan for competing salespersons under asymmetric information," European Journal of Operational Research, Elsevier, vol. 227(3), pages 570-580.
    2. Bernd Skiera & Sönke Albers, 1998. "COSTA: Contribution Optimizing Sales Territory Alignment," Marketing Science, INFORMS, vol. 17(3), pages 196-213.
    3. Darmon, Rene Y., 2002. "Salespeople's management of customer information: Impact on optimal territory and sales force sizes," European Journal of Operational Research, Elsevier, vol. 137(1), pages 162-176, February.
    4. Takeshi Shirabe, 2009. "Districting Modeling with Exact Contiguity Constraints," Environment and Planning B, , vol. 36(6), pages 1053-1066, December.
    5. Leonard M. Lodish & Ellen Curtis & Michael Ness & M. Kerry Simpson, 1988. "Sales Force Sizing and Deployment Using a Decision Calculus Model at Syntex Laboratories," Interfaces, INFORMS, vol. 18(1), pages 5-20, February.
    6. Murali Mantrala & Sönke Albers & Fabio Caldieraro & Ove Jensen & Kissan Joseph & Manfred Krafft & Chakravarthi Narasimhan & Srinath Gopalakrishna & Andris Zoltners & Rajiv Lal & Leonard Lodish, 2010. "Sales force modeling: State of the field and research agenda," Marketing Letters, Springer, vol. 21(3), pages 255-272, September.
    7. Andreas Drexl & Knut Haase, 1999. "Fast Approximation Methods for Sales Force Deployment," Management Science, INFORMS, vol. 45(10), pages 1307-1323, October.
    8. Andris A. Zoltners & Prabhakant Sinha, 1983. "Sales Territory Alignment: A Review and Model," Management Science, INFORMS, vol. 29(11), pages 1237-1256, November.
    9. Mesak, Hani I. & Ellis, T. Selwyn, 2009. "On the superiority of pulsing under a concave advertising market potential function," European Journal of Operational Research, Elsevier, vol. 194(2), pages 608-627, April.
    10. Howick, R. S. & Pidd, M., 1990. "Sales force deployment models," European Journal of Operational Research, Elsevier, vol. 48(3), pages 295-310, October.
    11. Albers, Sonke, 1996. "Optimization models for salesforce compensation," European Journal of Operational Research, Elsevier, vol. 89(1), pages 1-17, February.
    12. Douglas M. King & Sheldon H. Jacobson & Edward C. Sewell & Wendy K. Tam Cho, 2012. "Geo-Graphs: An Efficient Model for Enforcing Contiguity and Hole Constraints in Planar Graph Partitioning," Operations Research, INFORMS, vol. 60(5), pages 1213-1228, October.
    13. Hruschka, Harald, 2006. "Relevance of functional flexibility for heterogeneous sales response models: A comparison of parametric and semi-nonparametric models," European Journal of Operational Research, Elsevier, vol. 174(2), pages 1009-1020, October.
    14. Marco E. Lübbecke & Jacques Desrosiers, 2005. "Selected Topics in Column Generation," Operations Research, INFORMS, vol. 53(6), pages 1007-1023, December.
    15. Arvind Rangaswamy & Prabhakant Sinha & Andris Zoltners, 1990. "An Integrated Model-Based Approach for Sales Force Structuring," Marketing Science, INFORMS, vol. 9(4), pages 279-298.
    16. Müller, Sven & Wilhelm, Pascal & Haase, Knut, 2013. "Spatial dependencies and spatial drift in public transport seasonal ticket revenue data," Journal of Retailing and Consumer Services, Elsevier, vol. 20(3), pages 334-348.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Tobias Vlćek & Knut Haase & Malte Fliedner & Tobias Cors, 2024. "Police service district planning," OR Spectrum: Quantitative Approaches in Management, Springer;Gesellschaft für Operations Research e.V., vol. 46(4), pages 1029-1061, December.
    2. Baghersad, Milad & Emadikhiav, Mohsen & Huang, C. Derrick & Behara, Ravi S., 2023. "Modularity maximization to design contiguous policy zones for pandemic response," European Journal of Operational Research, Elsevier, vol. 304(1), pages 99-112.
    3. Knut Haase & Habib Zain Al Abideen & Salim Al-Bosta & Mathias Kasper & Matthes Koch & Sven Müller & Dirk Helbing, 2016. "Improving Pilgrim Safety During the Hajj: An Analytical and Operational Research Approach," Interfaces, INFORMS, vol. 46(1), pages 74-90, February.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Johannes Habel & Sascha Alavi & Nicolas Heinitz, 2023. "A theory of predictive sales analytics adoption," AMS Review, Springer;Academy of Marketing Science, vol. 13(1), pages 34-54, June.
    2. Darmon, Rene Y., 2002. "Salespeople's management of customer information: Impact on optimal territory and sales force sizes," European Journal of Operational Research, Elsevier, vol. 137(1), pages 162-176, February.
    3. Sprecher, Arno, 1999. "Sales force deployment by genetic concepts," Manuskripte aus den Instituten für Betriebswirtschaftslehre der Universität Kiel 514, Christian-Albrechts-Universität zu Kiel, Institut für Betriebswirtschaftslehre.
    4. Haase, Knut, 1999. "Sales force deployment by mathematical programming," Manuskripte aus den Instituten für Betriebswirtschaftslehre der Universität Kiel 508, Christian-Albrechts-Universität zu Kiel, Institut für Betriebswirtschaftslehre.
    5. D. M. King & S. H. Jacobson & E. C. Sewell, 2018. "The geo-graph in practice: creating United States Congressional Districts from census blocks," Computational Optimization and Applications, Springer, vol. 69(1), pages 25-49, January.
    6. Murali Mantrala & Sönke Albers & Fabio Caldieraro & Ove Jensen & Kissan Joseph & Manfred Krafft & Chakravarthi Narasimhan & Srinath Gopalakrishna & Andris Zoltners & Rajiv Lal & Leonard Lodish, 2010. "Sales force modeling: State of the field and research agenda," Marketing Letters, Springer, vol. 21(3), pages 255-272, September.
    7. Fabio Caldieraro & Anne T. Coughlan, 2009. "Optimal Sales Force Diversification and Group Incentive Payments," Marketing Science, INFORMS, vol. 28(6), pages 1009-1026, 11-12.
    8. Andris A. Zoltners & Prabhakant Sinha, 2005. "The 2004 ISMS Practice Prize Winner—Sales Territory Design: Thirty Years of Modeling and Implementation," Marketing Science, INFORMS, vol. 24(3), pages 313-331, September.
    9. Haugland, Dag & Ho, Sin C. & Laporte, Gilbert, 2007. "Designing delivery districts for the vehicle routing problem with stochastic demands," European Journal of Operational Research, Elsevier, vol. 180(3), pages 997-1010, August.
    10. Anna Franceschetti & Ola Jabali & Gilbert Laporte, 2017. "Continuous approximation models in freight distribution management," TOP: An Official Journal of the Spanish Society of Statistics and Operations Research, Springer;Sociedad de Estadística e Investigación Operativa, vol. 25(3), pages 413-433, October.
    11. Marc Fischer & Sönke Albers & Nils Wagner & Monika Frie, 2011. "Practice Prize Winner --Dynamic Marketing Budget Allocation Across Countries, Products, and Marketing Activities," Marketing Science, INFORMS, vol. 30(4), pages 568-585, July.
    12. Han, Jialin & Hu, Yaoguang & Mao, Mingsong & Wan, Shuping, 2020. "A multi-objective districting problem applied to agricultural machinery maintenance service network," European Journal of Operational Research, Elsevier, vol. 287(3), pages 1120-1130.
    13. Vidal, Thibaut & Laporte, Gilbert & Matl, Piotr, 2020. "A concise guide to existing and emerging vehicle routing problem variants," European Journal of Operational Research, Elsevier, vol. 286(2), pages 401-416.
    14. Camacho-Collados, M. & Liberatore, F. & Angulo, J.M., 2015. "A multi-criteria Police Districting Problem for the efficient and effective design of patrol sector," European Journal of Operational Research, Elsevier, vol. 246(2), pages 674-684.
    15. Andreas Drexl & Knut Haase, 1999. "Fast Approximation Methods for Sales Force Deployment," Management Science, INFORMS, vol. 45(10), pages 1307-1323, October.
    16. Drexl, Andreas & Haase, Knut, 1996. "Fast approximation methods for sales force deployment," Manuskripte aus den Instituten für Betriebswirtschaftslehre der Universität Kiel 411, Christian-Albrechts-Universität zu Kiel, Institut für Betriebswirtschaftslehre.
    17. Bernd Skiera & Sönke Albers, 1998. "COSTA: Contribution Optimizing Sales Territory Alignment," Marketing Science, INFORMS, vol. 17(3), pages 196-213.
    18. Sommer Gentry & Eric Chow & Allan Massie & Dorry Segev, 2015. "Gerrymandering for Justice: Redistricting U.S. Liver Allocation," Interfaces, INFORMS, vol. 45(5), pages 462-480, October.
    19. Ríos-Mercado, Roger Z. & López-Pérez, J. Fabián, 2013. "Commercial territory design planning with realignment and disjoint assignment requirements," Omega, Elsevier, vol. 41(3), pages 525-535.
    20. Ram Gopalan & Steven O. Kimbrough & Frederic H. Murphy & Nicholas Quintus, 2013. "The Philadelphia Districting Contest: Designing Territories for City Council Based Upon the 2010 Census," Interfaces, INFORMS, vol. 43(5), pages 477-489, October.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:ejores:v:237:y:2014:i:2:p:677-689. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/eor .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.