System and method of lost sales correction for promoted periods

Abstract

A system and method are disclosed for correcting lost sales for promotional periods. The method includes computing an average daily proportion of sales within calendar weeks for products, computing an expected range comprising a minimum and a maximum expected share for each day for the products, comparing historical daily shares with the expected ranges for the calendar weeks, determining a reference day for each calendar week by determining which day of each week represented by the historical daily shares falls closest to an expected value for the day, and correcting days falling outside the expected range using the reference day determined by calculating corrected sales values using the reference day, where calculating the corrected sales values further comprises determining a reference ratio for the day to be corrected by dividing an average value for the day by an average value for the reference day.