A stock redistribution tool that ranks store demand and balances fairness across stores to recommend stock transfers.
This repository contains a portfolio version of an Excel/VBA-based decision engine used to automate stock movement decisions.
- excel/ : Excel interface
- src/vba/ : VBA modules
- data/ : sample datasets
- docs/ : documentation and diagrams
- output/ : sample outputs
Initial portfolio version. Python migration planned.
- Identifies donor stores with excess stock
- Ranks receiver stores by demand signals
- Allocates stock using fairness constraints
- Produces a transfer packing plan with rationale
- Stock on hand (SOH)
- Weekly sales
- Store grading (A/B/C)
- Optional overrides
- Transfer plan (donor → receiver → qty → reason)
- Current: Excel/VBA prototype
- Next: Python calculation engine behind Excel UI
- Later: automated data pipeline + scheduled runs
This tool automates stock redistribution decisions that were previously performed manually by planners.
Key benefits:
- Reduces manual planning time from hours to minutes
- Improves stock availability in high-demand stores
- Prevents overstock accumulation in slow stores
- Creates consistent, explainable transfer decisions
- Improves fairness perception across store network
The goal is not only optimization, but operational adoption by business users especially in environments relying on excel.
Developed by Brian — Focused on building tools that turn operational data into smarter decisions.