I will build an excel inventory control system with dashboard and reorder alerts


About this gig
Planning inventory shouldn't require an expensive ERP. I'm a supply chain planner with 10+ years in manufacturing and FMCG, and I build Excel inventory systems that work the way stock really moves.
How it works: you log receipts, issues and adjustments, and the file calculates everything else automatically.
What you get:
- Transaction log with a full audit trail
- - Live on-hand stock per item (and per location in Premium)
- - Safety stock and reorder point based on your demand and lead times
- - ABC classification to focus on the items that matter most
- - Dashboard: stock value, days of cover, stock-outs, items to reorder
- - Color-coded reorder alerts
- - Short user guide
Why buyers choose it:
- Runs in standard Excel, no subscription, no macros required
- - Your data stays on your computer
- - Built around your own items, units and suppliers
Please message me before ordering so we can confirm your SKU count and needs.
Get to know Mina L.
Supply Chain Consultant, Demand Planning, SOP, ERP D365
- FromEgypt
- Member sinceSep 2026
- Avg. response time1 hour
Languages
Arabic, English
My Portfolio
FAQ
Do I need special software?
No. The system runs in Excel 2016 or newer, or Microsoft 365. No macros or add-ins are required.
Can you use my existing item list?
Yes. Send your item list in Excel or CSV and I will import it, including units, categories and suppliers.
Does it work for manufacturing companies?
Yes. It can track both raw materials and finished goods, based on my experience running production planning in manufacturing.
