This app demonstrates the power of predictive analytics to optimize inventory analysis by identifying predicted order and exhaust dates based on past purchasing behavior.
A user selects the stores, product categories, and the time range of purchasing behavior to analyze. Exhaust dates are predicted by analyzing the linear trend of the purchasing behavior per product over the selected historical time period. This information, along with the lead-time required for product shipping, allows for the identification of the expected Exhaust Date and the Order Date.
Outputs include a map of the location analyzed, table indicating the items closest to exhaust date, and detail information for each product showing a plot of past purchasing behavior, linear trend, order date, and exhaust date.