How to Find Out Which Products Actually Make You Money
Your best-selling product might be your least profitable. It is entirely possible for a product that is 40 % of your revenue to be 10 % of your profit, or none of it. Total profit hides this completely, which is why so many owners pour effort into the products that feel successful while the quietly profitable ones go unnoticed. Product profitability analysis fixes that. It shows you, product by product, how much money each one actually makes after its real costs. Done once, it often reshapes what you promote, what you reprice, and what you drop. Here is how to run it, carried through one example the whole way. Say you make specialty sauces and sell 5 products through retail and direct channels. We will analyze all 5 together. Step 1: Set up the data Pull revenue and units sold for each of the 5 products over a consistent period, ideally the last 12 months so seasonality evens out. Lay them side by side in a simple table, 1 column per product. You are building a scorecard, and it starts with how much each product sells and at what price. Do not eyeball this from memory. Pull the actual numbers, because memory tends to favor the products you like. Step 2: Allocate the direct costs For each product, assign the costs that belong only to it: ingredients, packaging, and any per-unit production labor. Our 5 sauces have different recipes, so their direct costs differ. The premium sauce uses costlier ingredients but sells for more; the basic sauce is cheap to make but sells thin. Enter each product's direct cost per unit and multiply by units sold. Now you can see gross margin per product, and already the picture starts to separate. Step 3: Choose an overhead method Products also consume shared costs: the kitchen, equipment, storage, and general labor. To compare fairly, you have to spread this overhead across products with a consistent driver. Pick 1 that reflects how each product actually uses those resources, such as production hours, batch count, or units made. The premium sauce takes longer to produce, so an hours-based method assigns it more overhead, which is only fair. Consistency is what matters. Use the same driver for all 5. Step 4: Build the comparison Now assemble the full view for each product: revenue, direct costs, allocated overhead, and the profit left over, both in dollars and as a percentage. Rank the five from most to least profitable. This ranking is the payoff, and it almost never matches the ranking by revenue. In our example, the mid-tier sauce that nobody thinks about turns out to carry the best margin, while the popular basic sauce, after overhead, barely breaks even. Step 5: Interpret the outliers Look at the 2 ends. Your most profitable products are where growth is worth the most, so they deserve more of your marketing and shelf space. Your least profitable, or unprofitable, products are decisions waiting to be made. A product losing money after full costs is not a loss leader unless you deliberately chose it as one. Usually it is just a leak nobody measured. Be careful with one thing. A low-margin product that drives volume of high-margin products can still earn its place. Judge the role, not only the line. But make that a conscious call, not an accident. Step 6: Act on what you found Analysis that changes nothing was wasted. For each underperformer you have four moves: raise its price, cut its cost, keep it deliberately for a strategic reason, or discontinue it. For our basic sauce that barely breaks even, a modest price increase or a packaging cost reduction likely turns it profitable without losing the volume it brings. For a true money-loser with no strategic role, dropping it frees up capacity for the sauces that actually pay. The weekly recap Here is the plan you can start now. This week, pull 12 months of revenue and units for each product. Next, assign direct costs per unit and choose one overhead driver you will apply to all of them. Build the ranked comparison and find your top two and bottom two. Then, for each of the bottom 2, decide in writing whether to reprice, re-cost, keep, or cut. Revisit the whole analysis once or twice a year, because costs and mix drift. This kind of product-level clarity is one of the most common things a fractional CFO uncovers in the first 90 days, and it frequently pays for the engagement on its own. |

.png)



Comments