You do not need a spreadsheet wizard. You need four numbers.
| Number | Where to find it |
|---|---|
| A. AI requests per user per month | Estimate from how people use your product. Start with a guess, then replace it with real data. |
| B. Average cost per request | Your AI provider's usage page. Includes both what you send and what comes back. |
| C. Other cost per user | Hosting, database, email, storage, payment fees. Divide the monthly bill by active users. |
| D. What one user pays you | Your price, minus payment fees. |
Cost per user = (A x B) + C
Compare it with D. If cost is near or above D, you do not have a pricing plan yet; you have a hobby with a bill.
Worked example (made-up numbers for illustration)
A user makes 200 AI requests a month at $0.01 each: $2.00. Other costs add $0.50. Cost per user: $2.50. If the plan costs $9 per month and payment fees take $0.57, you keep about $8.43 and your margin is healthy. If the plan costs $3, you are close to losing money on every active user.
Then test it: what happens to your margin if usage doubles? If one heavy user makes 2,000 requests? These 'what if' cases are where most surprises live.
Three ways to lower the number:
- Use cheaper models: for simple classifications, summarizations, or routing.
- Cache repeated answers: avoid re-running identical prompts.
- Send less text each time: trim prompt bloat and redundant context windows.