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

M
mina_l_morris
M
mina_l_morris
Mina L.

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.

Mina L.

Supply Chain Consultant, Demand Planning, SOP, ERP D365

  • FromEgypt
  • Member sinceSep 2026
  • Avg. response time1 hour
  • Languages

    Arabic, English
Supply Chain and Operations Manager with 10+ years in manufacturing: HDPE plastics (12 production lines), FMCG (Edita, Teriak) and Microsoft D365 F&O consulting. MBA in Supply Chain Management, CMRP certified, CPIM in progress. I build practical, ready-to-use planning tools: - Demand forecasting and S&OP models in Excel - Safety stock and reorder point tools - Production and capacity planning models - OEE and supply chain KPI dashboards - ERP (D365) SOPs and process documentation Built from real plant-floor experience and easy for your team to maintain. Message me with your challenge.

My Portfolio