I will build an excel inventory management dashboard
Supply Chain Analyst
About this Gig
Struggling to track your stock? Running out of best-sellers or sitting on dead inventory?
Im a supply chain engineering Masters student with hands-on experience in inventory audits, stock rationalization and logistics flow analysis. I build clear, easy-to-use Excel dashboards that show you exactly what is happening in your inventory.
What you get:
- Stock tracking (in / out / current level)
- KPI dashboard with charts (stock value, turnover, stockout rate)
- ABC analysis to focus on your most important products
- Reorder points, safety stock and low-stock alerts
- Simple demand forecast (Premium)
- A short guide so you can use the file on your own
Perfect for: e-commerce stores, small shops, small warehouses and startups.
Need it in Google Sheets or Power BI? Just ask, I can adapt the solution.
Please message me before ordering so we can discuss your needs. Je parle aussi français !
FAQ
Q : Do I need special software?
R : No. Microsoft Excel (2016 or later) or Google Sheets is enough.
Q : Can you work with my existing file?
R : Yes. I can clean, restructure and improve your current spreadsheet.
Q : What data do you need from me?
R : A list of your products with stock movements or sales history (Excel, CSV or an export from your tool). Sample or anonymized data is fine.
Q : Is my data kept confidential?
R : Absolutely. Your data is used only for your project and never shared.

