FormulaSurge
All sample projects

work

Sample: D2C Inventory Reorder System

Sample project - multi-channel stock consolidation across Shopify Amazon and warehouse with SKU reorder points and a dead-stock report.

  • d2c
  • multi channel inventory
  • reorder point
  • shopify amazon

Sample project. This is an illustrative build that shows how I would solve this kind of problem in Excel. It is not a past client engagement, and the business described is a typical scenario, not a real company.

The scenario
A typical D2C brand sells on Shopify, Amazon and wholesale with three inventory sources, reconciled by hand. The result: stock-outs on one channel and dead stock in the warehouse.
What I would build
Multi-channel inventory consolidation, SKU-level reorder point calculator, dead-stock report and weekly working-capital dashboard.
Designed to deliver
One trusted stock number and a weekly reorder list
Stack
Power QueryPower PivotXLOOKUPDAXSlicersVBA email

The typical starting point

The Shopify export, the Amazon export and a manually updated warehouse sheet never agree. Finance spends days each week working out what is actually in stock, while some SKUs run out and others sit unsold.

How I would build it

I would build a single Power Query pipeline that reads all three sources into one inventory table. An SKU master holds cost, price, lead time and safety stock. A reorder point calculator flags every SKU below threshold, a dead-stock report lists anything unsold for 90+ days, and a small VBA macro emails a weekly working-capital summary.

What it is designed to deliver

The founder gets one stock number they can trust, a weekly list of what to reorder and what is not moving, and finance stops reconciling channels by hand.

End of sample project

Want this built for your team?

Send us the workbook you are running today. We will come back with a fixed-scope proposal in a written reply within one working day - no discovery retainer, no sales call unless you ask for one.

  • Written scope and fixed price before any build work starts
  • Live workbook reviews - you see progress from week one
  • Documented walkthrough and 30-day support at handover

Engagement

Sample project

Get this kind of
result.

A build like this typically takes 2-4 weeks end-to-end. Send the brief - I will come back with a written plan and fixed price.

Typical build
2-4w
Named owner
1
Support after
30d
  1. 1Send the brief
  2. 2Quote in 24h
  3. 3Run it for 30d
CallWhatsApp
Mutual NDA availableMon–Sat, 9am–7pm IST

Other sample projects

Related

Keep reading

Sample: Multi-entity group consolidation dashboard

Case Study

Sample: Multi-entity group consolidation dashboard

Sample project - how I would consolidate several entities into one Excel P&L balance sheet and cash forecast with a one-click refresh

Read
Sample: Multi-store retail sales and stock dashboard

Case Study

Sample: Multi-store retail sales and stock dashboard

Sample project - how I would unify daily sales inventory and receivables across stores online and warehouse in one Excel dashboard

Read
Sample: Automated month-end close for manufacturing

Case Study

Sample: Automated month-end close for manufacturing

Sample project - a refresh-to-report Excel month-end close with checks that stop the run when source data drifts

Read
Sample: CA Firm GST Reconciliation Automation

Case Study

Sample: CA Firm GST Reconciliation Automation

Sample project - a Power Query pipeline that reconciles GSTR-2B with the Tally purchase register per client plus a practice-wide tracker.

Read
Sample: Pharma Distribution Sales Tracker

Case Study

Sample: Pharma Distribution Sales Tracker

Sample project - an Excel sales tracker for a pharma distributor with daily field-force entry scheme ROI and rep productivity.

Read
Sample: Restaurant Chain Food Cost Dashboard

Case Study

Sample: Restaurant Chain Food Cost Dashboard

Sample project - daily food cost % prime cost and waste tracking across locations in one Excel workbook.

Read
Sample: Logistics Freight Cost Model

Case Study

Sample: Logistics Freight Cost Model

Sample project - a multi-modal 3PL freight cost model in Excel with per-lane costing scenario analysis and contract pricing.

Read

Engagement standards

How every FormulaSurge engagement is run.

The same six rules on every project - from a quick formula fix to a multi-store retail dashboard.