Prompt Details
Model
Chat - (gpt-5.6)
Token size
572
Example input
[Product SKU Profile and Retail Pricing]: Vitamin C Facial Brightening Serum (30ml glass dropper). Retail selling price: $48.00 per unit. Direct Shopify checkout. Average order quantity: 1.0 unit.
[COGS and Landed Manufacturing Costs]: Landed COGS: $4.50 per unit (comprising $2.10 formulation and glass bottle, $0.60 dropper assembly, $0.40 printed carton, and $1.40 ocean freight and import tariffs).
[Fulfillment Pick Pack and Shipping Expenses]: 3PL pick and pack fee: $3.20. Outbound USPS Ground Advantage postage: $4.80. Custom branded corrugated mailer box and tissue: $0.60. Total variable fulfillment: $8.60 per order.
[Ad Spend Attribution and Merchant Fees]: Blended Meta Ads Cost Per Acquisition (CPA): $18.50. Shopify Payments processing fee (2.9% + $0.30): $1.69. Return and damage reserve allocation (2.0% refund rate): $0.96. Post-purchase support allocation: $1.00.
Example output
### 1. Contribution Margin Waterfall Breakdown Table
| Tier | P&L Component | Dollar Amount | % of Gross Revenue |
| :--- | :--- | :--- | :--- |
| **Revenue** | Gross Selling Price | $48.00 | 100.0% |
| **Cost of Goods** | Landed Unit COGS | -$4.50 | -9.4% |
| **CM1** | **Gross Product Margin** | **$43.50** | **90.6%** |
| **Variable Ops** | Fulfillment & Outbound Postage | -$8.60 | -17.9% |
| **Merchant Fees** | Shopify Payments (2.9% + $0.30) | -$1.69 | -3.5% |
| **CM2** | **Fulfillment Net Margin** | **$33.21** | **69.2%** |
| **Marketing** | Meta Ads Blended CPA | -$18.50 | -38.5% |
| **Return Reserve** | Damaged Goods & Refund Allowance | -$0.96 | -2.0% |
| **Customer Care** | Post-Purchase Support Allocation | -$1.00 | -2.1% |
| **CM3** | **Net Contribution Margin** | **$12.75** | **26.6%** |
---
### 2. Unit Economics & Paid Acquisition Viability Matrix
* **Pre-Ad Margin Pool:** $31.25 ($33.21 CM2 minus $1.96 return/support reserve).
* **Break-Even CPA:** **$31.25** (Maximum allowable acquisition spend before net transaction loss).
* **Break-Even ROAS:** **1.54x** ($48.00 Retail / $31.25 Break-Even CPA).
* **Current Performance ROAS:** **2.59x** ($48.00 Retail / $18.50 Actual CPA).
* **Ad Spend Safety Margin:** 40.8% buffer before ad fatigue triggers transaction losses.
---
### 3. Operational Profit Drag & Margin Vulnerability Diagnostic
* **Advertising Concentration:** At 38.5% of gross revenue, Meta Ads represents the largest single cost driver. A 20% spike in auction CPMs reduces CM3 down to $9.05 (18.9%).
* **Postage Weight Inefficiency:** Outbound postage ($4.80) exceeds landed manufacturing cost ($4.50), indicating that single-unit orders bear disproportionate shipping expense relative to weight.
---
### 4. Profit Optimization & Capital Scaling Playbook
1. **Two-Pack Bundle Anchoring:** Offer a dual-pack bundle at $84.00 ($42.00/unit). Postage remains identical ($4.80), diluting shipping costs from 10.0% to 5.7% of revenue and expanding CM3 to 34.2%.
2. **Subscription Conversion:** Introduce an auto-replenish delivery cycle offering 15% discount. Recurring orders eliminate the $18.50 acquisition CPA, generating $27.00+ net margin per replenishment.
3. **Threshold Shipping Upsell:** Institute a $50.00 free shipping minimum to incentivize adding an auxiliary lip balm or cleansing pad, increasing average order value past the fixed postage tier.
4. **Transit Packaging Consolidation:** Transition from rigid corrugated mailer boxes to padded kraft mailers to lower packaging unit costs by $0.35 and trim dimensional shipping fees.
Get this prompt + 9 more with Select$14 your first month, then $19/mo$14 first month, then $19/mo
View Select
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
4
Views
GPT-5.6
Model true SKU-level profitability, blended contribution margins, and marketing break-even thresholds for direct-to-consumer stores. Built for e-commerce founders, media buyers, and financial analysts seeking to audit ad spend efficiency, fulfillment fees, and return drag. Generates contribution waterfall tables, SKU profitability scorecards, and ad spend scaling limits.
...more
Added 3 weeks ago
