The Pricing Meeting That Went Sideways: A Case of Mixing Costs From Three Years
Why your profit margin is a hallucination if your cost inputs are hard-coded from 2022. We rebuild unit economics with time-stamps and sensitivity tables.
The Ghost in the Formula Bar
Come, lean in closer to the screen. I want you to look at cell C12.
The label says “Net Margin.” The cell is glowing green. The value is 35%. The CEO is smiling. The Sales Director is nodding. Everyone feels safe.
But now, let us perform an autopsy. Click on the cell. Look at the formula bar.
= (Price - 14.50) / Price
Do you see the $14.50? That is not a variable. That is a tombstone.
I asked, “Where did the 14.50 come from?” Silence. Finally, someone whispered, “I think Dave calculated that in 2022.”
The Lie: The spreadsheet is presenting a confident reality where shipping, materials, and labor still cost what they did three years ago. It is flattening time. It is telling us we are profitable, when in reality, the current cost is likely $18.00, and we are actually bleeding cash on every unit sold.
The Truth: A static number in a financial model is a lie waiting to be discovered. Costs are not rocks; they are fluids. They move. If our model does not move with them, we are navigating with a map of a city that has burned down.
Timestamp Your Assumptions
We must perform surgery on this sheet. We never, ever type a number inside a formula.
We create a new tab called INPUTS_2025.
Every assumption gets a row. And crucially, every assumption gets a “Last Updated” column.
| Variable | Value | Source | Last Updated |
|---|---|---|---|
| Container Shipping | $4,200 | Maersk Quote | 2025-08-15 |
| Labor / Hour | $22.50 | HR Payroll | 2025-08-01 |
| Material Loss % | 5.0% | Q2 Audit | 2025-06-30 |
Now, link your model to these cells. If you open this sheet and see a date from 2023, you know instantly that the model is expired. The date is the freshness seal. If the seal is broken, do not eat the data.
The Sensitivity Table
Now that we have the truth, we must test its strength. We do not guess the future; we stress-test the present.
We will build a Data Table (What-If Analysis) to see how fragile we are.
[TO EDITOR: Illustration needed. A Data Table Grid. Rows are “Cost Increase %”. Columns are “Price”. The cells show the resulting Margin %. Use conditional formatting: Green for positive, Red for negative. Show the “Red Zone” creeping in as costs rise just 5%.]
Look at the table. If our costs rise by just 10%—a very real possibility—our beautiful 35% margin vanishes into single digits. The static number said we were invincible. The sensitivity table says we are fragile.
We leave the meeting not with a celebration, but with a mission: Update the inputs. Verify the dates. Only then do we set the price.
FAQs
Why is hard-coding bad if the number is correct?
Because the number is only correct for a specific second in time. As soon as you type it, it begins to rot.
How do I spot this error?
Press `Ctrl + ~` (Show Formulas). If you see numbers mixed with math, you are looking at a liability.
What is a sensitivity table?
It is a way to ask 'What if?' repeatedly without breaking your model. It shows the safety zone.