How to Conduct a Profitability Analysis by Product or Service

Most Ontario business owners know their overall profitability, but many don’t know which specific products or services generate the most profit. This knowledge gap leads to poor decisions—investing marketing dollars in low-margin offerings while neglecting high-margin ones, or keeping unprofitable products that drain resources. At BBS Accounting in Toronto, we help clients analyze profitability at the product and service level, enabling data-driven decisions about pricing, marketing, and product mix. This guide shows you how.

Why Product-Level Profitability Matters

Overall business profitability masks important details. You might show 15% net profit overall while some offerings generate 40% margins and others lose money. Understanding this mix enables strategic decisions about what to emphasize, what to improve, and what to eliminate.

Product-level analysis reveals your most valuable offerings (focus marketing and sales here), loss leaders or breakeven products (determine if strategic value justifies keeping them), overpriced products (losing sales due to high prices), and underpriced products (leaving money on the table).

Many businesses discover that 20% of products generate 80% of profit—focusing on that 20% transforms results.

The Challenge: Allocating Costs

Calculating revenue by product is straightforward—your sales records show this. The challenge is allocating costs appropriately. Some costs are direct (clearly attributable to specific products), while others are indirect (shared across products).

Direct Costs: Cost of goods sold for that specific product, commissions paid on that product’s sales, and shipping costs for that product.

Indirect Costs: Rent, utilities, administrative salaries, marketing (unless product-specific), insurance, and general overhead.

Profitability analysis requires methodically allocating these indirect costs to products based on reasonable drivers.

Step 1: Identify All Products/Services

List every distinct product or service you offer. Group similar items if analyzing hundreds of SKUs—analyze by product line rather than individual items.

For service businesses, define services based on how you price and deliver them. A consulting firm might analyze: strategic consulting, implementation services, training workshops, and ongoing advisory retainers as separate services.

For product businesses, organize by product categories or lines unless you need item-level detail.

Step 2: Calculate Revenue by Product

Pull sales data from your accounting system or point-of-sale system for a defined period (typically annually or quarterly).

Generate a report showing revenue by product/service. Ensure the report captures all revenue including discounts (show net revenue after discounts, not gross).

Example Output:

• Product A: $250,000 revenue
• Product B: $180,000 revenue
• Product C: $120,000 revenue
• Product D: $90,000 revenue
• Total: $640,000 revenue

Step 3: Calculate Direct Costs

For each product, identify costs directly attributable to it.

Product Businesses: Cost of goods sold (what you paid for inventory), inbound freight/shipping costs, direct labor in production/assembly, product-specific packaging, and product-specific marketing.

Service Businesses: Direct labor (billable hours × labor cost), subcontractor costs, travel specific to projects, materials consumed on projects, and project-specific technology.

At BBS Accounting, we help clients properly categorize direct vs. indirect costs—proper categorization is crucial for accurate analysis.

Example:

• Product A: $100,000 COGS, $10,000 labor = $110,000 direct costs
• Product B: $90,000 COGS, $5,000 labor = $95,000 direct costs
• Product C: $60,000 COGS, $8,000 labor = $68,000 direct costs
• Product D: $50,000 COGS, $3,000 labor = $53,000 direct costs
• Total: $326,000 direct costs

Step 4: Calculate Gross Profit

For each product, subtract direct costs from revenue.

Gross Profit = Revenue – Direct Costs Gross Margin % = (Gross Profit / Revenue) × 100

Example:

• Product A: $250,000 – $110,000 = $140,000 gross profit (56% margin)
• Product B: $180,000 – $95,000 = $85,000 gross profit (47% margin)
• Product C: $120,000 – $68,000 = $52,000 gross profit (43% margin)
• Product D: $90,000 – $53,000 = $37,000 gross profit (41% margin)
• Total: $314,000 gross profit (49% overall margin)

Gross profit analysis alone provides valuable insights. Product A has the highest revenue AND highest margin—clearly your star product. Product D has the lowest margin—needs investigation.

Step 5: Allocate Indirect Costs

This is where analysis becomes complex but valuable. Indirect costs must be allocated to products using reasonable allocation bases.

Common Allocation Methods:

Revenue-Based: Allocate overhead in proportion to revenue. Simple but crude—assumes all revenue requires equal overhead support, which is often untrue.

Labor-Based: Allocate based on direct labor hours or costs. Reasonable for service businesses where labor is primary driver.

Square Footage: For warehouse/manufacturing space, allocate based on space each product consumes.

Transaction-Based: Allocate order processing costs based on order volume per product.

Activity-Based Costing (ABC): Most accurate but complex. Identify activities (customer service, order fulfillment, quality control) and allocate costs based on each product’s consumption of those activities.

For most small businesses, a hybrid approach works: allocate some costs by revenue, some by labor, some by units/orders.

Example Using Revenue-Based Allocation:

Total indirect costs: $200,000 annually

Product A allocation: ($250,000 / $640,000) × $200,000 = $78,125 Product B allocation: ($180,000 / $640,000) × $200,000 = $56,250 Product C allocation: ($120,000 / $640,000) × $200,000 = $37,500 Product D allocation: ($90,000 / $640,000) × $200,000 = $28,125

Step 6: Calculate Net Profit by Product

Subtract allocated indirect costs from gross profit.

Example:

• Product A: $140,000 – $78,125 = $61,875 net profit (24.8% net margin)
• Product B: $85,000 – $56,250 = $28,750 net profit (16.0% net margin)
• Product C: $52,000 – $37,500 = $14,500 net profit (12.1% net margin)
• Product D: $37,000 – $28,125 = $8,875 net profit (9.9% net margin)
• Total: $114,000 net profit (17.8% overall margin)

Now you have complete profitability picture by product. Product A generates 54% of total profit despite being 39% of revenue. Product D generates only 8% of profit despite being 14% of revenue.

Step 7: Analyze the Results

Look for patterns and insights:

Stars (High Revenue, High Margin): Product A is your star—39% of revenue, 56% gross margin, 25% net margin, 54% of profit. Strategy: Maximize sales. Increase marketing investment. Ensure adequate inventory/capacity. Protect from competitors. Consider selective price increases to maximize profit.

Cash Cows (Moderate Revenue, Good Margin): Product B generates solid profit with good margins. Strategy: Maintain position. Don’t over-invest. Harvest profit while defending market share.

Question Marks (Lower Margin but Significant Volume): Products C and D have lower margins. Strategy: Investigate why margins are lower. Can costs be reduced? Should prices increase? Are these loss leaders serving strategic purposes? Consider whether to discontinue if no strategic value.

Hidden Losses: If any products show negative net profit after allocation, seriously consider discontinuation unless they serve strategic purposes (drive sales of other products, provide market entry, or build customer relationships leading to profitable sales).

Advanced Analysis: Contribution Margin

Some analysts prefer contribution margin analysis—gross profit minus variable costs but not fixed costs allocated.

This reveals which products contribute most to covering fixed costs. Even products with modest net profit after full allocation might be valuable contributors worth keeping if they have positive contribution margins.

Customer Profitability Analysis

Extend product analysis to customer level—which customers generate most profit? Some customers buy high-margin products with minimal service requirements (profitable), while others buy low-margin products requiring extensive support (unprofitable).

Analyzing profitability by customer enables strategic decisions about customer acquisition focus and relationship management.

Time-Based Analysis

Conduct profitability analysis quarterly or semi-annually to track trends. Product profitability changes over time due to cost changes, pricing changes, competition, or volume shifts.

Trending analysis reveals whether profitable products are becoming more or less profitable, informing pricing and cost management decisions.

Common Findings

Most businesses conducting first-time profitability analysis discover:

The 80/20 Rule: Roughly 20% of products generate 80% of profit. Focus intensifies on that 20%.

Cross-Subsidization: High-margin products subsidize low-margin ones. This might be intentional strategy or accidental waste.

Pricing Disconnects: Some high-value products are underpriced while less-valuable products are overpriced.

Cost Control Opportunities: High-cost products benefit most from cost reduction efforts.

Volume vs. Value: High-volume products aren’t necessarily high-profit products.

At BBS Accounting, we’ve helped Toronto clients discover products generating losses they’d never identified—discontinuing them immediately improved overall profitability by 10-20%.

Strategic Actions Based on Analysis

Emphasize High-Margin Products: Increase marketing spend, train sales team to lead with these, offer promotions and bundles featuring them, and ensure adequate inventory/capacity.

Fix or Kill Low-Margin Products: Reduce costs (better suppliers, efficiency improvements), increase prices (if market allows), reposition as premium offerings (justify higher prices), bundle with high-margin products, or discontinue if unfixable.

Optimize Product Mix: Analyze customer purchasing patterns—do customers buying Product A also buy Product D? Can you upsell profitable products to existing customers? Should you create packages emphasizing high-margin items?

Pricing Strategy Refinement: Increase prices on underpriced high-value products, adjust prices on low-margin products (up if possible, down if necessary to drive volume), implement value-based pricing for differentiated offerings.

Cost Reduction Focus: Prioritize cost reduction efforts on high-volume products (small per-unit savings multiply significantly), identify shared cost drivers affecting multiple products.

Service Business Considerations

Service profitability analysis has unique aspects:

Labor Intensity: Some services require significantly more labor than others. Track actual hours by service type to calculate true labor costs.

Skill Requirements: Services requiring specialized skills cost more to deliver (higher wages, training costs, scarcity of talent).

Customer Service Requirements: Some services generate extensive support needs affecting profitability.

Scalability: Some services scale well (adding clients costs little), while others don’t (each client requires dedicated resources).

A consulting firm might discover that strategic consulting generates 35% margins while implementation services generate 15% margins—but implementation services lead to higher-margin advisory relationships. The full picture matters.

Manufacturing Considerations

Manufacturers have additional complexity:

Production Runs: Small production runs cost more per unit (setup costs spread over fewer units).

Machine Time: Products requiring extensive machine time consume more capacity and cost.

Complexity: Complex products with many components cost more to produce, inventory, and quality-control.

Scrap Rates: Products with high scrap/defect rates have hidden costs.

Manufacturers should track production costs carefully and allocate them accurately for meaningful profitability analysis.

Retail Considerations

Retailers must consider:

Inventory Carrying Costs: Slow-moving inventory ties up cash and incurs storage costs. Fast-moving inventory is more profitable even at similar margins.

Shrinkage: Theft, damage, or spoilage varies by product category.

Shelf Space: Products consuming premium shelf space should generate higher profit per square foot.

Turn Rate: Revenue per square foot and profit per square foot metrics reveal most valuable products.

Software and Tools

Several tools facilitate profitability analysis:

Accounting Software: QuickBooks, Xero, and Sage have reporting by product/service, though allocation of indirect costs typically requires manual calculation or customization.

Spreadsheets: Excel or Google Sheets work well for most small businesses with moderate product counts. Create templates for repeatable analysis.

Specialized Software: Profitability analytics platforms like Jirav, Spotlight Reporting, or industry-specific tools provide sophisticated analysis.

BI Tools: Power BI, Tableau, or Looker enable dynamic profitability dashboards pulling data from multiple sources.

At BBS Accounting, we help clients implement appropriate tools based on their business size and complexity.

Working with BBS Accounting

Profitability analysis requires accounting expertise and business understanding. We provide:

Data extraction from accounting systems, cost allocation methodology design, profitability calculation and reporting, trend analysis and insights, strategic recommendations based on findings, and quarterly or annual updates tracking changes.

Our analysis typically identifies 5-15% profit improvement opportunities through product mix optimization, pricing adjustments, and cost reduction focus.

Common Mistakes to Avoid

Ignoring Indirect Costs: Analyzing only gross margin ignores significant costs, creating incomplete picture.

Inappropriate Allocation: Using irrelevant allocation bases (e.g., allocating marketing costs by revenue when marketing efforts vary dramatically by product).

Paralysis by Analysis: Don’t spend months perfecting allocation models. Reasonably accurate analysis beats perfect procrastination.

One-Time Analysis: Profitability changes over time. Annual or quarterly analysis maintains accuracy.

Forgetting Strategic Value: Some low-profit products serve strategic purposes (market entry, customer acquisition, product line completion). Profitability alone shouldn’t drive all decisions.

The Bottom Line

Understanding profitability by product or service transforms decision-making from guesswork to data-driven strategy. You’ll know where to focus sales and marketing efforts, which pricing needs adjustment, where cost reduction provides most impact, and which products to emphasize or eliminate.

Don’t manage your business based on overall profitability alone. Dig deeper into product-level profitability and unlock insights that drive strategic improvements.

Contact BBS Accounting today for comprehensive profitability analysis. We’ll analyze your products or services, identify your most and least profitable offerings, recommend strategic actions, and implement tracking systems for ongoing visibility. Know where you make money—it’s the foundation of strategic business management.