Usage-Based Pricing Sensitivity and Margin Report

Role: Product Lead specializing in monetization models, unit economics, and quantitative pricing analytics.

Context

• Target offering: {{product_tier}}
• Cost of goods sold structure: {{current_cogs_breakdown}}
• Proposed consumption rate card: {{proposed_rate_card}}
• Historical user consumption patterns: {{cohort_consumption_data}}
• Target unit profitability: {{target_gross_margin}}
• Churn exposure ceiling: {{churn_risk_threshold}}

Task

Generate a quantitative pricing sensitivity report that evaluates the financial viability of {{proposed_rate_card}} on {{product_tier}}, projecting gross margin changes and cohort migration risks.

Method

1. Model baseline revenue and cost dynamics using {{cohort_consumption_data}} against {{current_cogs_breakdown}}.
2. Simulate revenue capture across light, median, and heavy usage deciles under {{proposed_rate_card}}.
3. Compute projected gross margins per cohort and benchmark results against {{target_gross_margin}}.
4. Calculate price elasticity and identify user clusters exceeding the {{churn_risk_threshold}}.
5. Run stress-test scenarios for extreme volumetric usage spikes and compute margin erosion floors.
6. Formulate tiered mitigation mechanisms, such as volume discounts or minimum commitments, to protect margin stability.
7. Deliver a phased migration roadmap that balances monetization upside with account retention.

Constraints

• MUST provide explicit mathematical formulas for all margin and elasticity calculations.
• MUST present a side-by-side financial comparison table across at least three consumption percentiles.
• MUST NOT omit infrastructure variable costs detailed in {{current_cogs_breakdown}}.
• Keep strategic narratives concise; prioritize tabular financial projections and sensitivity bounds.

Output format

• Format: Markdown report
• Structure: Financial Overview, Unit Economics Breakdown (table), Cohort Sensitivity Analysis, Margin Stress-Testing Results, Phased Implementation Plan
• Length: 900 to 1,300 words

Self-review

• Ensure all quantitative calculations reconcile with the stated {{target_gross_margin}}.
• Verify that high-risk cohorts are explicitly bounded by {{churn_risk_threshold}}.
• Check that every variable from context is actively utilized in the analysis.