IDEAS home Printed from https://ideas.repec.org/a/inm/ormksc/v24y2005i3p334-350.html
   My bibliography  Save this article

Practice Prize Article—: A Multichannel, Multiregion Sales Forecasting Model and Decision Support System for Consumer Packaged Goods

Author

Listed:
  • Suresh Divakar

    (Citigroup, New York, New York 10022)

  • Brian T. Ratchford

    (R. H. Smith School of Business, University of Maryland, College Park, Maryland 20742-1815)

  • Venkatesh Shankar

    (Mays Business School, Texas A&M University, College Station, Texas 77843-4117)

Abstract

We discuss the development and implementation of , a sales forecasting model, by pack size, category, channel, region, customer account and a Web-based decision support system (DSS) for consumer packaged goods. In addition to capturing the effects of such variables as past sales, trend, own and competitor prices and promotional variables, and seasonality, the model accounts for the effects of temperature, significant holidays, new product introductions, trading day corrections, and adjustments to the wholesale level. In general, the model forecasts sales volume satisfactorily for a leading consumer packaged goods company. The DSS enables top- and mid-level executives in sales, marketing, strategic planning, and finance to develop accurate forecasts of sales volume, plan prices, and promotional activities over a long time horizon; to track sales response to marketing actions over time; and to simulate forecast scenarios based on possible marketing decisions and other variables. is being rolled out for more users and more divisions in the company. The key take-aways are that successful development and implementation of a rigorous marketing science model require a strong internal champion, a careful balance between modeling sophistication and practical relevance, good diagnostic features, regular validations, and greater attention to the development of a fast and responsive DSS.

Suggested Citation

  • Suresh Divakar & Brian T. Ratchford & Venkatesh Shankar, 2005. "Practice Prize Article—: A Multichannel, Multiregion Sales Forecasting Model and Decision Support System for Consumer Packaged Goods," Marketing Science, INFORMS, vol. 24(3), pages 334-350, July.
    • Handle: RePEc:inm:ormksc:v:24:y:2005:i:3:p:334-350
    DOI: 10.1287/mksc.1050.0135
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/mksc.1050.0135
    Download Restriction: no
    File URL: https://libkey.io/10.1287/mksc.1050.0135?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
    ---><---

    References listed on IDEAS

    as
    1. Foekens, Eijte W. & Leeflang, Peter S. H. & Wittink, Dick R., 1994. "A comparison and an exploration of the forecasting accuracy of a loglinear model at different levels of aggregation," International Journal of Forecasting, Elsevier, vol. 10(2), pages 245-261, September.
    2. Wu, De-Min, 1973. "Alternative Tests of Independence Between Stochastic Regressors and Disturbances," Econometrica, Econometric Society, vol. 41(4), pages 733-750, July.
    3. Peter M. Guadagni & John D. C. Little, 1983. "A Logit Model of Brand Choice Calibrated on Scanner Data," Marketing Science, INFORMS, vol. 2(3), pages 203-238.
    4. David Besanko & Sachin Gupta & Dipak Jain, 1998. "Logit Demand Estimation Under Competitive Pricing Behavior: An Equilibrium Framework," Management Science, INFORMS, vol. 44(11-Part-1), pages 1533-1547, November.
    5. Magid M. Abraham & Leonard M. Lodish, 1993. "An Implemented System for Improving Promotion Productivity Using Store Scanner Data," Marketing Science, INFORMS, vol. 12(3), pages 248-269.
    6. Leeflang, P.S.H. & Wittink, Dick R., 2000. "Building models for marketing decisions: past, present and future," Research Report 00F20, University of Groningen, Research Institute SOM (Systems, Organisations and Management).
    7. John H. Roberts & Charles J. Nelson & Pamela D. Morrison, 2005. "A Prelaunch Diffusion Model for Evaluating Market Defense Strategies," Marketing Science, INFORMS, vol. 24(1), pages 150-164, August.
    8. David R. Bell & Jeongwen Chiang & V. Padmanabhan, 1999. "The Decomposition of Promotional Response: An Empirical Generalization," Marketing Science, INFORMS, vol. 18(4), pages 504-526.
    9. Greg M. Allenby & Thomas S. Shively & Sha Yang & Mark J. Garratt, 2004. "A Choice Model for Packaged Goods: Dealing with Discrete Quantities and Quantity Discounts," Marketing Science, INFORMS, vol. 23(1), pages 95-108, June.
    10. Harald J. van Heerde & Peter S. H. Leeflang & Dick R. Wittink, 2002. "How Promotions Work: Scan Pro-Based Evolutionary Model Building," Schmalenbach Business Review (sbr), LMU Munich School of Management, vol. 54(3), pages 198-220, July.
    11. Gerrit H. van Bruggen & Ale Smidts & Berend Wierenga, 1998. "Improving Decision Making by Means of a Marketing Decision Support System," Management Science, INFORMS, vol. 44(5), pages 645-658, May.
    12. Randolph E. Bucklin & Sunil Gupta, 1999. "Commercial Use of UPC Scanner Data: Industry and Academic Perspectives," Marketing Science, INFORMS, vol. 18(3), pages 247-273.
    13. Jean-Pierre Dubé, 2004. "Multiple Discreteness and Product Differentiation: Demand for Carbonated Soft Drinks," Marketing Science, INFORMS, vol. 23(1), pages 66-81, September.
    14. repec:dgr:rugsom:00f20 is not listed on IDEAS
    15. Bart J. Bronnenberg & Carl F. Mela, 2004. "Market Roll-Out and Retailer Adoption for New Brands," Marketing Science, INFORMS, vol. 23(4), pages 500-518, September.
    16. Albers, Sönke, 1993. "Analysis of profit contribution variance between actual and plan," Manuskripte aus den Instituten für Betriebswirtschaftslehre der Universität Kiel 332, Christian-Albrechts-Universität zu Kiel, Institut für Betriebswirtschaftslehre.
    17. Peter S. Fader & Bruce G. S. Hardie & Chun-Yao Huang, 2004. "A Dynamic Changepoint Model for New Product Sales Forecasting," Marketing Science, INFORMS, vol. 23(1), pages 50-65, October.
    18. Berend Wierenga & Gerrit H. Van Bruggen & Richard Staelin, 1999. "The Success of Marketing Management Support Systems," Marketing Science, INFORMS, vol. 18(3), pages 196-207.
    19. John D. C. Little, 1970. "Models and Managers: The Concept of a Decision Calculus," Management Science, INFORMS, vol. 16(8), pages 466-485, April.
    20. Prasad A. Naik & Kalyan Raman & Russell S. Winer, 2005. "Planning Marketing-Mix Strategies in the Presence of Interaction Effects," Marketing Science, INFORMS, vol. 24(1), pages 25-34, June.
    21. Venkatesh Shankar & Ruth N. Bolton, 2004. "An Empirical Analysis of Determinants of Retailer Pricing Strategy," Marketing Science, INFORMS, vol. 23(1), pages 28-49, May.
    22. Robert C. Blattberg & Kenneth J. Wisniewski, 1989. "Price-Induced Patterns of Competition," Marketing Science, INFORMS, vol. 8(4), pages 291-309.
    23. Magid M. Abraham & Leonard M. Lodish, 1987. "Promoter: An Automated Promotion Evaluation System," Marketing Science, INFORMS, vol. 6(2), pages 101-123.
    Full references (including those not matched with items on IDEAS)

    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. John D. C. Little, 2004. "Comments on ÜModels and Managers: The Concept of a Decision CalculusÝ," Management Science, INFORMS, vol. 50(12_supple), pages 1854-1860, December.
    2. Harikesh Nair & Jean-Pierre Dubé & Pradeep Chintagunta, 2005. "Accounting for Primary and Secondary Demand Effects with Aggregate Data," Marketing Science, INFORMS, vol. 24(3), pages 444-460, November.
    3. Randolph E. Bucklin & Sunil Gupta, 1999. "Commercial Use of UPC Scanner Data: Industry and Academic Perspectives," Marketing Science, INFORMS, vol. 18(3), pages 247-273.
    4. Leeflang, Peter, 2011. "Paving the way for “distinguished marketing”," International Journal of Research in Marketing, Elsevier, vol. 28(2), pages 76-88.
    5. Jorge Silva-Risso & Irina Ionova, 2008. "—A Nested Logit Model of Product and Transaction-Type Choice for Planning Automakers' Pricing and Promotions," Marketing Science, INFORMS, vol. 27(4), pages 545-566, 07-08.
    6. Praveen K. Kopalle & Carl F. Mela & Lawrence Marsh, 1999. "The Dynamic Effect of Discounting on Sales: Empirical Analysis and Normative Pricing Implications," Marketing Science, INFORMS, vol. 18(3), pages 317-332.
    7. Wierenga, Berend, 2011. "Managerial decision making in marketing: The next research frontier," International Journal of Research in Marketing, Elsevier, vol. 28(2), pages 89-101.
    8. Kurt A. Jetta & Erick W. Rengifo, 2009. "Improved Baseline Sales," Fordham Economics Discussion Paper Series dp2009-02, Fordham University, Department of Economics.
    9. Jean-Pierre H. Dubé, 2018. "Microeconometric Models of Consumer Demand," NBER Working Papers 25215, National Bureau of Economic Research, Inc.
    10. Jorge Silva-Risso & William V. Shearin & Irina Ionova & Alexei Khavaev & Deirdre Borrego, 2008. "Chrysler and J. D. Power: Pioneering Scientific Price Customization in the Automobile Industry," Interfaces, INFORMS, vol. 38(1), pages 26-39, February.
    11. Guyt, Jonne, 2015. "Consumer choice models on the effect of promotions in retailing," Other publications TiSEM c310f652-d725-4764-aac7-b, Tilburg University, School of Economics and Management.
    12. Ehrenberg, Andrew S. C. & Uncles, Mark D. & Goodhardt, Gerald J., 2004. "Understanding brand performance measures: using Dirichlet benchmarks," Journal of Business Research, Elsevier, vol. 57(12), pages 1307-1325, December.
    13. Ailawadi, Kusum L. & Beauchamp, J.P. & Donthu, Naveen & Gauri, Dinesh K. & Shankar, Venkatesh, 2009. "Communication and Promotion Decisions in Retailing: A Review and Directions for Future Research," Journal of Retailing, Elsevier, vol. 85(1), pages 42-55.
    14. Weber, Anett & Steiner, Winfried J., 2021. "Modeling price response from retail sales: An empirical comparison of models with different representations of heterogeneity," European Journal of Operational Research, Elsevier, vol. 294(3), pages 843-859.
    15. Jorge M. Silva-Risso & Randolph E. Bucklin & Donald G. Morrison, 1999. "A Decision Support System for Planning Manufacturers' Sales Promotion Calendars," Marketing Science, INFORMS, vol. 18(3), pages 274-300.
    16. Gary L. Lilien & John H. Roberts & Venkatesh Shankar, 2013. "Effective Marketing Science Applications: Insights from the ISMS-MSI Practice Prize Finalist Papers and Projects," Marketing Science, INFORMS, vol. 32(2), pages 229-245, March.
    17. Dapeng Cui & David Curry, 2005. "Prediction in Marketing Using the Support Vector Machine," Marketing Science, INFORMS, vol. 24(4), pages 595-615, January.
    18. Chen Zhou & Shrihari Sridhar & Rafael Becerril-Arreola & Tony Haitao Cui & Yan Dong, 2019. "Promotions as competitive reactions to recalls and their consequences," Journal of the Academy of Marketing Science, Springer, vol. 47(4), pages 702-722, July.
    19. Marshall Freimer & Dan Horsky, 2008. "Try It, You Will Like It—Does Consumer Learning Lead to Competitive Price Promotions?," Marketing Science, INFORMS, vol. 27(5), pages 796-810, 09-10.
    20. Harald J. van Heerde & Peter S. H. Leeflang & Dick R. Wittink, 2004. "Decomposing the Sales Promotion Bump with Store Data," Marketing Science, INFORMS, vol. 23(3), pages 317-334, December.

    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:inm:ormksc:v:24:y:2005:i:3:p:334-350. 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: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    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.