I will build excel inventory, supply chain and operations dashboards and models
Pine Script Developer and Supply Chain Excel Analyst
About this Gig
Running out of best-sellers while cash sits in slow stock? I turn your sales and inventory data into clear Excel or Google Sheets models that tell you what to order, when and how much.
What I build:
- Reorder points, safety stock and EOQ for every SKU
- - ABC / XYZ analysis to focus on the products that matter
- - Demand forecasts from your sales history (moving average, seasonality, trend)
- - KPI dashboards: stock turns, days of cover, fill rate, stockouts, dead stock
- - Process maps and SOPs for receiving, picking and replenishment (Lean)
Why me:
I'm a university lecturer in Operations and Supply Chain Management with an M.Sc. in Logistics (Norway) and an MBA (UK), plus industry experience in operations at a major international publisher. I teach this every semester, so you get the proven method, not guesswork.
You get a clean, documented workbook with formulas you can see and edit, a one-page summary of findings, and a short walkthrough.
Please message me before ordering with a description of your business and a sample of your data.
FAQ
What data do you need from me?
Ideally 12+ months of sales by SKU (date, product, quantity), current stock levels, supplier lead times and unit costs. An export from Shopify, Amazon, QuickBooks or your ERP is fine; I'll clean it.
Will it work in my version of Excel or in Google Sheets?
Yes. I build with standard formulas that work in Excel 2016+, Microsoft 365 and Google Sheets. No macros unless you ask, so nothing breaks when you share the file.
Is my business data kept confidential?
Yes. Your data is used only for your order, never shared, and deleted on request after delivery. Feel free to anonymise product names if you prefer.
