I will build an inventory forecasting system in google sheets

Hasan Santosa

Japan

I speak Indonesian, English, Japanese

Data Analyst and Spreadsheet Specialist

"I am a detail-oriented data analyst freelancer who helps businesses make sense of their data. I specialize in data cleaning, data entry, spreadsheet analysis, and creating simple reports and visualiz...
Read More
About this Gig

I build a complete, no-code inventory forecasting system in Google Sheets and Looker Studio purpose-built for eCommerce brands selling across multiple fulfillment locations (UK 3PL, US 3PL, Amazon FBA).

The system tells your ops team exactly when to reorder and how much to order automatically, every week, in under 30 minutes.

What you get: 6-tab Google Sheets system (SKU Master, Stock Snapshot, Sales Velocity, Inbound Tracker, Replenishment Engine, Dashboard) Auto-calculated Reorder Points (ROP) and Reorder Quantities (ROQ) per location Color-coded alerts: Reorder Now / Reorder Soon / Safe Looker Studio dashboard connected to Google Sheets (Standard & Premium) Built-in audit trail every edit must be signed or it's flagged UNVERIFIED Non-technical team friendly no scripts, no macros, no training needed

Perfect for: eCommerce brands on 23 fulfillment channels Ops teams who want clarity, not complexity Founders who need real-time visibility without expensive software

No SaaS fees. No lock-in. Your team owns the system forever.

Read More
build an inventory forecasting system in google sheets
Full Screen
build an inventory forecasting system in google sheets
Full Screen
build an inventory forecasting system in google sheetsbuild an inventory forecasting system in google sheets

Platform:

Excel

•

Google Sheets

•

VBA

Development technology:

VBA

•

Google Apps Script

•

Python

Expertise:

Formatting

•

Macros

My Portfolio

Related tags