Cost Modeling Formulas for CFO Reporting
Cost Modeling Formulas for CFO Reporting
AdminFollow
5 min•Feb 28, 2026
Views - 17
? Storage Cost
Storage Cost = Active TB × $ per TB per month
Separate:
Active storage
Long-term storage
? Compute Cost (On-Demand)
Query Cost = Data Scanned (TB) × $ per TB
? Compute Cost (Reservations)
Monthly Cost = Slots × Hourly Price × 24 × 30
If autoscaling:
Total = Baseline Commitment + Autoscaled Slot Seconds
? Slot Efficiency Metric
Slot Efficiency = (Total Slot-ms Used) / (Committed Slot-ms Available)
Low efficiency = overprovisioned.
? Cost Per Dashboard Query
Cost per Query =
(Query Slot-ms × Slot Price per ms)
(Query Slot-ms × Slot Price per ms)
? Cost Per Event
For PB event system:
Total Monthly Cost / Total Events Processed
This is a powerful CFO metric.
? Enterprise KPI Dashboard
Track:
Cost per TB scanned
Slot utilization %
Cost per user
Cost per dashboard
Cost per pipeline
Storage growth rate
Shuffle bytes per query
? Executive-Level Summary
At PB scale:
Skew is enemy #1
Shuffle dominates cost
Fair scheduling protects cluster
Reservations protect workload
Denormalization saves millions
Region planning prevents egress shock
CFO metrics must tie cost → business KPI
Comments (0)
No comments yet.