Subscription Plan Breakeven

Dropbox: Find each subscription plan's breakeven subscriber count and how profit scales.

Assignment

The subscriptions team has exported the latest figures for each subscription plan and wants a quick analysis before deciding which plans to keep, grow, or retire.

Deliverables

• The breakeven point for each plan (the number of subscribers it needs before it stops losing money).
• How each plan's profit changes as its subscriber count grows.
• A short closing report for the subscriptions team: your recommendation for any plan that isn't working, plus anything they should double-check before relying on the numbers.

Data Description

dropbox_subscription_plans.csv has one row per subscription plan:

• plan_id
• plan_name
• segment - customer segment the plan targets
• fixed_costs - the plan's monthly fixed costs
• variable_cost_per_user - monthly cost per subscriber
• revenue_per_subscriber - monthly revenue per subscriber
• current_subscribers

Practicalities

You can solve this in Python, SQL, or a mix of both — StrataScratch notebooks support both languages in the same notebook.

Assume this data comes directly from the billing system and hasn't been cleaned, so review it carefully before relying on the numbers. When something looks off, work out what it is and decide how to handle it; when a definition or a final decision is genuinely ambiguous, choose a reasonable option and explain why. There's often more than one valid way to compute a result, so explain the approach you take and the reasoning behind your choices.

What's assessed: your results, and how clearly you explain what you see in the data and justify the choices you make.