Learn & Understand

Budget Variance and the Sunk Cost Trap

In a hurry? Skip straight to the numbers.

Open the Project Budget Variance Calculator →

The budget variance calculator delivers a clean verdict: actual minus planned, over budget or under. The arithmetic is simple accounting, inherited from the standard-cost systems that manufacturers built a century ago to compare what production should have cost against what it did. But the moment a variance turns red, the calculation collides with one of the most stubborn errors in human judgment, the sunk cost fallacy, and how a manager reacts matters far more than the number itself.

Variance as an Inheritance From the Factory Floor

The idea of comparing actual against a pre-set standard did not originate in software or construction; it came from industrial cost accounting, where factories set a "standard cost" for a unit and then analyzed every deviation, material, labor, overhead, as a named variance. The project budget variance the calculator computes is a direct descendant: a planned figure, an actual figure, and the signed gap between them. The discipline is old and well-proven; the trap lies in what the gap tempts you to do.

The Sunk Cost Fallacy

When a project is running well over budget, the rational question is forward-looking: from here, is finishing worth the remaining cost? The fallacy is to answer with a backward-looking one: "we've already spent so much, we can't stop now." Money already spent is gone whether you continue or not, it is sunk, and it should carry zero weight in the decision about what to do next. Yet a large negative variance psychologically pulls people toward throwing good money after bad, precisely because the loss already booked feels unbearable to accept.

Two ways to read a large overrun
QuestionFocuses onLeads to
"We've spent so much already"Sunk, unrecoverable costEscalating commitment
"Is the remaining work worth its remaining cost?"Future cost vs future valueA rational decision

Why the Percentage Matters

The calculator expresses variance as a percentage as well as a dollar figure, and this is more than cosmetic. A raw overrun of a fixed amount is alarming on a small project and trivial on a huge one; the percentage normalizes the pain so projects of wildly different sizes can be judged on the same scale. It also strips away the emotional weight of a big absolute number, helping refocus attention on proportion rather than on the sheer size of the sunk figure.

Using Variance to Decide, Not to Grieve

The healthy use of a red variance is as a trigger for a fresh, forward-looking appraisal, not as a scoreboard of regret. It should prompt the question of whether the plan, the scope, or the project itself still makes sense given what remains to be spent. Read that way, the variance is an early alarm; read as a tally of loss, it becomes the very thing that keeps failing projects alive long past the point of reason.

For a fuller schedule-and-cost picture, use the Earned Value Calculator; to see how fast the remaining budget is disappearing, the Budget Burn Rate Calculator.

Ready to Put This Into Practice?

Now that you understand how it works, plug in your own numbers and get an instant, accurate result.

Use the Project Budget Variance Calculator Now →