Rafallah3141592/forecasting_engine.mvp

📦 SME Demand Forecasting & Reorder Optimization

A Streamlit application for SKU-level demand forecasting and inventory reorder optimization, designed for SMEs in the Qatari market.

🚀 Features

• —Upload Excel sales data (.xlsx)
• —Automatic SKU / Date / Sales column detection
• —Time-series feature engineering
• —LightGBM-based demand forecasting
• —Safety stock calculation
• —Forecast accuracy diagnostics
• —Interactive dashboards & charts
• —Downloadable forecast output

📊 Input Data Format

Your Excel file should contain:

• —SKU (product identifier)
• —Date (daily sales date)
• —Sales (units sold)

Column names are auto-detected (e.g. product, item, qty, units, etc.).

🧠 Model

• —LightGBM Regressor (CPU)
• —Lag features (1, 2, 3, 7 days)
• —Calendar effects (weekday, weekend, month)
• —Early stopping validation

📥 Output

• —Forecast quantity
• —Safety stock
• —Reorder quantity
• —Accuracy per SKU

🌍 Target Users

• —Retail SMEs
• —Distributors & wholesalers
• —Inventory planners
• —Supply chain teams

Built with ❤️ using Streamlit + LightGBM Deployed on Hugging Face Spaces