Free — no signup required

Introduction: Why Excel Fails in the Cloud

2 min read

The Static Trap

Think of how a restaurant forecasts food costs. They know roughly how many covers they'll serve each night, the cost of each ingredient, and the menu prices. The math is mostly linear. Cloud infrastructure is nothing like this.

In the old data center world, forecasting was similarly straightforward:
* Manager: "We need 10 new servers next year."
* Finance: "Okay, that's $50,000. Approved."
* Variance: $0. (You bought exactly 10 servers.)

In the cloud, infrastructure is elastic. Auto-scaling groups expand and contract every minute. Spot prices fluctuate. Usage spikes when a marketing email goes out at 9 AM and collapses by midnight. A single viral social media post can triple your compute bill for six hours.

Trying to forecast cloud spend using a static linear projection — "We spent $10k last month, so we'll spend $10k next month" — is a recipe for disaster. You will either dramatically over-budget (tying up capital that could fund engineering) or under-budget (triggering emergency CFO conversations mid-quarter).

Probabilistic Forecasting

Modern FinOps requires Probabilistic Forecasting. Instead of predicting a single number ("We will spend $100k"), you predict a range of outcomes with associated probabilities ("There is a 90% chance we spend between $95k and $110k, and a 5% chance we exceed $130k").

This is not a hedge or an excuse for imprecision. It is a more honest and more useful representation of reality. A single-number forecast implies certainty that does not exist. A probabilistic forecast communicates both the expected outcome and the risk envelope around it — which is exactly what a CFO needs to make capital allocation decisions.

The two core inputs to probabilistic forecasting are:
- Historical usage data: What did we actually consume, and how variable was it?
- Forward-looking assumptions: What business events (product launches, marketing campaigns, seasonal peaks) will change that baseline?

Interview Tip

Interviewers often ask: "How do you forecast cloud costs for a new product with no historical data?" The answer is: you decompose the product into its infrastructure primitives (compute hours, storage GB, API calls), estimate ranges for each based on comparable products or load tests, and run a Monte Carlo simulation across those ranges. You never say "we can't forecast it" — you say "here is our model and here are its assumptions."

Key Point: Probabilistic forecasting replaces false precision with confidence intervals. The goal is not to predict the future exactly — it is to bound the uncertainty so the business can make informed decisions about how much risk to accept.

This is one of 18 chapters

Every chapter is free — Kubernetes, Terraform, SRE, distributed systems, and more — with fast daily review built in.

Sign up free