Product Pricing Template for Small Business
Three documents and four sheets, including the price sensitivity your own sales history already measured and the break-even volume loss per SKU.
Free download · No account needed
Price Sensitivity
[Business] — what your own price changes already measured
One row per price change you have made. Not a forecast and not an industry figure. The response your own customers gave the last time you moved this price, which is the column every other pricing template leaves blank.
| SKU | Changed | From | To | Units before | Units after | Elasticity | Status |
|---|---|---|---|---|---|---|---|
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | — | — |
| — | — | — | — | — | — | unknown | never repriced |
| — | — | — | — | — | — | rejected | promotion ran in the same window |
The Status column is the point of the sheet. A change that ran alongside a promotion, a new account opening or a stockout is kept and marked rather than deleted, because a supply limit in the volume data looks exactly like price sensitivity and means the opposite.
A SKU with no price history reads unknown and gets a designed test. Borrowing an industry elasticity would fill the column in and make every measured number beside it worthless.
Every page that ranks for this query answers it the same way. Add up your costs, choose a markup or a target margin, look at what competitors charge, then adjust for what the market will bear. None of that is wrong. It is silent on the only question that decides whether a price change works, which is how much volume the increase will cost you and whether the margin can absorb the loss. That question has an answer, and for most businesses it is already sitting unread in the sales export.
Ninebark Coffee Roasters, invented for this page, sells nine coffee lines for $65,309 a month at a 42.8 per cent blended contribution margin. Five of the nine have been repriced before with usable volume either side, so each of those has a measured response: minus 2.40 on cold brew concentrate, minus 0.26 on wholesale house blend. That is a factor of nine across one price list in one business. No single percentage can be right for a book that behaves that differently.
The instinct was eight per cent on everything. Run through each line's own numbers, that lifts contribution 9.3 per cent and destroys contribution on three products, because they shed more volume than their margin can carry. Those three cost $1,582 a year and no monthly report would separate them from the gain. Priced per line instead, operating profit goes from $3,143 to $6,807, three prices hold, and the note to customers covers a shorter list.
What's in the pack
Cost and Margin Model sheet
What one unit costs, itemised down to green coffee at yield, direct labour, packaging, fulfilment and payment fees, then contribution in dollars and as a percentage. Fixed costs are deliberately excluded, so the number stays a decision input rather than an allocation argument. Fixed cost as a share of revenue becomes a line across the price list instead, and every SKU below it is flagged. On the worked example that line is 38.0 per cent and three wholesale products fall under it, at 36.4, 35.8 and 21.4.
Price Sensitivity sheet
Every price change already in your sales history, turned into an arc elasticity for that SKU. This is the sheet nothing else in the category has, because it is the only one built from what your own customers did rather than from a benchmark. Contaminated observations stay in the sheet with the reason attached, and a SKU that has never been repriced reads unknown rather than being filled in with a borrowed figure.
Scenario Impact sheet
Two numbers per SKU. The break-even volume loss the increase can absorb, which needs only the contribution margin and so exists for every product. And the loss the measured elasticity predicts, which exists only where there is history. The gap between them is the verdict, and it turns a price rise from a question of nerve into a question of arithmetic. If you quote jobs rather than run a price list, the same question lives in the service quoting pack.
Competitor Comparison sheet
Read from live pricing pages with the date captured, then normalised to a comparable unit before anything is compared, which is where an eyeball comparison usually goes wrong. On the worked example a rival's 10 oz bag at $19.00 reads as a modest premium on the shelf and is $22.80 on a 12 oz basis. The wider read on those same rivals, including what their customers say in public, is the competitor and market scan.
Pricing Rationale
The internal document holding the reasoning behind every number on the new list, so that when a price is questioned in six months the answer is not "costs went up". It records the readings that needed judgement rather than arithmetic. On this example there are two: the most price-sensitive product should not move at all, and an elasticity inside 1 has no interior optimum, so the textbook formula's answer there is wrong rather than surprising.
Change Plan
What moves, by how much, and on what date. Then the specific places a stale price survives a change: the variant under the product page, the saved favourites on the till, the wholesale list on each open account, the marketplace listing, and the unaccepted quotes already out. It also states the expected response per SKU before the change goes out, with the number at which to stop, so the result cannot be reinterpreted afterwards.
Customer Communication
The short notes that actually go out, one per affected group, giving the notice period the agreement requires rather than the one you remember. It settles the exception rule in advance too, because a discount given because somebody asked is a discount everyone learns to ask for. Reasoning belongs in the rationale document and not in the note: a message that argues the case invites the case to be argued.
How it works
- 1
Send the export
A sales export going back far enough to cover your last price change, with units by month, plus whatever you have on unit costs and your monthly fixed costs. Rough cost figures are fine to start with. Which components exist matters more on day one than whether each one is precise.
- 2
Cost one unit all the way down
Materials at yield, direct labour, packaging, fulfilment, payment fees. Then fixed costs divided by revenue, drawn as a line across the price list. Every SKU below that line is not covering its share of the overhead, which is usually the first real surprise and a better opening than any conversation about strategy. It is the same unit-economics move the owner financial dashboard makes at the whole-business level.
- 3
Find the price changes you forgot you made
Owners consistently undercount these, because a supplier increase passed straight through and a shipping threshold moving do not feel like price changes. Each one with comparable volume either side becomes an elasticity. Each one that ran alongside a promotion, a new account or a stockout is marked and kept rather than deleted.
- 4
Decide per SKU, then write it down
The break-even volume loss needs only the margin, so it exists for everything, and it is computed at the new unit cost because a percentage payment fee rises with the price. Hold what cannot absorb an increase, take more where the measured response says there is room, and design a test with a stated stop rule where there is no history. Then the rationale, the change plan and the customer note.
Frequently asked questions
What if I have never changed a price, so there is no history to measure?
Then the elasticity column says unknown and the plan becomes a test programme rather than a projection. The break-even volume loss still exists for every SKU, because it needs only the contribution margin, and it is often enough on its own. Filling the elasticity in from an industry figure would make the sheet look finished and make every measured number beside it worthless.
How many past price changes do I need for this to be worth doing?
One usable observation per SKU is enough to change a decision, and it is one more than the zero every other pricing template works from. On the worked example five of nine SKUs have one. Treat a single observation as a direction rather than a precise coefficient, which is why the plan takes a 16 per cent rise in two steps and re-measures between them.
The competitor comparison says I am cheap and my own history says hold. Which wins?
The history. A shelf comparison is evidence about a market, and an elasticity is evidence about the people who actually buy from you. On the worked example the median competitor sits 9.4 per cent above Ninebark's house blend per ounce. The plan still holds that price at $16.00, because its measured response says an increase would cost more volume than the margin can carry.
Can I show the old price beside the new one so the increase looks modest?
Be careful. Under the federal guides against deceptive pricing, a former price used in a comparison has to be one the product was actually offered at, openly and on a regular basis, for a reasonably substantial period. Where a price is not changing, say so plainly rather than presenting it as a saving against the new list.
Can I charge two wholesale accounts different prices for the same product?
Where they compete with each other, the differential has to trace to something real. The federal price discrimination statute permits differences that make due allowance for differences in the cost of manufacture, sale, or delivery arising from the methods or quantities involved. That is what the cost model gives you, and it is why the volume threshold in the change plan gets written down.
My costs went up. Is that not the whole answer?
It tells you the floor moved, not where the price should land. Two SKUs facing the same cost increase can need opposite decisions, and on this example they do. Cost gives you the break-even, and the measured response decides whether you can reach it. Where the tier boundaries fall is a separate question, handled in offer and packaging design.
How do I know a volume drop after a change was the price and not something else?
Often you cannot, which is why the sheet keeps a Status column instead of a clean one. Any window carrying a promotion, a new account or a supply cap is marked and excluded. Customers who stopped buying altogether are a different question, answered in the churn and lapse review, because a lapse pattern is not a price response.
Find out how much volume your next price rise can afford to lose
Download the blank pack as Word and CSV files, or open it in River, send a sales export and your unit costs, and get the break-even per SKU back before any price is decided.
Edit with AI