Store sales evaluation and prediction using spatial panel data models of sales components

Auke Hunneman, J. Paul Elhorst*, Tammo H. A. Bijmolt

*Corresponding author for this work

Research output: Contribution to journalArticleAcademicpeer-review

2 Citations (Scopus)
102 Downloads (Pure)

Abstract

This paper sets out a general framework for store sales evaluation and prediction. The sales of a retail chain with multiple stores are first decomposed into five components, and then each component is explained by store, competitor and consumer characteristics using random effects models for components observable at the store level and spatial error random effects models for components observable at the zip code level. We use spatial panel data over four years for estimation and a subsequent year for evaluating one-year-ahead predictions. Set against a benchmark model that explains total sales directly, the prediction error of our framework is reduced by 34% for existing stores during the sample period, by 5% for existing stores one year ahead and by 26% for new stores.

Original languageEnglish
Pages (from-to)127-150
Number of pages24
JournalSpatial Economic Analysis
Volume17
Issue number1
Early online date17-May-2021
DOIs
Publication statusPublished - 2022

Keywords

  • retailing
  • decomposition
  • sales components
  • loyalty programmes
  • spatial econometrics
  • MAXIMUM-LIKELIHOOD-ESTIMATION
  • LOYALTY PROGRAM
  • EMPIRICAL-ANALYSIS
  • LOCATION
  • ENTRY

Cite this