METHOD AND SYSTEM FOR DATA CLEANSING TO IMPROVE PRODUCT DEMAND FORECASTING

摘要

A method for cleansing product demand data to improve product demand forecasting. The improved data cleansing methodology enhances product weekly demand forecast accuracy by adjusting stock-out week demand values, and employing separate outlier logic for regular and promotional demand periods.

主权项

1. A computer-implemented method for identifying outliers within a data sample, the method comprising the steps of:
maintaining, in a data storage device, a database of historical demand information for a product, said historical demand information comprising regular demand values corresponding to non-promotional historical product sales, and promotional demand values corresponding to promotional historical product sales; establishing high and low boundary values for said regular demand values, and high and low boundary values for said promotional demand values; identifying, by a computer in communication with said data storage device, an individual regular demand value as an outlier regular demand value when said individual regular demand value is above, or below, said high and low boundary values for said regular demand values, respectively; and identifying, by said computer, an individual promotional demand value as an outlier promotional demand value when said individual promotional demand value is above, or below, said high and low boundary values for said promotional demand values, respectively.