<aside> 🛡️
+10% Revenue Per Visitor in 90 days. Or we refund the engagement. Book a teardown
</aside>
Three back-office jobs Claude can run end to end: model the P&L, triage the support queue, and get your store cited by the AI engines people now ask before Google. Each one is "Claude + a connector = an outcome that used to need a hire."
These are the unglamorous parts of a DTC operation. Nobody posts about their 13-week cash forecast. They are also the jobs where AI quietly saves the most hours, because the work is structured and repetitive and sits on data you already have. In customer service and answer-engine optimization, every vendor quotes you the ceiling number. The honest floor is next to it on every line.
The stack: Claude (spreadsheet skills) plus your P&L export plus SKU-level COGS. No special connector needed. You upload the files, Claude builds the model.
Operators report a 13-week cash forecast dropping from roughly 4 hours to roughly 40 minutes. AI does not invent finance. It takes the grunt work of cohorting margins, building scenarios, and rebuilding the model every time an assumption changes off your afternoon.
Who it is for: any founder or operator who runs the P&L in a spreadsheet by hand and dreads forecast season. The manual loop this kills is copying last quarter's model, hand-editing every assumption, then praying you did not break a formula.
Attached: our P&L (12 months) and SKU-level COGS. Build:
1. Contribution margin by SKU, by channel, and by customer cohort.
2. A 13-week cash-flow forecast with three scenarios: base, -20% revenue, +30% ad spend.
3. A sensitivity table showing how contribution margin moves with CAC and AOV.
Output as an Excel model with the assumptions on a separate tab so I can change them.
Then flag the 3 numbers I should worry about most and why.
<aside> ✅
Steal this: the "assumptions on a separate tab" line turns a static report into a model you can drive. Change one cell, watch the forecast move. Demand it on every financial model you ask Claude to build.
</aside>
Ask Claude to grade your numbers against these and tell you which lever (AOV, COGS, CAC, repeat rate) would move the P&L most.
| Metric | Healthy benchmark | Context |
|---|---|---|
| Contribution margin | Above 35% | Median DTC sits nearer 25% |
| LTV:CAC | Between 3:1 and 5:1 | Below 3:1 you are buying growth you can't keep. Above 5:1 you are probably under-spending |
| CAC payback | Under 90 days | The cash-flow killer once it creeps past a quarter |
Follow-up prompt that earns its keep: "Of AOV, COGS, CAC, and repeat rate, which single lever moves my contribution margin the most at current volumes? Quantify the impact of a 10% improvement in each."