Current Month Stockout Predictions

Predict Current-Month Stockouts and Compute the Historical Average

This workflow generates the current month stockout prediction from historical data. It crates lagged values from previous months, and keeps only the current-month row for the prediction. It then applies the saved regression model to estimate stockouts, calculates the mean historical stockouts from the original data, and places both results side by side. Finally, it rounds the values, keeps the relevant output columns, and returns a simple comparison of predicted stockouts for the current month versus the historical average.

Input data

Incoming from caller workflow

Output data

Outgoing from callee workflow

Predict Stockouts

• Lag previous months

• Apply trained regression model

• Compute mean stockouts on historical data