You're a SaaS operations analyst preparing this month's invoicing. Columns A–C contain 8 customers, their seat counts, and their plan tier.
Your task:
- In column D (Total Cost), compute each customer's monthly cost: look up their tier's per-seat price, then multiply by seat count.
Use this pricing table (build it on the sheet, or use inline arrays in your formula):
- Starter → $10 / seat
- Pro → $25 / seat
- Business → $50 / seat
- Enterprise → $100 / seat
Graded cells: D2, D6, D9.
Open this problem on a desktop to attempt it.