DecisionKits
Wholesale vs DTC Profit Simulator
Wholesale vs DTC Profit Simulator
- One-off payment & lifetime use
Couldn't load pickup availability
Should you sell more DTC, on marketplaces or wholesale?
Wholesale moves volume but earns less per unit and pays late; DTC earns more but gets more expensive to grow. This template compares the economics of each channel and finds the mix that earns the most — and how much cash each one ties up.
What you can do with it
- Compare net revenue, gross margin and contribution per unit by channel
- Test every DTC share from 0% to 100% and find the most profitable mix
- See how much cash is waiting to be paid in each channel
- Check a wholesale price before you sign a new stockist
What's inside
- Excel template (v5) with 3 tabs: Inputs · Dashboard · How to Use — sample data included so you see a finished example first
- README (step-by-step setup) and Why This Tool Matters guide
- Single-company license · works in Microsoft Excel 2019 or later and Microsoft 365
One-time purchase, instant download. Questions? info@decisionkits.com
Share
WHAT IT SOLVES
WHAT IT SOLVES
Wholesale moves volume but earns less per unit and pays late; DTC earns more but gets more expensive to grow. This template compares the economics of each channel, finds the mix that earns the most and shows how much cash each one ties up, so you can decide before you sign a new stockist.
WHAT YOU GET
WHAT YOU GET
You get a ZIP file, ready to use:
The Excel template (v5) with 3 tabs — Inputs, Dashboard and How to Use — and sample data, so you see a finished example first
A README with step-by-step setup
The Why This Tool Matters guide
A license for single-company use
Works in Microsoft Excel 2019 or later and Microsoft 365.
HOW IT WORKS
HOW IT WORKS
After checkout you get an instant download and an email with your ZIP file.
Open the Excel file and look at the finished example. Then, in the Inputs tab, replace the sample data with price, costs, fees and payment terms for DTC, marketplace and wholesale.
The Dashboard updates on its own: net revenue, gross margin and contribution per unit by channel, every DTC share from 0% to 100% with the most profitable mix, and the cash waiting to be paid in each channel.
I use it to report margins for my client accounts. Great structure, accurate formulas.