← Back to Stories

Story · Solution

The owner sees which prices costs have overtaken, before margin goes

Green coffee keeps getting dearer, but our prices have not moved.

Sound familiar?

Our costs keep rising but our prices have not, and I cannot say which products now earn too little.

Why it hurts

I own a small coffee roaster with a wholesale side. Green coffee keeps getting dearer, but our prices have not moved. I suspect some products now earn far less than they did, but I cannot say which, or by how much, and I have no way to tell what a price rise would do to sales.

How it is solved

Know which products have lost margin and why, which ones sit below a safe floor, and what a price change would likely do, before deciding on any new price.

  1. The owner sees each product's margin now and a year ago. The app uses the product's price and its unit cost at each point, so a product whose price has not moved while its cost has risen shows the fall in margin plainly.
  2. The owner sees the cost change behind a drop. A drop in margin is shown with its cause, such as a rise in the price of green coffee on the suppliers' bills.
  3. The owner sees products below the floor flagged as facts, not advice. A product earning less than the business's margin floor is flagged for the owner to weigh.
  4. The owner is never shown a margin the app cannot compute. A service with no cost recorded, such as a training workshop or a machine service visit, is shown as cost not recorded, never as a full margin.
  5. The owner sees the business set beside its industry. The blended margin is shown beside the usual ranges for coffee roasters and food manufacturers, and for retail food.
  6. The owner sees three price scenarios, worked out from what customers actually did. Where a product's price has changed before, the app uses how its sales responded. For products whose price has never changed, it uses stated assumptions.
  7. The owner approves any price message. If the owner decides to change a price, the message to customers waits for approval before it goes anywhere.

Works with

QuickBooks

The result

A margin summary at month-end: each product's margin against a year ago, the cost change behind each drop, products below the floor flagged, services with no cost shown as cost not recorded, the blended margin beside the industry's range, and three price scenarios grounded in how customers responded to real price changes.

  • If costs have risen on a product whose price has not moved, the margin loss is shown with the cost rise behind it, and the owner can test a new price before setting it.
  • If a product sits below the margin floor, it is flagged for the owner to reprice, bundle or drop.
  • If margins have held, the summary confirms it, and no price needs to change.
  • If a cost is missing, the product is shown as cost not recorded, so no margin is overstated.

Try it

The demo runs on WidgetCo Coffee Roasters, an example business: a coffee roaster with an online store and a wholesale side. You will see it as Dana, the owner.

Connected to this story