Model the full CPG retail margin waterfall—from $9.99 MSRP down through 45% retailer margin, 22% UNFI/KeHE distributor markup, 5% broker commission, free-fill cases, and per-SKU slotting fees—100% locally in your browser without a $249/month trade-spend platform.
Instant 50ms preview directly in your browser. Zero server queues, zero data leaks.
Drop Local File Here or Click to Browse
Supports CSV, JSON, TXT, XML & Log Streams
=SUMIFS(retail_gross, SKU, A2) - VLOOKUP(A2, retail_fees!A:D, 4, FALSE)⚠️ Why Manual Formulas Fail at Scale: Manual spreadsheet formulas break on multi-row retail store adjustments, tiered fees, and CSV delimiter shifts.
🛡️ Zero-Upload Local Studio Advantage: Run Retail Store calculations and CSV checks 100% locally in your browser.
Core capabilities built into ShelfSlotROI Studio
When a retailer takes a 45% margin ($5.50) and a distributor takes 22% off that ($4.29), adding a 5% broker fee and 14% trade spend leaves just $3.48 to cover manufacturing COGS, freight, and profit.
Giving 400 stores 1 free 12-unit case costs you $1.85 × 4,800 units ($8,880 in raw COGS) plus distributor MCB chargebacks often billed on the wholesale list price rather than your cost.
If a retail buyer requires 3.5 UPSW to keep your SKU on the shelf after a 6-month review, our engine calculates whether your velocity pays back upfront slotting before reset day.
Run your retail line-review pricing and distributor deduction math inside your browser with zero ERP integrations or monthly subscriptions.
Zero configuration, zero cloud server dependencies, instant execution.
Input your shelf retail price, landed unit COGS, case pack size, retailer margin %, distributor margin %, and broker commission.
Slide trade-spend deductions from 5% to 30% to model MCB chargebacks, scan-backs, and upfront slotting investments across store doors.
Unlock the full CPG margin waterfall table, free-fill MCB chargeback protector, and UPSW break-even calendar for a one-time $19 buyout.
See why merchants and prosumers switch from monthly subscriptions to our local buyout.
| Feature / Metric | 🛡️ ShelfSlotROI Studio | ☁️ Cloud SaaS (Vividly) |
|---|---|---|
| Pricing Structure | 🛡️ $19 One-Time Buyout (€3.99 Quick Pass) | ☁️ $249 to $799/month trade-promotion SaaS |
| Full MSRP-to-Pocket Margin Waterfall | 🛡️ Models Retail + Dist + Broker + Trade + COGS | ☁️ Requires complex ERP setup before running basic math |
| Free-Fill MCB Chargeback Warning | 🛡️ Calculates wholesale-billed MCB vs. raw COGS cost | ☁️ Does not warn first-time founders about MCB markups |
| Pricing & COGS Confidentiality | 🛡️ 100% Local Browser Execution (Zero Cloud Sync) | ☁️ Stores your wholesale rate cards on external servers |
Eliminate vendor lock-in and cloud upload security risks.
Why pay recurring monthly SaaS fees for retail store workflows? Switch to ShelfSlotROI Studio for a single $19 buyout.
Vividly syncs your data to remote servers. We process 100% locally on your machine.
Process multi-row retail store files instantly without broken VLOOKUP/SUMIFS formulas.
Deep technical breakdown driving our client-side productivity engine.
Processes ShelfSlotROI Studio structures directly inside isolated browser memory.
Ensures zero ShelfSlotROI Studio bytes touch external API servers or third-party storage.
Parses high-throughput ShelfSlotROI Studio records in real-time with sub-50ms response times.
Complete commercial data sovereignty with standalone offline capability.
No monthly bills. No sneaky price hikes. Pay once, use forever.
Live Local Studio Preview
Prosumer & Solo Professional
One-Off Emergency Unlock & Trial
Everything you need to know about privacy, local memory execution, and buyouts.
They compound sequentially down from MSRP. On a $10.00 MSRP with a 45% retailer margin, the retailer pays the distributor $5.50. If the distributor takes a 22% margin, they pay your brand $4.29—before broker fees or trade spend.
When you ship through a distributor, the distributor still buys the case from you and bills you back via a Manufacturer Chargeback (MCB) at the wholesale price PLUS a 10%–15% handling fee—turning a $20 COGS case into a $58 invoice deduction.
Most retail brands must budget 12% to 20% of gross wholesale revenue for trade spend (including temporary price reductions, scan-backs, distributor shows, and spoilage allowances).
UPSW stands for Units Per Store Per Week (also called velocity). Retailers track dollar velocity per linear foot; if your UPSW falls below category benchmarks during the 6-month category review, you get delisted before recovering your slotting fee.
Never. All margin waterfall and slotting payback calculations run 100% locally in your browser.
You get lifetime access to the CPG retail margin waterfall builder, Free-Fill vs. Cash Slotting comparator, UPSW velocity payback engine, and CSV export.