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 may be $18.00, leaving far less unit margin than the sheet suggests.
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.
Use the same gross-margin calculation throughout: Margin = (Price - Unit Cost) / Price. This measures the margin after the unit cost in the model, not net profit after every business expense.
The old $14.50 cost at a stated 35% margin implies a price of about $22.31: 14.50 / (1 - 0.35). Use that rounded price as the reference below. Treat $18.00 as the current-cost assumption to verify, not as a confirmed quote.
| Increase over assumed $18 cost | Unit cost | Margin at reference price $22.31 | Margin at illustrative price $18.00 |
|---|---|---|---|
| 0% | $18.00 | 19.32% | 0.00% |
| 5% | $18.90 | 15.28% | −5.00% |
| 10% | $19.80 | 11.25% | −10.00% |
The $18.00 price column is an additional break-even-price scenario, not the article’s stated selling price. Negative cells identify the loss zone for that scenario. All margins use the displayed prices and are rounded to two decimals.
Look at the table. If the assumed $18.00 current cost rises by 10%, the reference-price margin falls to about 11.25%. That is much narrower than the old 35% figure. 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.