Product Viability & Breakeven Calculator

The Product Viability Calculator in MerchantFlow is a profitability simulation tool that helps e-commerce merchants assess whether a new product will be profitable before committing to inventory. It uses your store's actual cost averages -- payment fees, ad spend rate, shipping, fulfillment, and more -- to project real-world margins, breakeven points, and sensitivity to cost changes.

What Is a Product Viability Analysis?

A product viability analysis answers the question: "Will this product be profitable at my store?" Instead of guessing, MerchantFlow pulls your actual operating costs and applies them to a hypothetical product, so you see projected margins based on real data rather than optimistic estimates.

How the Viability Calculator Works

1. Enter product details (selling price, COGS, expected monthly volume)
2. MerchantFlow applies your store's average cost rates automatically
3. See projected margin, breakeven point, and sensitivity analysis
4. Adjust variables to explore different scenarios

How to Access the Calculator

Navigate to Products > Viability from the main navigation.

What Store Averages Are Used?

The calculator pre-fills your store's actual averages, calculated from your real synced data:

• Payment fee rate - Average percentage charged by payment processors
• Refund rate - Historical percentage of orders refunded
• Ad spend rate - Advertising cost as a percentage of revenue
• Shipping cost rate - Average shipping cost per order
• Fulfillment cost rate - Warehousing and pick/pack fees
• Variable cost rate - Other variable costs as a percentage of revenue
• OPEX rate - Operating expenses as a percentage of revenue
• Funding repayment rate - Revenue-based funding repayment percentage

These averages update automatically as new data syncs, so your projections stay grounded in current business performance.

Simulation Features

Breakeven Analysis

Find the minimum selling price or maximum COGS at which a product remains profitable after all costs are accounted for. This helps you set pricing floors and negotiate with suppliers from a position of data.

Sensitivity Analysis

See how changes to key variables affect your margin:

• What happens if ad spend increases by 5%?
• What if your refund rate doubles?
• How much COGS reduction would you need to hit a 20% margin?

Sensitivity analysis reveals which cost levers have the most impact on profitability, so you know where to focus optimization efforts.

Scenario Comparison

Compare optimistic, realistic, and pessimistic scenarios side by side. Adjust price, volume, or costs for each scenario to understand the range of possible outcomes before committing capital.

Best Practices for Product Viability

• Run the calculator before sourcing new products - Know your margin floor before negotiating with suppliers
• Use your actual store averages for realistic projections instead of industry benchmarks
• Pay attention to the sensitivity analysis - Small changes in ad spend can flip margins from positive to negative
• Revisit viability as your store averages change over time, especially after significant operational changes
• Factor in funding costs if you plan to use revenue-based funding to finance inventory
• Compare against existing products - Use the Products Table to see how current products perform at similar price points

Frequently Asked Questions

How accurate are the viability projections?

Projections are based on your store's actual historical cost averages, which makes them significantly more accurate than industry benchmarks. However, new products may have different ad costs or return rates than your store average. Use the sensitivity analysis to model these variations.

Can I save viability analyses for future reference?

Currently, the calculator provides real-time projections. To save results, export or screenshot the analysis before navigating away. Saved viability reports are on the product roadmap.

What if I do not have enough store data yet?

For new stores with limited data, the calculator may show incomplete averages. In this case, you can manually override any cost rate field with your best estimates. As you accumulate more order and expense data, the automatic averages will become more reliable.

How does the breakeven analysis account for fixed costs?

The breakeven analysis includes your OPEX rate (fixed operating expenses as a percentage of revenue) in the calculation. This means your breakeven point accounts for the proportional share of overhead, not just variable costs like COGS and payment fees.

Should I use the viability calculator for existing products too?

Yes. If you are considering a price change, switching suppliers, or adjusting ad spend for an existing product, run the new numbers through the calculator to see how the change affects projected profitability.

Related Topics

• Products Table - View current product performance
• Product Detail Analytics - Deep-dive into individual products
• Expense Tracking - Understand your cost structure
• Revenue-Based Funding - Factor in funding costs
• P&L Overview - Complete financial tracking

---

Last updated: March 14, 2026