The cost spreadsheet is accurate. The margin looks good on paper. And yet
even so, by the end of the month, the results fall short of what the numbers promised. This is
the most common symptom of a problem that almost no small business measures: the
gap between the calculated price and the price actually charged
charged to the customer.
This gap has a name—price accuracy—and it is not the same as
high margins. A company may have a generous margin on paper but poor pricing accuracy
terrible, because the price the salesperson actually charges at the counter, during negotiations, or in the
the end-of-month promotion is no longer the price calculated by the spreadsheet. And it may
be the opposite: a modest margin, but with such consistent accuracy that the
the company knows, month after month, exactly where each percentage point of
results.
Measuring this gap does not require a new system or a data department. It requires
use, consistently, figures that most companies already calculate and
stores somewhere—it just doesn't compare them.
What Price Accuracy Is—and What It Isn’t
Price accuracy measures how closely the price actually charged matches the
price indicated by the calculation before any discount, negotiation, or adjustment
at the last minute. It is not the same as margin or profitability: a sale may
be profitable and still end up far from what the calculation
original estimate predicted—whether higher or lower.
The two concepts are often confused because they both appear in the same
conversation: “our margin is good” tells you nothing about whether the price charged is the
price that should have been charged. A healthy margin may be hiding a
poor accuracy—for example, when a salesperson discounts one product and
offsets it by arbitrarily raising the price of another, and the average result for the month
looks healthy even as each individual sale drifts further from what made sense.
The three numbers already in the business
There’s no need to create a new metric to measure accuracy. Three figures that
any company with a well-organized cost sheet already has—or can obtain
calculate in an afternoon — are enough to build the comparison:
- Contribution margin: the selling price after taxes have been deducted,
minus that product’s variable costs and expenses. It is the amount left to
cover fixed costs and generate profit.
- Profit margin: the contribution margin minus costs and expenses
allocated fixed costs. This is the actual net profit per product or sale.
- Break-even point: fixed costs and expenses divided by the contribution margin
contribution margin. It is the minimum sales volume needed to sustain operations at that price.
Taken individually, these three indicators show how the price is
behaving today. What changes the game is comparing them with where they should be,
based on the original calculation—and track the difference, sale by sale or product by
product, rather than just looking at the monthly average.
What Real-World Research Revealed About This Gap
A FIPECAFI master’s study conducted by Edson Clementino da Silva
in 2023 directly tested what helps narrow this gap. Seventy
small business managers worked through the same pricing case,
divided into three scenarios with increasing levels of information: in the first, only the
product and market prices; in the second, fixed costs and expenses as well, and
variable costs; in the third, also a calculation and simulation spreadsheet.
The technically correct price in that case was R$263.29. Only the group with the
spreadsheet came close: an average of R$266.22, with a standard deviation of
R$3.93—the tightest distribution and highest accuracy of the three groups.
The other two groups, despite seeing the costs, made larger and more
variation among their estimates.
The study's practical conclusion is clear: simply seeing the cost does not guarantee
accuracy. What set the most accurate group apart from the others was not having more
information available—it was having a calculation tool that could turn
that information into a price. Understanding the cost is essential, but it is not enough on its own
enough.
Why information alone isn't enough
This explains a common pattern in small businesses: the manager who recognizes the
cost spreadsheet every month, knows the COGS of each product line by heart, and
still keeps charging prices that stray from what the spreadsheet itself
would suggest. The information is right there. What’s missing is the step between having the number and
turning it into a repeatable decision—a method that translates cost and margin
target margin and market conditions into a price every time, regardless of who
is behind the counter that day.
Without this method, each salesperson applies their own informal criteria for
discount, every promotion is decided in a rush, and these small decisions add up
decisions is what creates the gap between the calculated price and the actual price. The
The gap does not stem from bad intentions; it stems from the lack of a common standard.
How to set up measurement with what you already have
To start measuring accuracy without waiting for any new tools, three
steps are enough to get the essentials in order:
- Choose a product group—the highest-volume or highest-margin products—
and record the price that the desired contribution margin would indicate for
each one, before applying any discounts.
- At the end of each week, compare this calculated price with the average price
actually charged for that product, including discounts and negotiated prices.
- Separate the variance into two types: judgment variance (the salesperson decided
charge a different price based on their own judgment) and error variance (the cost sheet
was outdated). These are different problems that require different solutions.
After a few weeks of doing this, a pattern emerges: either the company has a
discipline problem in applying the price, or there is a problem with the
cost calculation that supports the price. These are opposite diagnoses, and confusing them
is the most common way to waste energy fixing the wrong thing.
A numerical example
A store sets a product’s price using a 40% markup on a cost of
R$ 120:
price = cost × (1 + markup) = R$ 120 × 1.40 = R$ 168.00
That is the price the calculation indicated. In practice, the store sold the product for
on average, for R$ 150.00 that month—with discounts applied on a case-by-case basis. The difference
the difference between the calculated price and the actual price charged is:
variance = (R$ 168.00 − R$ 150.00) ÷ R$ 168.00 = 10.7%
That 10.7% does not appear in any average margin report because the store
remains profitable. But they show that, for every unit of that product sold,
product, the company is giving up a portion of what its own calculations
believed was the right price to charge—and multiplied across hundreds of sales each month,
makes the difference between a predictable outcome and one that can only be explained
after the month has already closed. The selling price calculator helps you revisit this
calculation quickly for any product, before deciding whether the discount
being applied still makes sense.
What Accuracy Really Measures
Pricing accuracy is not a higher-margin target, nor is it an indicator of
how “high” or “low” the price is. It is a measure of consistency: how closely
the price the customer sees matches the price the company, using its own
figures, decided it should be. A company may choose low margins
as a strategic choice and still achieve high accuracy because it applies exactly the target margin
it chose to apply. The problem isn't the price level—it's the gap between
what was decided and what was actually implemented. Closing that gap is, first and foremost,
anything else, a matter of method: measure, compare, and repeat the comparison
regularly, until the variance is no longer a surprise and becomes
information.
