
Build a pricing calculator that models per-user plus consumption revenue for your AI product
You'll have a working spreadsheet or simple script that shows how blended pricing (fixed seat + usage overage) changes your MRR, churn risk, and customer LTV compared to your current model.
What you'll make
AI Product Pricing Calculator
- calculate_revenue() — the core pricing logic comparing current vs hybrid models: what to include
- segment_customers() — usage pattern analysis and breakeven identification: what to include
- scenario_analysis() — stress testing pricing changes against growth assumptions: what to include
- main() — orchestration with real customer data input: what to include
Paste your working script that takes customer usage data and outputs revenue comparisons
The 3 parts
Each part ends with a check you can see.
Map Your Current Revenue Reality
Analyze your existing customer base to understand usage patterns and revenue distribution before modeling changes.
Done when
You have customer segments based on actual usage data with revenue per segment and identified outliers who break your current pricing assumptions.
Design Your Hybrid Pricing Structure
Create a per-user + consumption pricing model that balances revenue predictability with usage fairness.
Done when
You have a specific hybrid pricing formula with base price, consumption tiers, and overage rates that addresses your biggest current pricing problems.
Build and Test Your Pricing Calculator
Code a working calculator that compares revenue, customer profitability, and business metrics across pricing models.
Done when
You have a working script that takes customer data and outputs revenue projections, with at least 3 scenario tests showing how pricing changes affect your business.
Capstone: you put together your AI Product Pricing Calculator.
Where this helps
An elective: a single lesson that sits outside rtwo's job certificates and doesn't count toward one.
About this lesson
What you'll be able to do
- Run a working pricing calculator that models your current revenue vs per-user + consumption hybrid pricing
- Identify the exact breakeven points where customers switch from profitable to unprofitable under each model
- Have concrete numbers for how pricing changes affect customer acquisition cost and lifetime value
- Know which customer segments benefit vs get hurt by consumption pricing
Who it's for
- AI product founders trying to figure out sustainable pricing as usage patterns emerge
- Product managers at AI companies who need to model revenue impact before changing pricing
- Anyone building usage-based products who wants to understand the math before committing
What it won't cover
- Payment processing implementation or billing system setup
- Competitor pricing analysis or market positioning strategy
- Customer psychology or willingness-to-pay research
- Enterprise contract negotiation tactics
Skills you'll practise
- Revenue scenario modeling
- Breakeven analysis with multiple variables
- Customer segmentation by usage patterns
- Pricing sensitivity calculation